Analysis of Financial Statement by Using the Technique of Ratio Analysis

In: Business and Management

Submitted By samiul935
Words 15740
Pages 63
A PROJECT REPORT ON ―ANALYSIS OF FINANCIAL STATEMENT BY USING THE TECHNIQUE OF RATIO ANALYSIS” FOR ULTRA TECH CEMENT LTD AT KOVAYA, AMRELI, GUJARAT SUBMITTED TO TILAK MAHARASHTRA UNIVERSITY IN PARTIAL FULFILLMENT OF 2 YEARS FULL TIME COURSE MASTER OF BUSINESS ADMINISTRATION (MBA) Submitted By: FURKAN Y. KAMDAR (Batch 2008-10) Guided By: Prof.R.GANESHAN MAHARASHTRA COSMOPOLITAN EDUCATION SOCIETY’S PAI INTERNATIONAL CENTRE FOR MANAGEMENT EXCELLENCE CAMP PUNE-411001
1

Maharashtra Cosmopolitan Education Society’s PAI International Centre for Management Excellence

CERTIFICATE

This is to certify that FURKAN Y.KAMDAR student of PAI INTERNATIONAL CENTRE FOR MANAGEMENT EXCELLENCE, Maharashtra Cosmopolitan Education Society, Pune has completed his field work at ULTRA TECH CEMENT LTD on the topic of ―FINANCIAL STATEMENT ANALYSIS BY USING THE TECHNIQUE OF RATIO ANALYSIS”FOR ULTRA TECH CEMENT LTD and has submitted the field work report in partial fulfilment of 2 years full time course MASTER IN BUSINESS ADMINISTRATION of college for the academic year 2008-2009 He has worked under our guidance and direction. The said report is based on bonafide information.

Project Guide Name

Prof. R Ganesan

Designation

Director

Pai International Centre for Management Excellence Date: Place: Pune

2

PAI INTERNATIONAL CENTRE FOR MANAGEMENT EXCELLENCE Maharashtra Cosmopolitan Education Society

DECLARATION

I hereby declare that the project titled ―FINANCIAL STATEMENT ANALYSIS OF ULTRATECH CEMENT LTD.‖ is an original piece of research work carried out by me under the guidance and supervision of Prof.R.GANESAN. The information has been collected from genuine & authentic sources. The work has been submitted in partial fulfillment of the requirement of MASTER OF BUSINESS ADMINISTRATION (MBA).

Place: Pune Date: 26/02/2009

Signature: FURKAN KAMDAR

3…...

Similar Documents

Airtel- Financial Ratio Analysis

...FINANCIAL ANALYSIS FOR THE TELECOM SECTOR- A REPORT BY GROUP-4, SECTION-C AMAN SAHNI(4C) GAURAV SHARMA(16C) NEHA DEOLIYA(24C) PRATEEK GOEL(28C) SRIVATHSAN S.(43C) 1 INDEX 1. INDUSTRY OVERVIEW 2. COMPANY ANALYSIS 3.COMPETITIOR ANALYSIS 4. CONCLUSIONS 3 6 11 15 2 1. INDUSTRY OVERVIEW Introduction The telecommunication industry has been growing at a tremendous rate in India for the last few years. More than 18 million subscribers are added every month. Driven by various policy initiatives, the Indian telecom sector witnessed a complete transformation in the last decade. It has achieved a phenomenal growth during the last few years and is poised to take a big leap in the future. The telecom industry has been divided into two major segments, that is, fixed and wireless cellular services for this report. Besides, internet services, VAS, PMRTS and VSAT also have been discussed in brief in the report. In today’s information age, the telecommunication industry has a vital role to play. Considered as the backbone of industrial and economic development, the industry has been aiding delivery of voice and data services at rapidly increasing speeds, and thus, has been revolutionising human communication. Although the Indian telecom industry is one of the fastest-growing industries in the world, the current teledensity or telecom penetration is extremely low when compared with global standards. India’s teledensity of 36.98% in FY09 is amongst the lowest in the world.......

Words: 4878 - Pages: 20

Financial Statement Analysis

