Please Show Work/ Calculations
Question #1 NPV (3) A. Which cash flow below generates the largest NPV? Largest IRR? What is the value of the largest NPV? (3) B. Which cash flow below generates the least NPV? Least IRR? What is the value of the IRR? (2) C. Name two KEY differences between the NPV cited in A&the NPV cited in B? l.e. explain what forces were at play that caused one to be the largest NPV and the other to be the least NPV? (2) D. If you were the business owner, which cash flow (CF1 through CF10) would you prefer, assuming you can replicate the investment as many times as $1,000,000 in capital can cover? Initial Investment YRO MARR YR1 YR2 YR3 YR4 YRS YR6 YR7 NPV IRR CF1 | 17% | -$400,000.00 | $147,216.40 | $218,129,49 | $210,904.66 | $292,567.57 |$394,849.36| $394,849.36 | $394,849.36 NPV1/IRRI CF2 | 8% |-$1,000,000.00| $141,327.74 | $209,40431| S202,468.47 | S280,864.87 |$379,05539| $379,055.39 |$379,055.39 NPV2/IRR2 CF3 | 25%-$1,000,000.00| S852,000.00 | $279,055.22 | $180,456.00 | $174,955.46 |$372,525.05 | $560,030.89 |$509,603.89|NPV3/IRR3 CF4 20% $500,000.00 $176,659.68 $261,755.39 $253,085.59 $351,081.08 $473,81923 $473,819.23 $473,819.23 NPV4 /IRR4 CF5 | 21% | -$400,000.00 | $117,920.34 | $174,721.72 | S168934.63 | S234,346.62 |5316,27434| $316,274.34 | $316,274.34|NPV5/IRRS CF6 10$5,000.00$3,018.76 $4,472.88$4,324.73 $5,999.27$8,096.62 $8,096.629,096.62 NPV6/IRR6 CF7 | 10% | -$1,000.00 | $70,663.87 | $104,702.15 | $101,234.23 | $140,432.43 |$189,527.69| $189,527.69 | $189,527.69 NPV7/IRR7 CF8 22%$10,000.00 $141,327.74 $209,404.31 $202,468.47 $280,864.87 $379,055.39 $379,055.39 $379,055.39 NPV8 IRR8 CF9 17%$250,000.00 $132,494.76 $196,316.54 $189,814.19 $263,310.81 $355,364.42 $355,364.42 $55,364.42 NPV9/IRR9 CF10| 20% | -$425,000.00 | -$509,603.89 | $560,030.89 | $372,525.05 | $174,955.46 |$180,456.00 | $279,055.22 | $352,000.00|NPV10/1RR10