Question

Spalding Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Spalding expects sales in January year 1 to total $120,000 and to increase 5 percent per month in February and March. All sales are on account. Spalding expects to collect 70 percent of accounts receivable in the month of sale, 20 percent in the month following the sale, and 10 percent in the second month following the sale Required Prepare a sales budget for the first quarter of 2019. Determine the amount of sales revenue Spalding will report on the first 2019 quarterly pro forma income statement. Prepare a cash receipts schedule for the first quarter of 2019. Determine the amount of accounts receivable as of March 31, 2019.

Answer 1

Amoun of sales Revenue for the first quarter of 2019

Jan $120,000

Feb ( 120,000*1.05) 126,000

March ( 126,000* 1.05) 132,300

378,300

Cash Receipt schedule for the first quarter of 2019

Jan Feb March

Jan sales $84,000 24,000 12,000

Feb sales - 88,200 25,200

March sales - - 92,610

84,000 112,200 129,810

Amount of Account Receivable as of MArch 2019

Feb sale 10%* 126,000 $12,600

March sales( 20%* 132,300) + (10%*132300) 39,690

52,210

Step-by-step explanation:

cash receipt

Jan Sales : Jan 70% * 120,000 = 84,000

feb 20%* 120,000 = 24,000

March 10% * 120,000 = 12,000

Feb sales : Feb 70%*126,000 = 88,200

March 20% * 126,000 = 25,200

April 10%* 126,000 = 12,600

March sales : March 70%* 132300 = 92,610

April 20%*132300 = 26,460

May 10%*132300 = 13,230