Use the PMT, IPMT & PPMT Functions

If you do finance or just personal finance you are probably working on interest payments. Excel has a bunch of finance functions that help you figure out financial payments. In this video, I'll cover the different PMT functions and check out the video to learn how to use the different payment functions (PMT, IPMT & PPMT) in Excel.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[AA-lqpu]

Thank you for taking the time out to help us!

[everything.enjoyer]

thanks i have an exam tomorrow you saved me

[ronyshafiq]

To be frank you are very gentle for teaching. I like your video for learning. thanks a lot

[andreas.abrahamsson]

Brilliant! However, I can't get the fv function to work. Can you please add that to your video too?

[rauf]

Super so nice 👍
Anyway if you go bit slow where your arrow goes or so on,
Brilliant thanks 🙏
Rjj
London Uk 🇬🇧

[robertoalcon]

hi there, i am trying to build a tax rate calculator. The Idea is, i have a table of $Amount with their prescribe Tax Rate. I want to hard code those prescribe rate to the table so everytime i input a dollar amount, it iwll give me the correct tax rate base on the Rate Table. How can i do that. Thank you for your hlep.

[eilsaga]

how will you compute interest if less than a year?

[Strawberrysunset]

So this is for monthly huh, How do you go about calculating annual payments?

[vinodkumar]

Sir dekho jese ki 70000*12%*1month/100 to 8400 rupes interest hota h।but mem agar esi excel me ipmt formula ka use kre to interest 700 dikhta h right answer kon sa h ।hme to tensen ho gyi mem plz btao