How to Calculate Loan EMI in Microsoft Excel. Excel में लोन EMI, Interest, कैसे निकालें ?

[@hossain786100]

बिलकुल सही फॉर्मूला है। मैं एक लोन का पेमेंट शेड्यूल को इससे चेक किया एकदम सही है। हमें एक अच्छा जानकारी प्राप्त हुई है।

[@arjunohri6216]

seen many videos but only this video shows practically how to do it in excel. best video thank u very much

[@mr.explantionwala]

You are best teacher in the world 🌍❤️

[@unboxtheshopping9600]

So nice😊 bhaut acha samajaya

[@aSingh-2]

Best Video on RUclips Thank you Sir, I got.

[@JayashreeDeka-j6n]

So usefull video sir thank you sir❤😊

[@vikashkumar-op2ef]

Thank you so much for this valuable information 🙏

[@streetpaws428]

Thank you so much! I will pass my exam today

[@JyotiPatra-y6w]

thank you very much........nice explain🙏

[@classy_nikhil]

Thankyou sir it is very helpful❤❤❤

[@AnjuJangde-pd5ob]

मुझे बहुत अच्छे से समझ आया सर धन्यवाद 🙏

[@JyotiPatra-y6w]

sirji......superb👌

[@madhusmita5225]

Nice sir bahut ache se samjha di🙏🙏

[@sharma8548]

BAHUT HI ACCHE SE SAMJH AAYA THANK YOU.

[@A_Akshata_Akshata]

Thanks a lot😊..very much helpful...make such more informative videos ❤❤

[@tanishrajbhansali3544]

Thank you paaji❤

[@sandeepdhamanekar3725]

Thank you sir.👍👌👍

[@pareshkumargajipara4881]

Very nice information sir

[@digambarjadhav2888]

Best Information Video sir

[@thewinnersmindsets]

Very informative and useful video thanks 🙏

[@indian_facts.hakkers]

Thanks bhaiya 😊

[@aniketsawant8000]

Very helpful🎉

[@animashsarkar7667]

WOUNDERFUL SIR................VERY WOUNDERFUL.... THANK YOU..

[@shankhamukherjee2407]

Very very helpful video, Thankyou. Wish you all the best.

[@bidhanghosh2281]

Please give me the excel sheet in gdrive link..

[@Anshu-user-zk4ot3vj4b]

Thank u Bhaiya I was very confused but now everything is clear
Can u plz make one video on Moratorium period calculation on excel?

[@examswillclear8123]

Thank you so much mere Bhaiiii

[@BalaKrishna-l7t]

Nice videos sir

[@akashjangde9128]

Bahut hi shaandar ❤

[@muzamilabdul9340]

Good teaching

[@MangalaramJangaiah]

Well explanation

[@indiaemitar]

❤❤❤❤❤❤❤❤❤❤very good informations thanks❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

[@gireeshgawande8609]

Thanks so much sir

[@arvindkumarkushwaha2082]

Thanks dost

[@maheshupadhyay914]

Bhai repayment ko isme add karne ke liye batao

[@shrikanttrikachhiwar4685]

It is helpful to everyone

[@RavindraSinghTomar-k3o]

How to calculate if rate is increase after some year but emi amount same . what number of emi increase

[@neerabansal6214]

Thanks Sir 🎉

[@IKLoTaPAHADI]

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 🙏🙏🙏🙏❤️❤️❤️

[@bidhanghosh2281]

Please give me the excel sheet gdrive link..

[@tusharmehrotra4259]

Thank you , Ye compund interest hi h na

[@NarayanShukla-zn3dr]

Thanks ❤

[@millymaneesh204]

Thank you bhaiiii

[@rajeshsinghjadham9899]

Thanking you sir agar kuchh month ke bad interest rate plus ya minus hota tab automatic kaise calulation jab EMI fix hai

[@Sonal-gy1qe]

Very nice video sir

[@jkentertainmentvideostatus4611]

Uttam 📹

[@monikadesai8251]

Helpful... Thank you

[@AugustineValley]

Bht achi video thi❤. Plz tell me this : Mene 10 October 2022 ko 2 lac ka loan lia tha for 24 months tenure. To mera loan kiss date pe khatam hoga?? 10 October 2024 ko ya fr 10 November 2024 ko. Mene saari EMI time se bhari h

[@bidhanghosh2281]

Please give me the excel sheet in gdrive link..

[@sanjeebsaharia2187]

THANKS VERY WELL EXPLAINED

[@bidhanghosh2281]

Please give me the excel sheet gdrive link..

[@Amolsalve-p4t]

Thank You

[@AnupkumarSahu-f7q]

Thank you sir

[@irfankhan12786]

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😮❤❤

[@krishnapatil2130]

Appne jese bataya but amt nhi aa raha he principal value ki jagah par ,#value! Yesa aa raha he iska kuch solution batao plzz

[@nipjyotiboruah6718]

very nice

[@sangramsingh9432]

Thank you, sir

[@vishg143]

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

[@bidhanghosh2281]

How to download that excel sheet from gdrive? Please provide link..

[@narenka5618]

👌

[@Meriapeksha]

Bhai bhai agar 12:24 3648 mahine ka loan hai to kya EMI apne aap time period ke hisab kaise generate nahin hogi

