Tqu so much sir🔥 Mujhe y kafi difficult lag rha tha pr aapki video s meko 1st tym m hi pura concept clear ho gya Sch m bhut jayada acchi video banai h aapne bhut acche s explain kiya h God bless uh sir Once again Thanks alot
Thank you very much sir.... In our school computer sir have done in different way which I don't understand but this way is very easy to find out PMT,IPMT,PPMT
Loan amount 100000, interest rate 14% , payment year 4. mera value pmt = 2732.65, ipmt = 1166.67, ppmt= 1565.98, dear sir, apki value ki sat mera value q nehi milta? In excel 2013
Nice sir ❤ bahut acha bataye ho aap ❣️❣️💞❣️❣️ thanks sir pahle hi dekh leta aapka video to itna der nabi hota ab apke channel ko subcribe ker liya hu ❤❤❤❤❤❤❤❤❤❤❤❤❤
=pmt(b4/12,b4*12,-b3) formula me - ka use Karo agar -me value aa rahi . Isme loan amount ko minus kar Raha hai aur value aa jayegi . Agar kahi bhi aise ho to loan amount ya principle amount ko - kar Dena hai value aa jayegi
My pmt value is in Minus (-2732.65) I applied same method that you said in this video.
Same
@@sanjanarani9034 I Applied - Sign before Amount. Then value is Positive.
No,it's not a minus sign. It's a small dash. Trust me, because none of the entries are in negative value. So there's no chance of any minus sign.
Mere me bhi itna hi aaya hai lagta hai sir ka laptop bahut purana hi
same method but total 2732.65
😭😭 Thanks a ton sir ....I couldn't understand when my teacher was explaining me And here just in 7 minutes I got .
Same bro❤️❤️
Me bhi mera bhi teacher jab mujhe bataye the ipmt , ppmt , pmt to me achchi tarah samjh nahi paya but yaha per achchi tarah se samjh gye
Same mere saath bhi yahi hua
PMT formula is not giving correct answer ..pls help .
Good
Thanks sir.... I didn't understand when my trainer was making me understand it now I got it &
thanks for making this for learning us,
Me also😅
Thank You so much sir You have explained PMT, IPMT, and PPMT, Fuction in a simply way.... It will help me alot in future
Nice video ji 👍❤️
nice explanation sir ..... thank u so much ....plz make more video on excel .....❤️
Thank You so much sir jii❤
Acche trike se smjhane ke liye 👍💯❤
Your video is amazing sir. Thankyou so much sir
Thank you Sir....I love u so much....💗💗💗
Radhe radhe 🙏......TQ so much guruji...😊
I'm literally impressed than my teacher of computer
Thanks for the helping make the helping video 🥰🥰
Very nice sir
बहुत अच्छी जानकारी ...धन्यवाद🙏
Thanks sermughy yay bilkul bhi samagh me nahi a raha tha lekin apki video dekhanay Kay bad samgh me aya
Tqu so much sir🔥
Mujhe y kafi difficult lag rha tha pr aapki video s meko 1st tym m hi pura concept clear ho gya
Sch m bhut jayada acchi video banai h aapne bhut acche s explain kiya h
God bless uh sir
Once again Thanks alot
बहुत अच्छे से समझ आया sir ग्रेट work❤❤
Osm video sir bhot acha se samjh aagya Hai
Easily understood this 👍thank you
Thank you sir 😍..your video is amazing 🤩 thank you so much sir
Very knowledgeable video...
Thank you so much sir ji
Aapne bahut badhiya samjhaya thanku sir jiii
jay ho gurudev aapki
Very Very Good .. Easy way of most important Formula Presentation...Learned Professor .. Praiseworthy Explanation & Utilisation
Thanks sir
Bahut hi achha smjhhaya aap ne
bohat bariya
Thank you sir functions ko acche se batane ka liya
Thanks sir mujhe achha laga aapne jis tarah samjhaya Weldon😊😊
Great explanation thanku so much sir👍👍
Superb... aap bahut achha se samjhate hain🙏🙏🙏
a best tutorial for me because i gain knowledge
Thank you very much sir.... In our school computer sir have done in different way which I don't understand but this way is very easy to find out PMT,IPMT,PPMT
Thank you so much sir 🙏
Thank you sir you have explained ppmt ,ipmt and pmt thanku so much sir🎉🎉
Excellent Mr India
Good
Thank you so much 🙏 sir aap ka batane ka tarika bahot achha hai
Thank you sir😊
Thank you so much sir for this amazing video... 😊😊😊😊
Very helpful,thanks sir
A lot of thank you sir.
Tqs sir it helps me lot
Nice explanation....sir 🙂 thank you 🙂
Thanks for this awesome video 🙏🙏
👍👍👍👍
Thank you sir ji 🙏🙏
Thnx sir love u from Haryana 😘
Thank you so much sir,bhut hi acche se samjhaya hai aapne🙏
Thank you so much Sir. You have cleared all my doubts. Very nice video and presentation.😃😁
gjkcbtgmk
yhjn
nk
pj
h
Wow superb understand sir thank you!
Think you sir very nice 👍 video
Very good explanation
Good teaching style. Thanks
The way to teach is very good.
Bhut ache se samaz aaya
Thank you sir divine blessings ❤️🙌
Super so nice of you
Great job
Rj
🇬🇧
Wow excellent thank you sir
I did do it with you but my PMT was 2,732.65, IPMT 1166.67 & PMT 1565.98
Shobhana patel ji mere bhi calculation asi hi hai
Ha yahi ans hai
Take interest rate at 13.8%
LOVE YOU SIR😘❤🤟
Sir mere sir ne sahi se nhi samjhya tha aapki video se mujhe smaj aa gaya
Good information sir
Thank you so much sir🙏🏼🙏🏼🙏🏼🙏🏼🥰
Bahut achi video 🙏🥰
Great sir like this video
🙏🙏🙏🙏
Very useful ❤
Thanks a lot sir 🙏🏻🙏🏻🙏🏻
Thank your sir
Thank you soooo mach👍 Sir apne bohot acha answer bataya thank you👍 👍 👍 👍
Loan amount 100000, interest rate 14% , payment year 4. mera value pmt = 2732.65, ipmt = 1166.67, ppmt= 1565.98,
dear sir, apki value ki sat mera value q nehi milta? In excel 2013
Interest rate will be change day by day..becaz of month days
Thank you sir
Nice video thank you so much sir
Sir mujhe ek tally par video de dijiye sabhi voucher par alag alag bill kaise banate hai please sir
Thank you so much sir
Nice sir bahut accha samjhaya
This is perfect knowledge of emi thanks ...?.
Good night sir,
Best teach of all. thanks.
Apki awaz bhut madur h😍😍
sir, please also provide excel sheet link...Great video....
Thank you so much sir.
Thank you sir.
😊😊
Good.
Voice Clarity ek number
useful video.. thanks
Very nice sir ji
Thank you sir..😋🔥💗
Thank you sir and all doubts clear
thanks provide us this awesome explanation
Very god information
Nice sir ❤ bahut acha bataye ho aap ❣️❣️💞❣️❣️ thanks sir pahle hi dekh leta aapka video to itna der nabi hota ab apke channel ko subcribe ker liya hu ❤❤❤❤❤❤❤❤❤❤❤❤❤
I invest 2000p.m for 5 year and I will rec'd 2,50,000 on 5th year.
So, at what's rate of interest , I recd rs .2.5lac????
8.3798% per annum i.e. 0.6983% per month
Very Nice Formula Sir Thanks
Bhut bdya bataya h apnh
Thanks sir
NYC video sir
it's really help ne
=pmt(b4/12,b4*12,-b3) formula me - ka use Karo agar -me value aa rahi . Isme loan amount ko minus kar Raha hai aur value aa jayegi . Agar kahi bhi aise ho to loan amount ya principle amount ko - kar Dena hai value aa jayegi
Mst
Thku so much sirrrr
Tq so much🥰🥰🥰🥰🥰🥰
Thanks sir very nice vidio❤
Thank you sir it's for my help 🤗
Sir interest agar monthly installment me se deduct kar denge to bhi principal amount to Aa hi jayega.