A REPORT ONBHIWADI CYLINDERS PRIVATE LIMITEDFINANCIAL STATEMENT ANALYSISBy BhawnaRoll No. : 1600074B201Programme (2016-2019) K.
L. Datta & Co. Chartered Accountants BhiwadiCompany Guide:K.L. Datta & Co. Chartered AccountantsMr. Mudit Rustogi Sr. Manager, Accountant Auditor Bhiwadi, RajasthanFaculty GuideDr.
- Thesis Statement
- Structure and Outline
- Voice and Grammar
- Conclusion
Amit BaggaBML Munjal University`DECLARATIONI hereby declare that the Project Report “BHIWADI CYLINDERS PRIVATE LIMITED FINANCIAL STATEMENT ANALYSIS” is my own work to the best of my knowledge and belief. It contains no material previously published or written by another person or material which to substantial extent has been accepted for the award of any other degree, diploma or programme of any other institute, except where due acknowledgement has been made in textBHAWNADate: 23-07-2018 Roll No.:1600074B201BML Munjal UniversityDINESH KUMAR GOYALK.L.DATTA & CO.Chartered Accountant SPL-1(G), IND. AREAMob-9414012805 BHIWADI-301019 9214012805 CERTIFICATEThis is to certify that Ms.
Bhawna having I. D. No.
1600074B201, a student of Programme B.Com(KPMG) from Institute (BML Munjal University, Gurgaon) has done his/her Summer Internshipat K.L. Datta & Co.
, Chartered Accountants, SPL-1(G), RIICO Industrial Area, Bhiwadi, Distt. Alwar, Rajasthan from 21/05/2018 to 13/07/2018.This Project work entitled “Bhiwadi Cylinders Pvt. Ltd. – Financial Statement Analysis” done by Bhawna during his/her Summer Internship.
We wish her every success in life. M/S K.L. Datta & Co.,Place: Bhiwadi Chartered AccountantsDate: 17.07.2018 (D.K.
Goyal) Partner M. NO. : 074523—————————————————————————————————————————————Tel:- 01493-220920, 221770, Email: [email protected], [email protected]
com ACKNOWLEDGEMENTI have taken efforts in this summer internship. It would have not been possible without constant support and guidance of many people. I would like to extend my sincere thankfulness and indebtness to all those who extended their kind help by spending their precious time in explaining the various intricacies of the subject and suggesting the correct approach to me.
I am highly indebted to Mr Gopi Chand Goyal for their guidance and constant supervision as well as for providing information regarding my project work and also for helping me in completing my internship.I would like to express my gratitude towards my parents and member of K.L. Datta & COMPANY for their kind cooperation and encouragement which helped me in the completion of this internship.And lastly I would like to express my special gratitude to my supervisor Mr Mudit Rustogi for giving me such attention and time. This project has been a great learning experience for me and without his help it would not have been possible for me to do this project.
EXECUTIVE SUMMARYBhiwadi Cylinders Pvt. Ltd. (BCPL) established in 1998. It is one of the largest cylinder manufacturers in India, having an annual production capacity of around one million cylinders unit located at Bhiwadi.It is one of the leading cylinder suppliers to the public sector LPG marketing companies in India like Indian Oil Corporation Limited, Bharat Petroleum Corporation Limited and Hindustan Petroleum Corporation Limited and have so far gave nearly one million LPG cylinders to these marketing companies. Its other variety of products are refrigerant cylinders (non-refillable and refillable), stainless steel cylinders for special applications, automotive LPG cylindrical and toroidal tanks in various sizes and capacities.
Apart from this it’s involved in the manufacturing of multi-function valves used in automotive applications on board for LPG. The same section is manufacturing LPG cylinder and valves for disposable cylinders.Four modern production lines have been built with advance equipment’s in order to cater to domestic and international demand of LPG / Auto LPG / Non-Refillable / Refillable cylinders and valves. All the parameters of the quality are implemented by maintaining access to Indian, International, ISO, British, and American and European standards. For Indian markets the products are certified from Bureau of Indian Standards (BIS) as well as Petroleum and Explosives Safety Organization (PESO).Besides domestic marketing BCPL have also been exporting products to the countries like Kenya, Nigeria, Uganda, Rwanda, Mozambique, Ethiopia, Tanzania, Ghana, Chad and United Kingdom directly and various other countries all over the world indirectly.
For export to European market its LPG and Helium gas cylinders carry PI marking from Bureau Veritas. It also has cylinder manufacturing approval from US Department of Transportation to manufacture and market cylinders. Its manufacturing facilities are approved by Standard Organization of Nigeria (SON) and Kenya Bureau of Standards (KEBS). Its products have the certification of conformity from M/s Intertek (India).The emphasis of the company is always on delivery of the products, meeting international quality standards at the lowest possible cost. For this, continuous training is imparted to its employees from time to time and high level of motivation is maintained. The result of this teamwork is visible in the product which speaks for its qualitywith its diversified commitments to the national and international standard /quality and safety. It is most trusted name in the industry today but for them at BCPL there is no time to rest, as many more milestones are yet to be achieved.
TABLE OF CONTENTSCONTENT Page No. Acknowledgement………………………………………………………….….……….……IVExecutive Summary…………………………………………………….
………………………….
……..
..vList of Tables & Illustrations…………………………………………………………….
…8List of Diagrams…….
…….
……..
……
……
……..
…
…..
…..
…..
……
…..
….
……
…….
……..
……
…
…..
…….
….
…..
…
.8Introduction1.1 Company Overview…
……..
……
…..
…
…..
….
……..
…….
……
……..
….
…….
…
……..
……
……..
….
…………………
.91.2 Introduction of the Study………………………………………………………………………………………….14Review of Literature..
….
……..
…….
……
…….
….
…
…….
…
…….
….
…
…
…..
……
…
……
……
…..
…….
……
……
..……
.15Methodology….
…..
……
……..
….
……..
….
….
…
……..
…
…..
……..
….
…
…….
…………………………………16Data Analysis1.0 Balance sheet (2017-18)……………………………………………………………………………………………………………………………..171.1 Profit & Loss Statement (2017-18)………………………………………………………………………………..281.2 Comparative Ratio Analysis…………………………………………………………………………………………..35Findings & Suggestions………………………………………………………………………………………………………..……40Conclusion………………………………………..………………….………………………41Limitations of the Study………………………………………………………………………………………………………………………42Recommendations…………………………………………………………………………………………………..42Bibliography………………………………………….………………………………..……47 LIST OF TABLES & ILLUSTRATIONS Table No Topic Page NoTab 1 Balance Sheet (2017-18) 17Tab 2 Profit & Loss Statement (2017-18) 28Tab 3 Current Ratio 35 Tab 4 Quick Ratio 35Tab 5 Gross Profit Margin 36Tab 6 Net Profit Margin 36Tab 7 Return on capital employed 37Tab 8 Solvency Ratio 38 LIST OF DIAGRAMSDiagrams No Topic Page No.Fig (a) Liquidity Ratios 35Fig (b) Profitability Ratios 36Fig (c) Return on capital employed 39Fig (d) Solvency Ratios 38 COMPANY OVERVIEWBhiwadi Cylinders Pvt. Ltd. (BCPL) established in 1998. It is one of the largest cylinder manufacturers in India, having an annual production capacity of around one million cylinders with manufacturing unit located at Bhiwadi.PROMOTERSMr. Manvinder Singh – Managing Director An engineering graduate from Delhi College of Engineering. He is a well-known and respected technical professional in LPG cylinder industry in India and also a member of the following associations:• Member of committee appointed to revise gas cylinder rules. • Indian Auto LPG Coalition.• ME -16 committee of Bureau of Indian Standards.• Convener of the subcommittee to develop standards for Cryogenic Tanks • Represents India in ISO as expert in Gas Cylinder manufacturing.He has also established The Srijan School, Model Town, and New Delhi. Mr. Rajneesh Chopra – DirectorHolds a management degree from IMT Ghaziabad. Mr Chopra joined Bhiwadi Cylinders after a career in banking.His greatest strength to the team has been increasing the efficiency in operations, increasing the scale of operations and timely delivery of the goods. He is in charge the production, purchase, finance and other commercial activities. Mrs. Suminder Kaur – DirectorHolds a Post-Graduation from IIT, Delhi. Mrs. Kaur has worked in the area of software use and development. She joined Sapphire (India) Pvt. Ltd. as a Director in 2002 and thereafter joined Bhiwadi Cylinders Pvt. Ltd. In December 2005. Financial ProjectionsYEAR TURNOVER (INR)2018-2019 160 cr2019-2020 180 cr2020-2021 210 crPatentsBhiwadi Cylinders have applied Patent for the following product:High tensile steel cylinder for refrigerant gases. Products Range1. LPG cylinders for Indian market of 5, 14.2, 19 and 47.5 kg for public sector2. LPG cylinders for private marketers 12, 12.5, 15, 17 and 30 kg3. Auto gas tanks for LPG4. Gas cylinders for refrigerant gases like R22, R134a, R410a and R32 for Indian markets5. Brass valves for LPG cylinders and multi-function valves for Auto LPG6. Jumbo cylinders of 1000 liters for LPG.7. Tonners for R410a etc.8. Stainless steel tonners under development for propellants for medical use.9. Non-refillable cylinders refrigerant gases and other applications. These are completely exported indirectly by gas fillers / manufacturers and also deemed exports. Gas cylinders for exports to more than 25 countries. Team of BCPLThe highly trained and motivated team is one of the strongest pillars of the company. These include qualified engineers, finance, and human resource and management professionals. They encourage the team to enhance their skills by participation in trainings, seminars and exhibitions: in India and abroad. Mr R.K. Raina Mr Raina is an MBA with extensive marketing experience across various industries. He is spearheading exports of gas cylinders and valves and looks after the refrigerant gas cylinder market in India. Mr Ashish JainIs a graduate in Company Law? Has extensive experience in Finance. Manages the financial needs and relationships of the company. Mr S.K. Dey Is an Engineering graduate. Has extensive experience in valve development and manufacturing. Holds a patent of valve design. Mr Anurag PatelPost Graduate in welding technology and a Mechanical Engineer. Experienced in pressure vessel and cryogenic cylinder space with prominent companies in India. He manages the design, development and production of all big capacity cylinders in the company. Mr Sher SinghMr Singh is a graduate in Mechanical Engineering. He has spent more than 20 years at Bhiwadi Cylinders. He looks after the quality processes. Projects1986 – 1998Manufacturing of LPG cylinders for Indian public sector companies like Indian Oil Corporation Limited, Hindustan Petroleum Corporation Limited and Bharat Petroleum Corporation Limited.1998Bhiwadi Cylinders was set up for reconditioning of LPG cylinders.2003Started manufacturing disposable cylinders for various refrigerant gases. Today Bhiwadi is one of the well-known disposable cylinder manufacturer in the international market.2007Started manufacturing of valves for LPG cylinders. Today the company has a capacity to manufacture 25000 – 30000 valves per day.2008Started exporting various sizes of cylinders ranging from 3 kg to 50 kg. The company has so far exported cylinders to more than 30 countries all over the world.2015Started manufacturing low weight LPG cylinders made out of High tensile steel.2016Started manufacturing 990 ltr. tanks for commercial use. The demand for these tanks is growing steadily in India in commercial use. Presently the company is supplying these tanks to various reputed oil companies in India.Under development ProjectsBhiwadi Cylinders has the following projects under development:Manufacturing of tonners (1000 kg) for refrigerant gases .These tonners are in high demand in refrigerant industry locally as well as internationally.Manufacturing of Intermediate Bulk Carrier (IBC) SS tanks of various sizes and capacities. Future ProjectsBhiwadi Cylinders plans to develop the following products in the future: Manufacturing of CANS for refrigerant industry. They have a high demand in India as well as internationally and we expect their initial sale to be approximately 10 – 12 million pieces.Manufacturing of cryogenic TANKS.Legal Identity: Bhiwadi Cylinders Private Limited (BCPL) is incorporated on 01 January 1998. BCPL is classified as Non-govt company and is registered at Registrar of Companies, Delhi. BCPL authorized share capital is Rs. 60,000,000 and its paid up capital is Rs. 59,470,200.It is involved in Manufacture of refined petroleum productsAnnual General Meeting (AGM) of Bhiwadi Cylinders Private Limited was last held on 30 September 2016. INTRODUCTION OF THE STUDYBhiwadi Cylinders Pvt. Ltd. is a Private limited Company. It was founded in the year 1998 in Bhiwadi (Rajasthan). Its directors are Mr. Manvinder Sing, Mr. Rajneesh Chopra, and Mrs. Suminder Kaur. Finance is defined as the supplement of money when it is required. Finance is a must for every company. It is required to carry the operations of the company. Finance is vital for every company so it needs to look upon effectively. As we know that every company analyses its financial position after the end of its accounting period. This helps in knowing the strengths and weakness of the company and thereafter helps in the decision making of the company.There are many methods and techniques through which we can analyse the financial performance of the company such as Comparative statements, Cash flow analysis, Ratio analysis and other operative data.The very first step is to collect the information and analyse it for making decisions.Second step is to arrange the information in a proper way to compare and make significant relationships.And at last it is required to draw conclusions and make recommendations if any.The present study is made as a part of the B.COM (KPMG) programme for summer internship in the form of on the job training with following activities.To know about the financial position of the Bhiwadi Cylinders Pvt. Ltd.To know the strength and weakness of Bhiwadi Cylinders Pvt. Ltd.To measure the liquidity position of the company.To find out the operational efficiency of the company.To measure the growth rate over the years.To know about the solvency and inventory use of the company.To know the overall profitability of the company over the years.All the activities are carried out in the Bhiwadi Cylinders Pvt. Ltd. Office in Bhiwadi, Rajasthan. LITERARURE REVIEWBhiwadi Cylinders Pvt. Ltd. was incorporated in the year 2008. It is a Private Limited Company. It has currently three directors. It’s a manufacturing company headquartered at Delhi. The company has three designated directors Mr. Manvinder Sing, Mr. Rajneesh Chopra, Mrs. Suminder Kaur. The company started with adequate amount of capital and limited staff and farms. But slowly and gradually the company expanded and has become one of the top manufacturing company of Rajasthan. Bhiwadi Cylinders never lose the sight of the strategies that had helped establish the company. Their marketing remained an important aspect of the business.With progressive years Bhiwadi Cylinders have paid a lot of emphasis on expanding the company all over India. It has focused immensely on customer loyalty by providing quality products. Its marketing has also improved over the years. The company produces affordable products and has a flexible manufacturing set up for longer uniformity of products. It also comprises to international standards and fully absorption of technology. There is a rising competition among manufacturing companies so one has to set their prices accordingly. There should be a strong distribution network across the country which will help in expanding. Immense focus on retail marketing as well. Using innovative display and communicating to customers through exbhitions and trade shows for consistent brand building efforts. A highly skilled human work force can be formed by identifying hardworking and deserving candidates and rewarding them.The company is continually on the path to overcome any threats arising from competition amongst other manufacturers by making the product more competitive in terms of price and quality. The implementation of GST can also impact the company. METHODOLOGYThis project involved a lot of deep research and study of Bhiwadi Cylinders Pvt. Ltd. In this project report a sincere effort has been made to study the financial statements analysis of the company. During this study I have studied the financial position, projection and performance of the company. At last I have given interpretation and conclusion of the company.The whole of my study is based on secondary data Bhiwadi Cylinders Pvt. Ltd. I have not taken any primary data would not have been helpful to me. During the holding of my study I have taken help of the following secondary data.Annual report of Bhiwadi Cylinders Pvt. Ltd.Balance sheet of Bhiwadi Cylinders Pvt. Ltd.Profit and loss account of Bhiwadi Cylinders Pvt. Ltd.There are some of the tools which are applicable for the study of analysis and performance of Bhiwadi Cylinders Financial Statements.Comparative StatementsTrend AnalysisRatio analysisThe main objective of the project is to help the management of the organisation in decision making regarding the subject matter. Calculation and analysis of the financial statements is only the office task whereas the interpretation of the analysis needs knowledge, skills and intelligence. One of the easiest and most popular ways of evaluating performance of the organisation is to compare its present ratios with the past ones called comparison and through development action plan.Basically it gives an indication of the direction of change and reveals whether financial performance of the company has improved, detoriated or has remained constant over the years. The profitability of the company is especially highlighted through this.A lot of emphasis is given to the comparison between the accounting years which helps us to know the performance criteria of the company. Because of this we can also estimate the growth trends of the company. M/S BHIWADI CYLINDERS PRIVATE LIMITEDE-925,1200 ; 1201,INDUSTRIAL AREA,BHIWADI-301019Balance Sheet as at 31 March, 2018S.NO. PARTICULARS Note No. FIGURES AS AT 31.03.2018 (Amount in Rs.) FIGURES AS AT 31.03.2017 (Amount in Rs.)A EQUITY AND LIABILITIES 1 Shareholder’s Funds (a) Share Capital 1 5,94,70,200.00 5,94,70,200.00(b) Reserves & Surplus 2 13,09,92,342.31 6,44,45,872.80 2 Share Application Money Pending Allotment – 3 Non-Current Liabilities (a) Long-term borrowings 3 22,33,89,318.26 17,87,02,537.59 (b) Deferred tax liabilities (Net) 4 31,31,526.12 31,31,526.12 (c) Other Long term liabilities – (d) Long-term provisions – 4 (a) Short-term borrowings 5 21,39,10,414.71 20,27,99,488.50 (b) Trade Payables 6 23,47,27,080.53 30,85,42,615.59 (c) Other current liabilities 7 -1,20,42,917.76 3,37,08,334.14 (d) Short-term provisions 8 62,70,696.00 62,70,696.00 TOTAL 85,98,48,660.17 85,70,71,270.74 B ASSETS 1 Non-Current Assets (a) Fixed Assets (i) Tangible Assets 9 12,52,72,080.14 10,27,23,741.61 (ii) Intangible Assets – – (iii) Capital work – in – progress – – (iv) Intangible assets under development – – (b) Non-Current Investments 10 1,96,20,000.00 1,96,20,000.00 (c) Deferred tax assets (net) (d) Long-term loans and advances 11 0.00 7,50,000.00 2 Current Assets (a) Current Investments 12 82,07,414.21 80,60,908.21 (b) Inventories 13 30,59,64,280.65 27,11,64,759.65 (c) Trade receivables 14 25,99,83,499.60 30,62,02,259.28 (d) Cash and cash equivalents 15 97,50,124.99 13,66,889.80 (e) Short-term loans and advacnes16 60,51,508.00 10,00,66,877.48 (f) Other current assets 17 12,49,99,752.58 4,71,15,834.71 TOTAL 85,98,48,660.17 85,70,71,270.74Note No.-1 SHARE CAPITAL S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) SHARE CAPITAL 1 Authorised 60,00,000 equity shares of Rs. 10/- each 6,00,00,000.00 6,00,00,000.00 having Equal voting rights 2 Issued, Subscribed & fully Paidup in Cash 5947020 equity shares of Rs. 10/- each 5,94,70,200.00 5,94,70,200.00 having Equal voting rights 5,94,70,200.00 5,94,70,200.00A Reconciliation of the shares outstanding at the beginning and at the end of reporting period.Particulars Equity Shares-Current Year Equity Shares-Previous YearNumber Amount Number AmountShares outstanding at the beginning of the year 59,47,020.00 5,94,70,200.00 56,67,020.00 5,66,70,200.00 Shares Issued during the year – – 2,80,000.00 28,00,000.00 Shares bought back during the year – – – – Shares outstanding at the end of the year 59,47,020.00 5,94,70,200.00 59,47,020.00 5,94,70,200.00 B Terms / Rights attached to SharesAll equity shares are having equal voting rights. C Shareholding of more than 5% Name of Shareholder- Equity Shares As at 31 March 2018 As at 31 March 2017No. of Shares held % of Holding No. of Shares held % of Holding MANVINDER SINGH 1306182 21.96% 1306182 21.96%TRIBURG INVESTMENT & ENGINEERS PRIVATE LIMITED 1025332 17.24% 1025332 17.24%RAJNEESH CHOPRA 584504 9.83% 584504 9.83%KRIPRA FINVEST PVT LTD 350000 5.89% 350000 5.89%WENS AGRO FOODS LTD 300000 5.04% 300000 5.04%SUMINDER KAUR 615000 10.34% 615000 10.34%JAGMOHAN SINGH 320000 5.38% 320000 5.38%TOTAL 4501018 75.68% 4501018 75.70%D Shareholding of Less than 5% MAKAMASHI SALES P.LTD 200000 3.36% 200000 3.36%SUNINT INVESTMENT & TECHNOLOGY PVT LTD 260000 4.37% 260000 4.37%SAPNA JAIN 185000 3.11% 185000 3.11%ASHISH JAIN 150000 2.52% 150000 2.52%BEENA JAIN 15000 0.25% 15000 0.25%PRATAP CHAND CHANDANA 136002 2.29% 136002 2.29%DADI RESORTS & HOTEL LTD 250000 4.20% 250000 4.20%MAKAMASHI ENTERPRISES LTD 250000 4.20% 250000 4.20%TOTAL 1446002 24.30% 1446002 24.30%TOTAL 5947020 100.00% 5947020 100.00% Note No.-2-: Reserve & Surplus (Amount in Rs.) PARTICULARS As at 31.03.2018 As at 31.03.2017 a) Capital Reserve Opening Balance 7,82,605.00 7,82,605.00 Addition: Current Year Transfer – – Deduction : Written back in current year – – Closing Balance 7,82,605.00 7,82,605.00 b) Foreign Exchange Earning Reserve Opening Balance – – Addition: Current Year Transfer – – Deduction : Carried to General Reserve – – Closing Balance c) Surplus Opening Balance 6,11,43,267.80 5,45,99,620.31 Addition: Net Profit after tax transferred from Statement of Profit & Loss 6,65,46,469.51 74,90,307.49 Amount available for appropriations Deduction : appropriations for Tax (9,46,660.00) Closing Balance 12,76,89,737.31 6,11,43,267.80 d) General Reserve Opening Balance 25,20,000.00 25,20,000.00 Addition: Share Premium Earning Reserve – Deduction : appropriations – – Closing Balance 25,20,000.00 25,20,000.00 Total 13,09,92,342.31 6,44,45,872.80 Note – 3 LONG TERM BORROWINGS S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) Secured a Standard Chartered bank 95,30,214.26 1,11,84,299.89 (Secured against hypothecation of Office building of Registered Office situated at Delhi and personal guarantee of Directors @ 8.7%) b Edelwiese 2,69,45,945.00 2,96,91,533.00 (Secured against hypothecation of Property No. L-28/8, City Phase -II, Gurgaon and personal guarantee of Directors @ 13%) c Vehicle Loans (Annexure-A) 44,62,965.72 33,18,704.70 (Secured against hypothecation of respective vehicles and personal guarantee of Directors) Term Loan 3,34,05,090.28 Unsecured Loan (d) From Directors,ShareHolders & Theirs Relatives 75,00,000.00 – (e) Intercorporate Loans (Annexure-B) 141545103 13,45,08,000.00 – – Total 22,33,89,318.26 17,87,02,537.59 Note – 5 SHORT TERM BORROWINGS S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) Secured (a) Loans repayable on demand – i) HDFC Bank Limited 9,39,10,414.71 8,27,99,488.50 ii) WCDL(HDFC Bank) 12,00,00,000.00 12,00,00,000.00 Total 21,39,10,414.71 20,27,99,488.50 Note – 6 TRADE PAYABLES S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) (a) Trade Payable (Annexure-C) Services 42,77,415.46 74,09,186.33 Transporters 98,53,449.35 1,94,93,471.37 Goods 18,55,33,865.53 18,22,17,618.78 Trading Creditors 53,39,128.63 1,44,44,870.63 Advance from Customer 2,97,23,221.56 8,49,77,468.48 Total 23,47,27,080.53 30,85,42,615.59 ” There are Micro, Small & Medium enterprises to whom the company owes dues which are outstanding for more than 45 days of the Balance Sheet date of Rs.1,98,11,573.01 (As per sheet Attached) The above information regarding Micro, Small and medium enterprises has been determined to the extant such parties have been identified on the basis of information available with company Note – 7 OTHER CURRENT LIABILITIES S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) A -Other Payable Salary Payble (1,84,94,053.00) 1,42,84,745.00 Telephone Expenses Payable – 28,802.00 Electricity Charges Payable – 25,70,396.00 Others Expenses Payables(Annexure-D) 9,29,672.00 21,03,820.00 Security Deposite Against C Form 18,900.00 18,900.00 Duties & Taxex Payable (Annexure-E) 55,02,567.80 1,27,01,799.03 Intt Accured But Not Paid 19,99,872.11 -4.56 Total -1,20,42,917.76 3,37,08,334.14 Note – 8 SHORT TERM PROVISIONS S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) (a) -Provision for Income Tax 62,70,696.00 62,70,696.00 Total 62,70,696.00 62,70,696.00 Note 10 Non – Current Investments S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) (a) 65000 shares of M/s Sapphire India Pvt. Ltd. 1,96,20,000.00 1,96,20,000.00 Total 1,96,20,000.00 1,96,20,000.00 Note 11 LONG TERM LOANS AND ADVANCES S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) Capital Advances – 7,50,000.00 i) Empire Machine Tools 500000.00 ii) Web Overseas 250000.00 Total – 7,50,000.00 Note- 12 Current Investment S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) (a) Fixed Deposites (Bank of Maharashtra) 1,25,000.00 1,25,000.00 (b) Fixed Deposites (HDFC Bank) 51,96,196.00 50,49,690.00 (c) NSC 28,66,218.21 20,000.00 (d) Intt Accured on Fixed Deposited 20,000.00 28,66,218.21 Total 82,07,414.21 80,60,908.21 Note-13 INVENTORIES S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) (At lower of Cost or net realisable Vlaue) (As certified by the Management) (a) Raw Material 11,82,49,518.00 13,61,57,397.92 (b) Component 2,16,76,612.21 99,57,653.60 (c) Consumable 7,32,43,965.81 2,75,02,827.54 (d) Finished Goods 7,61,80,756.47 6,90,03,784.34 (e) Unfinished Goods 1,94,07,825.65 2,14,77,809.65 (f) Trading Stock 12,00,909.31 (g) Scrap (39,95,306.80) 70,65,286.60 Total 30,59,64,280.65 27,11,64,759.65 Note 14 TRADE RECEIVABLES S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) (Unsecured, considered good) – ANNEXURE – F MORE THAN 6 MONTHS 25,99,83,499.60 28631970.1 OTHERS 277570289.2 Total 25,99,83,499.60 30,62,02,259.28 Note 15 CASH & CASH EQUIVALENTS S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) (a) Cash & Cash Equivalents Balances with Bank in Current Accounts i) Bank Of Maharashtra(Bhiwadi) 1,42,534.27 2,38,238.27 iii) B.O.M. Delhi 29,25,957.00 67,581.04 iii) HDFC Bank Ltd. 27,78,818.31 3,13,212.08 Iv) S.B.I. Bhiwadi 8,71,185.68 1,06,046.68 (v)Hdfc New Ac 9,540.50 9,540.50 (b) Cash in Hand 3022089.23 6,32,271.23 Total 97,50,124.99 13,66,889.80 Note 16 SHORT TERM LOANS AND ADVANCES S.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) (Unsecured Considered good) Loans and advances to Suppliers (Annexure-G) 60,51,508.00 9,48,82,382.48 Loans and advances to others (Annexure-G) – 51,84,495.00 Total 60,51,508.00 10,00,66,877.48 Note 17 Others Current AssetsS.No. PARTICULARS AS AT 31.03.2018 (Amount in Rs.) AS AT 31.03.2017 (Amount in Rs.) (a) Security Deposits – 1,35,90,195.00 (b) Security Deposits to JVVNL 36,93,119.00 24,38,119.00 (c) Security Deposits to Sail 4,00,000.00 4,00,000.00 (d) Security Deposits to Others 2,66,870.00 2,66,870.00 (e) Tds Receivable – 75,945.80 (f) Interest Receivable(JVVNL) 1,52,983.00 1,52,983.00 (g) Advance to suppliers 7,00,21,875.75 – (h) Income Tax Advance(F.Y.2017-18) 53,98,945.80 34,00,000.00 (I) Service Tax Receivable – 24,93,872.60 (j) Excise Duty For Next Year on capital goods – 13,80,027.00 (k) Excise Duty (Cenvat Credit) – 18,53,887.77 (l) Sales Tax 3,26,189.00 8,05,273.00 (m) Income Tax Advance 54,020.00 54,020.00 (n) Export Incentive – 1,82,72,163.54 (o) Imprest (Director & Managerial Staff) 9,61,944.00 5,62,527.00 (p) Prepaid Expenses – 1,92,219.00 (q) SHIS (INCENTIVE RECIEVABLE) 6,60,045.00 – (r) Tender/ Earnest Money Deposits 1,71,40,195.00 – (s) Income Tac Advance Tax (AY 2018-19) 53,05,000.00 – (u) DEPB(In Hand Receivable) 1,75,930.01 – (v) Duty Drawback Receivable 40,52,649.53 – (w) Focus Incentive Receivable 1,00,00,000.00 – (x) Focus Products Scheme 7,92,250.00 – (y) FORGIEN CURRENCY(USD) 2,13,954.00 – (z) suspense account 50,16,899.49 – (za) GST on Reverse Charges 2,62,858.00 – (zb) Duties in Hand 1,04,025.00 – (zc) Prepaid Insurance – 11,77,732.00 Total 12,49,99,752.58 4,71,15,834.71 M/S BHIWADI CYLINDERS PRIVATE LIMITEDE-925,1200 & 1201,INDUSTRIAL AREA,BHIWADI-301019Statement of Profit and Loss for the year ended 31 March, 2018S.No. PARTICULARS Note No. FIGURES FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FIGURES FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)A CONTINUING OPERATIONS 1 Revenue from operations (Gross) 18 1,05,98,06,714.09 1,48,35,54,948.71Other operating Revenues 18A 4,79,047.00 3,46,329.84Less: Excise Duty – -14,26,61,089.87Revenue from operations (net) 1,06,02,85,761.09 1,34,12,40,188.682 Other income 18B 0.00 7,59,457.943 Total Revenue (1+2) 1,06,02,85,761.09 1,34,19,99,646.624 Expenses: Cost of materials consumed(Raw Material) 19 73,75,25,405.17 80,34,14,648.21Cost of materials consumed(Component) 19A 43,37,738.10 8,44,94,903.95Cost of materials consumed(Stores) 19B 3,61,81,659.29 17,08,25,133.07Trading Consumption 19C 0.00 1,81,24,675.67Changes in inventories of FG, WIP, SIT 19D 59,53,605.27 -4,81,36,283.28Employee benefits expenses 20 5,14,99,091.00 5,84,73,379.00Finance costs 21 95,11,932.31 4,50,50,734.07Manufacturing Expenses 22 8,24,78,448.76 9,89,87,294.92Selling & Distribution Expenses 23 31,220.00 30,05,544.36Administration Expenses 24 5,07,46,018.17 8,12,60,715.39Depreciation and amortization expense 9 1,10,00,838.00Interest & Bill Discounting 1,54,74,173.51 Excise Duty Total expenses 99,37,39,291.58 1,32,65,01,583.365 Profit / (Loss) before exceptional and 6,65,46,469.51 1,54,98,063.26extraordinary items and tax (3-4) 6 Exceptional items 25 0.00 13,96,604.507 Profit / (Loss) before extraordinary items and tax (5 + 6) 6,65,46,469.51 1,41,01,458.768 Extraordinary Items 9 Profit / (Loss) before tax (7 + 8) 6,65,46,469.51 1,41,01,458.7610 Tax expenses: (1) Current tax expenses – 46,00,000.00(2) Deferred tax – 3,40,455.2711 Profit / (Loss) from continuing operations (9 +10) 6,65,46,469.51 91,61,003.49B DISCONTINUING OPERATIONS 12.1 Profit / (Loss) from discontinuing operations – -12.2 Tax expense of discontinuing operations – -13 Profit/(loss) from discontinuing operations(12.1-12.2) – -C TOTAL OPERATIONS 14 Profit (Loss) for the year (11+13) 6,65,46,469.51 91,61,003.4915 Earnings per equity share of Rs. 10/- each:- (1) Basic (Continuing Operations) 26 11.19 1.54(2) Diluted (Continuing Operations) (3) Nominal Value of one Equity Share 10.00 10.00Note – 18 REVENUE FROM OPERATIONS S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(a) Sale of Products Manufactured(Domestic) Sales-New LPG Cylinders 8,56,65,793.98 47,58,67,224.75Sales-Disposable Cylinders 7,99,91,767.50 27,40,52,673.50Sales-Scrap 3,48,63,540.00 4,07,37,438.40Sales-S.C.Valve 6,59,29,020.97 16,19,79,026.32Sales R 22 68Litres 1,79,48,820.00 3,59,18,000.00Sales-V.P Rings – 1,16,19,200.00Sales-Raw Material – 15,47,43,675.65Misc Sale 4,38,87,971.01 1,35,512.00EXEMPTED SALE 14,943.56 -Sales IGST 35,98,30,882.93 -SALES SGST 20,78,79,034.60 — -Excise – 14,26,61,089.87Total Sale of Products Manufactured(Domestic) (a) 89,60,11,774.55 1,29,77,13,840.49Trading Sales including excise duty (b) 1,82,74,944.58Sale of Products Manufactured (Export) 16,37,94,939.54 16,75,66,163.64Excise Sales-Export Cylinders (c) 16,37,94,939.54 16,75,66,163.64Other operating Revenues Total (a+b+c) 1,05,98,06,714.09 1,48,35,54,948.71Note – 18A OTHER OPERATING REVENUE S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(a) Duty Drawback(Export) 4,79,047.00 19,64,290.00(b) Fluctuation of Currency(Export) 0 -16,17,960.16- -Total 4,79,047.00 3,46,329.84Note – 18B REVENUE FROM OTHERS INCOME S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(a) Intt. Recd From JVVNL 0.00 1,69,981.00(b) Int On FDR – 5,89,476.94(c) Profit on Sale of Plants & Machinery – -(d) Commision Recd – -Total – 7,59,457.94Note 19 COST OF MATERIALS CONSUMED (RAW MATERIAL) S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(a) Material consumed (Raw Material) -(Annexure- “H’) Opening Stock 13,61,57,397.92 9,12,47,044.46Add: Purchases 71,96,17,525.25 85,98,17,615.3885,57,74,923.17 95,10,64,659.84Less : Discount 1,14,92,613.71Less : Closing Stock 11,82,49,518.00 13,61,57,397.92Total 73,75,25,405.17 80,34,14,648.21Note – 19A COST OF MATERIALS CONSUMED (COMPONENT) S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(b) Material consumed (Component) (Annexure- “H’) Opening Stock 99,57,653.60 71,74,935.19Add: Purchases 1,60,56,696.71 87277622.362,60,14,350.31 9,44,52,557.55Less : Closing Stock 2,16,76,612.21 99,57,653.60Total 43,37,738.10 8,44,94,903.95Note – 19B COST OF MATERIALS CONSUMED (STOERS) S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2016 (Amount in Rs.)(c) Material consumed (Stores) (Annexure- “H’) Opening Stock 2,75,02,827.54 2,44,82,735.28Add: Purchases 8,19,22,797.56 17,38,45,225.3310,94,25,625.10 19,83,27,960.61Less : Closing Stock 7,32,43,965.81 2,75,02,827.54Total 3,61,81,659.29 17,08,25,133.07Note – 19C Trading Consumption S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(c) Material consumed (Stores) (Annexure- “I’) Opening Stock – 1,81,24,675.67Add: Purchases – – 1,81,24,675.67Less : Closing Stock – -Total – 1,81,24,675.67Note – 19D CHANGE IN INVENTORIES OF FINISHED GOODS, WIP, STOCK IN TRADE S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(d) Closing Stock (Annexure- “I’) Finished Cylinders 7,61,80,756.47 6,90,03,784.34Unfinished Cylinders 1,94,07,825.65 2,14,77,809.65Scrap -39,95,306.80 70,65,286.60TOTAL 9,15,93,275.32 9,75,46,880.59Less : Opening Stock Finished Cylinders 6,90,03,784.34 2,87,81,441.89Unfinished Cylinders 2,14,77,809.65 1,66,61,896.57Scrap 70,65,286.60 39,67,258.85TOTAL 9,75,46,880.59 4,94,10,597.31Increase/(Decrease) in stock (59,53,605.27) 4,81,36,283.28Note 20 EMPLOYEE BENEFIT EXPENSES S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(a) Salaries 2,24,23,679.00 2,84,91,337.00(b) Bonus 1,61,250.00 14,50,000.00(c) Directors Remuneration 2,70,00,000.00 2,54,87,025.00(d) Employers Share of Provident Fund & ESIC 7,59,552.00 16,98,935.00(e) Insurance Keyman – 5,38,767.00(f) Employee Gratuity – 39,230.00(g) El Encashment – 1,51,200.00(h) Incentive 46,058.00 61,885.00(i) Salary Arrear 28,250.00 5,55,000.00(j) Medicine & Treatment 6,96,000.00 -(k) Staff Over Time 3,84,085.00 -(l) ESIC on Interest 217.00 -Total 5,14,99,091.00 5,84,73,379.00Note 21 FINANCE COSTS S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(a) Interest expenses on Bank Loan 43,54,400.91 1,93,87,333.00(b) Bank Charges 6,12,373.76 10,18,861.87(c) Bill Discounting 7,57,600.14 19,29,960.92(d) Processing Fees 15,72,629.50 12,39,968.00(e) Other Interest 22,14,928.00 2,14,74,610.28Total 95,11,932.31 4,50,50,734.07Note 22 MANUFACTURING AND OTHER EXPENSES S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(a) Amc of M/C 1,97,100.00 2,24,99,629.00(b) Cartage 70,814.02 25,27,709.75(c) Cartage [email protected]% 990.00 -(d) Cartage Under GST 1,97,634.29 -(e) Consumable Stores 1,71,197.00 2,75,23,713.44(f) Cst on Purchases 25,39,069.36 3,01,319.75(g) Custom Duty – 4,38,855.19(h) Factory Power 1,76,80,021.00 1,27,41,906.93(i) Filling Permission(Chief Controller of Explosives, Nagpur) 13,50,350.00 51,59,146.00(j) Freight Inward and outward 1,40,76,206.24 -(k) Freight, Transportation 29,66,471.00 1,32,830.84(l) Job Work 40,53,482.25 2,03,56,649.00(m) Loading & Unloading Expenses 1,75,300.00 5,19,024.00(n) Marking & Testing Fees(Bureau of Indian Standards,Bureau Veritas) 71,05,327.00 9,31,376.80(o) Loading / Packing/ Service Charges Expenses 28,325.00 -(p) Machinery Repair & Maint. 21,200.00 -(q) Ocean Freight @5% 35,71,704.60 -(r) Pest Control Rodcut Control 24,500.00 -(s) Thc Transporation [email protected]% 8,17,764.00 -(u) Workmen Wages 2,74,30,993.00 58,55,134.22Total 8,24,78,448.76 9,89,87,294.92Note 23 Sales And Distribution Expenses S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(a) Advertisement Expenses 31,220.00 46,960.00(b) Sales Promotion Expenses 0 -(c) Business Promotion Expenses 0 29,42,822.36(d) Sample Sales 0 15,762.00Total 31,220.00 30,05,544.36Note 24 ADMINISTRATION EXPENSES S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(a) Adv Payment of Entry Tax Interest 546.00 -(b) Airport Charges 13,096.00 -(c) Auditors Remuneration – 1,73,000.00(d) Bill Discounting Charges(Hdfc Bank) 15,75,167.12 -(e) Brokerage & Commission 84,349.00 -(f) Building Repair & Maint. 39,700.00 -(g) Credit Card 33,23,869.99 -(h) Credit Card (M.S) 4,80,279.77 -(i) Custom Duty 18,88,900.51 -(j) Commission Charges 2,21,658.00 8,43,837.00(k) Discount & Rebate -5,538.50 -(l) Domestic Tours Expenses 4,33,197.00 -(m) Donation Expenses 1,25,200.00 27,500.00(n) Diwali Expenses 5,50,625.92 9,48,685.00(o) Entry Tax 5,74,113.00 1,16,634.00(p) FOODING EXPENSES 89,518.00 -(q) Freight 2,000.00 -(r) Freight Outward Service @18% 1,16,360.25 -(s) Freight Outward Services 1,20,81,860.26 -(t) Freight Outward (S.T.Paid) 88,65,444.57 -(u) Freight Outward (GST) -55,38,680.00 -(v) Freight Transportation (Outward) 68,41,207.00 4,53,69,561.60(w) Income Tax Demand AY-13-14 1,00,000.00 -(x) Interest on CST 83,898.00 -(y) Interest On Vat 1,860.00 -(z) Intt.On Entry Tax 35,010.00 -(za) Insurance 16,64,044.00 17,84,109.00(zb) Job Work Dished 5,70,280.00 -(zc) Job Work (Without Tax) 72,842.00 -(zd) LD Charges 49,24,334.72 91,68,846.68(ze) Legal Fees 11,61,840.00 2,76,138.10(zf) Medical Expenses – 11,53,927.00(zg) Membership & Subscription Expenses 8,000.00 68,000.00(zh) Office Expenses 5,30,038.00 3,40,233.36(zi) Postage & Telegram 1,07,305.45 1,43,776.00(zj) Printing & Stationery 1,97,299.00 5,52,875.31(zk) Professional Charges 12,50,590.00 3,79,000.00(zl) Processing Fees 12,435.00 -(zm) Repair & Maintaince 6,63,276.94 28,12,890.00(zn) Service Charges 44,341.25 25,243.00(zo) Service Tax – 15,89,359.00(zp) Short/Excess 22,730.98 63,345.69(zq) Staff Welfare Expenses 20,78,998.00 18,45,660.52(zr) Octroi – -58,201.84(zs) Income Tax Expenses – 2,000.00(zt) Stamp Duty 4,95,000.00 -(zu) Telephone Exp 3,21,859.55 12,33,972.03(zv) Travelling Expenses 41,92,793.00 90,79,139.84(zw) Vehicle Expenses 3,33,888.39 9,60,671.86(zx) Weighing Exp 1,10,480.00 1,58,864.00(zy) Late Fees – 22,01,648.24Total 5,07,46,018.17 8,12,60,715.39Note 25 Exceptional Items S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(a) Entry Tax (Prior Period Exp. 2012-13) (b) Sales tax on Demand (Prior Period Exp.) (2011-2012) – 60,121.00(c) Income tax Expenses – -(d) Professional Charges 2012-2016 – 1,03,397.00(e) Interest & Penalty on Excise Duty 2015-2016 – 1,82,928.00(f) Salary Expenses 2015-2016 – 21,769.00(g) Bonus 2015-2016 – 10,23,475.00Bank Charges 2015-2016 – 4,914.50Total 0.00 13,96,604.50Interest & Bill Discounting S.No. PARTICULARS FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(a) Interest on Bank Loan 1,28,45,684.00 -(b) Interest on BPCL 7,013.57 -(c) Interest on TDS 4,84,217.00 -(d) Interest on Term Loan 16,81,159.28 -(e) Interest On Vehicle Loan 3,16,057.78 -Total 1,54,74,173.51 0.00Note 26 Earning per Share S.No. PARTICULARS Unit FOR THE YEAR ENDED 31.03.2018 (Amount in Rs.) FOR THE YEAR ENDED 31.03.2017 (Amount in Rs.)(a) Profit(Loss)before tax amount used as the numerator Rs. 6,65,46,469.51 91,61,003.49(b) Number of equity Shares Nos. 59,47,020 59,47,020(c) Nominal Value of Shares Rs. 10.00 10.00(d) Earning Per Share (Basic & Diluted ) 11.19 1.54 COMPARATIVE RATIO ANALYSIS Liquidity ratiosCurrent ratio: Current Asset /Current LiabilitiesParticulars 2018 2017Current Assets 709939680.54 733977529.13Current Liabilities 228954863.33 551321134.23Current ratio 3.1 1.33 (Tab 3)Quick ratio: Current Asset – Stock in hand/Current LiabilitiesParticulars 2018 2017Current Assets 403975399.89 462812769.48Current Liabilities 228954863.33 551321134.23Quick Ratio 1.76 0.84(Tab 4) Fig (b)Analysis: The current ratio for the year 2018 stands at 3 and in 2017 it stands at 1.3 this means that the company is in a liquid position to pay its short term obligations. The quick ratio for the year 2017 is in its ideal state. As we know that quick ratio or acid test ratio is another liquidity metric for any given company. The quick ratio shows us the better picture of whether the company is able to pay its current liabilities. It tells us the inventory level.Profitability RatiosGross profit Margin: Gross profit/Net salesParticulars 2018 2017Gross profit 193329857.36 213529816Net sales 1059806714.09 1340893858.84GP Ratio 18.24% 15.92%(Tab 5)Net Profit Margin: Net profit/Net salesParticulars 2018 2017Net profit 66067422.37 14101458Net Sales 1059806714.09 1340893858.84ROI 6.23% 1.05% (Tab 6) (Fig c)Return on capital employed: Net operating profit/capital employedParticulars 2018 2017Net operating profit 66067422.37 14101458Capital employed 190462542.31 123916072.80ROCE 34.69% 11.38% (Tab 7) (Fig d)Analysis: The GP ratio has improved to certain extent in the year 2018. This means that the company is doing good at the operational level. ROI of the company has also increase to a large extent in the year 2018 which means that the company is getting enough returns as invested. Return on capital employed is a ratio that measures company’s profitability and efficiency with which its capital is employed. ROCE for the year 2018 has increased which would reflects the efficient use of capital. Solvency RatiosDebt equity ratio: Total Debt/Shareholder’s equity Particulars 2018 2017Total Debt 437299732 381502026.09Shareholder’s Equity 190462542.31 857071270.74Debt equity ratio 2.30 3.08(Tab 8)Total debts to total assets: Total debts/Total assetsParticulars 2018 2017Total debts 437299732 381502026.09Total assets 190462542.31 123916072.80Total debts to total assets 2.30 3.08(Tab 9) Fig (e)Analysis: Debt equity ratio is higher in 2018 as compared to 2017. It is not satisfactory. This means that the company is not using its debt to finance its assets relative to the amount of value represented in shareholders’ equity. Total debts to total assets ratio for the year 2018 and 2017 is 0.57 and 0.61. This ratio is an indicator of financial leverage. In 2018 50% of the company’s assets are financed creditors or debts .and the other 50% is managed by owners. It has decreased to a certain bit in 2017 which is good for the company. GST IMPLEMENTATIONThe manufacturing sector in India is not only overawed with concerns changing from decline in exports and infrastructure costs but also with the burden of complying with a complex indirect taxation system. Multiple indirect tax legislations have led to significant compliance and administrative costs, classification and valuation disputes and generally impaired the ease of doing business in this sector. The implementation of goods and services tax (GST) is therefore critical and essential to give a boost to an already failing sector.As Bhiwadi Cylinders is a manufacturing company and having aggregate turnover in in financial year exceeds Rs 20 lakh BCPL is also liable to register under GST law.BCPL furnish a return of GSTR – 1(Outward Supply) and GSTR – 3B (Consolidated Supply) to file an annual return.The condition necessary for BCPL to obtain ITC are:They get the tax invoice or Debit Note.Goods should be received.Supplier should paid the amount of tax.Return should be file under sec39 (R3).ITC not available to BCPL if:Goods are used for personal consumption andGoods lost, stolen, destroyed, written off or disposed of by way of gift or free samples. FINDINGS & SUGGESTIONSFindings: The current assets have decreased in 2018 by Rs 19020949.10 that is by 97.40%.The cash and bank balance have increased by Rs. 8383235.19 that is by 713.31%.The company provides loan and advances to its customers less in 2018 as compared to 2017 by 94015369.48 that is by 6.05%.Security deposits have same in both years that is 18900.Current liabilities are decreased in the year 2018 than previous year by Rs 108455860.75 that is by 80.32%.Net income of the company has decreased in the year 2018 than previous year by 79.05%.ROI of the company has increased to a large extent in the year 2018 which means that the company is getting enough returns as invested.Suggestions:The company should increase the current asset.The company should also strive to expand its business.The company should also reduce the long-term borrowings.The company should reduce the cost of management and operations in order to earn more profit.It should recover its money from defaulters in a limited time.It should also focus on controlling the non-operation expenses and other expenditures.To ensure the net profit at higher rate carefully designed risk management systems and should also look forward to customer services and grievances.To improve this the company should focus on decreasing the costs or expenses. We can divide the expenses into overhead and production costs to understand better expense reduction opportunities. CONCLUSIONFinancial statements are the lifeline for every organisation. If properly analysed and interpreted, they can tell us about the performance of the making which eventually helps in decision making. They reveal the mystery behind the prevailing loopholes in the company and give us some valuable insights.I have thoroughly studied the above balance sheet and Profit and loss account of Bhiwadi Cylinders Pvt. Ltd. as on 31st March 2018.After doing the analysis I came to know that the company was generating profit over the last ten years. This is a good sign for any company which has working in a competitive market, so the company should strive to work hard on it by knowing its strength and loopholes.The transactions of company according to my notice are within the powers of the company.Proper books of accounts have been maintained by the company. Everything is been kept in a systematic manner and by law.Proper returns have been received from the company’s branches.The balance sheet and profit and loss account are in agreement with the books of accounts.Now coming to the balance sheet, the company is in its progressive and initial years. It has maintained its profitability over these ten years. There has been a constant increase in the net profit of the company.Although the company does not have lot of competitors in Rajasthan, so the only focus of the company should be on maintaining the quality of their products. They should not dare to compromise on it.From ratio analysis of balance sheet of both the years of the company it is concluded that liquidity position of the company is good.Tally ERP 9.0 has been used for analysing the balance sheet and profit and loss statements of a company. . LIMITATIONS OF THE STUDY Somewhere or the other it is suffering from the limitations of financial statements.Price level changes is ignored in financial analysis.Financial analysis provide misleading result in absence of absolute data.Lack of exactness in financial statements analysis and interpret.Lack of comparability in financial statement analysis and interpret.In some cases the account has to make choice out of various alternatives e.g. choice in the method of depreciation, choice in the method of inventory valuation. RECOMMENDATIONSThe company has huge scope for contributing to company’s GDP. Although the performance of the company has lasted well over the years, still it should emphasize on improving its operation to stay in the competitive world. As the company is having a smooth run, it should increase its market penetration. They should reach out to the other parts of country as well. They should also focus on increasing their production and lowering the prices of their product.The company is continuously on the path to overcome any threats arising from imports/competition amongst other manufacturers by making the product more competitive in terms of price and quality which has been possible by reducing the input cost or overall price of the product.Focus on building brand image by increasing customer loyalty. In order to sustain in a competitive world the company should use innovative displays and should also conduct exbhitions to maintain a good rapport with customers.Nurturing and cultivating highly skilled human work force by motivating and rewarding them.OTHER COMPANY BALANCE SHEET AND PROFIT AND LOSS ACCOUNTM/S. RAMA PACKAGINGG1-1281A, RIICO IND. AREA, BHIWADI (ALWAR)BALANCE SHEET as at March 31,2018AMOUNT AMOUNT AMOUNTFOR THE L I A B I L I T I E S FOR THE FOR THE A S S E T S FOR THEPREV. YEAR CURR. YEAR PREV. YEAR CURR. YEAR CAPITAL A/C : FIXED ASSETS : 54,36,048.81 Op. Balance 59,75,293.91 14,05,920.36 (As per Annexure “A”) 13,93,821.78 3,00,519.27 Additional 1,22,363.10 9,52,562.83 Add.: Net Profit (49,62,641.79) 5,67,000.00 Less : Drawing 2,61,370.00 (36,837.00) Add : Jvvnl Interest & TDS (34,635.00) 1,10,000.00 Less : Income Tax 9,08,280.22 CURR. ASSET, LOANS & ADV. 59,75,293.91 2,22,868.00 Cash in Hand 3,13,026.00 16,24,560.00 Bank of Baroda, Bhiwadi 3,63,094.75 95,947.27 Vijaya Bank 2,05,333.99 74,364.11 HDFC Car Loan – 21,30,255.39 Stock in Hand 44,76,861.46 (As taken & valued and certified CURR. LIABIL. & PROV. : by the prop.) 6,05,096.00 Sundry Creditors “C ” 6,77,376.90 – Prepaid Insurance(Car) – 3,13,834.00 Expenses Payable “D” 3,60,681.66 8,36,502.00 Sundry Debtors (B) 18,41,856.00 51,643.00 K.L. Datta & Co. 8,383.00 3,463.00 TDS (JVVNL) – 10,46,441.56 2,12,643.00 Vat Recivable 67,333.00 31,172.00 Interest Recivable(JVVNL) – LOAN & ADVANCE : 4,56,900.00 Security Deposit (E) 5,60,900.00 5,60,900.00 Advance to Suppliers (G) – FINANCIAL NOTES ” H” 70,20,231.02 **** Total **** 19,54,721.78 70,20,231.02 **** Total **** 19,54,721.78 M/S. RAMA PACKAGINGG1-1281A, RIICO IND. AREA, BHIWADI (ALWAR)MANUFACTURING TRADING & PROFIT LOSS A/C For the period ending 31st March, 2018 FIGURES FIGURES FIGURES FIGURESFOR THE PARTICULARS FOR THE FOR THE PARTICULARS FOR THEPREV. YEAR CURR. YEAR PREV. YEAR CURR. YEAR 14,11,639.32 TO OPENING STOCK 1380265.39 13,80,265.39 11191300.00 BY SALES 34,83,100.00 17,63,100.00 RST 11,25,600.00 TO RAW MATERIAL CONSUMED : 94,28,200.00 CST 23,57,500.00 5,43,101.00 Op. Balance 7,49,990.00 68,95,368.00 GST 72,89,200.00 64,28,366.00 Purchase 61,45,378.00 69,71,467.00 68,95,368.00 BY CLOSING STOCK 7,49,990.00 Less Closing Stock 1380265.39 Finished Goods 44,76,861.46 62,21,477.00 62,21,477.00 TO MANUFACTURING EXPENSES : 32,98,550.00 Power & Elc. 35,50,088.00 43,08,531.48 40,050.00 Freight & Cartage 60,800.00 3,20,082.00 Wages 5,31,953.00 35,535.00 Consumable Store 1,40,418.48 15,210.00 E.S.I.C. 25,272.00 37,09,427.00 12,29,022.07 TO GROSS PROFIT C/d (46,24,203.41) 1,25,71,565.39 79,59,961.46 12571565.39 79,59,961.46 TO ADMINISTRATIVE EXP. 12,000.00 Accounting Charges 24,000.00 1,557.50 Bank Charges 2,159.30 12,29,022.07 TO GROSS PROFIT B/f (46,24,203.41) 2,875.00 BMA,Fees 2,875.00 34,635.00 To Interest Income (JVNL) 5,380.00 Car insurance 3,750.00 Economic Rent 4,286.00 94.00 To Business Adustment13.54 23,875.00 Fes & Taxes 70,614.00 15,950.10 Interest on Car Loan 2,880.89 – To Mis. Income – – Misc. Expenses 47,550.00 Packaging Material 48,705.00 4,025.00 Printing & Stationary 4,695.00 24,725.00 Professional Fees Water Expenses 4,248.00 38,050.00 Repair & Maint. 30,075.00 12,850.00 Travelling & Conv. 22,450.00 2,16,988.19 1,18,600.64 To Depreciation 1,21,450.19 9,52,562.83 TO NET PROFIT (49,62,641.79) 12,63,751.07 TOTAL (46,24,203.41) 12,63,751.07 TOTAL (46,24,203.41) GARG HOSPITALA-131,BHAGAT SINGH COLONYBHIWADIBALANCE SHEETAs on 31st March 2018FIGURES FIGURES FIGURES FIGURES FOR THE PARTICULARS FOR THE FOR THE PARTICULARS FOR THEPre. YEAR CURR. YEAR Pre. YEAR CURR. YEAR CAPITAL A/C FIXED ASSETS 10420984.91 As per Annexure “B” 11698403.80 7761245.57 (As per Annexure “A”) 6774023.55 LOAN (LIABILITY) 1321782.25 Investment “E” 1179782.25 1179782.25 Current Assets 215692.00 Ambulance Loan (IDBI) 107356.00 107356.00 157648.30 Cash in Hand 119615.29 3017716.72 Cash at Bank “D” 4989892.81 482287.07 FDR Current Liabilities & Provision 1614850.00 Deposits (Asset) 357295.50 5466803.60 14625.00 Sundry Creditors”C” 14850.00 Unsecured Loans 1600000.00 NOES ON ACCOUNTS “F” 10651301.91 **** Total **** 13420609.80 12740679.91 **** Total **** 13420609.40 BIBLIOGRAPHYBooks:I.M PANDEY. Financial Management New Delhi Vikas publishing house private Ltd. – ninth edition 2004GST. Indirect Taxation. CA Jitender DiwanCompany Data:Bank statement Other data of Bhiwadi Cylinders Private LimitedWebsiteswww.google.com
