In this exercise we will utilize MS Excel to build a simple model, and then use functions such as GoalSeek and What-If to perform advanced analytics, in this specific case model-based analytics or predictive modeling. In step 1 you will build the model, and in step 2 you will use the model to answer several questions. Step 1, building the model. You are helping as friend who wants to build a used car business. Your friend needs to build a five-year business plan and submit it to the bank. Here are the facts and assumptions your friend provides as input: 1. Overhead cost per year, which includes rent for a lot and office trailer, advertising, internet and telephone - $45,000 initially. 2. Average price to acquire used cars - $15,000 (we assume all cars are bought and sold in the same year) initially. 3. Initial sales volume - 20 cars. 4. Average cost to repair, detail, and re-condition each car - $2,000. 5. Average Sales price: $22,500 The Bank requires a 5-year plan. For years 2-5 you assume the following growth rates: 1. Increase for costs 5% per year on top of previous year (applies to overhead and conditioning). 2