You just graduated college with your Bachelors Degree and accepted a job offer at your dream company. You decided to celebrate by purchasing a Tesla Model S for $$104,490.$ You have a $720$ credit score, therefore you were able to get a $2\mathrm{.}9\%$ annual percentage rate $($APR$)$ on a $7$ year loan. You will be making monthly payments starting on July $1,2023.$ Using Excel, prepare a professional amortization schedule for the entire $7$ years. It must include the payment and the total amount of interest you will pay by month over the $7$ years. $($Hint: interest rates are annual, you must convert them to monthly and the periods must be in months, for example, how many months are in $7$ years$).$ The Excel cells must contain formulas when appropriate, I recommend cell referencing, and using both relative and absolute$.$ Use the PMT function for the payment. DO NOT use the PPMT or the IPMT functions.

B$8,,84,$ band$)$

$\backslash$table$[[4,$A$,,$c$,$D$,$E$,$F$,$G$,H,1],[1,$loan amount,,,,,,,,$],[2,$annual imerest c$$ate$,2,90\%,,,,,,,],[3,$Loan term $($years$),7,,,,,,,],[4,$loanterm $($months$),84,,,,,,,],[5,$monthly interst rate,$-$backd $12,,,,,,,],[6,,,,,,,,,],[?,$monthly parmens,,,,,,,,$],[$B$,$babs,FVALUEI,$3,,,,,,],[9,,,$s$,,,,,,],[10,,,,,,,,,]]$