Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Should the Outstanding Loan Balance be $0.00 or should it be $219,000 based on the financial information you see above? A B D E 1
Should the Outstanding Loan Balance be $0.00 or should it be $219,000 based on the financial information you see above?
A B D E 1 2 3 5 July 40,000 520,000 560,000 Cash Budget August September 35,050 35,435 693,000 779,500 728,050 814,935 Quarter 40,000 1,992,500 2,032,500 11 6 Cash Balance: Beginning 7 Add Cash Collections (From Sales Budget) 8 Total cash Available 9 Less Cash Disbursements 10 For Inventory (From Purchasing Budget) For Operating Expenses (From Selling and Admin Budg 12 For Equipment 13 For Cash Dividends 14 For Interest (From Previous Month's Borrowing) 15 Total Cash Disbursements 16 Excess (Deficiency) of Cash 17 Financing 18 Borrowing 19 Repayment 20 Total Financing 21 Cash Balance: Ending 280,950 213,000 200,000 50,000 0 743,950 (183,950) 336,125 288,000 253,300 196,750 90,000 0 0 0 2,190 $ 2,080 681,615 486,830 46,435 328,105 905,075 663,050 290,000 50,000 4,270 1,912,395 120,105 219,000 0 219,000 35,050 0 (11,000) (11,000) 35,435 0 (208,000) (208,000) 120,105 219,000 (219,000) 0 120,105 22 23 24 25 Outstanding Loan Balance 26 Interest on Borrowing (Due the Following Quarter) 27 $ 4.270 Your ending cash balance should be $120.105 on the tab called-Cash-BudgetStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started