Question: 2. (8 points) Based on the following information, complete the forecasts below just as we did in Project 2! Show only one decimal place of
2. (8 points) Based on the following information, complete the forecasts below just as we did in Project 2! Show only one decimal place of accuracy!
($ millions) Year 0 Year 1 Year 2 Year 3
| Sales | ||||
| Number of New Stores | 0 | 12 | 15 | 20 |
| Sales per New Store | 0 | 9.5 | 10 | 10.2 |
| Interest | ||||
| Interest Income Rate | 0.70% | 1.00% | 1.50% | 2.00% |
| Interest Expense Rate | 5.60% | 4.20% | 4.60% | 5.00% |
| Other Information ($ millions) | ||||
| Cash and Equivalents | 100 | 300 | 500 | 225 |
| Short-Term Debt | 150 | 100 | 60 | - |
| Long-Term Debt | 320 | 220 | 120 | 175 |
| Complete the following just as we did in Project 2: | ||||
| Year 1 | Year 2 | Year 3 | ||
| Sales from Newly Opened Stores | $35.00 | |||
| Sales from Stores Opened Last Year | 78.5 | |||
| Existing Store Sales | 2800 | |||
| Total Sales | 2913 | |||
| Net Interest Expense (Inc) | 23.5 |
| ||
What needs to be shown is that the equation is in balance (assests + liabilities = equity). Also, as net income increases and in term leads to more store openings, there needs to be balance in the equation as far as this equation being offset.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
