Question: Please show all intermediate steps and formulas used. Use excel to complete the problem. Mario Brothers, a game manufacturer, has a new idea for an
Please show all intermediate steps and formulas used. Use excel to complete the problem.
Mario Brothers, a game manufacturer, has a new idea for an adventure game. It can either market the game as a traditional board game or as a PC game, but not both. Consider the following cash flows of the two mutually exclusive projects. Assume the discount rate for both projects is 8 percent. Year Board Game PC -$ 1.750 -$3,800 1 800 2,300 2 1,500 1,680 3 320 1,350 OFNM a. What is the payback period for each project? (Do not round Intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b. What is the NPV for each project? (Do not round Intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) c. What is the IRR for each project? (Do not round Intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) d. What is the incremental IRR? (Do not round Intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) a. b. years years Board game payback PC game payback Board game NPV PC game NPV Board game IRR PC game IRR Incremental IRR c. 996 % d. 96
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
