Overview
Within this project, you will research the current value of a car of your choice that has been in existence for at least eight model years (from 2015 to 2022). You will use historical data from Kelly Blue Book’s website on your chosen vehicle to predict the depreciation in value of your vehicle in the future, using Microsoft Excel. I have included a “Final Exam Project Excel Template” under Content / Final Project you may use to help guide you in creating this file (see Template Sheet 1, labeled “Value Depreciation”).
Additionally, you will research current interest rates for financing a new vehicle, and create an amortization table in Microsoft Excel detailing what you owe on your car throughout the life of the loan (see Template Sheet 2, labeled “Amortization Table”).
You will change the length of the loan, the interest rate, and the amount borrowed (as described in the “Final Exam Project Worksheet” – also to be found on CougarView under Content / Final Project), and explore the results of these alterations. You will complete this exploration by filling out this Worksheet, carefully answering each question with values or complete sentences when necessary. Please type your responses.
Finally, you will write a one page reflection paper detailing your work on this project. Your paper must have your name (Tityanna) at the top, have 1 inch margins, be in 12 point font, double-spaced, and make use of complete, error-free sentences. The reflection paper must include the following information:
- the goal of this project in your own words;
- at least one thing that surprised you while completing the project;
- at least one further change each you made on the amortization table that was not prompted by the worksheet, and the results of that alteration;
- and a brief conclusion containing at least one connection between this project and each chapter we covered in your text (1 – 4) for four total connections.