2.1601 Using Linear and Exponential Functions - Transportation

Last updated about 1 year ago
33 questions
Use the spreadsheet at the beginning to calculate payments
Here is a spreadsheet to help you calculate payments. Make a COPY for yourself before you use it.

https://docs.google.com/spreadsheets/d/1FBkXFOpMwMqSlWKsUpeq5v67XPOSPn5kMTBShxCPTA4/edit?usp=sharing
Required
2
Required
2
Required
2
Required
2
Required
2
Required
2

Interest paid yearly.

Required
2

Total cost of loan over 5 years

Required
2

What is the monthly payment?

Required
2

Monthly payment?

Required
2

Total amount paid over 5 years

Required
2
Required
2
Required
2
Required
2
Required
2
Required
2
Required
2
Required
2
Required
2
Required
2

Which term affects payment the most?

Required
2

Which term affects payment the most?

Required
35

Do a screenshot of your spreadsheet. Create a pie chart that illustrates your yearly transportation expenses. I have included a sample screenshot. Yours should look like this except with YOUR name and numbers.

Required
2
Required
2

Monthly Payment?

Required
2

Total amount paid over course of the loan

Required
2

Total Cost after sale of the car at end of 6 years

Required
2

Monthly Payment?

Required
2

Total amount paid over course of the loan

Required
2

Total Cost after sale of the car at end of 6 years. Round up to nearest dollar

Required
2

Monthly Payment?

Required
2

Total amount paid over course of the loan

Required
2

Total Cost after sale of the car at end of 6 years.

Required
2

What is the best option?