Question
Assume you have received the following partially completed cash budget for The Good Company. It is noted that the company has a beginning cash balance
Assume you have received the following partially completed cash budget for The Good Company. It is noted that the company has a beginning cash balance in January of $15,000, however, a minimum balance of $25,000 will be used from that point forward. The firm is able to access short-term borrowing at 12% per annum (or 1% per month) to be paid monthly. The interest on any short-term borrowing is paid in the month after it is incurred.
THE GOOD COMPANY | ||||
CASH BUDGET Jan - Apr 2020 | ||||
January | February | March | April | |
$ | $ | $ | $ | |
Total cash receipts | 49,800 | 42,550 | 51,400 | 47,600 |
Total Cash Disbursement | 43,145 | 47,320 | 41,500 | 43,110 |
Net change in cash for the period |
|
|
|
|
Plus Beginning cash balance |
|
|
|
|
Less: Interest on short-term borrowing |
|
|
|
|
Ending Cash balance before short-term borrowing |
|
|
|
|
|
|
|
| |
New financing needed |
|
|
|
|
Ending cash balance |
|
|
|
|
Cumulative Borrowing |
|
|
|
|
Required: Complete the table showing the Cash Budget for the period January thru April
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