How to Calculate Loan EMI in Microsoft Excel. Excel में लोन EMI, Interest, कैसे निकालें ?
Vložit
- čas přidán 24. 08. 2022
- How to Calculate Loan EMI in Microsoft Excel. Excel में लोन EMI, Interest, कैसे निकालें ? PMT, PPMT, IPMT, PV Function in Excel.
Hello friends, kisi bhi loan amount ka emi calculate aasani se kar sakte hai, is video me loan calculate function pmt, ppmt, ipmt, pv function ke baare me bataya gaya hai,
Playlist -
Excel videos - • excel videos
Word videos - • ms word videos
Photoshop videos - • photoshop tutorial
#loanemicalculate
#loan_calculatin
#dchelping, - Jak na to + styl
seen many videos but only this video shows practically how to do it in excel. best video thank u very much
Very very helpful video, Thankyou. Wish you all the best.
THANKS VERY WELL EXPLAINED
So nice😊 bhaut acha samajaya
Best Video on CZcams Thank you Sir, I got.
Nice sir bahut ache se samjha di🙏🙏
Very informative and useful video thanks 🙏
thank you very much........nice explain🙏
Bahut hi shaandar ❤
Thank you so much mere Bhaiiii
You are best teacher in the world 🌍❤️
sirji......superb👌
Best Information Video sir
Thanks bhaiya 😊
Helpful... Thank you
very nice
Thank you bhaiiii
Very nice video sir
Thanks so much sir
Thank you, sir
Thanks Sir 🎉
Thank You
Sir yese or contents lao baki sheet ki jo computer institute m karwate h aap ache se explain kerna jese baki or h abhi ( Salary sheet , Employee sheet, attendance sheet, or jo bhi sikhne k liye ho excel m 🙏🙏🙏🙏❤️❤️❤️
Best
❤❤❤❤❤❤❤❤❤❤very good informations thanks❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤
Uttam 📹
Thanking you sir agar kuchh month ke bad interest rate plus ya minus hota tab automatic kaise calulation jab EMI fix hai
Pahle bar kisi ne sahi se bataya hai par kya aap yahi calculator me karke dikha sakte hai agar karke dikha de to bahut achha rahega please
Lekin outstanding balance ko zoro me kaise kare
Pls help me
Sir mai byaj ko calculate kiya to aapka jyada aara ha🤔....aur agar down payment bhi kiya ho too...maine formula ke lasta me pv-down pay bhi kiya nahi hua...sir ji plzzz reply😮❤❤
Sir maine computer me excell me ek sheet bnaya hai jisme maine sheet ko peotect kiya hai bt allow edit user range ki help se kuchh cell ko unlock bhi rakha hai...
PC me ms excell software par is sheet pe kam krne me koi dikkat nahi hoti...jo cell locked hain un par koi data entry nahi hoti aur jo unLock cell hain un par asani se data input ho jata hai...
Par jb is excell file ko mobile me transfer krke excell ke android version ke official app me open krta hu to sheet me kam nahi kar pata...
Means jo cell unlock hai jinpe main pc me data entry kr skta hu wo cell bhi excell ke mobile version wale app me lock ho jate hain.....iska solution btaeye sir
Why are we dividing by 12?
Ye interst hr mhine ka kese nikals
Ye o kiu nhi aaya
Agar isme 6 month ka weekly karna hoga to kaise hoga
Bhai bhai agar 12:24 3648 mahine ka loan hai to kya EMI apne aap time period ke hisab kaise generate nahin hogi
interest rate ko percentage format me likhna hai,
100000/- ka 9% ke hisab se 3year me 27000/- ka interest Hota Hai lekin aapka total sirf 1,14,479/- Aya Hai to aapka itna Kam kaise Aya.
Aap Flat Interest jor rahe hai, uske hisab se 100000 ka 9% k hisab se 3 saal ka byaj 27000 hua. Lekin jab hm log bank se loan lete hai to wo hame Reducing interest rate k hisab se loan dete hai. Aasan bhasa me smjhe to Jab hm log Loan k emi pay krte hai to usme Principal amount k sath sath interest bhi hota hai. To yadi ham 1st emi pay krenge to kuch hissa Interest me jayega or kuch hissa principal amount me. Is prakar se har mahina principal amount reduce hoga or uspe lgne wala byaj bhi km hoga. Or is liye jab loan khatam hoga to hm dekhenge ki hme byaj km dena para
कोई ग्राहक लगातार emi जमा नही कर रहा है।
जमा नहीं किया हुआ emi amount एक्सेल फार्मूला के द्वारा कैसे कैलकुलेशन करें।
Dear , Plz explain ....Suppose person took loan for 24 Months but after paying 12 months EMI . He paid rest principle amount then how to calculate rate of interest on his last principle amount . Thanks
12 emi dene ke baad jo bhi principle bachta use pay kar sakte hai baki mahino ka interest nahi lagega.
Ppmt or ipmt me nper ko multiply bhi to karna padega na 12 se
nper नहीं होगा, RATE DIVIDE होगा 12 से
@@DCHELPING sir lekin ager 1 year ka time period hota tho 12 se multiply kerna padta na
Bhai agar 7 mahine ka nikalna h to kese niklega
nper me 7 hona chahiye
F4 press krne se fix nahi ho Raha
This is easily fixed! Just hold down the Fn key before you press F4 and it'll work. Now, you're ready to use
Sir f4 keys se lock nahi ho raha hai hamre excel me
This is easily fixed! Just hold down the Fn key before you press F4 and it'll work. Now, you're ready to use
$ ka nishan kyo aa reha h formula apply karne k baad
Kyuki bro us value ko lock krr diya tha f4 se video dekho
F4 se lock nhi ho raha kya kare ?????
same issue here
This is easily fixed! Just hold down the Fn key before you press F4 and it'll work. Now, you're ready to use
Sir isme principal bad kyon Raha hai
Not interested🙂