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 $($see picture above$)$ 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. DO NOT use an Excel Template, you must create this yourself.

Deliverables: Two files. The first one will be the professional Excel Spreadsheet. The second one will be the same

spreadsheet but with "show formulas" turned on$.$ These should be saved as two separate files and both uploaded

to this assignment. PLEASE SHOW WHAT EXCEL FUNCTIONS$/$FORMATS WERE USED