Question
I need help ASAP thank you Magnificent Muffins Inc. requires a minimum cash balance of $800 at the end of each quarter. Complete the cash
I need help ASAP thank you
Magnificent Muffins Inc. requires a minimum cash balance of $800 at the end of each quarter. Complete the cash budget for Magnificent Muffins Inc.
Magnificent Muffins inc. Cash Budget For the Year ending December 31, 2020 | ||||
| Q1 | Q2 | Q3 | Q4 |
Cash (Beginning) | $600 | ? | ? | ? |
Cash receipts |
|
|
|
|
Cash from Sales | 1,300 | 1,060 | 1,100 | 1,850 |
Collections from Credit Customers | 500 | 1,440 | 900 | 2,150 |
total Cash Available
| ? | ? | ? | ? |
Cash Payments |
|
|
|
|
Inventory Purchases | 400 | 850 | 360 | 560 |
General & Admin. Expense | 625 | 1,150 | 300 | 940 |
Capital Expenditures | 875 | 1,200 | 700 | 800 |
Dividend Payment | 100 | 200 | 440 | 200 |
total Cash Payments | ? | ? | ? | ? |
|
|
|
|
|
Cash excess (deficit) | ? | ? | ? | ? |
|
|
|
|
|
Financing requirements |
|
|
|
|
Loan Borrowings | ? | ? | ? | ? |
Loan Repayments | ? | ? | ? | ? |
ending Cash Balance ( $800)
| ? | ? | ? | ? |
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