2.Now calculate the lump sum you would need today under the 3 scenarios. In other words, calculate for PV using the 5% return over 20, 30 and 40 years. You will include a payment since the only payment is the lump sum you need today to reach the $1,000,000 in 20, 30, and 40 years. In this case, be sure to set the compounding periods to annual. You are calculating 3 amounts.