Do you know? WPS Office is the ultimate FREE alternative to Microsoft Office! It's an all-in-one Office suite, seamlessly compatible with MS Office apps like Word, Excel, and PPT. Download for Windows, Mac, iOS, Android, and Linux here: Free Download Link: bit.ly/45lhE6N
Awesome video man...just one quick question what if interest rate get changed in between for e.g after paying EMI for almost 4 years if intrest rate dropped to 7 from 9%..how to calculate how much total intrest we paid.
Banks usually calculate emi on compound interest- compounded monthly, daily or annually. If you visit a Bank's emi calculator you will find different emi amount for different banks although principal and rate of interest are same.
This video is very helpful. If bank pay loan amount in part wise so how was I have calculated loan Emi,interest and princepal amount.? Waiting your valuable reply.
Can be possible client wise auto update loan amotozation table? Also if possible interest rate change so auto update automatic in excel Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment already showing in your video ,Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest
Thanks Please provide a video on rate of interest, flat rate of interest, and effective rate of interest. Because sometimes rate of interest ko hide kar flat rate of interest ko use karte hai loan provider.
Dear Sir, Please update excel tab and formula Add DOWNPAYMENT option, and monthly, quaterly, half yearly, yearly emi option, service charge option, INSURANCE OPTION ALL YEAR CHARG
JAB DESKTOP/LAPTOP EXCEL ME BNATE HAI, TO EMI'S NUMBER ME VALUE LIKHA NAHI ATA, LEKIN JAB GOOGLE DRIVE ME BNATE HAI TO EMI 'S ON 2ND COLUMN ONWARDS VALUE LIKHA ATA HAI INSTEAD OF AMOUNT , WHY??
Do you know? WPS Office is the ultimate FREE alternative to Microsoft Office! It's an all-in-one Office suite, seamlessly compatible with MS Office apps like Word, Excel, and PPT. Download for Windows, Mac, iOS, Android, and Linux here:
Free Download Link: bit.ly/45lhE6N
isme automatic number of installment ka table ban jaye aisa kuch batao
Simple & best. Being a banker I liked it. Thank u
Bahut bahut dhanyawad sir esi video banane ke liye
Awesome video man...just one quick question what if interest rate get changed in between for e.g after paying EMI for almost 4 years if intrest rate dropped to 7 from 9%..how to calculate how much total intrest we paid.
Banks usually calculate emi on compound interest- compounded monthly, daily or annually. If you visit a Bank's emi calculator you will find different emi amount for different banks although principal and rate of interest are same.
Thank you vedio is very helpful 👍👍👍👍
Auseome
Thank you so much Sir for this valuable class 🙏🙏🙏😊😊
Too nice vedio sir, I could solve my each and every doubt, Ur teaching style is too grate
VERY GOOD EXPLANATION, WILL HELP ME IN TOMORROWS EXAM
Good Luck dude
Your Video is Very Usefull. 👍
Very good video, explanation part was the best, best video for beginners and experts 👍🏻
Amazing 🎉🎉🎉sir please keep it up
Bahot zabardast bhaiyya
Well done sir...,🤘
will this not affect in leap years days?
This is nice, could you please do the calculation with new column what if we pay 1 month extra EMI/year
Awesome video sir
Thank you so much. Great video. Cleared all my doubt 🙏
This video is very helpful.
If bank pay loan amount in part wise so how was I have calculated loan Emi,interest and princepal amount.?
Waiting your valuable reply.
Thankuu soo much brother ❤️
Thanks bro...☺️..informative & nice presentation..👍👍🙏🏻
awesome video....sir please give demonstration for pre payment thank you
Well presented and well explained too. Thanq very much.
thanks a lot ,it was realy too good
Well explained
Thanks
Nice presentation sir👍👍
Nice information my friend
Thanks for liking
Really super explanation thank u so much
Thank you so much sir🎉
If we payment repayment then what should we do in excel??
Can you explain ballon, bullet, step up, step down, interest only amortization schedule
Very Nice Presentation
excel sheet download link not in dicription plz
Sir mjhe ye excel sheet purchase krni hai
सर क्या यही चीज वर्डप्रेस में हो सकती है ?
Nicely explained
Thanku sooo much sir... 🙏🙏🙏🙏
Agar amortization apne hisab se jyada or kaam kare to?
Society monthly bill AND SIMPLE INTEREST CALCULATION FOR WHOLE YEAR.
Thank you very very very very much Sir
Weekly loan repayment schedule kaise banaye plz help me
Hello kist 84 se jyada ho and month no apne ap lele up to endings balance 0 tak how ......
Bahut bahut Dhanyavaad sir. Can you also make video How Can I plan PRE PAY EVERY YEAR BY REDUCING TENURE. How to calculate LAST EMI DATE.
for that purpose we will make it using vb script and logics
Wonderful video
Very nicely illustrated
Emi calculation for staff??
Sir, Please make video on 'How to make age calculator in javascipt' with upcoming birthday.
very well explained
Can be possible client wise auto update loan amotozation table?
Also if possible interest rate change so auto update automatic in excel
Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment already showing in your video ,Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest
very nice Sir
Agar EMI me variations rahege to kya karna
How to download excel for practice
How pmt function calculate EMI amount
Pls explain
What's if we paid more than emi how it will effect on loan ?! Like we have emi 6000 or we paid 7000 what's will changes and how ?
Can I get this Excel sheet ??
Very very thanks sir jee
Can you provided simple 5years loan project report
Thank you sir very helpful vedio
Thank u Sir..
Agar muze bichame hi kuch amount repayment karni ho to esaka calculation kai kare esake bareme bataiye..
Good 👍
Nice sir
Thanks
Please provide a video on rate of interest, flat rate of interest, and effective rate of interest. Because sometimes rate of interest ko hide kar flat rate of interest ko use karte hai loan provider.
Mera interests flat hey
Yeh isme kaisa kare
Very helpful
Again thanks
Very usefull video
Nice video
EMI nahi jama karega to fine or internet kaise calculate karege
MOST AMAZING VIDEO THANKU SIR
How to add Prepayment option?
@
Buzz2day Tech
Don't use background music when you're teaching something . It's very irritating .
Thank you for feedback
Sir अगर ये एंडिंग blance टाइम से पहले जमा करते है तो कैसे निकलेंगे
Dear Sir,
Please update excel tab and formula
Add DOWNPAYMENT option, and monthly, quaterly, half yearly, yearly emi option, service charge option, INSURANCE OPTION ALL YEAR CHARG
Very nice
मुझे एक्सेल शीट 1 मे एम्पलोयी सॅलरी बनाने की बाद शीट 1से जनरेट करना है अलग अलग एक्सेल शीट मे जनरेट कैसे करें
Thankyou sir. But. How to calculate 1.5 years ? Im from nepal
super, thanks
Very2 nice....
Sir, how to calculate Loan for 6 months in reducing Balance method???
Please calculate with Half yearly frequency
Sir ye drow kaise kiya
thanks for share
Effective rate is mandotry
Please sir WMI calculator
THANKU SO MUCH ,,,
JAB DESKTOP/LAPTOP EXCEL ME BNATE HAI, TO EMI'S NUMBER ME VALUE LIKHA NAHI ATA, LEKIN JAB GOOGLE DRIVE ME BNATE HAI TO EMI 'S ON 2ND COLUMN ONWARDS VALUE LIKHA ATA HAI INSTEAD OF AMOUNT , WHY??
Sir ending balance mein zero Nahin a rh h 😟
Is video ke 1k view abhi nahi hui aur mujhe yahan ek ad dikha
Thank you sir
ek baat puchni hai?
Puchiye
Thnq
Nice
Thanks
Principul amount 2 month jayada ho gya
Best
🤔🤔🤔🤔
👍
Why that stupid music so loud
Very valuable information
Thank you sir
Thankuu soo much brother ❤️