Excel - Financial Functions for a House or a Car

Показать описание

Excel has a lot of Financial Functions. We will look at several functions for a home purchase or a car purchase. The functions include PMT, IPMT, PPMT, CUMPRINC, and CUMIPMT. These are great functions for personal finance and business.

Chapters:
0:00 Intro
0:18 Data overview
0:55 PMT Function
2:17 Total Paid and Interest
2:49 IPMT Function
4:31 PPMT Function
5:30 CUMPRINC Function
6:59 Keyboard CTRL + quotes to copy
7:11 CUMIPMT Function

CUMIPMT Function - Returns the cumulative interest paid on a loan between start_period and end_period.
CUMPRINC Function - Returns the cumulative principal paid on a loan between start_period and end_period.

#chrismenard #chrismenardtraining #exceltraining #microsoftexcel #excelfunctionsguide

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!