
A C YEAR pv @ 18% Cash flows -$100,000,000 $30,000,000 $30,000,000 $30,000,000 $30,000,000 $30,000,000 $30,000,000 $30,000,000 $50,000,000 26.13% IRR(B3:39) 0.84746 0.71818 0.60863 0.51579 0.43711 0.37043 0.31393 0.26604 NPV Discounted cash flows $100,000,000 $25,423,729 $21,545,533 $18,258,926 $15,473,666 $13,113,276 $11,112,946 $9,417,751 $13,301,908 $27,647,735.99 NPV IRR Project's payback period $27,647,736 26.13% 3.33 100000000/30000000