Emi Loan Calculator in Excel | Excel में Emi कैसे Calculate करें | Learning Zone Sanju
HTML-код
- Опубликовано: 19 авг 2024
- Emi Calculator | Loan Repayment Schedule | Loan Calculator
=================================
हेलो दोस्तों,
इस वीडियो में हम Fully Automatic Loan EMI Calculator बनाना सीखेंगे। जिसमे Installment , Principle और Interest सब कुछ automatically calculate होगा। तो जल्दी से वीडियो को Like कीजिये और वीडियो को End तक जरूर देखियेगा।
=================================
Link of the format : docs.google.co...
To download the format follow the simple steps
1. click on the link
2. Go to file menu & Move cursor to the download option,
3. There you will see the "Microsoft Excel" option. Click on that & you file fill be download in MS excel.
More Related Videos
Special Vlookup : • 🔥 New Vlookup Trick | ...
How to maintain stock in Excel : • How to Maintain Stock ...
If function : • 🔥 If Function Tutorial...
=================================
#emicalculator #loanrepayment #exceltutorial #exceltricks #exceltipsinhindi #loanschedule #learningzone #excel2021
Search Terms
emi calculator in excel
emi calculation in excel
bank loan emi calculator in excel
term loan emi calculator in excel
business loan emi calculator in excel
how to calculate emi in excel
emi calculator
calculate emi in excel
loan calculation in excel
home loan emi calculation in excel
how to create emi table in excel
reducing balance emi calculator excel sheet
emi calculator excel
loan emi calculation in excel
emi calculator excel sheet with prepayment option
how to make loan repayment schedule in excel
loan repayment schedule
repayment schedule
loan repayment schedule in excel
amortization payment schedule excel
car loan repayment schedule in excel
excel loan repayment schedule in tamil
make a loan repayment schedule in excel
fixed payment amortization schedule excel
how to generate loan repayment schedule in excel?
#loan repayment schedule
*loan repayment schedule
loan repayment table in excel
schedule
emi calculation formula
loan calculator
emi calculator
home loan calculation method
loan emi calculation
emi calculation in excel
how to calculate emi on loan
loan calculation formula
loan amortization schedule excel
bank emi calculation formula
how to calculate emi
car loan emi calculation formula
home loan emi calculator excel
calculation of emi
emi calculator for home loan
emi calculator in excel
loan sheet in excel
amortization table excel
emi calculation
emi sheet in excel
home loan calculator
how to calculate emi in excel
interest rate calculation
loan amortization schedule
loan emi calculation formula
loan repayment schedule
amortization schedule
bank home loan interest calculation
bank loan emi calculation formula
calculate interest rate
education loan emi calculator
emi calculator app
emi interest calculation formula
gold loan interest calculation formula
home loan
home loan emi calculation
home loan emi calculator
home loan prepayment calculator
how to calculate emi on car loan
how to calculate emi on personal loan
if formula in excel
learning zone
lic home loan
loan installment calculation
loan ki emi kaise calculate kare
loan repayment
loan repayment calculation
pmt
teri meri dooriyan
Excellent and inspiring tips
Very Best and logical way to teach,
Love from Pakistan dear sir
Thank you, you explained very well in the video and after watching your video, I understood completely. How to format EMI in Excel Thank you once again! Sir....
Thanks a lot for comments and love..... ☺️
thank you so much sir .From Nepal
♥️
Thanks, Very Well & Logical Described Video.
Thanks, if you like it don't forget to share and subscribe 👍
Great Job 👍
Very good sir😊
Thankyou sir❤
Thank you😊
Good
hello bro mujhe ek help chaiye! ek finance back office mein excel mein kya kya kaam hota hai usksa playlist hai kya?? mujhe tutorial chaiye!
thnks for valuable knowledge❤
Simple interest k liya reducing amount k liye batoo
Sir, pls make a video on EMI calculation of Co-operative society.
Ok
Hello sir how to calculate daily emi two month please show it on youtube
I am greatly benefited. Keep this request of mine
Hi sir, This vides is awesome, and Will you add Repayment option for the same Project please
sorry for late reply, but I will definitely try, what you said
15 days loan installment ke liye banao sir
sorry dear, but mene try kiya to loan kam se kam 1 month ka to banana hi padega
Sir prepayment wala column bhi chahiye 🥲
Ok sure will do next time
What if initially no principal amount is paid
the interest will be calculated on balance outstanding amount.
Sir 15 days par emi Leni h tab kaise banaye sheet
Great! But Interest does not match my calculation
I thing total interest 500000 * 12% = 60000
Please explain it.
Pls remember here you calculated interest on simple interest method. but in the excel sheet we have used the compound interest method.
and pls also specify the no. of installment & also write how much total interest you got from your excel sheet.
Sir, i want ot know the tenure of a loan, if the loan amount is 2 lacs, Rate of interest 1.25% per month and the EMI amount is 15000
Currently I don't know this function... I will answer it definitely soon
कोई ग्राहक लगातार emi जमा नही कर रहा है।
जमा नहीं किया हुआ emi amount एक्सेल फार्मूला के द्वारा कैसे कैलकुलेशन करें।
iske liye ek differenet tareeke se loan schedule banana padega... ho sake to me iske liye ek new tareeke par video banane ki koshish karunga
Please
Mera date ka column # value! Aisa show ho Raha hai. Formula same hai.
Ya to function me kuch mistake h ya fir dates ko check Karo.... Wo date format me nhi hongi..
Iska exam from bheje
If Rate Change ?
Amount will be automatically change
@@LearningZoneSanju Suppose 2 year Rate 9% after 2 year Rate 12% how to effect it?
@@LearningZoneSanju If only Interest Received ?
You would need to calculate in 2 steps
1st : calculate on 9% for 4 year (because whole loan is for 4 years ( 2 yr @ 9% + 2 yr @ 12%))
Step 2 : Take the closing balance at the end of 2 year as loan amount and calculate again @12% for 2 year
@@LearningZoneSanju dear sir this only example suppose 20 year loan and if interest rate change not fix hogh or law
How to do can you provide video or excel sheet example?
Can you share the link?
docs.google.com/spreadsheets/d/1xID8b1fEj_V7tUHu_7xxR7-k-ISUOUbV/edit?usp=sharing&ouid=106577866057590256908&rtpof=true&sd=true
if installment is skipped. then how calculate
Also add a coloum for the payment before the balance outstanding column
The enter zero for no payment it will skip the emi payment