Please answer the below in Excel format. Please explain and show all steps. Thank you in advance

hw chapter 7, 8 Excel Home lnsen Draw Page Layout Formulas Data \"\"I.' ~ _ F _ . '7 2-,, . \" _' . an _' S lit 1. , /.r:W 5108 0 Side Formula Bar Q [ 7) Lq H-L p I . 2 ' V \\ A , \"7 Hide Bjnchronous Scrolling ormal Page Brea ustom V Gridlines Headin 5 Zoom 100% Zoom to New rrange Heeze "-1.\". ' ,4?qu . _' ' Preview :, Views E 9 Selection Window All 33:55 ,, 4 c: j. H, sEIVJindOWPOSIUOI Workbook Views Show Zoom window ~- El ~~$v= _'_ m ' 1| ' 2 l A j B L c l D L E q718 , ' Computing net present value. Hammersmith Homes is comsidering four possible housing 3 development projects, each requiring an initial investment of $5,000,000. The cash inflows ,, 7 ' rorn each of the projects follows: ear project A project B Project c project d $0 -5,000,000 -5,000,000 5,000,000 -5,000,000 ' 1 2000000 4000000 0 1000005\" 2 2000000 2000000 0 2500000\" 3 2000000 2000000 0 3000006\" 4 2000000 1000000 0 2500000 5 2000000 1000000 10000000 10000007 _ >>>>> ' , n only one project; which shouldiitichoge': project is superior to the others