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)

? 3 - 6 X Discounted cash flow analysis - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign in Calibri M Paste BIU- % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A1 X A 6 c D E F G H K 1 2. 3 If the appropriate discount rate for the following cash flows is 6.18 percent per year, what is the present value of the cash flows? 4 5 6 Discount rate 6.18% 7 8 9 Cash flow 2,480 10 Year 1 $ 2 3 4 3,920 2,170 Complete the following analysis. Do not hard code values in your calculations. 12 13 14 15 16 17 18 19 20 21 Present value Sheet1 3 HHH 100% READY Attempt(s) Hint