Free Essay

Financial Analysis

In:

Submitted By kokila
Words 10013
Pages 41
A STUDY ON FINANCIAL ANALYSIS IN RANE ENGINE VALVES PVT LTD AT ALANTHUR
A Project Report Submitted by
P.KOKILA
(30307631027)
Under the guidance of
Mr.P.Ganesh,M.com,M.B.A,M.phil,(Ph.D)
FACULTY OF MANAGEMENT STUDIES
In partial fulfillment of the requirements for the award of the degree of MBA
IN
Department of Management Studies
Anand Institute Of higher Technology

ANNA UNIVERSITY
CHENNAI 600 025
JUNE 2009

I BONAFIDE CERTIFICATE

Certified that this project report titled “A Study on Financial Analysis in Rane Engine Valves Pvt Ltd at Alanthur “is the bonafide work of Mr./Ms.KOKILA.P (Registration Number: 30307631027)Who carried out the research under my supervision. Certified further, that to the best of my knowledge the work reported herein does not form part of any other project report or dissertion on the basis of which a degree or award was conferred on an earlier occasion on this or any other candidate.

Internal Guide Head of the Department (P.Ganesh,M.Com., M.B.A.,M.Phil,( Ph.D.) (Dr.M.Kavitha, M.B.A, M.Phil, PhD.)

Submitted to Project and Viva Examination held on_____________.

Internal Examiner External Examiner

II

KOKILA.P (Registration Number: 30307631027) II MBA
ANAND INSTITUTE OF HIGHER TECHNOLOGY,
KAZHIPATTUR - 603103

DECLARATION

I hereby declare that the project entitled A Study on Financial Analysis in Rane Engine Valves Pvt Ltd at Alanthur in partial fulfillment of the requirements of Anna University for the award of the degree in Master of Business Administration is my original work and that it has not formed the basis for the award of any degree, associateship, fellowship, diplomo or any other similar title.

Signature of the student

(KOKILA.P)

III

ACKNOWLEDGEMENT

My sincere thanks to Our Honorable Founder & Chairman KALVIVALLAL.THIRU.T.KALASALINGAM B.COM., for his sincere endeavor in educating me in his premier institution.

I also express my gratitude to Our Principal Dr.T.A.Raghavendiran, Ph.D, M.I.S.T.E, Principal who helped me in completing the project.

I also thank our Head of the Department, and also our Faculty, Dr. M. Kavitha Muthukumaran, Bsc., M.B.A., M.Phil., Ph.D, for her “make easy guidance” and support in completing this project work successfully.

I would like to express my gratitude to Mr.P.Ganesh,M.com, MBA.for his valuable guidance, ideas and encouragement for the successful completion of the project.

I take this opportunity to acknowledge the help, guidance and co-operation received from the management of rane engine valves my special thanks to Manager-HR & admin, Mr.K.KARTHIKEYAN who in spite of their busy schedule took keen interest in enabling me to finish the project successfully.

IV

ABSTRACT

The project has been taken up in Rane Engine Valves, Alanthur.., to study the financial performance in the organization as a part of its continuous improvement process so as to come up with steps needed for its progress.

The financial analysis is the process of identifying the financial strength and weakness of the firm by properly establishing relationship between the item of the financial account.

The study made use of descriptive research design since it employs the data from the financial statements of the company. Secondary data are based on the five years annual report from 2004-2008.

Financial tools used for the study are Schedule of changes in working capital, Comparative balance sheet, Common size balance sheet and Ratio analysis. Trend analysis and correlation are the statistical tools used for the study.

Only limited period of five years is considered for the study. Based on the study, it was found that management of inventory, current assets and manufacturing expenses has not been satisfactory.

V

TABLE OF CONTENTS

|S.NO |CONTENT |PAGE.NO |
|1 |LIST OF TABLES |VII |
|2 |LIST OF CHARTS |VIII |
|3 |CHAPTER-1 – Introduction |1 |
|4 |CHAPTER-2 – Review of Literature |17 |
|5 |CHAPTER-3 – Research Methodology |19 |
|6 |CHAPTER-4 – Data Analysis and Interpretation |21 |
|7 |CHAPTER-5 – Conclusion |59 |
|8 |BIBLIOGRAPHY |62 |

VI

LIST OF TABLES

|S.NO |CONTENT |PAGE NO |
|1 |Table showing the schedule of changes in working capital for 5 years. |21 |
|2 |Table showing comparative balance sheet for 5 years |29 |
|3 |Table showing the common size balance sheetfor 5 years |37 |
|4 |Table showing the return on sales for 5 years |38 |
|5 |Table showing the relationship between EBITDA & Sales for 5 years |39 |
|6 |Table showing the return on net operating assests ratio for 5 years |40 |
|7 |Table showing the return on equity for 5 years |41 |
|8 |Table showing the earnings per share for 5 years |42 |
|9 |Table showing the operative asset turnover ratio for 5 years |44 |
|10 |Table showing the fixed asset turnover ratio for 5 years |45 |
|11 |Table showing the Gross working capital turnover ratio for 5 years |46 |
|12 |Table showing the Operating safety margin for 5 years |47 |
|13 |Table showing the Debt to capital employed for 5 years |48 |
|14 |Table showing the current ratio for 5 years |49 |
|15 |Table showing the Employee cost to net sales ratio for 5 years |50 |
|16 |Table showing the net sales per employee for 5 years |51 |
|17 |Table showing Value added per employee for 5 years |52 |
|18 |Table showing the cost per employee for 5 years |53 |
|19 |Table showing the Trend analysis for sales 5 years |54 |
|20 |Table showing the Trend analysis for profit for 5 years |57 |

VII

LIST OF CHARTS
|S.NO |CONTENT |PAGE NO |
|1 |Chart showing return of sales for 5 years |38 |
|2 |Chart showing relationship between EBITDA and sales 5 years |39 |
|3 |Chart showing return on net operating assets for 5 years |40 |
|4 |Chart showing return on equity for 5 years |41 |
|5 |Chart showing earnings per share for 5 years |42 |
|6 |Chart showing operating assets turnover ratio for 5 years |44 |
|7 |Chart showing fixed asset turnover ratio 5 years |45 |
|8 |Chart showing gross working capital turnover ratio for 5 years |46 |
|9 |Chart showing operating safety margin for 5 years |47 |
|10 |Chart showing debt to capital employed for 5 years |48 |
|11 |Chart showing current ratio for 5 years |49 |
|12 |Chart showing employee cost to net sales ratio for 5 years. |50 |
|13 |Chart showing net sales per employee for years |51 |
|14 |Chart Showing Value added per employee for 5 years |52 |
|15 |Chart Showing Cost per employee for 5 years. |53 |
|16 |Chart Showing Trend analysis for sales for 5 years |55 |
|17 |Chart Showing Trend analysis for profit for 5 years |58 |

VIII

CHAPTERIZATION

CHAPTER 1 - INTRODUCTION 2. INDUSTRY PROFILE 3. COMPANY PROFILE 4. PRODUCT PROFILE 5. NEED OF THE STUDY 6. OBJECTIVES OF THE STUDY 7. SCOPE OF THE STUDY 8. LIMITATION OF THE STUDY

CHAPTER 2 - REVIEW OF THE LITERATURE

CHAPTER 3 - RESEARCH METHODOLOGY 3.1 RESEARCH METHODOLOGY 3.2 TOOLS APPLIED IN THE STUDY

CHAPTER 4- DATA ANALYSIS AND INTERPRETATION 4.1 ANALYSIS OF WORKING CAPITAL RATIO 2. ANALYSIS ON LEVERAGES 3. ANALYSIS OF CURRENT ASSESTS AND CURRENT LIABILITIES 4. TO ACCESS THE IMPACT OF WORKING CAPITAL ON PROFITABILITY 5. ANALYSIS OF THE ELEMENTS OF WORKING CAPITAL
CHAPTER 5 – CONCLUSION 5.1 SUMMARY OF FINDINGS 2. SUGGESTIONS ANDRECOMMENDATION 3. CONCLUSION 4. BIBLIOGRAPHY

IX

CHAPTER I

(INTRODUCTION)

-1-

CHAPTER 1 – Introduction

1.1 INTRODUCTION

Financial analysis is the means of communicating accounting information which is generated in the various accounting processes to the external users of accounts. The external users include investors, employees, lenders, suppliers, and other trade creditors, customers, government and their agencies and the public at large. Financial statements meet the common information needs of most of the users. They provide the financial effects of past events only and do not provide non-financial information. Accordingly, financial statements do not provide all the information which the external users’ may need for decision-making.
Accounting is the process of identifying, measuring and communicating information to permit informed judgments and decisions by the users of information.
Financial statement are prepared and presented for the external users of accounting information.
In India, a complete set of financial statement includes balance sheet, a profit and loss account, and schedules and notes forming part of balance sheet and profit & loss account. F.Wood in his work ‘Business Accounting’ has defined the term interpretation as follows. “ To interpret means to put the meaning of a statement in simple terms for the benefit of a person”. According to Kennedy and Muller, “ the analysis and interpretation of financial statements are an attempt to determine the significance and meaning for financial statement data so that the forecast may be made of the prospects for future earning, ability to pay interest and debit maturities (both current and long-term) and profitability and sound dividend policy. Thus, analysis of financial statements means such a treatment of the information contained in the financial statements as to afford a full diagnosis of the profitability and financial positions of the firm concerned.

-2-

The balance sheet and profit and loss account are to be interpreted to convey meaningful message to the lay man who is still the typical shareholder in our country. Interpretation is considered to be the most important function of management accountant because the management of today needs relevant data and information to conduct its function efficiently. The information is more valuable if it is presented in analytical form than in absolute form. Management Accountant is expected to analyze and interpret the financial statements to perform his basic duty of ‘communication to the management’.

Interpretation in its widest sense includes many processes like arrangement, analysis, establishing relationship between available facts and finally making conclusions.

-3-

RESEARCH BACKGROUND

Research involves scientific and inductive thinking and promotes the development of logical habits of thinking and organization. Research also makes its own contribution to the existing stock of knowledge, enabling its advancement.

Research Design A research design is the specification of the methods and procedures for acquiring the information needed to structure or solve problems. Its overall operational pattern or frame work of the project that stipulates what information is to be collected, which sources and with what procedures. The researcher used Analytical research design for the research study.

The analytical research is the term used to describe a research project that considers the secondary data (The data extracted from various sources like research report and published articles). It is non – interactive document research. It describes & interprets the past or recent past from selected sources. The sources may be document preserved. In collection analytical research performance is to identify & estimate the effect of the problem.

-4-

1.2 INDUSTRY PROFILE The world's top car makers turn to India for the nuts and bolts of their vehicles. Riding this success, and capitalizing on the spiraling demand of domestic auto companies, the Indian automobile components industry has emerged as one of India's fastest growing manufacturing sectors, and a globally competitive one. According to the Auto Component Manufacturers Association (ACMA), the apex body of component makers in India, global sourcing of components from the country will double from US$ 2.95 billion to US$ 5.9 billion in 2008-09, and is slated to hit US$ 20 billion in seven years. Of the total global auto components trade of US$ 185 billion, India's share is 0.4 per cent. The auto component sector generated sales of about US$ 15 billion in fiscal year 2006-07, including US$ 2.8 billion worth of exports, says ACMA. Industry sales will swell to US$ 40 billion by 2016 with US$ 20 billion coming from exports, ACMA says. The global auto component industry is expected to touch US$ 1.9 trillion by 2015, of which around 40 per cent (US$ 700 billion) is potentially expected to be sourced from low cost countries like India. The ACMA-McKinsey Vision 2015 document estimates the potential for the Indian auto component industry to be US$ 40-45 billion by 2015. Of this, 50 per cent is expected to come from exports. India is estimated to have the potential to become one of the top five auto component economies by 2025. The industry has been experiencing a high growth rate of 20 per cent over the period 2000-05 and is expected to grow at a rate of 17 per cent over the period 2006-14. Similarly, while growth rate of exports has been 25 per cent during 2000-05, the growth rate is expected to grow by 34 per cent during 2006-14. -5- A large number of cars in North America, Europe and in other auto marts of the world now carry Indian brands under their bonnets. Of the US$ 2.21 billion worth of component exports by the Indian auto component industry, around 70 per cent are bought by global majors such as General Motors, Ford Motor and DaimlerChrysler, among others. Rane products are exported to over 19 countries across the globe.
Investments
Since 2000, the auto component industry has recorded an investment level of US$ 0.44 billion and has attracted US$ 530 million in terms of foreign direct investment (FDI). The Investment Commission has set a target of attracting foreign investment worth US$ 5 billion for the next five years to increase India's share in the global auto components market from the present 0.4 per cent to 3-4 per cent. • Chrysler is setting up a local sourcing unit in Chennai and is expected to start sourcing for its global plant by next year. Palfinger AG, the Austrian hydraulic lifting, loading and handling systems manufacturer, has joined hands with Western Auto LLC, Dubai, the vehicle dealership arm of ETA Star group, have invested US$ 1.7 million to set base in India. • IFCI Venture Capital Funds Ltd is launching a private equity fund in association with German consultancy UBF-B worth US$ 144.67 million focused entirely on domestic automotive components industry. • The world’s third largest auto components maker, Magna International Inc., plans to bring two more group companies to India in the next 12 months and is considering the Gurgaon, Chennai and Pune regions for these manufacturing facilities. • Auto parts maker Robert Bosch of Germany will invest US$ 201.4 million in its Indian subsidiaries over the next two years. Ashok Leyland and Nissan Motor have invested US$ 500 million in three joint ventures to manufacture light commercial vehicles (LCVs), LCV engines and power train components.

-6-

1.3COMPANY PROFILE

HISTORY: About the “Rane” Group The Rane group among the oldest and most forceful group in the automotive component industry, was founded over six decades ago, beginning unpretentiously in 1929 as ‘Rane private limited’ – trading in automobiles and parts- Rane has moved over the years to become a leader today in each of its major product lines.

The industrial policy in the mid 1950’s provided virtually the new deals for the Indian automotive industry. Rane ever responsive to emerging opportunities, ventured into the production of auto components in Engine Valves Limited in1959. Rane (Madras) limited commenced manufacturing operations in 1960. Rane brake lining ltd was born in 1964. And in 1965, when Rane (Madras) limited shed its trading activities, the transformation of a trading enterprise into a manufacturing force was complete.

VISION • To position RML as a global ball joint supplier through customer focus. • To retain leadership in the domestic steering gear market and penetrate chosen export markets.

MISSION & VALUES • Provide superior products and services to customer and maintain market leadership. • Evolve as an institution that services the best interests of all stack holders. • Pursue excellence through total quality management. • Ensure the highest standards of ethics and integrity in all activities.

-7-

PROFILE Rane Engine valves commenced its operations in the year 1960.It manufactured steering and suspension systems for every segment of automobile industry, viz., Passenger cars, Multi utility Vehicles, Light commercial vehicles, Heavy commercial vehicles and Farm tractors. It has Strategic technical partnerships with M/s TRW Inc, USA for Steering Gear Products & TRW Ehrenreich Gmbh & Co. and Germany for Steering Linkage Products. It holds major market share in India both in Manual Steering gear systems & suspension systems.

MANUFACTURING The production plants at Chennai (2 plants), Mysore, Pondicherry each address a specific industry segment. Independent manufacturing cells produce specialized high end components.

Chennai Plant – focus on Light Commercial Vehicle, Heavy Commercial Vehicle and Utility Vehicles segments
Mysore Plant – focus on Tractor and Commercial vehicle segments
Pondicherry Plant – focus on Passenger Car Segments
Varanavasi (Chennai) plant – focus on Ball joints and linkages
Uttrakhand – focus on customers North of India.

-8-

ORGANIZATIONAL CHART

[pic]

UNIQUENESS

REVL HAS A DISTINCT ADVANTAGE OVER COMPETITORS DUE TO:

• Wide product range(RCB gears, rack & pinion gears, suspension & steering linkages and hydrostatic gears)

• Wide market range (passenger cars, multi utility vehicles, light commercial vehicles, heavy commercial vehicles, & farm tractors)

• Technology Leader

-9-

SWOT ANALYSIS

| | |
|Strength |Weakness |
|Employee involvement, |High material cost, |
|Specialized machines, |Excess turn out ratio of executives, |
|Reliable vendor base, |Poor integration of product and process development |
|Good logistics convenience, |High lead time |
|Easy availability of manpower, |Poor understanding of SAP |
|Reputation, |Frequent raw material price increase, |
| |Volatile market |
|Opportunities |Threats |
|Export opportunities for SGP, |Shift from manual steering to power steering |
|Export opportunities for SSLP, |Competition from MNC`s |
|Entry of Multinational OEMs, |Unpredictable market situations, |
|Export opportunities for IBJ ball joints. |Lack of market intelligence, |
| |Cost pressure from suppliers and customers |

-10-

1.4 PRODUCT PROFILE

STEERING LINKAGES Rane produces various types of steering linkages products. The products are designed and produced on the basis of the vehicle manufacture’s demand. The products that are produced are as follows: ❖ TIE ROD ENDS ❖ BALL JOINTS ❖ CENTRE LINK ASSEMBLIES ❖ LOWER CONTROL ARMS ❖ RE-CIRCULATING BALL TYPES STEERING GEARS

Group Company and Product Range Rane (Madras) Limited – Steering & Suspension Systems. • Rane TRW Steering Systems Limited – Power Steering Systems. • Rane Engine Valves Limited – Valves, Valve guides camshafts, Tappets. • Rane Brake Lining Limited – Brake Lining disc pads, Composite brake, Blocks, clutch facings. • TRW Rane Occupant Restraints Limited – Seat Belt Systems. • Rane Nastech Limited – Energy Absorbing Steering columns. • Rane Luk Clutch Limited – Pressure Plate assemblies Dual/double clutch assemblies for tractors.

Production Ranges in Rane Group These are branches in Rane group, which are manufacturing different products of different types. They are;

-11-

RANE (MADRAS) LIMITED STEERING SYSTEMS
Manual steering systems-gears and linkages • Re-circulating ball • Rack & pinion • Worm & roller • Serviceable ball joints • Greased for life ball joints

RANE ENGINE VALVES LIMITED
Valve train components for IC engines • Valves • Valve guides • Tappets • Camshafts
RANE brake lining limited
Frication material-automotive & railway brake applications • Brake linings • Clutch facing • Disc pads • Railway brake block
RANE TRW STEERING SYSTMES LIMITED
Power steering systems • Fully integral hydraulic re-circulating ball • Power steering gears • Rack & pinion power steering gears • Hydrostatic steering gears • Hydraulic vane pumps

-12-
TRW RANE OCCUPANT RESTRAINTS LIMITED Seat belt systems • Mini ELR seal belts 3.5 • Static seat belts 3.6 • Buckle assemblies

ASSOCIATE COMPANIES Kar Mobiles Limited – Automotive Valves Diesel Valves for Locomotive engines and defense application.JMA Rane Marketing Limited – Distribution company for auto components.

DOMESTIC CUSTOMERS Rane is either number 1 or 2 on every market segment that they serve. They supply to all the OEMs and engine manufacturers in the country in addition to being a significant supplier to the after market. Their OEM customers include. 1. Eicher 2. Fiat 3. Honda 4. Indian railways 5. Maruti Udyog Limited 6. Toyota 7. TAFE 8. Escorts 9. Ford 10. Hero Honda 11. Hyundai 12. Mahindra & Mahindra 13. TELCO 14. TVS – Suzuki 15. Tata Cummins 16. Ashok Leyland

INTERNATIONAL CUSTOMERS 1. Spartan Motor Industries, USA 2. Nissan Diesel, Japan 3. Nason Auto Parts, Australia 4. New Holland, UK

-13-

1.5 NEED FOR THE STUDY • Revl will stand to gain with this study and analysis of the financial statements for five years. • To enable the firm to formulation its polices for future business operation. • The present analysis provide useful base to other scholars. • To help the management in decision making. • To ascertain the profitability, solvency and efficiency of the company. • To suggest remedies.

-14-

1.6 OBJECTIVES OF THE STUDY

PRIMARY OBJECTIVE • To evaluate the financial performance of Rane Engine valves, Alanthur.

SECONDARY OBJECTIVE • Main object of the study is to analysis the function and formation of revl and its services and sales. • The study is aimed to see how for the company is able to plan its operations and to see the effective tools of the management. • To analyse the financial performance for five years of revl. • To study the financial statement of revl through various accounting ratios. • Study mainly involves a focus on financial infrastructure and its management ie, budgeting, controlling, costing, financial resources, debt and credit management etc. • To highlight the set back of the organization. • To draw the approximate finding and conclusion.

-15-

1.7 SCOPE OF THE STUDY

• The study has been conducted with a view to bring out simple measuring tool for enhancing working capital requirement. Here the study would be helpful to the finance manager to work out the requirement capital to decide of the company. • The scope of working capital management is management of cash, management of receivables and management of inventory. • The study pertains to financial management aspect like financial planning ,fund flow, ratio analysis with the help of important financial documents etc finding at particular areas, it tries to understand and establishes the general fact. • The study mainly focus on finding out of fiscal strength and resources of revl.

-16-

1.8 LIMITATIONS OF THE STUDY

• The study was conducted in revl. • Major information that was needed for the study was based only on the actual reports and decision made with various personel of the company hence the data collected is secondary in nature. • Due to lack of constraints in time and source of information, approach has been conducted only on important function requirement for project. • Analysis the financial performance is based on published data. • It is assumed that the accounting methods and procedures have been consistently followed.

CHAPTER II

(LITERATURE SURVEY)

-17-

CHAPTER 2 – Literature Survey

2.1 Review of literature

1. Environmental and Financial Performance Literature

Abstract

"We review the growing literature relating corporate environmental performance to financial performance. We seek to identify achievements and limitations of this literature and to highlight areas for further research. Our primary interest is to assess the adequacy of the literature in informing corporate managers how, when, and where to make pro-environment investments that will pay off with financial returns for long-term shareholders. To do so, we create a conceptual framework that maps the influence of regulators, public health scientists, environmental advocates, consumers, employees, and other interested parties upon corporate financial returns. Our discussion has relevance to all parties interested in influencing corporate actions that affect the environment."

2. An Investigation of the Perceived Financial Performance

Abstract

"This paper is primarily based on Rogers’ diffusion of innovations theory and Auger’s empirical study. An empirical research study was conducted to investigate the perceived financial performance of commercial printing firms for conducting business-to-customer (B2C) activities using Web technology. Financial performance was measured using four financial indicators: sales, profits, costs, and return-on-investment (ROI). The diffusion of innovations theory states that an innovation brings changes to a company. Web technology is an innovation that affects company’s performance. This paper investigates the effect of Web technology on commercial printing firms’ financial performance."

3. Strategic and Financial Performance Implications of Global Sourcing Strategy: A Contingency Analysis
Abstract

"Using a contingency model of global sourcing strategy, this study investigated the moderating effects of sourcing-related factors on the relationship between sourcing strategy and a product's strategic and financial performance. The results lent some support to the contingency model of global sourcing strategy in that product
-18-

innovation, process innovation and asset specificity were significant moderator variables for financial, but not strategic, performance. However, the results provided no support for bargaining power of suppliers and transaction frequency as moderator variables. In other words, in achieving high financial performance for a product, whether a particular sourcing strategy should be used for a particular product depended on the levels of product innovation, process innovation and asset specificity."

4. Implications for financial performance and corporate social responsibility

Abstract
"We investigate whether CEO implicit motives predict corporate social performance and financial performance. Using longitudinal data on 258 CEOs from 118 firms, and controlling for country and industry effects, we found that motives significant predicted both financial performance (Tobin's Q and the CAPM) and social responsibility. In general, need for power and responsibility disposition were positively predictive whereas need for achievement and affiliation were negatively predictive of outcomes. Contrary to previous theorizing, corporate social responsibility had no link to financial performance. Our findings suggest that executive characteristics have important consequences for corporate level outcomes."

2 5. Financial statement analysis: A data envelopment analysis approach

Abstract
"Ratio analysis is a commonly used analytical tool for verifying the performance of a firm. While ratios are easy to compute, which in part explains their wide appeal, their interpretation is problematic, especially when two or more ratios provide conflicting signals. Indeed, ratio analysis is often criticized on the grounds of subjectivity, that is the analyst must pick and choose ratios in order to assess the overall performance of a firm.
In this paper we demonstrate that Data Envelopment Analysis (DEA) can augment the traditional ratio analysis. DEA can provide a consistent and reliable measure of managerial or operational efficiency of a firm. We test the null hypothesis that there is no relationship between DEA and traditional accounting ratios as measures of performance of a firm. Our results reject the null hypothesis indicating that DEA can provide information to analysts that is additional to that provided by traditional ratio analysis. We also apply DEA to the oil and gas industry to demonstrate how financial analysts can employ DEA as a complement to ratio analysis."

CHAPTER III (METHODOLOGIES)

-19-

CHAPTER 3 – Methodology
3.1Meaning of research
DESCRIPTIVE STUDY

Descriptive Study

Descriptive study is undertaken in order to characteristics of variables of financial analysis. • Ratio Analysis • Comparative Financial Statements • Common Size statements • Net working capital analysis • Trend analysis
3.2Data Collection

The study when conducted in REVL all data were sorted out and logical conclusion were drawn towards the estimated and function of the company based on the interview with officers and managers of the various heads of the department with high important data in finance department.
Primary data In order to make study effective data has been collected especially from financial department. The primary data collected by interview with staff,officers,managers of each department with regard to functions management.

Secondary data Secondary have been collected from the company record like books of accounts,budgets,bank performance review, cost of procedure, sales report,annual report published by company.

-20-

3.3Tools for Analysis

Financial Tools • Schedule of Changes in Working Capital • Comparative Balance Sheet • Common – Size Balance Sheet • Ratio analysis Statistical Tool • Trend analysis • Correlation

CHAPTER IV
(DATA ANALYSIS AND INFERENCE)

-21-

CHAPTER - 4 Data Analysis and Interpretation

TABLE NO:4.1 TABLE SHOWING SCHEDULE OF CHANGES IN WORKING CAPITAL FOR THE YEAR 2003- 08 (Rs. in ‘000)
|PARTICULARS |2003-2004 |2004-2005 |INCREASE |DECREASE |
| | | | | |
|A.CURRENT ASSETS | | | | |
| | | | | |
|Inventories |181332 |276780 |95448 |- |
| | | | | |
|Sundry Debtors |289598 |353757 |64159 |- |
| | | | | |
|Cash & Bank Balance |5838 |4266 |- |1572 |
| | | | | |
|Loans & Advances |66106 |50418 |- |15688 |
| | | | | |
|Total Current Assets |542874 |685221 |- |- |
| | | | | |
|B.CURRENT LIABILITIES | | | | |
| | | | | |
|Liabilities |255118 |367622 |- |112504 |
| | | | | |
|Provisions |8639 |28387 |- |19748 |
| | | | | |
|Total Current Liabilities |263757 |396009 | | |
| | | | | |
|Working capital (A-B) |279117 |289212 |159607 |149512 |
| | | | | |
|Increase in working capital |10095 |- |- |10095 |
| | | | | |
|TOTAL |289212 |289212 |159607 |159607 |

(SOURCE:Secondary Data) -22-

INTERPRETATION The analysis of working capital for the year 2003 showed a net increase of Rs.10095000 when compared to the previous year. The percentage of increase in working capital was 3.62%.

-23-

TABLE NO:4.2. TABLE SHOWING SCHEDULE OF CHANGES IN WORKING CAPITAL
FOR THE YEAR 2003- 08 (Rs. in ‘000)
| | | | | |
|PARTICULARS |2003-2004 |2004-2005 |INCREASE |DECREASE |
| | | | | |
|A.CURRENT ASSETS | | | | |
| | | | | |
|Inventories |276780 |322735 |45955 |- |
| | | | | |
|Sundry Debtors |353757 |413568 |59811 |- |
| | | | | |
|Cash & Bank Balance |4266 |66080 |61814 |- |
| | | | | |
|Loans & Advances |50418 |73592 |23174 |- |
| | | | | |
|Other Current Asset |- |13 |13 |- |
| | | | | |
|Total Current Asset |685221 |875,988 |- |- |
| | | | | |
|B.CURRENT LIABILITIES | | | | |
| | | | | |
|Liabilities |367622 |383675 |- |16053 |
| | | | | |
|Provisions |28387 |25605 |2782 |- |
| | | | | |
|Total Current Liabilities |396009 |409280 |- |- |
| | | | | |
|Working capital (A-B) |289212 |466708 |193549 |16053 |
| | | | | |
|Increase in working capital |177496 |- |- |177496 |
| | | | | |
| | | | | |
|TOTAL |466708 |466708 |193549 |193549 |

(SOURCE:Secondary Data) -24-

INTERPRETATION: From the above table it is inferred that the working capital for the year 2004 showed a net increase of Rs.177496000 when compared to the previous year. The percentage of increase in working capital was 61.37%.

-25-

TABLE NO:4.3 TABLE SHOWING SCHEDULE OF CHANGES IN WORKING CAPITALFOR THE YEAR 2005- 06 (Rs. in ‘000)
| | | | | |
|PARTICULARS |2005-2006 |2006-2007 |INCREASE |DECREASE |
| | | | | |
|A.CURRENT ASSETS | | | | |
| | | | | |
|Inventories |322735 |393103 |70368 |- |
| | | | | |
|Sundry Debtors |413568 |435864 |22296 |- |
| | | | | |
|Cash & Bank Balance |66080 |4381 |- |61699 |
| | | | | |
|Other Current Assets |13 |393 |380 |- |
| | | | | |
|Loans & Advances |73592 |54314 |- |19278 |
| | | | | |
|Total Current Asset |875988 |888055 |- |- |
| | | | | |
|B.CURRENT LIABILITIES | | | | |
| | | | | |
|Liabilities |383675 |480320 |- |96645 |
| | | | | |
|Provisions |25605 |41958 |- |16353 |
| | | | | |
|Total Current Liabilities |409280 |522278 |- |- |
| | | | | |
|Working capital (A-B) |466708 |365777 |93044 |193975 |
| | | | | |
|Decrease in working capital |- |100931 |100931 |- |
| | | | | |
|TOTAL |466708 |466708 |193975 |193975 |

(SOURCE:Secondary Data)

-26-

INTERPRETATION During the year 2005 working capital showed a net decrease of Rs.100931000 when compared to the previous year. The percentage of decrease in working capital was 21.63%.

-27-

TABLE NO: 4.4 TABLE SHOWING SCHEDULE OF CHANGES IN WORKING CAPITALFOR THE YEAR 2006- 07 (Rs. in ‘000)
| | | | | |
|PARTICULARS |2006-2007 |2007-2008 |INCREASE |DECREASE |
|A.CURRENT ASSETS | | | | |
| | | | | |
|Inventories |393103 |500289 |107186 |- |
| | | | | |
|Sundry Debtors |435864 |486293 |50429 |- |
| | | | | |
|Cash & Bank Balance |4381 |15147 |10766 |- |
| | | | | |
|Other Current Assets |393 |445 |52 |- |
| | | | | |
|Loans & Advances |54314 |97471 |43157 |- |
| | | | | |
|Total Current Asset |888055 |1099645 |- |- |
| | | | | |
|B.CURRENT LIABILITIES | | | | |
| | | | | |
|Liabilities |480320 |531256 |- |50936 |
| | | | | |
|Provisions |41958 |38590 |3368 |- |
| | | | | |
|Total Current Liabilities |522278 |569846 |- |- |
| | | | | |
| | | | | |
|Working capital (A-B) |365777 |52999 |214958 |50936 |
| | | | | |
|Increase in working capital |164022 |- |- |164022 |
| | | | | |
|TOTAL |529799 |529799 |214958 |214958 |

(SOURCE:Secondary Data)

-28-

INTERPRETATION: The working capital for the year 2007 showed a net increase of Rs.164022000 when compared to the previous year. The percentage of increase in working capital was 44.84%.

-29-

TABLE NO:4. 5. TABLE SHOWING COMPARATIVE BALANCE SHEET FOR THE YEAR 2003 & 2004

|PARTICULARS |2003 |2004 |Increase / Decrease |Percentage |
|Assets: | | | | |
| | | | | |
|Fixed Asset |5,13,112,000 |5,22,427,000 |9,315,000 |1.8154 |
| | | | | |
|Investment |79,774,000 |76,912,000 |-2,862,000 |-3.5876 |
| | | | | |
|Inventories |181,332,000 |276,780,000 |95,448,000 |52.6372 |
| | | | | |
|Sundry Debtors |289,598,000 |353,757,000 |64,159,000 |22.1545 |
| | | | | |
|Cash & Bank |5,838,000 |4,266,000 |-1,572,000 |-26.9270 |
| | | | | |
|Loans & Advances |66,106,000 |50,418,000 |-15,688,000 |-23.7315 |
| | | | | |
|Deferred tax Asset |8,330,000 |32,190,000 |23,860,000 |2.864 |
| | | | | |
|Miscellaneous Expenditure |84,374,000 |- |-84,374,000 |-100 |
| | | | | |
|TOTAL |1,228,464,000 |1,316,750,000 |88,286,000 | |
|Liabilities: | | | | |
| | | | | |
|Capital |121,953,000 |121,953,000 |- |- |
| | | | | |
|Reserve & Surplus |244,922,000 |215,784,000 |29,138,000 |11.8968 |
| | | | | |
|Secured loans |535,346,000 |512,758,000 |22,588,000 |4.2193 |
| | | | | |
|Unsecured loans |62,486,000 |70,246,000 |-7,760,000 |-12.4188 |
| | | | | |
|Current Liabilities |263,757,000 |396,009,000 |-132,252,000 |-50.14 |
| | | | | |
|TOTAL |1,228,464,000 |1,316,750,000 |88,286,000 | |

(SOURCE:Secondary Data)

-30-

INTERPRETATION From the above table it is inferred that, fixed asset had increased to 1.81%, investment had decreased to -3.58%, inventories had increased to 52.63%, sundry debtors had increased to 22.15%, cash and bank had decreased to -26.92%, loans & advances had decreased to -23.73%, deferred tax asset had increased to 2.864%, miscellaneous expenditure had decreased to -100%, no change in capital, reserves & surplus had increased to 11.89%, secured loans had increased to 4.21%, unsecured loans had decreased to -12.41%, current liabilities had decreased to -50.14%.

-31-

TABLE NO: 4.6. TABLE SHOWING COMPARATIVE BALANCE SHEET FOR THE YEAR 2004 & 2005
| | | |INCREASE / DECREASE | |
|PARTICULARS |2004 |2005 | |PERCENTAGE |
|ASSETS: | | | | |
| | | | -46,074,000 | |
|Fixed Asset |5,22,427,000 |476,353,000 | |-8.8192 |
| | | | -76,862,000 | |
|Investment |76,912,000 |50,000 | |-99.9349 |
| | | | | |
|Inventories |276,780,000 |322,735,000 |45,955,000 |16.6034 |
| | | | | |
|Sundry Debtors |353,757,000 |413,568,000 |59,811,000 |16.9074 |
| | | | | |
|Cash & Bank |4,266,000 |66,080,000 |61,814,000 |1448.9920 |
| | | | | |
|Loans & Advances |50,418,000 |73,605,000 |23,187,000 |45.9895 |
| | | | | |
|Deferred tax Asset |32,190,000 |- |-32,190,000 |-100 |
| | | | | |
|TOTAL |1,316,750,000 |1,352,391,000 |35,641,000 | |
|LIABILITIES: | | | | |
| | | | | |
|Capital |121,953,000 |135,391,000 |-13,438,000 |-11.0190 |
| | | | | |
|Reserve & Surplus |215,784,000 |204,793,000 |10,991,000 |5.0935 |
| | | | | |
|Secured loans |512,758,000 |511,204,000 |1,554,000 |0.3031 |
| | | | | |
|Unsecured loans |70,246,000 |85,400,000 |-15,154,000 |-21.5728 |
| | | | | |
|Current |396,009,000 |409,280,000 |-13,271,000 |-3.3511 |
|Liabilities | | | | |
| | | | | |
|Deferred tax Liability |- |6,323,000 |-6,323,000 |-100 |
| | | | -35,641,000 | |
|TOTAL |1,316,750,000 |1,352,391,000 | | |

(SOURCE:Secondary Data)
-32-

INTERPRETATION The table shows that, fixed asset had decreased to -8.81%, investment had decreased to -99.93%, inventories had increased to 16.60%, sundry debtors had increased to 16.90%, cash and bank had increased to 1448.99%, loans & advances had increased to 45.98%, deferred tax asset had decreased to -100%, Capital had decreased to -11.01%, reserves & surplus had increased to 5.09%, secured loans had increased to 0.30%, unsecured loans had decreased to -21.57%, current liabilities had decreased to -3.35% and Deferred tax liability had decreased to -100%.

-33-

TABLE NO:4. 7. TABLE SHOWING COMPARATIVE BALANCE SHEET FOR THE YEAR 2005 & 2006

| | | | | |
|PARTICULARS |2005 |2006 |INCREASE / DECREASE |PERCENTAGE |
|ASSETS: | | | | |
| | | | | |
|Fixed Asset |476,353,000 |475,853,000 |-5,00,000 |-0.10 |
| | | | | |
|Investment |50,000 |50,000 |- |- |
| | | | | |
|Inventories |322,735,000 |393,103,000 |70,368,000 |21.80 |
| | | | | |
|Sundry Debtors |413,568,000 |435,864,000 |22,296,000 |5.39 |
| | | | | |
|Cash & Bank |66,080,000 |4,381,000 |-61,699,000 |93.37 |
| | | | | |
|Loans & Advances |73,605,000 |54,314,000 |-19,291,000 |26.21 |
| | | | | |
|Other Current Assets |- |3,93,000 |3,93,000 |100 |
| | | | | |
|Miscellaneous Expenditure |- |43,588,000 |43,588,000 |100 |
| | | | | |
|TOTAL |1,352,391,000 |1,407,576,000 |55,155,000 | |
|LIABILITIES: | | | | |
| | | | | |
|Capital |135,391,000 |124,141,000 |11,250,000 |8.31 |
| | | | | |
|Reserve & Surplus |204,793,000 |251,511,000 |-46,718,000 |-22.82 |
| | | | | |
|Secured loan |511,204,000 |382,098,000 |129,106,000 |25.25 |
| | | | | |
|Unsecured loan |85,400,000 |67,285,000 |18,115,000 |21.21 |
| | | | | |
|Current Liabilities |409,280,000 |522,278,000 |-112,998,000 |-27.61 |
| | | | | |
|Deferred tax liability |6,323,000 |60,233,000 |-53,910,000 |-852.60 |
| | | | | |
|TOTAL |1,352,391,000 |1,407,546,000 |-55,155,000 | |

(SOURCE:Secondary Data)

-34-

INTERPRETATION

From the above table it reveals, fixed asset had decreased to -0.10%, investment had not increased or decreased, inventories had increased to 21.80%, sundry debtors had increased to 5.39%, cash and bank had increased to 93.37%, loans & advances had increased to 26.20%, other current assets had increased to 100%,miscellaneous expenditure had increased to 100%, Capital had increased to 8.31%, reserves & surplus had decreased to -22.82%, secured loans had increased to 25.25%, unsecured loans had increased to 21.21%, current liabilities had decreased to -27.60% and Deferred tax liability had decreased to -852.60%.

-35-

TABLE NO: 4.8. TABLE SHOWING COMPARATIVE BALANCE SHEET FOR THE YEAR 2006 & 2007

| | | | | |
|PARTICULARS |2006 |2007 |INCREASE / DECREASE |PERCENTAGE |
|ASSETS: | | | | |
| | | | | |
|Fixed Asset |475,853,000 |611,180,000 |135,327,000 |28.44 |
| | | | | |
|Investment |50,000 |50,000 |- |- |
| | | | | |
|Inventories |393,103,000 |500,289,000 |107,186,000 |27.27 |
| | | | | |
|Sundry Debtors |435,864,000 |486,293,000 |50,429,000 |11.60 |
| | | | | |
|Cash & Bank |4,381,000 |15,147,000 |10,766,000 |245.74 |
| | | | | |
|Loans & Advances |54,314,000 |97,471,000 |43,157,000 |79.46 |
| | | | | |
|Other Current Asses |3,93,000 |4,45,000 |52,000 |13.23 |
| | | | | |
|Miscellaneous Expenditure |43,588,000 |48,365,000 |4,777,000 |10.96 |
| | | | | |
|TOTAL |1,407,576,000 |1,759,240,000 |351,694,000 | |
|Liabilities: | | | | |
| | | | | |
|Capital |124,141,000 |112,891,000 |11,250,000 |9.06 |
| | | | | |
|Reserve & Surplus |251,511,000 |338,134,000 |-86,623,000 |-34.44 |
| | | | | |
|Secured loan |382,098,000 |571,982,000 |-189,884,000 |-49.69 |
| | | | | |
|Unsecured loan |67,285,000 |102,193,000 |-34,908,000 |-51.69 |
| | | | | |
|Deferred tax liability |60,233,000 |64,194,000 |-3,961,000 |-6.58 |
| | | | | |
|Current Liabilities |522,278,000 |569,846,000 |-47,568,000 |-9.11 |
| | | | | |
|TOTAL |1,407,546,000 |1,759,240,000 |-351,694,000 | |

(SOURCE:Secondary Data)

-36-

INTERPRETATION From the above table it reveals, fixed asset had increased to 28.44%, investment had not increased or decreased, inventories had increased to 27.27%, sundry debtors had increased to 11.60%, cash and bank had increased to 245.74%, loans & advances had increased to 79.46%, other current assets had increased to 13.23%,miscellaneous expenditure had increased to 10.96%, Capital had increased to 9.06%, reserves & surplus had decreased to -34.44%, secured loans had decreased to -49.69%, unsecured loans had decreased to -51.69%, Deferred tax liability had decreased to -6.58% and current liabilities had decreased to -9.11%.

INTERPRETATION

• Investment is consistently decreasing during the year.

• Inventories are increasing from year after year.

• Sundry debtors have reduced from 30.96 to 27.64 during the year 2006 – 2007.

• There is a constant fluctuation in loans and advances.

• Capital is in the decreasing trend from 2005.

• Reserves and surplus have constantly decreased till 2005 after that it started to increase.

-37-
Table No: 4.26 COMMON SIZE BALANCE SHEET
| | | | |
|PARTICULARS |2004 |2005 |2006 |
|2004 |60410 |1240860 |4.86% |
|2005 |94433 |1732878 |5.44% |
|2006 |108893 |1950117 |5.58% |
|2007 |189063 |2763005 |6.84% |
|2008 |210983 |3263192 |6.46% |

(SOURCE:Secondary Data)

INTERPRETATION Return on Sales ratio is widely used to evaluate a company's operational efficiency. This measure is helpful to management, providing insight into how much profit is being produced per rupee of sales. The ratio of ROS is increasing every year except 2007 where there is a decline in the ratio which signals looming financial troubles to the company.
CHART NO. 4.9. CHART SHOWING RETURN ON SALES

-39-

TABLE NO:4.10. TABLE SHOWING RELATIONSHIP BETWEEN EBITDA AND SALES

Return on sales = EBITDA- Other income/Net sales

(Rs. in ‘000)
|Particulars |EBITDA – Other Income |Net Sales |Ratio |
|2004 |126300 |1240860 |10.17% |
|2005 |162336 |1732878 |9.36% |
|2006 |162343 |1950117 |8.32% |
|2007 |260887 |2763005 |9.44% |
|2008 |289416 |3263192 |8.86% |

(SOURCE:Secondary Data)

INTERPRETATION

From the table it is inferred that the ratio which was highest during the year 2003 (10.17%) has gone down to 8.86% in the year 2007.

CHART NO. 4.10. CHART SHOWING RELATIONSHIP BETWEEN EBITDA AND SALES

-40-

TABLE NO:4.11 TABLE SHOWING RETURN ON NET OPERATING ASSETS

RONA = EBIT – Other Income/ Net Fixed Asset + Working Capital

(Rs. in ‘000)
|Particulars |EBIT – Other Income |Net Fixed Asset + Net Current |Ratio |
| | |Asset | |
|2004 |60410 |751260 |8.04% |
|2005 |94433 |796021 |11.86% |
|2006 |108893 |932994 |11.67% |
|2007 |189063 |824132 |22.94% |
|2008 |210983 |1106377 |19.06% |

(SOURCE:Secondary Data)

INTERPRETATION: During the year 2006 the ratio went up sharply from 11.67% to 22.94%, but immediately saw a drip to 19.06% in the subsequent year. Lower the return indicates less profit performance of the company.

CHART NO: 4.11 CHART SHOWING RETURN ON NET OPERATING ASSETS

-41-

TABLE NO:4.12 TABLE SHOWING RETURN ON EQUITY

ROE= Profit after tax/Equity

(Rs. in ‘000)

|Particulars |PAT |Equity |Ratio |
|2004 |1004 |255455 |0.393% |
|2005 |72016 |305547 |23.56% |
|2006 |42307 |346507 |12.20% |
|2007 |86402 |392297 |22.02% |
|2008 |136166 |466854 |29.166% |

(SOURCE:Secondary Data)

INTERPRETATION: ROE is a measure of a corporation's profitability that reveals how much profit a company generates with the money shareholders have invested. It is also known as "Return on net worth”. When compared to 2003 there is a tremendous increase in ROE during the year 2007 which shows that the equity is well utilized in the company.

CHART NO: 4.12 CHART SHOWING RETURN ON EQUITY

-42-

TABLE NO:4. 14TABLE SHOWING EARNINGS PER SHARE

EPS = PAT – Preference dividend/No. of equity shares

(Rs. in ‘000)
|Particulars |Earnings Available for S/H`s |No. of equity shares |Ratio |
|2004 |1006862.40 |4195260 |0.24 |
|2005 |72032614.20 |4195260 |17.17 |
|2006 |54886383.00 |10164145 |5.40 |
|2007 |81516442.90 |10164145 |8.02 |
|2008 |13294701.66 |10164145 |13.08 |

(SOURCE:Secondary Data)

INTERPRETATION Earnings per share (EPS) are the earnings returned on the initial investment amount.From the table it is clear that the EPS has increased during the year 2004 from 0.24 to 17.17 but it has greatly decreased in the next year to 5.40 again the ratio started to increase from 2006.

CHART NO. 4.13CHART SHOWING EARNINGS PER SHARE

-44-

ASSET PRODUCTIVITY

TABLE NO:4. 14TABLE SHOWING OPERATING ASSET TURNOVER RATIO

Operating asset turnover ratio = Net sales/ Net fixed assets + Working capital.

(Rs. in ‘000)

|Particulars |Net Sales |Net Fixed Asset + Net current |Times |
| | |asset | |
|2004 |1240860 |751260 |1.65 |
|2005 |1732878 |796021 |2.17 |
|2006 |1950117 |932994 |2.09 |
|2007 |2763005 |824132 |3.35 |
|2008 |3263192 |1106377 |2.94 |

(SOURCE:Secondary Data)

INTERPRETATION The operating asset turnover ratio calculates the total sales for every rupee of assets a company owns. The above table reveals that there is a decrease in ratio during the year 2007 when compared to 2006.This has been mainly due to inefficient usage of assets to increase sales.

CHART NO. 4. 14CHARTSHOWING OPERATING ASSET TURNOVER

-45-

RATIO

TABLE NO:4.15TABLE SHOWING FIXED ASSET TURNOVER RATIO

4.7 Fixed Asset Turnover Ratio = Net Sales/ Net Fixed Asset (Rs. in ‘000)
|Particulars |Net Sales |Net Fixed Asset |Times |
|2004 |1240860 |471748 |2.63 |
|2005 |1732878 |506809 |3.42 |
|2006 |1950117 |466286 |4.18 |
|2007 |2763005 |458355 |6.03 |
|2008 |3263192 |576578 |6.31 |

(SOURCE:Secondary Data)

INTERPRETATION

Fixed asset turnover ratio indicates how well the business is using its fixed assets to generate sales. During the year 2004-2008 there has been a regular increase in the ratio. Though the utilization of fixed assets has let to corresponding increase in sales, they have not been employed to the optimum level.

Chart No: TABLE NO:4.15TABLE SHOWING FIXED ASSET TURNOVER RATIO

[pic]

-46-

TABLE NO:4. 16TABLE SHOWING GROSS WORKING CAPITAL TURNOVER RATIO

Gross Working Capital Turnover Ratio = Net Sales/Gross Working Capital (Rs. in ‘000)
|Particulars |Net Sales |Gross w/c |Times |
|2004 |1240860 |540187 |2.30 |
|2005 |1732878 |685221 |2.53 |
|2006 |1950117 |875988 |2.23 |
|2007 |2763005 |888055 |3.11 |
|2008 |3263192 |1099645 |2.97 |

(SOURCE:Secondary Data)
INTERPRETATION
From the above table it is clearly seen that the ratio is increasing constantly from 2005 which indicates the smooth running of the business. A higher sale in comparison to working capital indicates overtrading and a lower sale indicates under trading.

CHART NO: 4. 16CHART SHOWING GROSS WORKING CAPITAL TURNOVER RATIO

[pic]

-47-

RISK INDICATORS

TABLE NO: 4.17 TABLE SHOWINGOPERATING SAFETY MARGIN

Operating safety margin = Margin of safety/Net sales

(Rs. in ‘000)
|Particulars |Net Sales – BES |Net Sales |Ratio |
|2004 |-73719.16 |1240860 |-5.94% |
|2005 |258337.54 |1732878 |14.90% |
|2006 |500250.43 |1950117 |25.65% |
|2007 |962404.49 |2763005 |34.83% |
|2008 |1006258.40 |3263192 |30.83% |

(SOURCE:Secondary Data)

INTERPRETATION

The ratio has been consistently increasing from 2003-06 but it has declined during the year 2007 by 4%.This shows that the company should concentrate in fixed and variable cost to increase the operating safety margin.

CHART NO: : 4.17 CHART SHOWINGOPERATING SAFETY MARGIN

-48-

TABLE NO: 4.18TABLE SHOWING DEBT TO CAPITAL EMPLOYED

Debt to capital employed = Total borrowings / Total capital employed

(Rs. in ‘000)
|Particulars |Total Borrowings |Total Capital Employed |Percentage |
|2004 |598035 |751260 |79.60% |
|2005 |583004 |796021 |73.23% |
|2006 |596604 |932994 |63.94% |
|2007 |449383 |824132 |53.41% |
|2008 |674175 |1106377 |61.00% |

(SOURCE:Secondary Data)

INTERPRETATION:

From the above table it is inferred that, there has been a continuous decrease in the ratio from the year 2003-2006 where as in the year 2007 it has shot up to 61%.

CHART NO:4.18 CHART SHOWING DEBT TO CAPITAL EMPLOYED

[pic] -49-

TABLE NO: 4.19TABLE SHOWING CURRENT RATIO

Current Ratio = Current Asset / Current Liabilities

(Rs. in ‘000)
|Particulars |Current Asset |Current Liabilities |Ratio |
|2004 |540187 |410650 |1.31 |
|2005 |685221 |511512 |1.33 |
|2006 |875988 |569252 |1.53 |
|2007 |888055 |644221 |1.37 |
|2008 |1099645 |844992 |1.30 |

(SOURCE:Secondary Data)

INTERPRETATION: The current ratio is used to measure whether or not a firm has enough resources to pay its debts over the next 12 months. From the table it is evident that the company has never been able to achieve its standard norms (2:1). This shows that the company has not managed its current assets and liabilities satisfactorily.

CHART NO: 4.19 CHART SHOWING CURRENT RATIO

-50-

-50-

PEOPLE PRODUCTIVITY

TABLE NO:4.20 TABLE SHOWINGEMPLOYEE COST TO NET SALES RATIO

(Rs. In ‘000)
|Particulars |Employee Cost |Net Sales |Ratio |
|2004 |193908 |1240860 |15.62% |
|2005 |213193 |1732878 |12.30% |
|2006 |185146 |1950117 |9.49% |
|2007 |272403 |2763005 |9.85% |
|2008 |319841 |3263192 |9.80% |

(SOURCE:Secondary Data)
INTERPRETATION
The ratio which dropped from 15.62% (during the year 2003) to 9.49% (during the year 2005) however once again started to rise and finally reached 9.80 during the year 2007.

CHART NO: 4.20 CHART SHOWINGEMPLOYEE COST TO NET SALES RATIO

[pic]

-51-

TABLE NO:4.21 TABLE SHOWINGNET SALES PER EMPLOYEE

NSPE = Net Sales / No. of employees

(Rs. in ‘000)
|Particulars |Net Sales |Total no. of employees |Ratio |
|2004 |1240860 |798 |1554.96 |
|2005 |1732878 |831 |2085.29 |
|2006 |1950117 |828 |2355.21 |
|2007 |2763005 |861 |3209.06 |
|2008 |3263192 |930 |3508.80 |

(SOURCE:Secondary Data) INTERPRETATION

This ratio indicates the average revenue generated per person employed. The table shows that there has been periodical increase in the net sales per employee right from 2004-2008.Higher the NSPE higher will be the profitability.

Chart No: 4.21 TABLE SHOWINGNET SALES PER EMPLOYEE

-52-

TABLE NO: 4.22 TABLE SHOWING VALUE ADDED PER EMPLOYEE

VAPE= Value addition / No. of employees

(Rs. in ‘000)
|Particulars |Value Addition |Total no. of employees |Rs |
| 2004 |581425 |798 |728.60 |
|2005 |820999 |831 |987.96 |
|2006 |785013 |828 |948.08 |
|2007 |1194436 |861 |1387.26 |
|2008 |1439097 |930 |1547.41 |

(SOURCE:Secondary Data)

INTERPRETATION

The table shows that there has been considerable increment in the value added per employee except for the year 2005.

CHART NO. 4.22 CHART SHOWING VALUE ADDED PER EMPLOYEE

-53-

TABLE NO: 4.23TABLE SHOWING COST PER EMPLOYEE

Cost per employee = Total employee cost/ Total number of employees

(Rs. in ‘000)
|Particulars |TEC |Total no. of employees |Rs |
|2004 |95835 |798 |242.99 |
|2005 |110860 |831 |256.54 |
|2006 |96276 |828 |223.60 |
|2007 |142952 |861 |316.37 |
|2008 |167198 |930 |343.91 |

(SOURCE:Secondary Data)

INTERPRETATION From the table, it can be inferred that the cost per employee has increased over the period 2004-2008 except 2005, however this increase is unavoidable. STASTICAL ANALYSIS
| | | | | | |
|YEAR |NET PROFIT |NET |Dx |Dy |DxDy |
| | |SALES |= X - 4.23 |= Y -195.01 | |
| | | | | | |
|2004 |124.09 |-2 |-248.18 |4 |117.51 |
| | | | | | |
|2005 |173.29 |-1 |-173.29 |1 |168.25 |
| | | | | | |
|2006 |195.01 |0 |0 |0 |219.002 |
| | | | | | |
|2007 |276.30 |1 |276.30 |1 |269.75 |
| | | | | | |
|2008 |326.32 |2 |652.64 |4 |320.50 |
| | | | | | |
|TOTAL |1095.01 |0 |507.47 |10 |1095.01 |

(SOURCE:Secondary Data)

-55-
The equation of straight line is:

Y = a+ bx

∑X = 0 (Q (QX

Where, a = ______ , b = _______

N X2

Where, a = 219.002 b= 50.747

Y= a+b (P-2005) = Rs.371.2447
Chart No:4.24 CHART SHOWING TREND ANALYSIS FOR SALES

[pic]
-56-
INTERPRETATION

When other factors remain the same, the value of sales in Rane (Madras) Ltd is estimated to be Rs.371.24 crores for the year 2007-08. The trend shows the increase in sales values.

-57-
TABLE NO:4.25 TABLE SHOWING TREND ANALYSIS FOR PROFIT

(Rs in Crores)
| | | | | | |
|YEAR |PROFIT |X= P-2005 |QX |X2 |Y |
|(P) |(Q) | | | | |
| | | | | | |
|2004 |0.10 |-2 |-0.20 |4 |1.06 |
| | | | | | |
|2005 |7.20 |-1 |-7.20 |1 |3.91 |
| | | | | | |
|2006 |4.23 |0 |- |0 |6.76 |
| | | | | | |
|2007 |8.64 |1 |8.64 |1 |9.61 |
| | | | | | |
|2008 |13.62 |2 |27.24 |4 |12.45 |
| | | | | | |
|TOTAL |33.79 |0 |28.48 |10 |33.79 |

(SOURCE:Secondary Data)

The equation of straight line is

Y = a+ bx

∑X = 0 (Q (QX

Where, a = ______ , b = _______

N X2
Where, a = 6.758 b= 2.848

Y= a+b (P-2005) = Rs.15.302

-58-

CHART NO: 4.25 CHART SHOWING TREND ANALYSIS FOR PROFIT

[pic]

INTERPRETATION The company showed an increasing trend in Net profit throughout the year. The trend net profit has been projected as Rs.15.302 Crores for the year 2008.

CHAPTER V
(CONCLUSIONS)

-59- 5.1 Findings • The study of funds flow statement that is source of fund and application of funds. In the source of funds the share holders funds as well as loan funds were increasing every year. • The working capital trend of the company has helped us to know the overall working capital trend it was sound and good as the current asset was overall current liabilities through out the period of the study. • The study of working capital of the organization, the working capital trend shows an increase in every year. In case of application of fund it has mainly utilized for purchase of investment and fund asset and rest was utilized for effective utilization of working capital. • The study of capital structure of the organization shows that the company issued new share every year. Over the year of quantum of secured loans and unsecured have increased in every year.

-60-

5.2 Suggestions and recommendations

• The major source of funds for that the company was through loans, so it should try to reduce funds from loan and should stress up on the cost of there funds. • The major proportion of funds has been utilized in working capital. It can go for expansions programmes, as the company financial position healthy.

-61-

5.3 – Conclusion

The project involves the study of financial analysis in Rane Engine Valves. The analysis carried out included Common size balance sheet, Comparative Balance sheet and Ratio Analysis based on which certain findings were arrived at. In order to overcome the drawbacks in the finding few suggestion are given. Implementation of these suggestions will help improve the financial performance of the company.

-62-

1 BIBLIOGRAPHY

1 TEXT BOOKS

❖ I.M.Pandey, Financial Management, Vikas Publishing House Pvt.Ltd. 8th • Edition 1999. ❖ Khan and Jain-Basic Financial management & Practice- Tata McGraw • Hill- 5th Edition 2001.

❖ C.R.Kothari, Research Methodology, Wishva Prakashan, New Delhi, 2001.

❖ R.P.Rustagi, Fundamentals Of Financial Management, Tata McGraw hill • Publishing Company Ltd, 5th Edition, 2001.

❖ Prasanna Chandra, Financial Management Theory and Practice, Tata • McGraw Hill Publishing Company Ltd., New Delhi, 1997.

❖ Annual Reports

2 WEBSITES

www.rane.co.in

APPENDIX

-63-

BALANCE SHEET FOR THE YEAR 2004

| Schedule | 2004-2005 (Rs. 000) |
| | |
|I. SOURCES OF FUNDS | |
| | |
|Shareholders’ Funds | |
|Capital A |121,953 |
|Reserve & Surplus B |244,922 |
| |366,875 |
|Loan Funds | |
|Secured Loans C |535,346 |
|Unsecured Loan D |62,486 |
| |597,832 |
| |_________ |
|TOTAL |964,707 |
| |__________ |
|II. APPLICATION OF FUNDS | |
| | |
|Fixed Assets E | |
|Gross Block |1,033,242 |
|Less: Accumulated Depreciation |542,778 |
|Net Block |490,464 |
|Capital work in progress |22,648 |
| |513,112 |
|Investments F |79,774 |
|Current Assets, loans and Advances | |
|Inventories G |181,332 |
|Sundry Debtors H |289,598 |
|Cash and Bank Balances I |5,838 |
|Loans and Advances J |66,106 |
| |542,874 |
|Less: Current liabilities & Provisions | |
|Liabilities K |255,118 |
|Provisions L |8,639 |
| |263,757 |
|Net current Assets |279,117 |
|Deferred Tax Assets |8,330 |
|Miscellaneous Expenditure M |84,374 |
| |__________ |
| | |
|TOTAL |964,707 |
| Schedule | 2005-2006 (Rs. 000) |
|INCOME | |
|Sales and Operating Revenues N |1,756,888 |
|Other Income O |39,313 |
| |1,796,201 |
|TOTAL INCOME | |
| | |
|EXPENDITURE | |
|Manufacturing and other Expenses P |1,602,387 |
|Finance charges Q |84,590 |
|Depreciation / Amortization |67,903 |
| | |
|TOTAL EXPENDITURE |1,754,880 |
| | |
| | |
|Profit / ( loss) before exceptional items |41,321 |
|VRS Charged off |------ |
|Profit on sale of investments |7,835 |
|Profit / ( loss) before Taxation |49,156 |
| | |
|Provision for Taxation: | |
|Current |1,000 |
|Deferred |(23,860) |
| |(22,860) |
|Profit after Taxation |72,016 |
| | |
|Prior year adjustment: | |
|Taxes paid |----- |
|Deferred Tax Liability reversed |----- |
| |__________ |
| |------ |
|Profit after prior year adjustment |72,016 |
|Surplus brought forward |20,249 |
|Transfer from Debenture Redemption Reserve |42,082 |
| |_____________ |
|Profit available for appropriation |134,347 |
|Less: | |
|Preference Dividend –Interim 13.5% |10,800 |
|Equity Dividend –Interim 10% |4,195 |
|Tax on dividends |1,921 |
|Transfer to General Reserve |92,431 |
| |109,347 |
|Surplus carried to Balance Sheet |25,000 |

-65-

BALANCE SHEET FOR THE YEAR 2005

| Schedule | 2005-2006 (Rs. 000) |
| | |
|I. SOURCES OF FUNDS | |
| | |
|Shareholders’ Funds | |
|Capital A |121,953 |
|Reserve & Surplus B |215,784 |
| |337,737 |
|Loan Funds | |
|Secured Loans C |512,758 |
|Unsecured Loan D |70,246 |
| |583,004 |
| | |
|TOTAL |_________ |
| |920,741 |
|II. APPLICATION OF FUNDS |_________ |
| | |
|Fixed Assets E | |
|Gross Block | |
|Less: Accumulated Depreciation |1,105,026 |
|Net Block |598,217 |
|Capital work in progress |506,809 |
| |15,618 |
|Investments F |522,427 |
|Current Assets, loans and Advances |76,912 |
|Inventories G | |
|Sundry Debtors H |276,780 |
|Cash and Bank Balances I |353,757 |
|Loans and Advances J |4,266 |
| |50,418 |
|Less: Current liabilities & Provisions |685,221 |
|Liabilities K | |
|Provisions L |367,622 |
| |28,387 |
|Net current Assets |396,009 |
|Deferred Tax Assets |289,212 |
| |32,190 |
| |___________ |
|TOTAL |920,741 |
| |___________ |

-66-

PROFIT & LOSS ACCOUNT FOR THE YEAR 2006

| Schedule | 2005-2006 (Rs. 000) |
|INCOME | |
|Sales and Operating Revenues M |1,984,763 |
|Other Income N |16,937 |
| |2,001,700 |
|TOTAL INCOME | |
| | |
| | |
|EXPENDITURE | |
|Manufacturing and other Expenses O |1,822,420 |
|Finance charges P |43,244 |
|Depreciation / Amortization |53,450 |
| | |
|TOTAL EXPENDITURE |1,919,114 |
| | |
|PROFIT BEFORE TAX |82,586 |
|Provision for Taxation – Current |6,500 |
|Deferred |33,779 |
| | |
| |__________ |
|PROFIT AFTER TAX | |
|Transfer to Capital Redemption Reserve |40,279 |
| |11,250 |
|PROFIT AVAILABLE FOR APPOPRIATION | |
|Less: |31,057 |
|Dividend on Preference Shares @ 13.5% | |
|Dividend on Equity Shares @10% |5,838 |
|Provision for tax on distributed profits |10,164 |
|Transfer to General Reserve |2,188 |
| |2,200 |
| |_____________ |
| | |
| |20,390 |
| |_____________ |
|Surplus carried to Balance Sheet | |
| |10,667 |
| |_____________ |

-67-

BALANCE SHEET FOR THE YEAR 2006

| Schedule | 2005-2006 (Rs. 000) |
| | |
|I. SOURCES OF FUNDS | |
| | |
|Shareholders’ Funds | |
|Capital A |135,391 |
|Reserve & Surplus B |204,793 |
| |340,184 |
|Loan Funds | |
|Secured Loans C |511,204 |
|Unsecured Loan D |85,400 |
| |596,604 |
|Deferred Tax Liability |6,323 |
| | |
|TOTAL |___________ |
| |943,111 |
|II. APPLICATION OF FUNDS |__________ |
| | |
|Fixed Assets E | |
|Gross Block | |
|Less: Accumulated Depreciation | |
|Net Block |1,091,807 |
|Capital work in progress |625,521 |
| |466,286 |
|Investments F |10,067 |
|Current Assets, loans and Advances |476,353 |
|Inventories G |50 |
|Sundry Debtors H |322,735 |
|Cash and Bank Balances I |413,568 |
|Loans and Advances J |66,080 |
| |73,605 |
|Less: Current liabilities & Provisions |875,988 |
|Liabilities K | |
|Provisions L |383,675 |
| |25,605 |
|Net current Assets |409,280 |
| |466,708 |
| |___________ |
|TOTAL | |
| |943,111 |
| |___________ |

-68-

PROFIT & LOSS ACCOUNT FOR THE YEAR 2007

| Schedule | 2006-2007 (Rs. 000) |
|INCOME | |
|Sales and Operating Revenues N |2,796,236 |
|Other Income O |4,468 |
| |2,800,704 |
|TOTAL INCOME | |
| | |
| | |
|EXPENDITURE | |
|Manufacturing and other Expenses P |2,535,349 |
|Finance charges Q |35,778 |
|Depreciation / Amortization |71,824 |
| | |
|TOTAL EXPENDITURE |2,642,951 |
| | |
|PROFIT BEFORE TAX |157,753 |
|Less: Tax expense - Current |13,275 |
|- Deferred |53,910 |
|- fringe Benefit Tax |4,166 |
|PROFIT AFTER TAX |86,402 |
|Balance brought forward from previous year |10,667 |
| | |
|PROFIT AVAILABLE FOR APPOPRIATION |97,069 |
|Less: | |
|Transfer to Capital Redemption Reserve |11,250 |
|Transfer to General Reserve |8,640 |
|Dividend on Preference Shares @ 13.5% |4,311 |
|Interim Dividend on Equity Shares @15% |15,246 |
|Final dividend on Equity Shares |15,246 |
|Tax on Dividends |4,881 _____________ |
| | |
| |59,574 |
| |____________ |
| | |
| |37,495 |
|Surplus carried to Balance Sheet |____________ |

-69-

BALANCE SHEET FOR THE YEAR 2007

| Schedule | 2006-2007 (Rs. 000) |
| | |
|I. SOURCES OF FUNDS | |
| | |
|Shareholders’ Funds | |
|Capital A |124,141 |
|Reserve & Surplus B |251,511 |
| |375,652 |
|Loan Funds | |
|Secured Loans C |382,098 |
|Unsecured Loan D |67,285 |
| |449,383 |
|Deferred Tax Liability |60,233 |
| |__________ |
|TOTAL |885,268 |
| |__________ |
|II. APPLICATION OF FUNDS | |
| | |
|Fixed Assets E | |
|Gross Block |1,154,030 |
|Less: Accumulated Depreciation |695,675 |
|Net Block |458,355 |
|Capital work in progress |17,498 |
| |475,853 |
|Investments F |50 |
|Current Assets, loans and Advances | |
|Inventories G |393,103 |
|Sundry Debtors H |435,864 |
|Cash and Bank Balances I |4,381 |
|Other Current Assets J |393 |
|Loans and Advances K |54,314 |
| |888,055 |
|Less: Current liabilities & Provisions | |
|Liabilities L |480,320 |
|Provisions M |41,958 |
| |522,278 |
|Net current Assets |365,777 |
|Miscellaneous Expenditure R |43,588 |
| |____________ |
| | |
|TOTAL |885,268 |
| |____________ |

-70-

PROFIT & LOSS ACCOUNT FOR THE YEAR 2008

| Schedule | 2007-2008 (Rs. 000) |
|INCOME | |
|Sales and Operating Revenues N |3,304,680 |
|Other Income O |25,125 |
| |__________ |
|TOTAL INCOME |2,800,704 |
| | |
| | |
|EXPENDITURE | |
|Cost of Goods Sold P |2,071,876 |
|Employee costs Q |319,841 |
|Manufacturing & Selling Expenses R |623,547 |
|Interest and Finance Charges S |52,221 |
|Depreciation / Amortization |78,433 |
| |___________ |
|TOTAL EXPENDITURE |3,145,918 |
| |__________ |
| | |
|PROFIT BEFORE TAX |183,887 |
|Less: Tax expense - Current |40,000 |
|- Deferred |3,961 |
|- fringe Benefit Tax |3,760 |
| |___________ |
|PROFIT AFTER TAX |47,721 |
| |__________ |
| | |
|Balance brought forward from previous year |173,661 |
| | |
| | |
|PROFIT AVAILABLE FOR APPOPRIATION | |
|Less: | |
|Transfer to Capital Redemption Reserve |11,250 |
|Transfer to General Reserve |51,868 |
|Dividend on Preference Shares @ 15% |2,792 |
|Interim Dividend on Equity Shares @ 40% |40,657 |
|Tax on Dividends |6,094 |
| |112,661 |
| |___________ |
| | |
|Surplus carried to Balance Sheet |61,000 |
| |___________ |

-71-
BALANCE SHEET AS AT 31ST MARCH 2008

| Schedule | 2007-2008 (Rs. 000) |
| | |
|I. SOURCES OF FUNDS | |
| | |
|Shareholders’ Funds | |
|Capital A |112,891 |
|Reserve & Surplus B |338,134 |
| |375,652 |
|Loan Funds | |
|Secured Loans C |571,982 |
|Unsecured Loan D |102,193 |
| |674,175 |
|Deferred Tax Liability |64,194 |
| |__________ |
|TOTAL |1,189,394 |
| |__________ |
|II. APPLICATION OF FUNDS | |
| | |
|Fixed Assets E | |
|Gross Block |1,328,750 |
|Less: Accumulated Depreciation |752,172 |
|Net Block |576,578 |
|Capital work in progress |34,602 |
| |611,180 |
|Investments F |50 |
|Current Assets, loans and Advances | |
|Inventories G |500,289 |
|Sundry Debtors H |486,293 |
|Cash and Bank Balances I |15,147 |
|Other Current Assets J |445 |
|Loans and Advances K |97,471 |
| |1,099,645 |
|Less: Current liabilities & Provisions | |
|Liabilities L |531,256 |
|Provisions M |38,590 |
| |569,846 |
|Net current Assets |529,799 |
|Miscellaneous Expenditure R |48,365 |
| |___________ |
| | |
|TOTAL |1, 189,394 |
| |____________ |

-----------------------
[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

-64-

PROFIT & LOSS ACCOUNT FOR THE YEAR 2005

Similar Documents

Premium Essay

Financial Analysis

...2 Graduate Thesis By Teia R. Merring Copenhagen Business School Strategic and financial analysis and valuation of B&O 0 1 Executive Summary................................................................................2 Introduction............................................................................................6 1.1Motivation.................................................................................................................. 6 1.2Problem Specification................................................................................................ 8 1.3Problem Identification................................................................................................ 8 1.4Problem Handling .................................................................................................... 10 1.5Structure and Methodology...................................................................................... 12 1.5.1Introduction and Presentation........................................................................... 12 1.5.2Strategic Analysis............................................................................................. 12 1.5.3Financial Statement Analysis ........................................................................... 13 1.5.4Prognoses and Budgets..................................................................................... 14 1.5.5Valuation.......................................

Words: 60014 - Pages: 241

Free Essay

Financial Analysis

...three years and also shows the forecast of the company for financial year 2012. This would help investors and researchers to decide on investing to SWM or not. SWM has been analyzed step by step in order to find out its true value in the industry. The analysts have first looked into SWM business and strategy where it has been noted that SWM was a result of merger of seven group holdings and Australian West Newspaper in order to expand and use their resources efficiently. Secondly, SWM accounting policies and procedures have been analyzed where they showed that the company is following the accounting standards and using their flexibility that was given by the standard in order to measure some accounts in the financial statement. This flexibility was compared to the industry where it has noted that the company is valuing these accounts in a proper way. Thirdly, a financial analysis was also undertaken. It has been understood that the company, though there was a merger, is managing their resources well that resulted to positive book and cash returns. Lastly, the forecasts of the said company, where the analyst has determined the company’s value and the full set of financial statement for 2012, were estimated and calculated intelligently. With the help of the four steps of business analysis, the group has recommended that it is safe to invest to seven west media even if merger has occurred twice in the last three financial year. I. INTRODUCTION In order for a business...

Words: 1963 - Pages: 8

Premium Essay

Financial Analysis

...Financial analysis (also referred to as financial statement analysis or accounting analysis or Analysis of finance) refers to an assessment of the viability, stability and profitability of a business, sub-business or project. It is performed by professionals who prepare reports using ratios that make use of information taken from financial statements and other reports. These reports are usually presented to top management as one of their bases in making business decisions. Financial analysis may determine if a business will: Continue or discontinue its main operation or part of its business; Make or purchase certain materials in the manufacture of its product; Acquire or rent/lease certain machineries and equipment in the production of its goods; Issue stocks or negotiate for a bank loan to increase its working capital; Make decisions regarding investing or lending capital; Make other decisions that allow management to make an informed selection on various alternatives in the conduct of its business. Contents [hide] 1 Goals 2 Method 3 See also 4 Notes 5 External links Goals[edit] Financial analysts often assess the following elements of a firm: 1. Profitability - its ability to earn income and sustain growth in both the short- and long-term. A company's degree of profitability is usually based on the income statement, which reports on the company's results of operations; 2. Solvency - its ability to pay its obligation to creditors and other third parties in...

Words: 455 - Pages: 2

Premium Essay

Financial Analysis Tools

...Financial Analysis Tools Nicola Maclin American Military University Managers should have the ability to assess performance of decisions they have made or intend to make, through structured and robust financial analysis. Managers need tools to forecast or predict as they struggle to make decisions on a daily basis to execute business strategy for the company. Financial analysis tools can drive projections and predictions in many areas of the business, from planning for production and distribution to decisions on a product or service. Managers can use these tools to both assess and improve business performance. Performance evaluation is an important component of managing a business. Managers need feedback to evaluate how well they have accomplished business strategy and managed key business process. Managers need to be able to link strategy with profitability. Financial analysis tools can help provide that much needed feedback. Financial data can be used to compute ratios analysis. These financial ratios gives managers the first look at the company’s vital signs and is used to assess a complete financial health and identify operational problems. Ratio analysis allows management to quickly and efficiently address concerns like: return on capital investment and the company’s profit margin. Ratio analysis can be an effective and useful management tool if ratios are calculated on items that are meaningful and where practical steps can be taken to make improvements in...

Words: 415 - Pages: 2

Premium Essay

Financial Analysis

...Financial analysis Accountancy Financial analysis (also referred to as financial statement analysis or accounting analysis) refers to an assessment of the viability, stability and profitability of a business, sub-business or project. It is performed by professionals who prepare reports using ratios that make use of information taken from financial statements and other reports. These reports are usually presented to top management as one of their bases in making business decisions. Continue or discontinue its main operation or part of its business; Make or purchase certain materials in the manufacture of its product; Acquire or rent/lease certain machineries and equipment in the production of its goods; Issue stocks or negotiate for a bank loan to increase its working capital; Make decisions regarding investing or lending capital; Other decisions that allow management to make an informed selection on various alternatives in the conduct of its business. Financial analysts often assess the firm's: 1. Profitability -its ability to earn income and sustain growth in both short-term and long-term. A company's degree of profitability is usually based on the income statement, which reports on the company's results of operations; 2. Solvency - its ability to pay its obligation to creditors and other third parties in the long-term; 3. Liquidity - its ability to maintain positive cash flow, while satisfying immediate obligations; Both 2 and 3 are based on the company's...

Words: 826 - Pages: 4

Premium Essay

Financial Analysis

...Weeks 13 and 14 (4/21-5/1): Lease Financing and Course Conclusion Yikes! We are at the bittersweet time in our course together. It is almost over. We’ll miss it so much, but we might also want to do something else with the rest of our lives. In these last 1.7 weeks, we’ll cover another topic which, in addition to Financial Analysis and Planning, serves the function of integrating much of the material we have covered. That topic is Lease Financing. There is a lot of material on the structure of the lease and on the accounting treatment of leases, but the analytical focus will be on the lease-buy decision. The lease-buy decision is actually a financing decision. The analysis of the advisability of a lease typically follows a prior decision to acquire an asset (based on an investment decision analysis). In lease analyses we are comparing lease financing (which is a type of debt) to “regular” debt financing. Video 20 and Chapter 25 in BMA are the main materials. As you review the video, work through the lease example in the Excel file (financing uma 13.xlsx). Toward the end of video 20 is described the concept of adjusted present value. Pay close attention to this material as well, because it describes how in some very specific cases the results of an investment decision and a financing decision must be considered together. The deliverable for this two-week period is Exercise 4, which is an individual, i.e., not a team, exercise. We’ll also use the time to review...

Words: 666 - Pages: 3

Premium Essay

Financial Analysis

...its components 8 Economic Analysis 8 Recommendation 9 Executive Summary In 1999, the CEO of Companhia Cervejaria Brahama (largest brewer in Brazil) was considering the bit for Antarctica (second largest brewer in Brazil). The purpose for this merger was to exploit the potential synergies and avail the economies of scale. The secondary motive was to raise the barriers to entry to the industry especially for the multinational firms. For the purpose of acquisition, the valuation for both of the companies needs to be done in the analysis supported by the calculations. The impact of merger and the rise of potential synergies to be evaluated to estimate the overall benefits of the deal. Moreover, the mode of transaction also need to be considered. As both of the companies are large in nature and dominate the industry, all the related factors before the acquisition need to be considered. In issue in the case mainly highlights the valuation of the Antarctica, the company that would be acquired by Brahama, another beer company. The management is concerned about the pros and cons of the mergers and acquisition and also worried about the method to acquire the company. There are several options that could be used by Brahama to acquire Antarctica. The options mainly includes cash transaction and share-to-share transaction. The management of both companies is also considering the shareholders reaction towards the acquisition of these two. The analysis would be made to find out the...

Words: 2464 - Pages: 10

Premium Essay

Introduction to Financial Ratios and Financial Statement Analysis

...9-193-029 REV: SEPTEMBER 13, 2004 WILLIAM BRUNS Introduction to Financial Ratios and Financial Statement Analysis There is almost always a reason why someone picks up an organization’s financial statements and begins to analyze them. Lenders or creditors may be interested in determining whether they will be repaid money they have lent or may lend to the organization. Investors may be interested in comparing a potential investment in one organization with that of another. Employees may want to compare the current performance or financial status of their employer with earlier periods. Regulatory agencies often need to assess organizational or industry financial health and performance. Financial analysis is always based on a set of questions, and the specific questions requiring answers depend on who the financial statement user is and the reasons for his or her analysis. Financial analyses based on accounting information consistently involve comparisons. Amounts or ratios may be compared with industry norms, the same measurement in a prior period, the same measurement in a competitor’s organization, or with planned and budgeted amounts previously established. Figuring out which comparisons will best answer the questions motivating the analysis is one of the necessary steps in making the best use of accounting information. Financial ratios can help describe the financial condition of an organization, the efficiency of its activities, its comparable profitability...

Words: 951 - Pages: 4

Premium Essay

Financial Analysis

...FINANCIAL STATEMENT ANALYSIS: A TOOL FOR PERFORMANCE EVALUATION A Case Study of Oceanic Bank By IBRAHIM UMAR PGA/09/07766 M.Sc. Assignment Submitted to Dr. M.I. Kida CNA Department of Accountancy University of Maiduguri 2Financial Statement Analysis: A Tool for Performance Evaluation Jan. 2010 3Financial Statement Analysis: A Tool for Performance Evaluation ABSTRACT Financial statements are prepared to meet external reporting obligations and also for decision making purposes. They play a dominant role in setting the framework of managerial decisions. But the information provided in the financial statements is not an end in itself as no meaningful conclusions can be drawn from these statements alone. However, the information provided in the financial statements is of immense use in making decisions through analysis and interpretation of financial statements. There are various methods or techniques that are used in analyzing financial statements, such as comparative statements, schedule of changes in working capital, common size percentages, trend analysis and ratios analysis. This study intends to analyze financial statement of Oceanic bank in Nigeria in order to come up with an in-depth fact finding on its performance and to see if there is any connection between the recent global economic crisis and its overall performance. 4Financial Statement Analysis: A Tool for Performance Evaluation INTRODUCTION 1.1 Background Financial statement represents...

Words: 5278 - Pages: 22

Premium Essay

Financial Analysis

...What is the primary objective of financial statement analysis? The primary objective of financial statement analysis, according to the text, is to assist an investor or leader in determining the fundamental value of the firm. (Brigham & Ehrhardt, 2014) The analysis involves comparing a firm’s performance to that of other firms in the same industry, and also evaluating trends in the firm’s own financial position over time. 2. How are ratios used in financial statement analysis? Provide an example. Ratios are designed to extract important information that might not be obvious at a first glance over the firm’s financial statements. (Brigham & Ehrhardt, 2014) For example, one company may be $5 Million in debt while another is $50 Million in debt. It is impossible without further information to say which company is in a stronger financial position. This further information comes from standardizing each firm’s debt in relation to its assets, earnings, and interest. This standardization is done through ratio analysis. 3. Review the 3 basic financial statements, pretend you are an investor and you have $100,000 you must invest. You can only invest in 1 company, and you can only view one financial statement. Which statement would you choose to look at and why? I would ask to see the statement of cash flows if I could only view one financial statement, because I feel it would give the best view of the current state of the firm’s financial health. Since I can’t compare statements...

Words: 323 - Pages: 2

Premium Essay

Financial Analysis

...Financial Analysis – Week Five Final Assignment ACC 205 Principles of Accounting I July 4, 2000 Financial Analysis As an introduction, financial analysis provides an opportunity to make informed decisions about the health and viability of the company under review. The analysis can be done in several ways, but most commonly the business activities of a particular entity are compared internally from one year to the next. Similarly, the company is compared to an external but similar company in the same industry. Alternatively, one could also compare the activity of the company under review with that of an industry average of similar companies. The various financial analysis techniques used by accountants and analysts are all designed to provide the best possible estimate of financial viability of a company on a go forward basis. The company selected for this project is a publicly held healthcare corporation based in Boca Raton, Florida and named Cross Country Healthcare. As an overview, the company is comprised of three segments: contingent nurse and allied healthcare provider staffing, physician staffing, and other human capital management services, the latter of which provides education and training programs to the healthcare industry, as well as retained search services for physicians and healthcare executives in the United States. Competitors of Cross Country Healthcare would be companies similar to Staff Care, Maxim, Delta Staffing, Onyx MD, and others...

Words: 1702 - Pages: 7

Premium Essay

Financial Analysis

...named "BUSINESS FINANACE" course code 201.Business finance course helps us to develop a framework for decision making in the context of managerial finance and to provide a solid grounding in the principles and practice of financial management. All of the important and basic areas of finance is covered in this course. This course helps us to develop the skills to understand how managers access, understand, analyze, and utilize financial information for decision making. In this course financial ratio analysis is a very important term what helps us to find out the real condition of any company's. Here we are going to find out the financial ratios of GENERATION NEXT FASHIONS LTD from . We will use the time series to compare of GENERATION NEXT FASHIONS LTD's ratios. 1.2 Objectives of the project paper: The traditional financial statements that comprise of the balance sheet and profit and loss account do not give enough information related to financial operations of the company. These financial statements prepared as per the statutory requirement of law need to be analyzed in order to evaluate the past performance of the company and the future prospects. Our perspective to do this project paper are giving below: * To gather practical knowledge about ratio analysis. * How do the time series work to do the internal comparison? * What types of solution GENERATION NEXT FASHIONS LTD can take to improve its future condition. * We want to see the past and present condition...

Words: 3597 - Pages: 15

Premium Essay

Financial Analysis

...Financial Data Analysis Jesse Patacsil HCS 577 June 29, 2012 Financial Data Analysis Financial data analysis is the procedure for assessing budgets and other finance-related things to determine the sustainability of a business venture. A financial analysis is used to analyze whether a unit is constant, solvent, liquid, or profitable enough to be invested in by shareholders. When looking at a specific company, the financial analyst will often focus on the income statement, balance sheet, and statement of revenue and expenses statements. In addition, one key area of financial analysis involves comparing the company's past year performance into an estimate of the company's future performance.(Stock Analysis, 2912) On the Balance sheet the patient accounts receivable had a larger allowance for bad debts on the audited version. There was $1,000,000 more in the allowance for bad debts (or doubtful accounts) in the audited version of the financial statements (Patton-Fuller Community Hospital, 2009). This means that the hospital most likely will not collect on this patient accounts receivable and has classified it as a bad debt so it is estimated to result in a loss. The management uses historical data to estimate bad debt but new agreements with managed care payers required an adjustment to the expense and allowance during the audit (Patton-Fuller Community Hospital, 2009). This also decreases the total assets by $1,000,000 in the audited version of the balance sheet...

Words: 778 - Pages: 4

Premium Essay

Financial Analysis

...Cango Financial CanGo Financial Analysis Report The success of a business depends on its ability to remain profitable over the long term, while being able to pay all its financial obligations and earning above average returns for its shareholders. This is made possible if the business is able to maximize on available opportunities and very efficiently and effectively use the resources it has to create maximum value for all involved stakeholders. One way the performance of a company can be measured on critical areas such as profitability, its ability to stay solvent, the amount of debt exposure and the effectiveness in resource utilization, is performing financial analysis where a set of ratios provides a snapshot of company performance and future prospects. Financial analysis is also a very useful technique that forms a basis for making key decisions about company operations. In addition to internal company members, these ratios are used by potential investors and shareholders to make investment decisions about the company. The investment ratios can be broken down into 4 key areas, efficiency, financial leverage, liquidity and profitability. Starting with efficiency, we have the inventory turnover and receivables turnover ratios. The inventory turnover ratio indicates how many times the company is able to turnover its inventory. In CanGo’s case, the ratio value is low, meaning that it is not effectively turning over its inventory, which also means it isn’t quickly and effectively...

Words: 1092 - Pages: 5

Premium Essay

Financial Analysis

...Running head: FINANCIAL ANALYSIS OF TARGET & J.C. PENNY Financial Analysis of Target & J.C. Penny Linda S. Mosquera Columbia College University Abstract There are two companies which stand out as being optimal candidates for selling out to CB&M. I collected each company’s financial statements and analyzed five years’ worth of data provided via the company’s annual reports specifically pertaining to the balance sheet and the income statements. Interpreting a few specific financial ratios, I will provide an in-depth analysis in determining which of the two companies is healthier financially. Introduction Financial ratios are classified according to the information they provide. Some of the frequent used ratios are: liquidity ratios, P/E ratio and profitability ratios. I will provide an in-depth analysis in determining which of the two companies is healthier financially. Liquidity Ratios Target J. C. Penny J. C. Penny is a chain of mid-range department stores based out of Plano, Texas. It was started by James Cash Penney under the initial partnership with Thomas Callahan and Guy Johnson, who owned dry goods stores called Golden Rule (J.C. Penny). Penney took ownership of the store around 1907 when Callahan and Johnson dissolved their partnership. “It currently operates “approximately 1,100 stores and at jcpenney.com, customers will discover a broad assortment of national, private and exclusive brands to fit all shapes, sizes, colors and wallets”...

Words: 725 - Pages: 3