EMI loan calculator excel reducing balance sheet design with statement in Ms Excel
HTML-код
- Опубликовано: 19 авг 2024
- This video describes the EMI calculation sheet design in , if you like the video then give your feedback.
Training File:- drive.google.c...
loan calculator excel reducing balance
Emi Calculator
Reducing Balance Method of Loan Calculation
Simple Loan Calculator
emi calculator excel sheet with prepayment option
loan repayment schedule excel download
loan calculator reducing balance formula
loan calculator excel formula
pre emi calculation excel spreadsheets
simple interest loan calculator excel formula
how to calculate reducing balance interest rate in excel
emi calculator excel download india
Friends on this channel you are given absolutely original information about Microsoft Word Microsoft Excel Power Point Video Mixing Computer Hardware Laptop Hardware Online Information.
Friends, before uploading videos on this channel, it is kept in mind that this video should benefit you and you can learn a lot from one video.
Where does the friend go, no one has any work
My instagram Link : / ctechindia
My Instagram Personal Link : / chandan.ctech
Facebook Page Link: / ctechindia
My Other Hindi Channels:
Real Tutorial : ✅
/ @designapna
My Website: www.designapna...
#EMI #loancalculator #Ctech Наука
One of the finest explanation i have seen on RUclips channel. Very clear & Proper Explanation. Thanks to upload this video. Big thanks to you 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.
Thanks for your valuable & well-explained calculator
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.
Love From Pakistan Punjab ...
Thanks ...
Great. I created a similar Google Sheet to track my personal loan. Subscribed to the channel. Thanks.
very nicely explained in simple hindi language
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
wow, apne bohot esyly sikha diya.....thank you sir..
This video is useful informative for excel beginners
Thank you.
Sir thanku so much ek baar me mai aapke sath sab kar liya love you so much sir ❣️
भाई मेने आपका फेसबुक पेज को लाइक किया है
Superb explanation. I understood this method thanks a lot Sir.
Nice video with good explanation 👍
This Video is very helpful to me.. Thanks sir
Thank you Brother very nicely explained and made it understood.
Knowledge full Video Great Job Sir
Apka video, formula, etc 100% sahi hai. Lekin asal zindegi me bank ka calculator bahut alag hai. Public ko lut Rahi hai
right, thanks aap ne c tech channel ko 4 year pahle subcribe kiya tha
Right
Thanku sir ji aapne bahut ache se samjhay
Very well explained, thank you so much..
Thanks you giving a valuable knowledge
thanks sir very use full videos
Sir,
Very well explained.
bro i love you 😂 yrr itni accha se explain kra yrr both accha
Good & precise explanation !
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.
Sir please, teaching telly .my English is not good but I am practice and use whole day . Thanks Sir.
सर एक प्रॉफिट एंड लॉस और बैलेंस शीट का वीडियो बनाये plz
Best work...Dhanyvad
Really... Very good explained, informative video.
Ye to sab mix ho gya h mere dimag me first time kara
thank you so much for this informative and helpful video
Very good vedio and also very good presentation go ahead⏩⏩⏩
Thank you.. sir ... Great work done sir... So much respect,,,
Thank You sir for such a wonderful video ❤
Really helpful brother, although advance payment didn’t worked. Would you mind helping me on this?
Dear Sir thanku so much for this useful information
Thanks Brother 🌹🌹
Very good explanation. very nicely. thanks
Very nice sir
Super Video Sir Thanks a Lot
❤❤❤❤❤ superb
Fantastic!
Very good sir batane ke liye
Bahot badhiya
Very good bhai good luck
sirjee, nice video and very simple explanation, i request for the same file with penalty interest and late payment fee on month/daily basis
भाई मेरी टाईल्स की दुकान है तो इस पर भी विडिओ बनाओ प्लीज
ok aap pahle bhi sms kiye the
Ha sir
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
Very nicely explained for a layman like me . Thank you
Great 😊
Excellent
Very well explained SIR
good job bro.
THANKS SIR
Bhaishab ek baar advance wala column m data dalkar bhi dekho negetive value aa jati h niche
Too nice vedio sir
AWESOME EXPLAINATION. THANK YOU FOR THIS
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
Nice explanation, please correct spellings on the initial part of the video
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
good, valuable task
thank you,,
Superb
very good explanation
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...
How knowledgeable video sir❤
bhai bhai bhai bhai
lovely
op
Thankyou..
Thanks a lot sir what a ...... 😊
Nice Video
Excellent video brother
Hello sir how to calculate daily emi two month please show it on youtube
I am greatly benefited. Keep this request of mine
Helpfull to all of us
Thanks
Very nice sir ji
So much helpful 🔥🔥
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
Nice explaination
Thank you sir!!
Thank you for this.
Very good Sir
Nice Vedio
Superb this one! Can you make a video on nper in this patern? Reply me plz.
Thank you bro
Thanks bhai....
thanks
Create video on housing loan EMI amount paid till maturity with advance payment facility in Excel worksheet with allformulas to be shown in worksheet
Superb👍
Sir please make video regarding calculate day wise interest on loans automatically..
Thank you 🤝
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
One flaw in this.. When we do an advance payment then either the time period or EMI should reduce.. Which is not happening
Advance payment ka aapne nahi bataya .
Please tell us if we pay advance payment than what is calculation formula for that
Also create video on gold loan EMI amount and interest with advance payment facility with formula in Excel worksheet ASAP
I again request you to create video on gold loan EMI amount and interest with advance payment facility with formula in Excel sheet asap
Dhiran mandali vala formula banaie sir
Awesome
Flat rate formula kaise please vedio bana dijiye
Sir Daily Emi ki Formula Chaye plz