HDTutorial
EN
How to Make Loan Amortization Tables in Excel || Download Demo File

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Make Loan Amortization Tables in Excel || Download Demo File

68,011 views October 28, 2017 15:34

Watch on YouTube
ChannelMatt Macarty

Description from the creator

Please SUBSCRIBE:
youtube.com/subscription_center?add_user=mjmaca…
Loan Amortization Schedule in Excel
alphabench.com/data/excel-amortization-tutorial…

Download the file used by following the link above.

Calculate any loan payment here using PMT function:
alphabench.com/data/excel-pmt-function.html


Basic and advanced loan amortization tables in Excel. Demonstrates PMT, IPMT and PPMT functions. With visualization of balance and cumulative interest over the life of the loan. Also discusses the NPER function.

See how the finance of mortgage loans works. See the impact of extra payments on the life of the loan and total interest paid.


The file used can be downloaded at the link above.

About this tutorial

Matt Macarty published this 15:34 video tutorial on October 28, 2017. It has been watched 68,011 times on YouTube.

Duration
15:34
Published
October 28, 2017
Views
68,011
Likes
371

Share

This tutorial in other languages