PMT Function Excel - How To Use

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

In this video, you'll learn how to use the Excel PMT function. It calculates payments for a loan based on constant payments and a constant interest rate.

Skip to:
0:00 PMT function Excel - what is it?
0:22 Required arguments
0:35 Example - car loan
2:44 Optional arguments
3:31 Example - future value

——

#ExcelTutorial #PMTFunctionExcel #LearnExcel

——

——

For more updates follow us on:

——
Created and presented by Claudia Buckley for GoSkills
Рекомендации по теме
Комментарии
Автор

That's incorrect!!
You must no use TEM=TEA/12!! That's an error.
The correct formula is:
TEM=((1+TEA)^1/n)-1

IvanCortinas_ES