Calculate Auto Loan Payments in Excel

This spreadsheet calculates your auto loan payments.

Get the spreadsheet here: http://investexcel.net/auto-loan-payment-calculator

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.

From: InvestExcel

Amortization in Excel (Part 1: Simple Calculator)

voir la vidéo

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.

From: Justin Conroy

Back top

2 Resources