Please help me with thecorrect 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)

Calculating loan payments - Excel ? X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Colibri - 11 - A" A Paste BIU- B- &- A- Alignment Number Conditional Format as Cell Cells Editing Formatting Table . Styles ~ Olpboards Font Styles A1 X V G A D EF GHI K You want to buy a new sports coupe for $79,500, and the finance office at the dealership has quoted you an APR of 5.8 percent for a 60-month loan to buy the car. What will your monthly payments be? What is the effective annual rate on this loan? Cost of Car $ 79,500 Discount rate 5.8% # of years 5 # of times compounded per year 12 12 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 14 Payment 15 16 Effective interest rate 17 18 19 Sheet1 READY + 100% Attempt() HintYou are planning to save for retirement over the next 30 years. To do this, you will invest $850 per month in a stock account and $350 per month in a bond account. The return of the stock account is expected to be 10 percent, and the bond account will pay 6 percent. When you retire, you will combine your money into an account with a return of 5 percent. How much can you withdraw each month from your account assuming a 25-year withdrawal period? Monthly stock investment 850 Monthly bond investment 350 Stock return 10% Bond return 6% 10 Years to save 30 11 Retirement return 5% 12 Retirement years 25 13 Months per year 12 14 15 16 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 17 18 Stock account value at retirement 19 20 Bond account value at retirement 21 22 Total account value at retirement 24 Monthly withdrawal 25 25 27 Sheet1 + 10014 READY Attemptly Hint