Build spreadsheets to analyze the options available to RAINBOW PRODUCTS in the attached case.
Calculate, as requested in the Case, the Payback, NPV and IRR of each of the alternatives (A, B, and C) for your Concession Stand business. For NPV and IRR use the Excel functions built in, as you learned previously.
For calculating Payback, use free form, but make sure to demonstrate the payback calculation.
OFFER a Conclusion, and state your reasons in support of your conclusion(s). What should we do?
291-031 Investment Analysis and Lockheed Tri Star * * 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: c Incremental Cash Flows Project Add a New Window Update Existing Equipment Build a New Stand Rent a Larger Stand 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 Year 3 44,000 23,000 70,000 14,000 . Using the internal rate of return rule (IRR), which proposal(s) do you recommend? Using the net present value rule (NPV), which proposal(s) do you recommend? How do you explain any differences between the IRR and NPV rankings? Which rule is better? A B C D E F 1 r= Investment T=0 Year 1 Year 2 Year 3 (75,000) 44,000 44,000 44,000 (50,000) 23,000 23,000 23,000 2 15% 3 Add a New Window 4 5 Update Existing Equipment 6 7 Build a New Stand 8 9 Rent a Larger Stand 10 (125,000) 70,000 70,000 70,000 (1,000) 12,000 13,000 14,000 291-031 Investment Analysis and Lockheed Tri Star * * 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: c Incremental Cash Flows Project Add a New Window Update Existing Equipment Build a New Stand Rent a Larger Stand 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 Year 3 44,000 23,000 70,000 14,000 . Using the internal rate of return rule (IRR), which proposal(s) do you recommend? Using the net present value rule (NPV), which proposal(s) do you recommend? How do you explain any differences between the IRR and NPV rankings? Which rule is better? A B C D E F 1 r= Investment T=0 Year 1 Year 2 Year 3 (75,000) 44,000 44,000 44,000 (50,000) 23,000 23,000 23,000 2 15% 3 Add a New Window 4 5 Update Existing Equipment 6 7 Build a New Stand 8 9 Rent a Larger Stand 10 (125,000) 70,000 70,000 70,000 (1,000) 12,000 13,000 14,000
