From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 24,300 courses taught by industry experts.

PMT and FV functions: Calculating monthly payments and earnings

PMT and FV functions: Calculating monthly payments and earnings - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

PMT and FV functions: Calculating monthly payments and earnings

“

- [Instructor] Excel has over 50 financial functions. And unless you're in the financial arena, you're not likely to use most of them, but certainly a couple of them. And the ones we're going to be showing you, I think have a lot of wide appeal and need. One's called PMT. If you're borrowing money for car or house, possibly you'd be interested in that one. If you're saving money, function called FV. To the right of each of these, we've got a list and it's displayed with a so-called heat map. You don't have to do that of course, but that could be handy too, particularly if you're shopping around using different interest rates or comparing different interest rates and different prices of things you want to consider buying. Let's zoom in on this and first focus on PMT. I'll get rid of these maps to the right and then show you how to create them quickly using a feature in conditional formatting. Let's zoom in on the PMT portion…

Contents