This exercise will refine your skills on the use of the spreadsheet and at the same time introduce you to the search techniques on the internet.
Exercise:
1. Using the internet search for the cost of a new or used vehicle of your choice.
2. Determine the equipped cost and print out the data along with a vehicle picture.
3. Create a spread sheet that allows you to add in destination costs and sales charges.
4. Subtract your $2000 down payment.
5. Using the payment function under the spreadsheet calculate and print the monthly payment for the following combinations:
6%, 7%, 8%, 9% interest for 60 months
7% interest at 24, 48, 60 and 72 months.