One of the finest explanation i have seen on TH-cam channel. Very clear & Proper Explanation. Thanks to upload this video. Big thanks to you Sir.......🙏
I am still unemployed. Because, I learn new skills. Thanks so much . I'm practice everyday with your help .😇 maybe I found a good job as soon as possible.
Very informative video sir. Your way of explaining is ousum 😊. I made the same Excel sheet . And also I subscribe to your channel sir. Now I will follow all your videos sir, thank you sir
thank you for this awesome informative video. aab agar mai fix emi varu toa total monthly payment, total interest paid aur baki ke niche wale calculation ke liye kya formula rakh sakte hai? hope to get the reply with the formula asap...
This video is very helpful to us.I request you to make video on termdeposit subject. It means in Excel worksheet some coloumn are there. like start date, end date, period,rate of interest, interest amount, TDS amount, remaining principal amount with TDS shall continue till maturity date or due date. Interest amount and TDS amount should show separately in Coloumn. according to financial year till maturity.most important thing is that as soon as we select the period from drop down menu rate should be apply according to financial year till maturity.automatically I want this worksheet for both category means simple interest and compounding interest.period should show in period column according to start date and end date. please make video on this subject ASAP. TDS amount limit is 40000 yearly.if Interest crossing 40000in a year then tds to be deducted from interest and balance interest amount continued with principal till maturity date. Thanks in advance.
Very good explanation bro. How to add variable interest rates in sheet as banks rates are changing (reducing) compared to the rate when loan was started
Hi, Good explanation, but there is a mistake, I created same Excel sheet, but it doesn't takes consideration of the Advance PAyment done. The Interest should go down, if after advance the principal reduces, but the interest and principal payment remains same.
सर जी डेली रेडूसिंग बैलेंस इंटरेस्ट में कौनसा फार्मूला लगेगा वो बताओ किसी ने 1 तारीख को लोन लिया और क़िस्त हर महीने 10 को कट रही ह ओर हर महीने 1 से 10 के बीच कोई दिनाँक को पार्ट पेमेंट भी कर रहा है
Love From Pakistan Punjab ...
Thanks ...
Great. I created a similar Google Sheet to track my personal loan. Subscribed to the channel. Thanks.
Sir thanku so much ek baar me mai aapke sath sab kar liya love you so much sir ❣️
भाई मेने आपका फेसबुक पेज को लाइक किया है
You have very simple working. You should also consider advance payment/Prepayment that will affect pmt factor resulting in different Emi.
I am very happy to get such easy formula for my home loan to keep a close watch.
very nicely explained in simple hindi language
Knowledge full Video Great Job Sir
bahut badiya aur simple hain. thanks
bro i love you 😂 yrr itni accha se explain kra yrr both accha
Awesome bhai.. Reducing interest ka formula bhi bata dein please.
One of the finest explanation i have seen on TH-cam channel. Very clear & Proper Explanation. Thanks to upload this video. Big thanks to you Sir.......🙏
This video is useful informative for excel beginners
Thank you.
I am still unemployed. Because, I learn new skills. Thanks so much . I'm practice everyday with your help .😇 maybe I found a good job as soon as possible.
Nice video with good explanation 👍
Good & precise explanation !
Very well explained, thank you so much..
This Video is very helpful to me.. Thanks sir
Thanku sir ji aapne bahut ache se samjhay
Very good bhai good luck
Best work...Dhanyvad
Very informative video sir. Your way of explaining is ousum 😊. I made the same Excel sheet . And also I subscribe to your channel sir. Now I will follow all your videos sir, thank you sir
Bahot badhiya
Thanks for your valuable & well-explained calculator
Thank you Brother very nicely explained and made it understood.
Thanks Brother 🌹🌹
Super Video Sir Thanks a Lot
Superb explanation. I understood this method thanks a lot Sir.
Thank You sir for such a wonderful video ❤
Ye to sab mix ho gya h mere dimag me first time kara
thanks sir very use full videos
Really... Very good explained, informative video.
Very good sir batane ke liye
Thanks you giving a valuable knowledge
Very good vedio and also very good presentation go ahead⏩⏩⏩
Thank you.. sir ... Great work done sir... So much respect,,,
Nice explaination
thank you so much for this informative and helpful video
good job bro.
Dear Sir thanku so much for this useful information
Too nice vedio sir
Thanks a lot sir what a ...... 😊
wow, apne bohot esyly sikha diya.....thank you sir..
Fantastic!
Very well explained SIR
Great 😊
Very nice sir ji
How knowledgeable video sir❤
Very good explanation. very nicely. thanks
Excellent
good, valuable task
very good explanation
Superb👍
Thanks bhai....
❤❤❤❤❤ superb
Nice Vedio
Sir,
Very well explained.
THANKS SIR
Nice Video
Time best video hai ye
Excellent video brother
Thank you sir!!
Very good sir
bhai bhai bhai bhai
lovely
op
Thanks bro
Sir please, teaching telly .my English is not good but I am practice and use whole day . Thanks Sir.
Very nice
सर एक प्रॉफिट एंड लॉस और बैलेंस शीट का वीडियो बनाये plz
thank you,,
Really helpful brother, although advance payment didn’t worked. Would you mind helping me on this?
Thank you for this.
Superb
thank you for this awesome informative video.
aab agar mai fix emi varu toa total monthly payment, total interest paid aur baki ke niche wale calculation ke liye kya formula rakh sakte hai?
hope to get the reply with the formula asap...
So much helpful 🔥🔥
Thank you bro
Very nicely explained for a layman like me . Thank you
Awesome
Excellent 👌
Helpfull to all of us
Thankyou..
AWESOME EXPLAINATION. THANK YOU FOR THIS
This video is very helpful to us.I request you to make video on termdeposit subject. It means in Excel worksheet some coloumn are there. like start date, end date, period,rate of interest, interest amount, TDS amount, remaining principal amount with TDS shall continue till maturity date or due date. Interest amount and TDS amount should show separately in Coloumn. according to financial year till maturity.most important thing is that as soon as we select the period from drop down menu rate should be apply according to financial year till maturity.automatically
I want this worksheet for both category means simple interest and compounding interest.period should show in period column according to start date and end date. please make video on this subject ASAP. TDS amount limit is 40000 yearly.if Interest crossing 40000in a year then tds to be deducted from interest and balance interest amount continued with principal till maturity date. Thanks in advance.
Thank you 🤝
Wow👏👏👏
thanks
भाई मेरी टाईल्स की दुकान है तो इस पर भी विडिओ बनाओ प्लीज
ok aap pahle bhi sms kiye the
Ha sir
Wow 🔥🙏
Nice explanation, please correct spellings on the initial part of the video
Bhaishab ek baar advance wala column m data dalkar bhi dekho negetive value aa jati h niche
sirjee, nice video and very simple explanation, i request for the same file with penalty interest and late payment fee on month/daily basis
👍👌
Very well Explained , can you let us know how can Moratorium be added in this Excel , this will be best format for finance people and customers
Kya isme interest rate ko b adjust kr saktey hai kuch months k baad?
Mera interest rate Kam hua h 14th month me
Very good explanation bro. How to add variable interest rates in sheet as banks rates are changing (reducing) compared to the rate when loan was started
Superb this one! Can you make a video on nper in this patern? Reply me plz.
Aapne jo education dee superfast hai per ek kami rahe gayi ADV. Payment ka aapne formula nahi bataya to pls... Use bhi aap bataya dijiye
Hi, Good explanation, but there is a mistake, I created same Excel sheet, but it doesn't takes consideration of the Advance PAyment done. The Interest should go down, if after advance the principal reduces, but the interest and principal payment remains same.
Ya, correctly said.. Interest amount should be reduced once the advance payment is done
nice video but jab aap advance payment karte hai to uske anusar principal and interest amount calculate nai ho raha hai . check karke bata dijiya
What if Adv payment will made? Tenure will be less?
सर जी डेली रेडूसिंग बैलेंस इंटरेस्ट में कौनसा फार्मूला लगेगा वो बताओ
किसी ने 1 तारीख को लोन लिया और क़िस्त हर महीने 10 को कट रही ह ओर हर महीने 1 से 10 के बीच कोई दिनाँक को पार्ट पेमेंट भी कर रहा है