2. Suppose you own a concession stand that sells hot dogs, peanuts, popcorn, and beer at...

Transcribed Image Text:

2. Suppose you own a concession stand that sells hot dogs, peanuts, popcorn, and beer at a ball park. You have three years left on the contract with the ball park, and you do not expect it to be renewed. Long lines limit sales and profits. You have developed four different proposals to reduce the lines and increase profits. The first proposal is to renovate by adding another window. The second is to update the equipment at the existing windows. These two renovation projects are not mutually exclusive, you could take both projects. The third and fourth proposals involve abandoning the existing stand. The third proposal is to build a new stand. The fourth proposal is to rent a larger stand in the ball park. This option would involve $1,000 in up-front investment for new signs and equipment installation; the incremental cash flows shown in later years are net of lease payments. You have decided that a 15% discount rate is appropriate for this type of investment. The incremental cash flows associated with each of the proposals are: Project Add a New Window Update Existing Equipment Build a New Stand Rent a Larger Stand . . • Incremental Cash Flows Investment -$75,000 -50.000 -125,000 -1,000 Year 1 44,000 23,000 70,000 12,000 Year 2 44,000 23,000 70.000 13.000 Using the internal rate of return rule (IRR), which proposals) do you recommend? Using the net present value rule (NPV), which proposalls) do you recommend? How do you explain any differences between the IRR and NPV rankings? Which rule is better? Year 3 44,000 23,000 70,000 14,000 2. Suppose you own a concession stand that sells hot dogs, peanuts, popcorn, and beer at a ball park. You have three years left on the contract with the ball park, and you do not expect it to be renewed. Long lines limit sales and profits. You have developed four different proposals to reduce the lines and increase profits. The first proposal is to renovate by adding another window. The second is to update the equipment at the existing windows. These two renovation projects are not mutually exclusive, you could take both projects. The third and fourth proposals involve abandoning the existing stand. The third proposal is to build a new stand. The fourth proposal is to rent a larger stand in the ball park. This option would involve $1,000 in up-front investment for new signs and equipment installation; the incremental cash flows shown in later years are net of lease payments. You have decided that a 15% discount rate is appropriate for this type of investment. The incremental cash flows associated with each of the proposals are: Project Add a New Window Update Existing Equipment Build a New Stand Rent a Larger Stand . . • Incremental Cash Flows Investment -$75,000 -50.000 -125,000 -1,000 Year 1 44,000 23,000 70,000 12,000 Year 2 44,000 23,000 70.000 13.000 Using the internal rate of return rule (IRR), which proposals) do you recommend? Using the net present value rule (NPV), which proposalls) do you recommend? How do you explain any differences between the IRR and NPV rankings? Which rule is better? Year 3 44,000 23,000 70,000 14,000

Answer rating: 100% (QA)

Calculate NPV and IRR in excel using the formulae as follows NPV NPV15C2E2 Init... View the full answer