$5.(0-6$ pts$)$ Based on the values in row $6,$ write an Excel function in cell C $6$ to calculate the annual interest rate of the loan for the Ford Windstar. $($Hint: Use the RATE$()$ function and multiply the result by the number of periods per year to get the annual interest rate. No $\backslash (\backslash$$ $\backslash )$ are needed since you are not copying down or across here.$).=$RATE $,,,0)*6.(\backslash (0-6\backslash$mathrm$\{$pts$\}\backslash ))$ The salesman has told you that for only $\backslash (\backslash$$ $320\backslash )$ a month and no money down you can own a Mustang. The loan has an annual interest rate of $\backslash (6\mathrm{.}2\backslash \%\backslash )$ compounded monthly and is payable over the next $4\mathrm{.}5$ years. The salesman, however, failed to mention the actual selling price of the vehicle. Write an Excel function in cell B$7$ to calculate the selling price $($which is also the loan amount since the down payment is $\backslash (\backslash$$ $0\backslash ))$ of this vehicle. $($Hint: Use the PV$()$ function here. No $\backslash (\backslash$$ $\backslash )$ are needed since you are not copying down or across here.$).\backslash (=$P V$(\backslash$quad $/\backslash ),,0)7.(0-7$ pts$)$ Your great uncle Zeus has died unexpectedly and left you a bank CD in his will. The CD was purchased $10$ years ago for $\backslash (\backslash$$ $12,000\backslash )$ and pays $\backslash (6\backslash \%\backslash )$ per year compounded annually. Write an Excel formula or function in cell J$3,$ which can be copied down to the cells J$4$:J$7,$ to determine $($TRUE or FALSE$)$ if you have enough money to purchase this car without any financing. You will not have any cell references for the financial function so just hard$-$code the numbers for it$.($Hint: Use the FV$()$ function here and check its result to see if it is greater than or equal to the selling price for each vehicle. Remember to check if you need a $\backslash$$ in one or more of the numbers in the cells used since you are copying this down.$).\backslash (=$F V$(\backslash ),,0.$