can you show me how to do this in excel. where exaclty goes where im the cells. thanks

P11:1M change the initial cash outlay to 510 mon and the annual cash intown to $2,400,000 per year. Also include Profitability Index Pil calculation for all four ratos) Datingo rewictory to produce un babas juhtub.000.000 de hecho hiye Calate the prolongach of the following 10 ti 11 1 12 IN 13 14 15 16 I 10 Year CE 11 20 1 21 2 21 23 24 5 25 5 25 27 28 ION- 29 - 30 31 Mate BOP H- - ven TO Future Cat NPV functional for yean 16 Add amount to the FOFPV a year amount FOPV/Year Thirt make the Year amount positive rumber-see pace 340 341 TOP- 40 - 41 42 43 TOP 4. 46 4116 P11-1M PIN P11.12 PIT-22M P11-23M + Ready MacBook Pro M P Q 2 P11-1M (change the initial cash outlay to $10 million and the annual cash Inflows to $2,400,000 per year. Also include Profitability Index [PI calculation for all four rates) Dowing Sportswear is considering building new factory to produce aluminum baseball bat. This project would require an inch outlay to $10,000,000 and would generate annual net Chinows of $2,400,000 per year for years Calculate the promets NPV and wing each of the following discount rates 10 2.9% D. IN 11 CON 12 d. 15 13 14 15 16 17 10 Year Cost 19 20 1 21 2 22 3 23 4 24 5 25 6 26 27 Hate Elven 28 FOFPV TOFFuture Cat Flow, NV function in Excel for years 1-6 29 NY- As the amount from the Focal year amount 30 - FOFPV/Year Chint make the Year amount a positive number see page 340 341 31 32 Rate 33 FOP 34 NIV 35 H 36 37 Rate 38 FOP 39 NPV 40 - 41 42 Rate 43 FOFPV 44 NOVE 45 46 011 P11-1M P11.3M P11-12M P11-22M P11-23M +