VPV in Excel® Input cash flows for initial outlay and free cash inflows in cells A1 to A6. In cell A7 type the following formula: =A1+npv(.15,a2:a6) Excel will give the NPV $764 SJTU ACEM Instructor:Tangzongming 2014 spring 11-10NPV in Excel  Input cash flows for initial outlay and free cash inflows in cells A1 to A6.  In cell A7 type the following formula: =A1+npv(.15,a2:a6)  Excel will give the NPV = $764 SJTU ACEM Instructor:Tangzongming 2014 spring 11-10