Question

Problem 5-14 Comparing Investment Criteria 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 $1,650 $3,600 2,200 1,400 1,660 300 1,250 780 WN- 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

A YEAR WNPO B DE Board game cash flows cumulative cash flows pv @ 11% discounted cash flows $1,650.00 $1,650.00 1.0000 $1,650.00 $780.00 $870.00 0.9009 $702.70 $1,400.00 $530.00 0.8116 $1,136.27 $300.00 $830.00 0.7312 $219.36 26.04% NPV $408.33 IRR(B3:36) payback: 1.62 years 1+(870/1400) DVD cash flows cumulative cash flows pv @ 11% discounted cash flows -$3,600.00 -$3,600.00 1.0000 $3,600.00 $2,200.00 -$1,400.00 0.9009 $1,981.98 $1,660.00 $260.00 0.8116 $1,347.29 $1,250.00 $1,510.00 0.7312 $913.99 22.14% NPV $643.26 IRR(B13:B16) payback: 1.84 years 1+(1400/1660) YEAR 2 3 IRR

Board game DVD 1.62 1.84 b) Board game DVD $408.33 $643.26 Board game DVD 26.04% 22.14%

B Difference in cash flows year 1 2 3 Board game Cash flows -$1,650.00 $780.00 $1,400.00 $300.00 Incremental IRR DVD Cash flows -$3,600.00 $2,200.00 $1,660.00 $1,250.00 $1,950 -$1,420 -$260 -$950 18.66% IRR(D3:06)