Question

Morgan Company's budgeted income statement reflects the following amounts: Sales Purchases Expenses January $ 112,000 $ 70,000 $ 23,200 February 102,000 58,000 23,400 March 117,000 73,250 26,200 April 122,000 76,500 27,800 Sales are collected 50% in the month of sale, 30% in the month following sale, and 19% in the second month following sale. One percent of sales is uncollectible and expensed at the end of the year. Morgan pays for all purchases in the month following purchase and takes advantage of a 3% discount. The following balances are as of January 1: Cash $ 80,000 Accounts receivable* 50,000 Accounts payable 64,000 *Of this balance, $30,000 will be collected in January and the remaining amount will be collected in February. The monthly expense figures include $4,200 of depreciation. The expenses are paid in the month incurred. Morgan’s budgeted cash receipts in February are:

Answer 1

Answer:

Net cash Receipts in February = $21,500

Explanation:

Closing balance of January

Opening balance + (Sales  X 50%) + Accounts Receivable provided - Cash paid for purchases of previous month X 97% - (Expenses - Depreciation)

= $80,000 + $112,000 X 50% + $30,000 - $64,000 X 97% - ($23,200 - $4,200 (Depreciation)) = $80,000 + $56,000 + $30,000 - $62,080 - $19,000

= $84,920

Closing Balance of February

= Opening balance + Sales X 50% + Previous month sale X 30% + December sale X 19% - Payment for purchase in month of January X 97% - (Expenses of the month - Depreciation)

= $84,920 + $102,000 X 50% + $112,000 X 30% + $20,000/20% X 19% - $70,000 X 97% - ($23,400 - $4,200)

= $84,920 + $56,000 + $33,600 + $19,000 - $67,900 - $19,200

=$106,420

Notes

1. Opening receivables were $50,000 which is 50% of sale of December, i.e. 20% = $20,000 out of which 1% is bad debt and not received.
2. Purchases are paid next month with a discount of 3% i.e. 100- 3 = 97% of the purchase amount.
3. Depreciation is not paid in cash and thus not included in cash payments of expense.

Thus Net cash Receipts in February = Closing - Opening = $106,420 - $84,920 = $21,500