Dream Cars

Your wealthy aunt is beginning to distribute cash to all her relatives. She wants to buy you the car of your dreams. But you must do some research and give her details about your choices. She is a wise consumer and wants to know the price as well as the options you can add to your car. In your research, you develop an Excel Spreadsheet with the following features.

She also wants you to project the cost of each car next year and two more years. Car prices increase about 6% each year. Build a formula for years '12, '13, and '14 that represent a 6% increase from the year before. Also, options increase 4% each year.

• Dream Cars title centered across spreadsheet
• 3 cars and their MSRP
• 3 images
• columns for this model year (2011), 2012, 2013 and 2014
• prices after 6% increase each year
• 5 options, add-ons, or upgrades
• option prices after 4% increase each year
• totals for all columns
• websites for all information and images collected
• landscape on one sheet
• single and double underline for totals
• your name and the date in a footer
• use interesting fonts, color, line styles and fill colors

Here is a sample of the format.