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)

FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Aria -AA % Paste BIU. A- Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D15 v Se B C E F G H 1 . 4 5 6 $ No Annual payment # of years Interest rate 15,800 5 7.9% 8 10 11 12 13 14 15 16 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. a. PV of ordinary annuity $ 63,251.44 PV of annuity due b. FV of ordinary annuity 17 18 19 FV of annuity due 20 21 22 23 Sheet1 Lol LI READY Attempts) Step: Use the PV function to calculate the present value. 100% Hint 1/3