You just graduated college with your Bachelors Degree in accounting and accepted a job offer at your dream company. You decided to celebrate by purchasing the vehicle of your dreams. Think big, for this class's sake. (Pictured above is a 2009 Chrysler PT Cruiser Convertible. back in 2009, the cost for this vehicle range from $18,000 to $25,000).

You have a 720 credit score, therefore you were able to get a 5% interest rate on a 7 year loan. You will be making annual payments. 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 over the 7 years. The Excel cells must contain formulas and cell referencing when appropriate, both relative and absolute.

Calculate two additional amortization schedules using 6% and 7%.

Provide the following deliverables and REVIEW THE GRADING RUBRIC BEFORE SUBMITTING THIS PROJECT:

A.) All three amortization schedules in MS EXCEL