Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You own a small bagel store in a downtown Eugene location. Your tandoori-baked bagels are a big hit, so you are considering opening a second

You own a small bagel store in a downtown Eugene location. Your tandoori-baked bagels are a big hit, so you are considering opening a second store in a local neighborhood where many Indian expatriates live.

You estimate that leasing and equipping the new store will cost $100,000. (Assume that you can secure this capital somehow.) In the first year the store will produce profits (positive cashflow) of $10,000. In years 2 through 5 you expect it will have no real competition, so profits will grow at a 10% annual rate. But as the novelty wears off and competitors enter your local market, profit growth will slow: to 6% annually in years 6 through 10, and to 2% annually in years 11 through 15. You believe that by year 15 you will wish to exit the business, either because the market will become crowded, or because you are a serial entrepreneur and you will want to chase a different dream.


Record your answers to the following computational questions.

Base case analysis (most likely scenario)

  1. Without doing any significant calculations, what would you expect the payback period for this investment to be (roughly, within one year)?
  2. What is the computed payback period (within 0.5 years)?
  3. What is the return on investment (RoI) over the payback period?
  4. What is the return on investment (RoI) over the full 15 years?
  5. Because you are a new and small business, investors expect a high return to compensate them for their risk, so your cost of capital is considerable. What is this investment's NPV over 15 years at a 15% discount rate?
  6. At a 15% DR, should you go forward with the new store?
  7. Say you are able to convince your investors that your company isn't so risky, and you get them to drop their discount rate—say to the cost of capital of many large cap stocks. What is the NPV at a 10% DR?
  8. Should you go forward with the project at a 10% DR?
  9. Within a 0.1% tolerance, what is the internal rate of return (IRR) of this project?


Pessimistic scenario

  1. The above answers were under your "best guess" assumptions about the store's future profit growth. For this and the next two questions, redo your calculations under "pessimistic" assumptions, assuming that the store's profits do not grow at all (i.e., remain at $10,000 per year for fifteen years.) What is the NPV at a 10% DR now?
  2. What is the project's IRR? 
  3. How does this IRR compare with the cost of capital for a small business?


Optimistic scenario

  1. Finally, try a more optimistic assumption. For this and the next two questions, assume that from a year 1 cashflow of $10,000, profits grow each year at 10% throughout the full 15 years. What is the project's NPV at a 15% DR?
  2. What is its NPV at a 10% DR?
  3. Within 0.1%, what is its IRR?

Step by Step Solution

3.52 Rating (159 Votes )

There are 3 Steps involved in it

Step: 1

Base Case Analysis Without calculations the payback period would likely be within 2 years This is based on the initial cost of 100000 and the firstyea... 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

International Business The Challenges of Globalization

Authors: John J. Wild, Kenneth L. Wild

7th edition

133063003, 978-0133401776, 133401774, 978-0133063004

More Books

Students also viewed these Finance questions

Question

How does the concept of hegemony relate to culture?

Answered: 1 week ago

Question

What is the role of government in a market economy?

Answered: 1 week ago