Question: can you help correct? Required 1 Required 2 Prepare a cash budget, by month and in total, for the three-month period. (Cash deficiency, repayments and

Required 1 Required 2 Prepare a cash budget, by month and in total, for the three-month period. (Cash deficiency, repayments and interest shoul indicated by a minus sign.) June May 59,000 $ Quarter 39,000 84.720 X $ 350,120 409,120 483,160 567,880 1.052,280 1,091,280 Prime Products Cash Budget April Beginning cash balance IS 39,000 $ Add receipts: Collections from customers 219,000 Total cash available 258,000 Less cash disbursements: Merchandise purchases 174,600X Payroll 19,600 Lease payments 29,200 Advertising 62,600 Equipment purchases 0 Total cash disbursements 286,000 Excess (deficiency) of cash available over disbursements (28,000) Financing Borrowings 87,000 Repayments 0 Interest 0 Total financing 87.000 Ending cash balance $ 59,000 $ DOO 213,000 19,600 29,200 62,600 0 $ 181,500 24,000 29,200 47.680 112,000 394,380 173,500 569,100% 63,200X 87,600 172,880 112,000 1,004,780 86,500 324,400 84,720 0 0 OO 0 0 (87.000) (1.220) (88,220) 85,280 87.000 (87,000) (1,220) (1.220) 85,280 84,720 $
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
