Studying Balance Sheet for Limit (Part 2) : Ratios & Net Working Capital
Вставка
- Опубліковано 6 вер 2024
- This is the second video regarding Balance Sheet analysis. In this, we have explained how to group the items of Balance Sheet for analyzing them for Business Limits. We have also explained how to calculate Current Ratio, Quick Ratio, Leverage Ratio, Debt Equity Ratio & Net Working Capital.
In the first video regarding Balance Sheet analysis, we explained about various items of Balance Sheet. Link for Part 1 is given below:
• Studying Balance Sheet...
very very thank you sir ap din dugni raat chugni tarakki kare. May God bless you sir.
Awesome sir the way you explain is so helpful for beginners with no banking background
Your explanation is very easy to understand the financial analysis, waiting for next updation on P&L account and DSCR Sir.
Sir it’s very helpful for me as I am from science background. Thank you so much
Easy and Great To Understand Balance Sheet for Banker
Another Great video literally an eye opener for every banker
@Finologist It was great learnimg from your Videos , Easy to understand and in layman lang. Request you if you can upload the excel sheet which u have prepared.
Thanks fr watching & for the feedback Prateek ji. Drop a mail to finologistforall@gmail.com. We will mail you the excel worksheets.
Thank you so much..itni easy language me samjhane k liye... keep posting video like this to better understand the credit portfolio.
sir, part 1 and part 2 video is very helping for who work in banking sector in liability department and who want move in asset department. thanks a lot. sir i want to know how to assessment for cc limit as well as how to calculate existing cc limit based on stock statement. once again thank to you . waiting for your next video based on what i mention in my comment.
Same here
Awesome video for cc limit analysis
Explained in a very simple manner useful for a person with non commerce background thanks
Thanks a lot Somesh ji. Plz share it with your friends n colleagues. 🙏
@@FINOLOGIST definitely
Plz provide your email id and contact no.
Easy to understand the financial analaysis,waiting for next videos regarding balance sheet comparison, assessment on CC level, profitability ratios.plz upload soon.
The way Sir you teach it's really helped me a lot and also cleared my all doubt regarding this .
But sir I want to know .. how to assess net worth & gross profit from the balance sheet .
Thank u so much for easily explained all things, it's very helpful for me for calculating CC limit.
Thanks for the feedback Mr Verma. Plz share it with your friends and colleagues too.
@@FINOLOGIST sir please share your contact details
Was waiting for this video and it’s worth watching. Plz keep posting next videos without breaks and thanks for providing knowledgeable information. 👍🏻
Good explain for non commerce back ground,, thank you sir👌
Absolutely fantastic way to explain. Pls add video to analyse P & L also.
Sir upload the next video pls. U r explanation is awesome.
Thanks. Plz share it with your colleagues n friends. Will upload next part shortly.
@@FINOLOGIST ok sir thanks.
Easy to understand.Kindly continue..
Thanks Mr Vikash
Very good initiative sir
Thanks sir for your excellent video
Thanks a lot Subhas ji. Do share it with your friends & colleagues. 🙏
सर जी आप बहुत अच्छी तरीके से समझाते हैं शेयर मार्केट में इन्वेस्ट करने से पहले बैलेंस शीट कैश फ्लो कौन-कौन से पैरामीटर देखें यह इस पर वीडियो बनाएं प्लीज
Sirjee, Ahapka bohot bohot Dhanyawad. Ahapne jis taraha se sikaya hain jo bahut hi saral bhasha main aur bahut hi saral example hone se Asani se samaj main.
Ahapse request hain ki same aiasehi Partnership firm, PVT LTD aur other companies ke example ke sath Mortgage loan aur MSME loans ka under writing video with calculation ka video jarur banaye.
Good bless you.
Nitin ji, aapka bahut bahut dhanyavaad. Hum aapki aur aap jaise saathiyon ki sahayta ke liye aage bhi aise video banate rahenge. 🙏
very very good explain and important sir
Waiting for the next part.. Please release it.
hi sir liked your video, its very easy to understand, please share videos for accessing auto loan in banks, what all ratios we consider while funding car.
Sir.. nicely u have explained. Thank u so much sir.. Sir, when we expect you next video i.e. balance sheet part 3 ?
Nice sir
Sir thank you for this extraordinary and very helpful video. Can I get the format of Financials all pages?
Thank you sir.. Thank you so much
Superb..
Very nicely explained ..
Very nice knowledge
Thanks 🙏
Thanks for watching Suraj ji. Plz share it with your friends & colleagues 🙏
Great sir..... Keep updating
Sir... Excellent Explanation... Waiting for next video on Profit & Loss Account Analysis please
Hai sir.! Thanks for informative video. Kindly, share the excel format.
Thank you so much sir
Thanks a lot Raju ji. Plz share it with your friends and colleagues too. 🙏
Make similar video on cost,volume profit analysis in MS excel!
Awesome explanation sir 🙏🙏
Thanks a lot Maneesh. Plz share it with your friends & colleagues too🙏
Dear sir plz explain P&L 🙏🙏
SIR,Please DO VIDEO WHERE company balance sheet AND PL analysis where all limits like CC ,TL,PACKING CREDIT,POST SHIPMENT CREDIT,LC LIMIT ASSESSMENT,LG LIMIT FIXATION ARE COVERED AT A TIME IN ONE PROPOSAL
Very easy way to learn..Sir plz share excel link if you can
Plz drop a mail to finologist finologistforall@gmail.com. We will share the Excel.
Thank you sir for your this video. CA Articles required this type of video. Sir If you don't mind can you make a video on Project Report and CMA Data.
Very briellent sir
Sir make a video how to punch balance sheet in cma and how to make projections
what to do if NWC is greater than loan required . if turnover is 250 lakh 25% is Rs.62.50 lakhs, loan required is 30 lakhs( a), but nwc is 70 lakh.
Theoretically speaking, it would be difficult to derive necessary MPBF (Maximum Permissible Bank Finance) for CC Limit in such a case. However, if borrower gives a plan & undertaking of using the available excess liquidity for Fixed Asset creation or long term Investments, then that portion of NWC can be considered as non Current Asset while calculating MPBF.
Sir bank loan account closed hone par debit and credit equal hona chahiye
Thanks nice information..
Thanks for watching Sanjeev ji 🙏
Hello sir, your videos is very useful for assessment of Credit proposal please so let us know when will you release your subsequent video of this topics.
Nice work done
Sir.. When will expect next video??, very useful upto part 2🙏
Great video
sir yadi bank ki cc limit ho to uske liye closing stock ki ratio kese calculat kre 180 days debit or credit
Sir please upload more case studies of listed companies.thanks🙏
Superb sir....how easy u have made this ratio balance sheet
Thankyou Chirag ji 🙏
Thanks for the information
very useful
Thanks ji
How to appraisal a cc limit and term loan
Sir SB and fixed deposit ka interest jo earn hua hai usko asset main Side karenga ya liability side Main
Hope you are good sir. Please update us when you will release new videos.
Nice information sir
Sir can you please explain what things we have to check in Loan Against Property case.
What sir only CONGRATS please provide me editable format of all pages of the financials
@@user-dd5dt1ho6s plz drop a mail to finologistforall@gmail.com. I will share the formats through return mail.
Very nice explained.Thanks a lot sir.Can u pls provide that excel sheet as the same is not visible.
Sir part 3 nahi milrha , please share part 3 ,we will be very thankful to you
Kindly explain whether unsecured loans which are not part if quasi capital will come in long term liabilities
Such unsecured loans should be treated as Long Term Liabilities if these are to be retained in the business for more than one year. In case these are to be paid within 12 months from the date of balance sheet, then these should ideally be treated as Current Liabilities.
Pls explain DSCR method
We hv already discussed DSCR in a video. Link is ua-cam.com/video/SNnf78rRHvg/v-deo.html
Plz make more same type video on analysazation....
We are working on it. 🙏
👍👍
Thank you sir
Sir, very good explanation by you on the topic. Request to ZOOM the screens since not readable
Thanks a lot. Plz watch it on PC or Laptop in higher resolution for better clarity.
How to determine % of overheads from balance sheet.
I am costing engineer I need to settle norms with supplier
Sir pls upload 3rd part
Thanks a lot Prince. We will upload next parts shortly.
@@FINOLOGIST plzz & plzz sir, kindly upload next part very soon.. we are eagerly waiting for part 3..👏👏
Pls sir or video post kariye... mai credit analysis job karna chahta hu...
Thank u sir
Sir
How have you considered TNW as capital .. rather its TA- TL- tangible Assets.
Correct me if I am wrong
Let me put it this way Aditya ji. This presentation is intended to drive home the idea of basics of Financial Analysis for Bank Limits.
TNW can be equal to Capital when there are no Intangible Assets in the Balance Sheet. Some Banks also deduct Investments in or Loans to Group Concerns to arrive at TNW. Clarity about concept is the goal. Happy that you raised a query!
PLZ PROVIDE Q&A PDF FOR CCP EXAM IF AVAILABLE
Make more videos sit on balance sheet
Sir please add next vedio regarding balance sheet
Very soon Ganesh ji
Next video kab ayega sir p/l ka?
Kindly share the link of part 1 video
Sir, where is the 3rd video link????
Please provide me.
Sir mujhe ITR ka basic concept clear karna h
If there is any book for balance sheet analysis.plze recommend
Hi. There are many books available for Balance Sheet. There are many sources available online too. But what matters is simplicity of concept which I have not found as yet. What I have learnt & conveyed in my videos is solely on the basis of practical experience.
Sir please provide that excels in description
Sir, next part??
Sir, part 3 upload kijiye
Thanks. Plz share it with your colleagues n friends. Will upload next part shortly.
Itne jo aap last me discuss kiye uske video kbb tk aayenge....waiting since long
Thanks for watching Mr Raj. We are working on it. Will try to upload as soon as possible.
@@FINOLOGIST m a banker sir...need all relevant video plz upload it as soon as possible...
What is gross profit
Net profit,profit before tax, etc
Sir can i get that excel sheet
Sir if possible please give pdf of this balance sheet and Excel sheet of formulas
Sir mujhe project Reports banane ka class karna hai..
Plz share this balance sheet for future revision plz share.....
Plz share your email id. I will try to send the pdf.
Plz chk your mail
@@FINOLOGIST sir।i am banker plz make an appraisal video... that cover all ratio all type of method of lending ie mpbf turnover method...and all concept that will help ful for msme credit officer...
Sir Please share spreadsheet to ratio analysis exle
@@FINOLOGIST sir I request you on mail please find name of akash sharma
Sir anpi exl sheet ka link de do
Ĺ
L
😊
Your video quality is worst ...not good
Plz watch it on PC, not on Mobile. Plz also increase Video quality in settings.