create a model on excel about Car Buying (purchase vs lease, various car types, money down, rates, new vs used) following these instructions

Part 1 Part 1 will be a Word document and include: 1- A least a paragraph providing a background on the topic you are creating the model for (tell me about the personal finance problem you are addressing in your own words). Also briefly detail who is the model meant for? (For example is it someone just starting their career, with a family, already working etc.? What complexities did you account for? (For example, life does not always go as planned. If appropriate, did you account for a situation like this in your model?) 2- At least one paragraph with instructions related to properly using the model. What does the user need to input? What are the primary outputs? How can changes/updated be made? 3- A paragraph highlighting the various Excel skills used in this project. (At least one sentence for each item listed in part 2 below. Also include a discussion of any other skills used.) Note: Be sure to use proper citations if you use any outside sources (Investopedia, textbooks, etc.). A paragraph should be at least 4 sentences to receive full credit.

Part 2 Part 2 will be your model created in Excel. You model at minimum must include: 1- A simple (finance) graph/chart with the appropriate labels including title and axis labels 2- A fancy graph/chart with the appropriate labels (must include colors, images, and stacking for credit) 3- Two different If Statements. You may not repeat the same If statement in 2 cells (When turning in your project, please highlight the cells with the if statements yellow, so this requirement is easy to find) 4- A sensitivity analysis using DataTables covered in this course. You may not replicate the DataTable from our class example or the one from the group project. 5- A Lookup Function (vlookup) or time value of money (TMV) function. (When turning in your project, please highlight the cell(s) yellow with the functions, so this requirement is easy to find) 6- A drop down menu using Data Validation that connects to your model. When the user changes this selection, the model updates. (When turning in your project, please highlight the cell(s) yellow with this aspect, so this requirement is easy to find) 7- Inputs and outputs clearly labeled (need a clear goal to model and user inputs to obtain it) 8- Your model should be well formatted and be easy to use. (Must include color formatting as discussed in class.) 9- Your model should be sufficiently robust/complicated ( and should requires a great deal more time and effort than any of the group projects completed in the course). An acceptable model will include all of the above plus additional calculations/considerations/scenarios/real-world aspects. As I mentioned above, now is the time to impress me.

Part 3 Part 3 will be your individual presentation. The presentation at minimum must include: 1- Presentation must be completed using no notes (do not simply read Part 1 of your project or read prewritten notes). You may only use your Excel file (no PowerPoint or notes). The presentation should be professional and last between 5 and 7 minutes. The presentation must be at least 5 minutes to be eligible to receive full credit. 2- The presentation must cover at minimum: a. What problem the model solves b. Clearly describe the inputs and outputs c. How you incorporated the Excel skills mentioned in part 2. Describe where you use it in your model, how you created that step/the formulas used and what it does/means. 3- Your presentation should be well-organized, professional, and easy to understand