Question

Wii Brothers, a game manufacturer, has a new idea for an adventure game. It can market the game either as a traditional board game or as an interactive DVD, but not both. Consider the following cash flows of the two mutually exclusive projects for the company. Assume the discount rate is 11 percent.

  

Year	Board Game			DVD
0	–$	900		–$	2,100
1		630			1,450
2		600			1,150
3		150			500

  

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.)

   

Answer 1

Solution :

a. The payback period for Project Board Game = 1.45 years

The payback period for Project DVD = 1.57 years

b. The NPV for Project Board Game = $ 264.22

The NPV for Project DVD = $ 505.27

c. The IRR for Project Board Game = 30.74 %

The IRR for Project DVD = 26.95 %

d. The Incremental IRR for the two projects = 24.17 %

Please find the attached screenshots of the excel sheet containing the detailed calculation for the solution.