...CHAPTER 5—BASICS OF ANALYSIS MULTIPLE CHOICE 1. Statements in which all items are expressed only in relative terms (percentages of a base) are termed: a. vertical Statements. b. horizontal Statements. c. funds Statements. d. common-Size Statements. e. None of the answers are correct. \. 2. In financial statement analysis, ratios are: a. the only type of analysis where industry data are available. b. absolute numbers converted to a common base. c. fractions usually expressed in percent or times. d. the only indication of the financial position of the firm. e. None of the answers are correct. 3. Denver Dynamics has net income of $2,000,000. Oakland Enterprises has net income of $2,500,000. Which of the following best compares the profitability of Denver and Oakland? a. Oakland Enterprises is 25% more profitable than Denver Dynamics. b. Oakland Enterprises is more profitable than Denver Dynamics, but the comparison can't be quantified. c. Oakland Enterprises is only more profitable if it is smaller than Denver Dynamics. d. Further information is needed for a reasonable comparison. e. Oakland Enterprises is more profitable if it is a larger firm than Denver Dynamics. 4. Which of the following can offer a type of comparison in financial statement analysis? a. Past ratios and figures b. Industry averages c. Statistics of competitors d. All of the answers are correct. e. None of the answers are correct. 5. Which of the......

Words: 2598 - Pages: 11

Financial Ratio Analysis

...Objective: Ratio analysis expresses the relationship among selected items of financial statement data. A ratio expresses the mathematical relationship between one quantity and another. The relationship is expressed in terms of a percentage, a rate or a simple proportion. Ratios can provide clues to underlying that may not be apparent from individual financial statement component. However, a single ratio by itself is not very meaningful. For discussion making the companies use the following types of comparisons. a. Intra-company comparisons b. Industry average comparisons c. Intercompany comparisons Methodology: For our report we have collected the financial reports of the following companies (for the year 2009 and 2010): 1. Apex Tannery 2. Monno Ceramic 3. Bata Shoe 4. Meghna Cement & 5. Fu-wang Food We have calculated the following ratios for the each of the companies for both years: 1. Current ratio 2. Quick ratio 3. Inventory turnover ratio 4. Long term debt ratio 5. Debt to total asset ratio 6. Total asset turnover 7. Times interest earned ratio We have found the average value of each of the ratios for the organizations. We made intercompany comparison based on the average value of these ratios to identify the best and the worst company. In the end we tried to identify the reasons which caused the best and the worst companies to have those ratios. Description of the Ratios: ......

Words: 3169 - Pages: 13

Financial Ratio Analysis

...Financial Ratio Comparison of Tesco Plc and Sainsbury Plc Introduction Abraham Brilloff once said, “Financial statements are like a fine perfume-to be sniffed but not swallowed.” This means to make rational decisions in keeping with objectives of the firm by busing the financial statements (Helfert, 2003), it is important to critical and analytical sniff but to simply swallow the statistical information from the statements. Using what tools to get into the deep sight of financial statement and see the beautiful sight of the financial world is what the essay focuses about (Matsumoto, Melkote & James, 1995). This essay centers on demonstrating and understanding of the purpose of financial ratios analysis, applying a range of financial accounting ratios to analyze and interpret financial statements and trend analysis of financial statements, using these ratios to critically evaluate the comparable companies’ performance and critically propose constructive suggestion to the discussed companies. And this essay selects Tesco Plc and Sainsbury Plc as a set of basement to analyze financial ratios of the companies’ financial statements. Tesco Plc and J. Sainsbury Plc are the comparable companies. Tesco Plc, whose headquarters are in UK, is one of the world's largest retailers with operations in 14 countries. Tesco Plc operates not only store mainly offering food, general merchandise, clothing, and electrical products, but also finance service, such as retail banking, financial,......

Words: 2574 - Pages: 11

Financial Analysis: Financial Statement Ratios and Metrics

