# 1. Introduction to Car Loans attachmentStudents can submit work

Playback Speed:
Transcript

Welcome Back!

In this activity, you will learn about financing a car.

You will calculate the total monthly payment and the total interest for a series of loan amounts using PMT and absolute value functions and absolute and relative cell references.

You will also research cars and use an image function to insert pictures of the cars in your spreadsheet.

Say you are in the market for a new or used car.

You find a car you love, but you can’t afford to buy it out of pocket.

Few people can!

One option is to get a loan for the money, or to finance the car.

Financing means that you borrow money from a lender and pay them back little by little.

Not only do you pay back the principal, or the amount of money you borrowed; you also pay an additional percentage of that principal to the lender for using their money.

This additional percentage is called interest.

There are three factors that determine how much you’ll pay each month for a loan: The amount of money you borrow; The interest rate, also called the annual percentage rate, or A-P-R; and The term of the loan, or the time it takes you to pay it off.

Sometimes having a lower monthly payment means that you pay more overall!

If this sounds overwhelming, don’t worry.

Financing a car is not always a straightforward process, and there are many options to consider.

In this activity, you will create a spreadsheet to help you determine how much money you could afford to borrow when buying a new or used car.

On the spreadsheet, you will select an interest rate, or A-P-R, and a loan term and convert these to monthly amounts.

You will also specify a price range for the car you will research.

Once you have this basic information, you will calculate and record a table of possible loan amounts; your monthly payment; total payments, or the total amount you will spend on the car; and the amount of money you will spend on interest.

Once you set up your spreadsheet, you will research new or used cars to get an idea of what they cost per month, as well as the total amount you will pay over the term of the loan.

To begin, go to sheets dot google dot com slash create to start a blank spreadsheet.

Name it Loan Amount Chart.

Then, move on to the next video to start calculating costs.