The answer is -4.46% but I don't know how to do the formula on excel. please help

No answer yet for this question. Ask a Tutor

Question:

The answer is -4.46% but I don't know how to do the formula on excel. please help me The formula is "RATE(4,0,-12377500,10311500,0) * 1 " but it doesn't work on excel.

Image transcription text

W Cours W Excel2 M Quest x1 Integr x Int X G Future Cours G Althou C Altho C Please C Altho C Altho C Altho C Altho + X C https://ezto.mheducation.com/ext/common/excelonline/excel-tool.html?Q_13252727562093226_ans11 Excel McGraw Hill Excel Question - Saved Search (Alt + Q) File Home Insert Draw Formulas Data Review View Help Editing Comments < elling Eza Workbook Statistics L& Check Accessibility Show Changes New Comment Notes Resume Protection Be Manage Protection . . . B14 V X V fx A B C D E F G H K L 3 McGraw Hill X 4 Input area: Future value $10,311,500 Check Answers Present value $12,377,500 8 Years Check My Work 9 10 (Use cells A6 to B8 from the given information to complete this question.) 11 Legend 12 Output area: Graded cell: Leave blank if no answer is 13 needed. 14 Rate 15 Scratchpad: Use as a non-graded 16 workspace 17 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 19 Nothing in this area will be graded, but it will be submitted with your assignment. 20 21 < E Graded Worksheet + Save and Return to Assignment Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% + 75 F Q Search 4:27 PM ENG Heavy rain soon D 9/26/2023