...Applied Managerial Finance Financial Analysis: Financial Statement Ratios and Metrics November 30, 2013 Financial Analysis: Financial Statement Ratios and Metrics Mary has asked me to provide a list of financial ratios that she needs explained and a computation of each for Apex Printing. She would also like to see a comparison of these ratios to other firms in the printing sector. I am going to provide an indication of how each of these ratios differ from Apex’s and whether or not the ratio is indicative of better performance by Apex (Task List, 2013). Financial ratios are used to look at how an organization performs and what kind of financial situation they may be in. Information that is provided in the financial statement is used to calculate these ratios. Ratios show trends and as comparisons to other organizations. They also have the capability to predict bankruptcy. There are several different types of ratios used according to the particular type of information they want to provide. These are liquidity, asset turnover, financial leverage, profitability and dividend policy ratios (NetMBA, n.d.). Explain and compute Current ratio of Apex Short-term financial obligations can be seen in the liquidity ratio. Short-term creditors use this information to determine whether or not to extend credit to an organization. Current ratio and the quick ratio are the most frequently used ratios in this area (NetMBA, n.d.). As one of the most popular ratios used to compute a......

Words: 1240 - Pages: 5

Financial Statement Analysis

...Report on | Financial Statement Analysis & Valuation of Monno Jute Stafllers | A report on “Financial Statement Analysis & Valuation of Monno Jute Stafllers ” Course Title: FINANCIAL STATEMENT ANALYSIS & VALUATION Course Code: F-401 Submitted To: Dr. Mahmood Osman Imam Professor Department of Finance, University of Dhaka Hussain Ahmed Enamul Huda Lecturer Department of Finance, University of Dhaka Submitted By: Sayma Khair 17-115 BBA 17th batch 4th year 1st semester Department of Finance, University of Dhaka Date of Submission: July22, 2014. Letter of Transmittal July 22, 2014 Mahmood Osman Imam Professor Department of Finance University of Dhaka Subject: Submission of term paper on Financial Statement Analysis & Valuation of Monno Jute Stafllers Dear sir, I am extremely gratified & enthusiastic to present a report on Financial Statement Analysis & Valuation Of Monno Jute Stafllers as per as a part of requirement of our BBA Program of Course “FINANCIAL STATEMENT ANALYSIS & VALUATION”, Course no: F-401 . This report was assigned to us with a view to scrutinizing our skill and flamboyance when it comes to financial statement analysis know-how. Moreover, the purpose of this term paper was to extract our inner ability & enhance our financial statement analysis & valuation related potentials. We acknowledge......

Words: 8567 - Pages: 35

Financial Ratio Analysis of Colgate

...Financial Reporting Analysis Ratio Analysis Of Colgate Palmolive (INDIA) Limited Submitted to: Dr. T. P. GHOSH Submitted by: Group I 1. Apurva Shahi 2. Deepali Agarwal 3. Konda Moulika 4. Mallipati Manoj 5. Mitali Pravin 6. Nidhi Agarwal Contents: 1. Abstract 2. Introduction and details of project 3. Colgate Palmolive( India) Limited Profile 4. Ratio Analysis of Colgate Palmolive( India) Limited I. Profitability Ratios II. Liquidity Ratios III. Solvency Ratios IV. Turn-Over Ratios V. Valuation Ratios 5. Conclusion Abstract: A financial statement is a collection of data organized according to logical and consistent accounting procedures. Its purpose is to convey an understanding of some financial aspect of a business firm. 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 decision. The present paper......

Words: 2554 - Pages: 11

Financial Statement Analysis and Ratios

...Scholars' Repository Honors Theses Student Scholarship Fall 2012 An Analysis of Fraud: Causes, Prevention, and Notable Cases Kristin A. Kennedy University of New Hampshire - Main Campus, kaj79@wildcats.unh.edu Follow this and additional works at: http://scholars.unh.edu/honors Part of the Accounting Commons Recommended Citation Kennedy, Kristin A., "An Analysis of Fraud: Causes, Prevention, and Notable Cases" (2012). Honors Theses. Paper 100. This Senior Honors Thesis is brought to you for free and open access by the Student Scholarship at University of New Hampshire Scholars' Repository. It has been accepted for inclusion in Honors Theses by an authorized administrator of University of New Hampshire Scholars' Repository. For more information, please contact scholarly.communication@unh.edu. An Analysis of Fraud: Causes, Prevention, and Notable Cases University of New Hampshire Honors Thesis in Accounting Kristin Kennedy ADMN 799 Professor Le (Emily) Xu Fall 2012 Table of Contents I. II. III. IV. V. VI. VII. Background……………………………………………………………........1 a. What is accounting and what role does financial reporting serve?..........1 b. History of accounting standards………………………………………..2 c. Role of auditing………………………………………………………...5 Fraud……………………………………………………………………….6 a. Two types of fraud……………………………………………………..6 i. Misappropriation of Assets…………………………………….7 ii. Misrepresentation of Financial Statements…………………….7 b. Fraud Triangle………………………………………………………….8 c. What to look......

