Initial investment expected cash flows

Initial investment expected cash flows

Attach an Excel file to show your computations for Questions 1 and 2.

  1. The table below gives the initial investment and expected cash flows over the next five years for two different projects. Assume that the industry you are in expects a return of 10%, which you use as the discount rate in net present value (NPV) calculations and as the required rate of return for purposes of deciding on projects. Also, assume that management only wants to invest in projects that pay off within four years.

For each project, compute the payback period, NPV, and internal rate of return (IRR). Then explain whether each project should be accepted based on these three criteria.

Project A

Project B

Initial Investment

$40,000

$28,000

Year

Cash Flows

1

$10,000

$10,000

2

$10,000

$13,000

3

$10,000

$5,000

4

$10,000

$5,000

5

$10,000

$6,000

  1. Suppose you are planning on becoming a vendor at the arena where your favorite sports team plays. You are trying to decide between opening up a souvenir stand selling T-shirts, caps, etc., with your sports team’s logo or opening up a hot dog and beer stand. It is more expensive to open up the hot dog and beer stand because you need to purchase a license to serve alcohol and you need to spend money to comply with health department regulations. Revenue from the souvenir stand is likely to be unpredictable because fans of your favorite team tend to want to purchase hats and T-shirts only when the team is winning. Revenue from hot dogs and beer seem to be a little more steady since fans want to eat and drink regardless of whether the team is winning.

    Below is a table with the initial investment cost of each type of stand and the annual payments you expect over the next five years. The annual payments will be different depending on how well your team does. Therefore, you will estimate how much cash flow you will get depending on whether your team does better than expected (optimistic), the same as the past few years (most likely), and worse than expected (pessimistic). Use a discount rate of 8%.

Based on the table below, answer the following items:

  1. Calculate the net present value (NPV) for each type of stand under each of the three scenarios. Calculate the range of possible NPV values for each type of stand.
  2. Based on your answer to A) above and your own guesses about how well you think your favorite team will do over the next five years, which type of stand would you rather invest in?

Souvenir Stand

Hot Dog and Beer Stand

Initial Investment

$100,000

$150,000

Annual Cash Inflows (5 Years)

Outcome

Pessimistic

$30,000

$50,000

Most likely

$50,000

$60,000

Optimistic

$70,000

$70,000

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.