Share Comments Insert v AutoSave OF OF A A SU: Rivera_Berk_DeMarzo_Harford_Problem_8-28_Start Save As Home Insert Draw Page Layoure Formulas Data Review View Tell me Times New Roman v 14 ~ A Wrap Text General Paste BIU B o v A Merge & Center Conditional Format Cell Formatting as Table Styles Office Update To keep up-lo-date with security updates, fixes, and improvements, choose Check for Upciales. C12 fx Y 8 Delete Y Sort & Filter Format Find & Select Analyze Data Sensitivity Check for Updates A B C E F . H L L M N N P a R 5 T U V W X 3 Complete the steps below asing cell referencer lo giver dara ar previous calculations. In some cases, a simple cell reference is all wou need. Yo copy/paste a formula acres a row or down a coluna, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used the directions will specify the use of that function. Da war type in numerical data into a cellar function. Instead, make a reference to the cell in which the data is found Make your computations only in the bine cells highlighted below. Ir all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, wally the Given Data section. You are choosing between two projects, but can obly take one. The cash flows for the projects are given in the table below: a. What are the IRRs a' the two projects! b. If your discount me is 5%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently? 0 1 2 3 4 10 11 Project Project $ $ -50 S -100 S 25 20 S 20 S 20 S 50 S 15 60 40S 12 13 u. What are the IRR saf' the two projects? 14 15 16 IRR project A TRR project B 17 12 b. If your discount rate is 5%, what are the NPVs of the two projects? ? 16 Discount rate 5% 21 NPV preject A NPV project c. The difference in the initial investment causes NPV and IRR to rank the projects differently, 20 Is this statement True False? 8-28 + Select destination and press ENTER pr chacar Paste 92%