Question
g. Equipment will be acquired for cash: $4,000 in January and $10,000 in February. h. Management would like to maintain a minimum cash balance of
g. Equipment will be acquired for cash: $4,000 in January and $10,000 in February.
h. Management would like to maintain a minimum cash balance of 3,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of 2,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 2% per month, and for simplicity we will assume that interest is not compounded. The company would as far as it is able, repay the loan plus accumulated interest at the end of the quarter.
Required:
Using the data above:
1. Complete the following Schedule:
Schedule of expected cash collections | ||||
January | February | March | Quarter | |
Cash sales | ||||
Credit sales | ||||
Total collections |
2. Complete the following:
Merchandise Purchases Budget | ||||
January | February | March | Quarter | |
Budgeted cost of goods sold | ||||
Add: desired ending inventory | ||||
Total needs | ||||
Less: beginning inventory |
| |||
Required purchases |
Schedule of expected cash disbursements- Merchandise Purchase | ||||
January | February | March | Quarter | |
December purchases | ||||
January purchases | ||||
February purchases | ||||
March purchases | ||||
Total disbursements |
3. Complete the following schedule:
Schedule of expected cash disbursements- Selling and administrative expenses | ||||
January | February | March | Quarter | |
Commissions | ||||
Rent |
| |||
Other expenses |
| |||
Total disbursements |
4. complete the following cash budget:
Cash Budget | ||||
January | February | March | Quarter | |
Cash balance, beginning | ||||
Add: cash collections | ||||
Total cash available | ||||
Less: cash disbursements | ||||
For inventory | ||||
For Selling and administration | ||||
For equipment |
| |||
Total cash disbursements | ||||
Excess /deficiency of cash |
| |||
Financing: | ||||
Borrowings |
| |||
Repayment |
| |||
Interest |
| |||
Total financing |
| |||
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