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

Answer:

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

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