Question
Use the following information to answer Question 3. Harvest Oaks beginning balance of cash on April 1 is $450,000. Harvest Oaks wants to maintain a
Use the following information to answer Question 3.
Harvest Oaks beginning balance of cash on April 1 is $450,000.
Harvest Oaks wants to maintain a minimum cash balance of $400,000. The company has an agreement with a local bank that allows the company to borrow money in any increment at the beginning of each month. The interest rate on these loans is 1% per month and is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.
Question 3. Use the table below to prepare the cash budget for the second quarter.
Cash Budget | ||||
April | May | June | Quarter | |
Beginning cash balance |
|
|
|
|
Total cash receipts | 2,225,000 | 2,450,000 | 2,700,000 | 7,375,000 |
Total cash available |
|
|
|
|
Less total cash disbursements | 2,500,000 | 2,700,000 | 2,200,000 | 7,400,000 |
Excess (deficiency) of cash available over disbursements |
|
|
|
|
Financing: |
|
|
|
|
Borrowings |
|
|
|
|
Repayments |
|
|
|
|
Interest |
|
|
|
|
Total financing |
|
|
|
|
Ending cash balance |
|
|
|
|
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