1) An input worksheet - this entire worksheet is devoted to all your hard-coded numbers and information - the rest of your model should be running with functioning formulas, no hard-coded numbers or errors.
2) Income Statement - run by formulas, on its own worksheet, for at least the next 10 years
3) Balance Sheet - run by formulas, on its own worksheet, for at least the next 10 years
4) Cash Flow Statement - run by formulas, on its own worksheet, for at least the next 10 years
5) Project Ratios - run by formulas, on its own worksheet, for at least the next 10 years
a. This will help with your analysis of the project's validity.
b. Examples: ROI, ROE, Debt-to-Equity, any other ratios you feel are important
a. Should the company move forward with this project? Is it a smart financial decision?
b. Are there any areas of concern? Or areas that if adjusted could be better for the company's bottom line?
If the project is not viable and shouldn't be pursued, what are the major reasons why the company should not move forward with the project?
Important notes to consider:
· Use straight line depreciation over the life of the asset.
· Use the current Bank of Canada Prime borrowing rate as your interest rate for all debt financing, and maintain that same rate for all of your analysis.
· Did you taking into account inflation over the next 10+ years? *Most companies use CPI (Consumer Price Index) as a peg for their inflation rates.
· Did you take into account tax? The company is operating in Alberta that has a combined Provincial and Federal tax rate of 27%. Assume all tax is due at the end of the fiscal year and there is no accrual. You are not operating as a small business, therefore, there are no tax advantages.
Projected Capital Cost for the new arena: $555 Million Canadian
Asset Life = 35 Years
Cost of new arena to be split 3 ways equally - Municipal Government, Owners, Arena Users (ticket surcharge for hockey or other events)
You will model this from the position of owners, meaning that 2/3 of the project cost will be put up by you, the other 1/3 will be covered by the City but they would hold a 1/3 ownership interest in the property. The 2/3 capital cost will be from 100% debt financing. Only half of which will only receive offsetting revenue (ticket surcharge).
Total construction time is 1 year, then the arena will be ready to host events, earn revenue, and start depreciation.
Assume 40 home games annually (build the model conservatively - meaning any post season income is extra)
Recently Asked Questions
- What is user application development (UAD)? Discuss the advantages and disadvantages of UAD
- Identify some specific ethical or social responsibility issues that might be faced by small-business managers and employees in each of the following areas:
- What is the difference between network monitoring and application performance monitoring? Why is it important to provide both?