Words: 14962 - Pages: 60

Financial Ratio Analysis

...2006, 2007 and 2008 to analyze the ratios, and conduct a DuPont analysis to find the competitive position and the level of performance of both the organizations in respect to the calculated ratios. In addition we have done index analysis of both balance sheet and income statement to find the position of the organizations in respect of profitability. The organizations are pharmaceutical companies. The reason behind calculating the ratios of different years of a company gives us a complete view about company’s gradual improvement or decline. The chosen company has gained significant popularity in the market of Bangladesh and has been running the business for a considerable period. The report consists of five types of ratio analysis which are as follows: 1. Liquidity Ratio 2. Financial Leverage Ratios 3. Interest Coverage Ratio 4. Activity ratios 5. Profitability Ratios Under these primary categories there are several other sub categories. I calculated those ratios and provided interpretation of the results and also evaluated the company’s position in terms of their results. Last but not the least we did the index analysis of the balance sheet and income statement. We found some problems in the financial activities of the company and provided recommendations based on that. 2. Introduction Ratio analysis is a numerical attempt to analyze the performance and financial position of a business. By converting absolute numbers into ratios, we can compare between one firm......

Words: 6669 - Pages: 27

Ratio and Financial Statement Analysis

...FINANCIAL DECISION MAKING FOR MANAGERS: Ratio And Financial Statement Analysis NAME: JAMES B. TAYLOR DATE: 04/09/2015 Table of Content I. Executive Summary.....................................................................................3 II. Introduction..................................................................................................4 III. Financial statements tools and techniques...................................................4 IV. Exhibits…………………………………………………………………...10 V. Analysis of Results.....................................................................................11 VI. Recommendations……………………………….......................................13 VII. Conclusions……………………………………………………………….13 VIII. References………………………………………………………………...14 Executive summary This paper is focused to assess financial health of a business firm. I have chosen one of the leading retail companies in the country (Higgins, 2011). This paper will carry out a financial analysis on Hamster Limited in order to have a comprehensive assessment about its financial health analysis. This paper will analyze and assess the financial environment in which the company operated. Through a comprehensive analysis, my objective is to understand the influence of financial factors in the firm and its decision making. I will evaluate different ratios to acknowledge their impact on Hamsters performance over the few years. I will identify, assess and......

Words: 2513 - Pages: 11

Financial Statement Analysis

...CHAPTER 5—BASICS OF ANALYSIS MULTIPLE CHOICE 1. Statements in which all items are expressed only in relative terms (percentages of a base) are termed: a.|Vertical Statements| b.|Horizontal Statements| c.|Funds Statements| d.|Common-Size Statements| e.|none of the answers are correct| ANS: D 2. In financial statement analysis, ratios are: a.|the only type of analysis where industry data are available| b.|absolute numbers converted to a common base| c.|fractions usually expressed in percent or times| d.|the only indication of the financial position of the firm| e.|none of the answers are correct| ANS: C 3. Denver Dynamics has net income of $2,000,000. Oakland Enterprises has net income of $2,500,000. Which of the following best compares the profitability of Denver and Oakland? a.|Oakland Enterprises is 25% more profitable than Denver Dynamics.| b.|Oakland Enterprises is more profitable than Denver Dynamics, but the comparison can't be quantified.| c.|Oakland Enterprises is only more profitable if it is smaller than Denver Dynamics.| d.|Further information is needed for a reasonable comparison.| e.|Oakland Enterprises is more profitable if it is a larger firm than Denver Dynamics.| ANS: D 4. Which of the following can offer a type of comparison in financial statement analysis? a.|past ratios and figures| b.|industry averages| c.|statistics of competitors| d.|all of the answers are correct| e.|none of the answers are......

Words: 2469 - Pages: 10

Financial Statement Analysis

