View the step-by-step solution to:

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

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.


 

The Project


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

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question