Please show formulas so I can better understand this.

C5 Creating a NPV Profile - KO 3 Discount Rate: Make sure that the Pro- Forma NPV on the "ProForma" tab is set Create a NPV profile belom by creating a scatter chart of rows 11& Cells B5 to B9 in this worksheet can link to cells C32 through G32 Calculate the present value of cash flows in columns C through G u NPV in row 11 is simply the sum of rows 5 through 9 for each Rows 11 &12 are used to create the NPV profile graph below Do not forget the labels in your NPV profile graph CF ) PVICE) PV(CE PV CE) .060,000.00) $825,184.38 $872,990.33 $916,928.98 2,405,751.93 10 11 NP 12 Discount Rate: 13 15 18