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 the relationship between an antigen, an antibody, and the plasma membrane?
- Hi, can you show me step by step how to solve this differentiation equation and which rule to apply? Thank you!
- Should organizations/providers be required to turn over the minutes, discussions or decisions of ethical committees?