Brand New Car

Objectives: Students will use Google Spreadsheet to figure out the price of 5 cars they would like to purchase and estimate how much their monthly payment would be if they finance the cars for 60 months.

Students will also determine how much a 5% down-payment would be and how much they will need to pay in taxes and registration fees.

Directions: Part 1

Create a Google Spreadsheet.
A1= Title "Car Payments"
Row 2 Blank
A3= Cars
B3=Price
C3= 5% Down Payment
D3= Taxes and Registration
E3= Total Price
F3=Months
G3=Total Monthly Payment

Part 2. 1st Formula for the 5% Down Payment and a 9% for taxes and registration

In Cell C4 you will type in your formula. That is the price of the Car X 5%

=B4*5%

Make sure to type it exactly how you see it here.

Auto fill to C8.

In Cell D4 type

=B4*9%

Part 3: Total Price of the Car

In Cell E4 you will type in your formula to determine the total price of the car.

=B4-C4+D4

Make sure to type it exactly how you see it here.

Auto fill to E8.

Part 4: Determine Monthly Payment Price

In Cell G4 you will type in your formula to determine the total price of the car.

=E4/F4

Make sure to type it exactly how you see it here.

Auto fill to G8.

If you get a #DIV/0! error make sure to add 60 to the month

Part 5: Search for Cars.

Google search the type of car you would like to own.

Start off with affordable cars maybe the latest version of the cars your parents drive. Your last car can be the high end car you dream of.

Write the name of the car in column A.

Get the MSRP price and add that as the price of the car in Column B

Part 6: Add A Chart:

You will select 2 ranges A3 to A8. and G3 to G8.

You do this by first selecting A3 to A8. Then on the keyboard hold down the CTRL button and while holding it down select G3 to G8. (see image below.)

Then select the "Insert Chart" icon

It will automatically create a new "Chart". Use that one and make sure it doesn't cover the data.

Page updated

Report abuse