[@DCHELPING]

interest rate ko percentage format me likhna hai,

[@vishwakarmashailesh]

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

[@InspectorJalandhar]

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

[@DCHELPING]

12 emi dene ke baad jo bhi principle bachta use pay kar sakte hai baki mahino ka interest nahi lagega.

[@bidhanghosh2281]

Please give me the excel sheet in gdrive link..

[@NadeemKhan-kp5ew]

Ppmt or ipmt me nper ko multiply bhi to karna padega na 12 se

[@DCHELPING]

nper नहीं होगा, RATE DIVIDE होगा 12 से

[@IKLoTaPAHADI]

@@DCHELPING sir lekin ager 1 year ka time period hota tho 12 se multiply kerna padta na

[@sudharajpoot014]

Lekin outstanding balance ko zoro me kaise kare
Pls help me

[@georgejose4528]

How to calculate emi when rate changes ? Eg 5% for first 5 years and 7% for remaining 2 years.

[@Sri_harivanshchandrajuu]

After 5year change the percentage to 7per

[@RavindraSinghTomar-k3o]

​@@Sri_harivanshchandrajuubut emi price same ho . Toh number of emi change hogi vo kese calculate kare

[@Mrbansal140]

Please share excel format

[@pritambhowmik1831]

Bhai F4 me projection aa jaha raha hai...freeze karne ka koi dusra tareeka?

[@yushaabidi110]

Function key ke sath press karo

[@RajRoy-kf9mu]

Agar isme 6 month ka weekly karna hoga to kaise hoga

[@hanumandas778]

लोन किस्त के लिए एक मोटी रकम एक साथ जमा कराने पर तुलनात्मक कितना फायदा होगा।

[@rathodpravin9172]

Bahot acha kar sakte hai bahot acha ap ka interest amount kam jayega

[@nayanapatel7749]

Best

[@rudrapratap-jb7ji]

कोई ग्राहक लगातार emi जमा नही कर रहा है।
जमा नहीं किया हुआ emi amount एक्सेल फार्मूला के द्वारा कैसे कैलकुलेशन करें।

[@vilathatso7375]

Ppmt formula is always coming zero . please help

[@tiger7858]

🤓🤓👌👌👌

[@hksaini1323]

Sir f4 keys se lock nahi ho raha hai hamre excel me

[@rworld2297]

This is easily fixed! Just hold down the Fn key before you press F4 and it'll work. Now, you're ready to use

[@sorabjuyal3762]

Batao bhai loan nahi de rakha hai sir ne rate,nper, emi de rakha hai loan kaise nikale samjhao do mujhko bhai

[@DCHELPING]

pv function use karo

[@NadeemKhan-kp5ew]

Bhai agar 7 mahine ka nikalna h to kese niklega

[@DCHELPING]

nper me 7 hona chahiye

[@Pushpajain2912]

Ye interst hr mhine ka kese nikals

[@piyahablani27]

F4 press krne se fix nahi ho Raha

[@rworld2297]

This is easily fixed! Just hold down the Fn key before you press F4 and it'll work. Now, you're ready to use

[@bidhanghosh2281]

​@@rworld2297Please give me the excel sheet in gdrive link..

[@juhithakur4259]

F4 se lock nhi ho raha kya kare ?????

[@suman213]

same issue here

[@rworld2297]

This is easily fixed! Just hold down the Fn key before you press F4 and it'll work. Now, you're ready to use

[@rahulparewa1710]

525000 loan pr 11% se 84 month ki EMI kya aaygi

[@DCHELPING]

8989.28

[@JaiswalsinghGuller]

good video but not so help full but over all good

[@arunsharma-tk6bd]

$ ka nishan kyo aa reha h formula apply karne k baad

[@hunnymodelll]

Kyuki bro us value ko lock krr diya tha f4 se video dekho

[@pramodsahu4459]

Ok

[@naimuddin3681]

96000 ka batao emi 4546 aati h

[@Pushpajain2912]

Ye hr mhine ka interest kese nikla

[@svsrinivas9]

Excel sheet?

[@veerstar5]

ग़लत ❌ लग रहा है। Explain this. हर row में interest को outstanding का 1/120 मतलब 10/12 % होना चाहिए जो कि कुछ rows तक सही लग रहा है लेकिन 24वीं row में यह interest 39248.33*1/120=327.07 होना चाहिए जबकि यह 294.36 है। WHY ?

[@SurajVishwakrma-us2lv]

Sir isme principal bad kyon Raha hai

[@sumitsingh-e1q]

Ye o kiu nhi aaya

[@INFOMasterOD]

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.

[@Anshukumar-mw4cy]

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

[@IR5UM]

​@@Anshukumar-mw4cyek bat mai b puchta hu
Maan lo 20 sal phle 2 rupye ki byaj se 2,00,000 lakh pr kya byaj hoga,, or kya chkrvrti byaj hoga....

[@IR5UM]

Ye excel mai video bnao plz

[@bidhanghosh2281]

Please give me the excel sheet in gdrive link..

[@payeldas8378]

Why are we dividing by 12?

[@officialnishant09]

Not interested🙂

[@Kaif_gaming07]

Outstanding mtlb present value na

[@Gauravchavan57478]

Thanks bhai

[@hanumandas778]

Very nice