Calculate Auto Loan Payments in Excel

This spreadsheet calculates your auto loan payments.

Get the spreadsheet here:

It lets you study the effect of different parameters on the loan. For example, you can investigate how changing the payment frequency changes the total interest paid across the lifetime of the loan.

View more

From: InvestExcel

Related topics : loan calculator auto excel spreadsheet / calculating loan payments in excel / calculating loan interest

Amortization in Excel (Part 1: Simple Calculator)

In this video, I demonstrate how to calculate the monthly payment, total amount paid, and interest paid for an Amortized loan. This can be applied to Mortgages, auto loans, credit card bills, etc.

This is the first of a series. In this next videos, I will show you how to create an amortization schedule.

View more

From: Justin Conroy

Related topics : loan calculator auto interest paid / credit loan mortgage