DONT GIVE ME THAT FORMULA CAUSE IT DOESNT WORK GIVE IT TO ME IN AN EXCEL SHEET OR FORMULA WITH PROOF I WILL MARK IT WRONG. THE RIGHT ANSWER IS BELOW HOW CAN I USE EXCEL

Problem $2$:

You are offered the opportunity to put some money away for retirement. You will receive $6$ annual payments of $$20,000$ each beginning in $25$ years. How much would you be willing to invest today if you desire an interest rate of $9\%?$

Solution:

Cash$-$flow key method

CF$0=0$; CO$1=0$; F$01=24$; CO$2=20,000$; FO$2=6$; CPT NPV I$(9)$ NPV $($$$11,340\mathrm{.}85)$