Hello, Can you help me solve this problem using excel? I am having problems with the accuracy of NPV in excel using =NPV(Rate,Value 1, Value 2, etc.

Jeff wants to retire in 15 years when he turns 65. Jeff wants to have enough money to replace 75% of his current income less what he expects to receive from Social Security at the beginning of each year. He expects to receive $20,000 per year from Social Security in todays dollars. Jeff is conservative and wants to assume a 6% annual investment rate of return and assumes that inflation will be 4% per year. Based on his family history, Jeff expects that he will live to be 95 years old. If Jeff currently earns $100,000 per year and he expects his raises to equal the inflation rate, approximately how much does he need at retirement to fulfill his retirement goals? Answer is: $2285172

I used my 10BII Calculator

Step #1 - NPV at Time Period Zero

0 orange shift Cfj

0 orange shift CFj

14 orange shift Nj

55,000 orange shift CFj

30 orange shift Nj

1.06 divide 1.04 = - 1 x 100 = Orange shift NPV

Answer: 953,522.61

Step #2 - FV of Account at Retirement

15 N

6 I/YR

953,622.61 PV

0 PMT

FV

Answer: 2,285,172.41