Please help me with the correct excel function formula

I understand how to do it manually, but I don't understand excel

Only excel formula, please. For example = Rate(D8-D9 ,,D6,D7)(both pictures are related to the question)

FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In - 12 - A" A Paste BIU- B- - A- Alignment Number Conditional Format as Cell Editing Formatting . Table. Styles = Clipboard ant Styles D13 X =PV[D8,D7,-D6] A C D E G H Book Suppose you are going to receive $15,800 per year for five years. The appropriate interest rate is 7.9 percent. Print a. What is the present value of the payments if they are in the form of an ordinary annuity? What is the present value if the payments are an annuity due? b. Suppose you plan to invest the payments for five years. What is the future value if the payments are an ordinary annuity? What if the payments are an annuity due? rences Annual payment $ 15,800 # of years 5 Interest rate 7.9% 10 11 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 12 13 a. PV of ordinary annuity $ 63,251.44 14 15 PV of annuity due 16 17 b. FV of ordinary annuity 92,507.64 Sheet1 READY LOT 1007 Attempt(s) 0/3 HintWeek 7: Assignment FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 5 Aris - 12 . A A Paste Alignment Number Conditional Format as Cells Edging Formatting . Table- 5 Styles Fort 12 5 D13 X v =PV[DB,D7,-D6) points C # of years 5 Interest rate 7 9% Complete the following analysis. Do not hard code values in your Print 11 calculations. All answers should be positive. 12 13 a. PV of ordinary annuity $ 63 251.44 References 14 15 PV of annuity due 16 17 b. FV of ordinary annuity $ 92,507.64 18 19 FV of annuity due 20 21 22 25 Sheeti + 1001 Hint