From the course: Real Estate Analysis Foundations
Join today to access over 22,600 courses taught by industry experts.
The amortization calculator - Microsoft Excel Tutorial
From the course: Real Estate Analysis Foundations
The amortization calculator
- Hey guys, in this lecture, we're going to take a look at the loan amortization calculator or loan amortization schedule. This is a file that you see in front of me right now that you can download. It is associated with this lecture, so download it right now and you'll see what is in front of me and I want to walk you through what's in here and how you can use it for your own needs. So here, take a look at the cells that are in blue here. These are the only cells you need to edit to see how this calculator works. So for an amortized loan, remember we need to have an actual loan amount or known as the principal is how much you borrow, the interest rate, the term of the loan in years, and then say a starting first payment date and this one you can leave it as is or you can put in a date but if you put in a date, it'll give you the nice date of the payments for all the other payments. So, this one's not necessary for the calculations but it's better for you to match it up according to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.