need to use time value calculations in excel for areas in red

Annuity Req 2 New(1) (3) - Excel Eeview View Developer Help Power Pivot Tell me what you want to do 2. Wrap Text Merge & Center + Alignment $ Conditional Formats Fong Tables Insert Delete FC Cell ty 719.01 You win the lottery and are offered either $240,000 per year at the end of each year for 20 years, or a lump sum of $3,800,000 paid 1 year from today. If market interest rates are only 2.4%. which option should you choose? How much do you gain by making the correct choice? 22,317.71 24% for annuity for lump sum 20 2 40.000 3.800.000 per year. arn 42% ve upon PV of Annuity Option: PV of Lump Sum Difference (gain) Choice 1.782 61