Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part A. You goal is to perform an NPV & investment criteria analysis of a Tim Horton's franchise in NS. Assume $500,000 in annual sales

image text in transcribed

Part A. You goal is to perform an NPV \& investment criteria analysis of a Tim Horton's franchise in NS. Assume $500,000 in annual sales in year 1 growing linearly to $1,500,000 in sales in year 5 and staying flat after that, build a sales-driven model. You will have to construct a hypothetical income statement and estimate cash flows generated by the business. After you perform NPV analysis, internal rate of return, estimate payback, discounted payback, profitability ratio. Assumptions 2 : - further, the following information was gathered from Tim Hortons website regarding costs of starting a franchise itn Canada: - royalty fee of 4.5% of gross sales - rental fee: your rental fee is 170,000 . Assume that this is fixed cost that does not vary with sales - advertising fee of 4% of gross sales - working capital investment of $50,000 and equipment purchase is $450,000 - at least two partners; assume annual salary of $40,000 per partner. Further, more data was collected from other sources: - assume cost of goods sold of 60% of gross sales - assume straight-line depreciation of 10% of total itnvestment on equipment purchase of $450,000 - corporate tax rate is 15.5%. Losses, if any, are tax deductible over 20 -year period 2 Additional cost of capital assumptions: - assume cost of debt of 7% - cost of equity is estimated using yield-plus-risk-premium approach; use historical or implied equity risk premium - debt-to-equity ratio equals one (1.0) You may use template on the next page for youx estimates. Note: I built an excel worksheet with four tabs - assumptions, NPV \& other investment criteria, NPV under inflation, and tax loss carryforwards. Part B. Perform NPV analysis only, assuming inflation rate of 4% a year. Note that some of your entries from part A will be affected by inflation directly, some other through sales, and yet the third category will remain unaffected. Part A. You goal is to perform an NPV \& investment criteria analysis of a Tim Horton's franchise in NS. Assume $500,000 in annual sales in year 1 growing linearly to $1,500,000 in sales in year 5 and staying flat after that, build a sales-driven model. You will have to construct a hypothetical income statement and estimate cash flows generated by the business. After you perform NPV analysis, internal rate of return, estimate payback, discounted payback, profitability ratio. Assumptions 2 : - further, the following information was gathered from Tim Hortons website regarding costs of starting a franchise itn Canada: - royalty fee of 4.5% of gross sales - rental fee: your rental fee is 170,000 . Assume that this is fixed cost that does not vary with sales - advertising fee of 4% of gross sales - working capital investment of $50,000 and equipment purchase is $450,000 - at least two partners; assume annual salary of $40,000 per partner. Further, more data was collected from other sources: - assume cost of goods sold of 60% of gross sales - assume straight-line depreciation of 10% of total itnvestment on equipment purchase of $450,000 - corporate tax rate is 15.5%. Losses, if any, are tax deductible over 20 -year period 2 Additional cost of capital assumptions: - assume cost of debt of 7% - cost of equity is estimated using yield-plus-risk-premium approach; use historical or implied equity risk premium - debt-to-equity ratio equals one (1.0) You may use template on the next page for youx estimates. Note: I built an excel worksheet with four tabs - assumptions, NPV \& other investment criteria, NPV under inflation, and tax loss carryforwards. Part B. Perform NPV analysis only, assuming inflation rate of 4% a year. Note that some of your entries from part A will be affected by inflation directly, some other through sales, and yet the third category will remain unaffected

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Banker To The World

Authors: William Rhodes

1st Edition

0071704256, 978-0071704250

More Books

Students also viewed these Finance questions

Question

6. How do histories influence the process of identity formation?

Answered: 1 week ago