Excel PMT Function and Data Table - Part 1

In this tutorial I show you how to create a Payment Function PMT in Excel and how to build a Data Table. This is Part 1 of 3 in our Mortgage Calculator project.
To watch Part 2 (Creating an Amortization Schedule) click on the link below
To watch Part 3 (The Cumulative Schedule) click on the link below

[katiekim]

Thank you so much!! This video is really useful!

[Footloose]

Thank you, great video, would it be possible to show the same process but paying a variable amount in a bank account working on a yearly interest rate but calculated daily and compounded monthly - that would be awesome - thanks again