Combined Cash Budget February and March February March Beginning cash balance Pl
ID: 2523922 • Letter: C
Question
Combined Cash Budget February and March February March Beginning cash balance Plus: Cash collections Plus: Cash from sale of plant assets Total cash available Less: Cash payments (purchase inventory) Less: Cash payments (operating expenses) Total cash payments (1) Ending cash balance before financing Minimum cash balance desired Cash excess (deficiency) 16,500 80,200 2,100 107,100 41,500 47,900 98,700 22,900 20,000 20,000 Plus: New borrowings Less: Debt repayments Less: Interest payments (2) Total effects of financing Ending cash balance(1(2)Explanation / Answer
Raymond Adventures Combined Cash Budget February and March February March Beginning Cash balance $16,500.00 $20,000.00 Plus : Cash collections $90,600.00 $80,200.00 Plus : Cash from sale of plant assets $0.00 $2,100.00 Total Cash available $107,100.00 $102,300.00 Less : Cash payments (purchase inventory) $50,800.00 $41,000.00 Less : Cash Payments (operating expenses) $47,900.00 $38,400.00 Total Cash payments $98,700.00 $79,400.00 (1) Ending cash balance before financing $8,400.00 $22,900.00 Minimum cash balance desired $20,000.00 $20,000.00 Cash Excess (deficiency) -$11,600.00 $2,900.00 Financing Plus : New borrowings $11,600.00 $0.00 Less : Debt repayments $0.00 $2,832.33 Less : Interest payments $0.00 $67.67 (2) Total effect of financing $11,600.00 -$2,900.00 Ending Cash balance (1) + (2) $20,000.00 $20,000.00