Assume that the five owners of Mountain Sports Ltd. decide to collectively invest personal funds into the
Fantastic news! We've Found the answer you've been seeking!
Question:
Assume that the five owners of Mountain Sports Ltd. decide to collectively invest personal funds into the Canmore expansion (this is a continuation of question 4). Mountain Sports will require an open line of credit up to a maximum of $350,000. It will be necessary to convince the bank manager of this new Canmore branch ability to repay its line credit plus interest within a year.
Management has provided the following list of assumptions to help in the preparation of the cash budget (note: you will need to use the projected income statement provided in Question 4 to complete the cash budget): | |||||
1. Beginning cash balance invested by owners | $ 59,000 | ||||
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | ||
2. Sales by quarter (as % of total projected sales) | 24% | 27% | 28% | 21% | |
3. Type of collections from customers | |||||
Cash Sales | 35% | ||||
Credit Sales (accounts receivable) | 65% | ||||
Cash sales are collected in the quarter of the sale, all credit sales are collected in the quarter after the sale. | |||||
4. Merchandise purchases | |||||
Merchandise purchases (cost of goods sold) are all paid in the quarter following purchase. (Quarter 1 purchases are bought in Quarter 1 but paid for in quarter 2). | |||||
5. Operating expenses | |||||
All other operating expenses (all expenses except cost of goods sold) are paid on a monthly basis. | |||||
6. Required investment in equipment paid in cash in the first quarter | $ 138,000 | ||||
7. Quarterly income tax payments paid in cash | $ 7,000 | ||||
8. Minimum cash balance | $ 21,000 | ||||
9. Borrowing and Repayments | |||||
Any borrowing will take place on the first day of the quarter and any repayments are paid at the end of the quarter. All borrowing and payments are made in increments of $1,000. Interest on borrowing can be ignored. |
Related Book For
Posted Date: