This is question 2 of the homework assignment. We need to solve A), B), C), D), etc. that is shown in the excel. I am having trouble with the formulas.

Excel File Edit View Insert Format Tools Data Window Help 100% O Fri 6:54 PM a HW-invproc-stu-Summer2020 Q Search Sheet Home Formulas Data Review View 9+ Share V Insert Page Layout X fc F10 R s T U v w X 26 27 2) 28 A 40-year old person planning for retirement anticipates the need for his/her retirement assets to generate $70,000 per year once he/she stops working. a) If this person expects to have a "need for earthly currency" for 20 retirement years, how much does his/her retirement assets have to be worth at retirement age, if the portfolio of assets is expected to earn 4.5% per year and he/she expects to leave nothing to heirs? 29 30 31 N I PMT PV FV 5