Use the PMT, IPMT & PPMT Functions

[@everything.enjoyer]

thanks omg!!!!!! i have an exam tomorrow you saved me

[@DougHExcel]

Good luck!!

[@ronyshafiq]

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

[@DougHExcel]

Hi rony shafiq, glad you liked it, thanks for commenting!

[@AA-lq5pu]

Thank you for taking the time out to help us!

[@DougHExcel]

You're welcome, thanks for the comment!

[@yoitired]

Very useful tutorial, thanks!

[@joshuamanampiu6489]

Simple. Thanks Doug

[@DougHExcel]

You're welcome!

[@1955rauf]

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

[@DougHExcel]

Hi Abdelrauf Raja, thanks for the comment!

[@TheAnjana777]

Thank you Doug !

[@DougHExcel]

You're Welcome!

[@Coouge]

Thank you very much!!

[@DougHExcel]

+Coouge you're welcome!

[@andreas.abrahamsson]

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

[@DougHExcel]

maybe something in this playlist? kzbin.info/www/bejne/rJvUe6SVnNCJaLc

[@butterflytov1]

Thanks Doug! So helpful!

[@DougHExcel]

You're Welcome!

[@robertoalcon838]

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.

[@DougHExcel]

Hi Roberto Alcon, sorry 🙁....but try a post on the mrexcel.com forum!

[@landerdiricx9762]

this helped me out allot! thanks man!

[@DougHExcel]

You're welcome! Glad it helped!

[@A_name_is_a_name]

Thank you

[@DougHExcel]

You’re welcome

[@backendadmin1217]

I like your videos.

[@DougHExcel]

Thanks!

[@Strawberrysunset23]

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

[@DougHExcel]

For 5 years,try rate would not divided by 12, nper would be 5

[@Strawberrysunset23]

So In my example, I have a loan principle of $300,000, 6% Interest rate per year, and number of years 30. so would my PMT look like this : =PMT(6%,30,-300,000)?

[@eilsaga643]

how will you compute interest if less than a year?

[@DougHExcel]

assuming an interest is for the year and it is compounded monthly, then the periods should be 12 (for 12 months in a year) and the interest is divided by 12.

[@sreenivasulueppali9087]

Send Excel link

[@jay55patel]

THANK YOU I LIKE IT

[@DougHExcel]

Hi Jay Patel, thanks for the comment!

[@Boudz57]

now i understand thanks

[@DougHExcel]

You're welcome!

[@user-vinodkumar143]

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

[@DougHExcel]

Sorry, don’t understand the comment/ question...

[@tahirmunir5472]

@@DougHExcel If calculate the monthly payment by using calculator it will be different than the answer what EXCEL is giving by using PMT . Excel is not calculating the correct monthly payments