Question

Could you fill out the financing section for me? need help with borrowing, repayment, and interest

3. Cash Budget April May June Quarter $ 8,000.00 $ 4,000.00 $ 4,000.00 $ 8,000.00 $56,000.00 $ 67,200.00 $82,800.00 $206,000.00 $64,000.00 $ 71,200.00 $86,800.00 $222,000.00 Beginning Cash Balance Add: Cash Collections Total Cash Available Less: Cash Disbursements Materials Selling and administrative Equipment purchase Total Disbursements Excess (Deficiency) Financing: Borrowing Repayment Interest Total Financing Ending Cash Balance $47,850.00 $ 58,500.00 $53,550.00 $159,900.00 $13,300.00 $ 15,460.00 $18,700.00 $ 47,460.00 $ 1,500.00 $ - $ - $ 1,500.00 $62,650.00 $ 73,960.00 $72,250.00 $208,860.00 $ 1,350.00 $ (2,760.00) $14,550.00 $ 13,140.00 X+.01x=4000-1350 $ 4,000.00 $ 4,000.00 $ 4,000.00

Answer 1

particulars	april	may	june	quarter
excess(deficiency)	1350	(2760)	14550	13140
financing
borrowing	2650	6760		9410
Repayment			9410	9410
interest			100.5	100.5
total financing
ending balance	4000	4000	5039.5	13039.5

interest for first borrowal =2650*10/100*2/12=44.17

interest for second borrowal =6760*10/100*1/12=56.33