00 10 100 2500 10 110 2500 10 120 2500 10 130 2500 10

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: C Base WACC +10% WACC +20% WACC +30% 90 $25.00 10% 100 $25.00 10% 110 $25.00 10% 120 $25.00 10% 130 $25.00 10% 100 $17.50 10% 100 $20.00 10% 100 $22.50 10% 100 $25.00 10% 100 $27.50 10% 100 $30.00 10% 100 $32.50 10% 100 $25.00 7% 100 $25.00 8% 100 $25.00 9% 100 $25.00 10% 100 $25.00 11% 100 $25.00 12% 100 $25.00 13% $-19.25 6.53% 7.91% 3.48 Changing Cells: Sales 100 70 80 Salvage $25.00 $25.00 $25.00 WACC 10% 10% 10% Result Cells: NPV $-4.03 $-49.68 $-34.46 IRR 9.28% 0.83% 3.71% MIRR 9.57% 4.32% 6.16% Payback 3.30 3.93 3.69 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray. $-4.03 9.28% 9.57% 3.30 $11.19 11.97% 11.16% 3.13 $26.40 14.62% 12.69% 2.97 $41.62 17.21% 14.16% 2.79 $-7.10 8.72% 9.24% 3.31 $-6.08 8.91% 9.35% 3.31 $-5.05 9.10% 9.46% 3.30 $-4.03 9.28% 9.57% 3.30 $-3.01 9.47% 9.68% 3.29 $-1.98 9.65% 9.79% 3.29 $-0.96 9.83% 9.90% 3.28 $13.51 9.28% 8.36% 3.30 $7.45 9.2...
View Full Document

This homework help was uploaded on 02/16/2014 for the course BUS 330 taught by Professor Ned during the Winter '13 term at American University in Bulgaria.

Ask a homework question - tutors are online