...ANALYSIS OF FIANANCIAL STATEMENT MUSTEHKAM CEMENT LIMITED PRESENTED TO: TAHSEEN MOHSIN PRESENTED BY: MUHAMMAD USMAN GHANI 105221003 (03454657966) PREFACE This is the project of financial statement analysis in which we have to apply the financial technique to doo the financial analysis in deep by firm comparability, by ding credit analysis, making pro forma statements and showing reality in it, we were asked to do long term solvency analysis, profitability analysis and valuation in which we have to calculate expected return through DDM and CAPM model. We do the analysis of whole firm in detail on its financial data, calculate the whole ratios of business through which we can analyze in which position the business is running and what problems are faced by the firm and is the firm having any financial risk or in case of solvency measure the firm has through which it can pay its obligations. The project was full of problem because to apply the financial technique we need financial data have to find out which element have to put in that formula and first time I have visit the KSE site to collect the previous stock price of share which was learning point for me that which place how you have to collect data have to do interpretation. ...

Words: 2794 - Pages: 12

Financial Ratio Analysis

...2 FINANCIAL RATIO ANALYSIS: 2 Purposes and considerations of ratio analysis 2 PHARMACEUTICAL INDUSTRY IN PAKISTAN 3 FEROZSONS LABORATORIES LIMITED 4 LIQUIDITY ANALYSIS RATIOS 4 Current Ratio: 4 Quick Ratio 5 Working Capital: 6 Absolute Liquid Ratio: 8 SOLVENCY RATIOS (Capital Structure Analysis Ratios) 9 Debt Ratio 9 Debt to Equity Ratio 9 Interest Coverage Ratio 10 Equity Ratio 12 Assets to Equity Ratios 13 PROFITABILITY ANALYSIS RATIOS: 14 GENERAL PROFITABILITY: 14 Gross profit ratio/ margin: 15 Operating Expense Ratio: 16 Operating Profit Margin: 17 Net Profit Ratio: 18 OVERALL PROFITABILITY: 19 Earnings per Share (EPS): 19 Return on Equity (ROE): 20 Return on Assets (ROA): 21 Return on Capital Employed: 22 ACTIVITY ANALYSIS RATIOS 23 Operating Cycle 27 Assets Turnover Ratio 30 Working Capital Turnover Ratio 31 CAPITAL MARKET ANALYSIS RATIOS 32 Price earnings ratio(PE): 32 Dividend Yield Ratio 34 Market to Book Ratio 35 Dividend Payout Ratio 36 STATIC ANALYSIS: 37 REFERENCES: 44 INTRODUCTION TO THE PROJECT The project covers the trend analysis of Ferozsons, a pharmaceutical company in Pakistan, and the static analysis of the same with its major rival, Glaxo Smith Kline Pakistan Limited FINANCIAL RATIO ANALYSIS: The financial statements are essential but they are only the starting point for successful financial management. Financial Ratio Analysis is applied to Financial Statements to......

Words: 8084 - Pages: 33

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......

Words: 951 - Pages: 4

Financial Ratios and Analysis

...a.) Ratios are useful indicators of a firm's performance and financial situation. Most ratios can be calculated from information provided by the financial statements. Financial ratios can be used to analyze trends and to compare the firm's financials to those of other firms in the same industry. Managers use ratio analysis to identify situations needing attention; potential leaders use financial analysis to determine whether a company is creditworthy; and stockholders use ratio analysis to help predict future earnings, dividends, and free cash flow. b.) The 2011 current ratio is calculated by using the following formula: current assets/current liabilities= 2,680,112/1,039,800= 2.58:1 The 2011 quick ratio is calculated by using the following formula: current assets-inventories/current liabilities=2,680,112-1,716,480/1,039,800=.93:1 The higher the current ratio the better the company’s liquidity because it provides insight about a firm's ability to meet its short-term financial obligations; therefore after calculating the 2009, 2010, and projected 2011 current ratio using the current assets/current liabilities formula we find the following ratios: 2009: 1,124,000/481,600=2.33:1 2010: 1,946,802/1,328,960=1.46:1 projected 2011: 2,680,112/1,039,800=2.58:1 The projected 2011 balance sheet leads us to believe that the year 2011 will have more liquidity than in the previous 2 years. Ratios are very useful to managers, bankers and stockholders for various......

Words: 592 - Pages: 3