Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help with the yellow fields please 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
need help with the yellow fields please
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 288,000 196,750 0 Cash Balance: Beginning Add Cash Collections (From Sales Budget) Total cash Available Less Cash Disbursements For Inventory (From Purchasing Budget) For Operating Expenses (From Selling and Admin Budget) For Equipment For Cash Dividends For Interest (From Previous Month's Borrowing) Total Cash Disbursements Excess (Deficiency) of Cash Financing Borrowing Repayment Total Financing Cash Balance: Ending 280,950 213,000 200,000 50,000 0 $ 743,950 (183,950) 336,125 253,300 90,000 0 2,190 681,615 46,435 0 905,075 663,050 290,000 50,000 2,190 1,910,315 122,185 484,750 330,185 219,000 (219,000) 219,000 0 219,000 35,050 0 (11,000) 11,000 35,435 0 (208,000) 208,000 122,185 122, 185 $ Outstanding Loan Balance Interest on Borrowing (Due the Following Quarter)Step 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