Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A cash budget is prepared for a retail company. The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill
A cash budget is prepared for a retail company. The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill in the missing amounts (Note: Omit 000's in your answers).
QU | AR | T | ER | ||
---|---|---|---|---|---|
1 | 2 | 3 | 4 | Year | |
Cash balance, beginning | $7 | - | - | - | - |
Add: Collections from customers | - | - | 97 | - | 321 |
Total cash available before current financing | 72 | - | - | - | - |
Deduct: Disbursements: | |||||
Purchase of inventory | 36 | 43 | - | 27 | - |
Operating expenses | - | 28 | 31 | - | 114 |
Equipment purchases | 7 | 9 | 9 | - | 34 |
Dividends | 1 | 1 | 1 | 1 | - |
Total disbursements | - | 81 | - | - | - |
Excess (deficiency) of cash available over disbursements | (2) | - | 9 | - | - |
Financing: | |||||
Borrowings | - | 13 | - | - | - |
Repayments (including interest)* | - | - | - | (17) | - |
Total financing | - | - | - | - | - |
Cash balance, ending | -____________ | -__________ | -___________ | -_________ | -________ |
*Interest will total $1,000 for the year |
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