verify the answers with Excel

The insurance settlement pays you $50,000 in one year, Growing at 6% per year for a total of 10 years The discount rate is 4% What is the value today? PMT_* 47169.81 PMT NPER FV R G 50000 10 0 0.04 0.06 PV 524.581.34 pv=50000/(0.04-0.06)+(-0.2098) 10 PV = 48076.92 + 49001.48 + 49943.82 + 50904.27 + 51883.2 + 52880.96+ 53897.9 + 54934.4 + 55990.83 + 57067.57 = 524581.34 PV = 48076.92 + 49001.48 + 49943.82 + 50904.27 + 51883.2 + 52880.96+ 53897.9 + 54934.4 + 55990.83 + 57067.57 = 524581.34 period payment pv of pmt 1 50000 48076.92 2 50000 49001.48 3 50000 49943.82 4 50000 50904.27 5 50000 51883.2 6 50000 52880.96 7 50000 53897.9 8 50000 54934.4 9 50000 55990.83 10 50000 57067.57 sum 524581.4