Premium Essay

Ratio and Balance Sheet Analysis

In:

Submitted By kamalsidhu
Words 7143
Pages 29
SUBMITTED BY:
Kamaljeet Kaur * BLR1208032003
Maria Jennifer * BLR1208032002

SUBMITTED ON:
24th Sep, 2012

BANGALORE MANAGEMENT ACADEMY BANGALORE
SESSION – 2012-13

TABLE OF CONTENTS SR.NO. | PARTICULARS | PAGENO. | 1. | ABSTRACT | 3 | 2. | LITERATURE REVIEW | 4-6 | 3. | INTRODUCTION | 7 | 4. | STATEMENT ANALYSIS | 8-9 | 5. | RATIO ANALYSIS * FINANCIAL RATIOS * PROFITABILITY RATIOS * TURNOVER RATIOS | 10-1112-1617-20 | 6. | TABLE OF RATIOS | 21 | 7. | CONCLUSION | 22 | 8. | REFERENCES | 23-24 | 9. | APPENDIX | 25-26 | 10. | WORKING NOTES | 27-30 | 11. | NOTES | 31 |

ABSTRACT
The title of our project is HCL infosystem ltd. The purpose of this assignment is to compare the financial position of HCL between two years 2010 and 2011 by calculating different ratios from a given balance sheet and make a comparative analysis between these two years by comparing with the ideal ratio. Ratio analysis provides us an overview of the company’s financial position in both short term and long term. The ratio analysis, comparative balance sheet and common size balance sheet are gives an accurate picture of company’s position. As financial ratio analysis is a useful technique to measure, compare, and evaluate the financial condition and performance of a company and by calculating these ratios it can help us to answer if the company is business profitable and if it is able to pay its bills and to find how the business is financed and also the company’s financial performance of 2011 compared to 2010. To summarize in short in this assignment we are going to study and calculate different ratios of HCL INFOSYSTEM LTD’s balance sheet and profit & loss account of 2010 and 2011 and make a comparative analysis of these two years and to conclude its overall financial performance in 2011 compared to 2010. These financial statements are

Similar Documents

Premium Essay

Term Paper

...ANALYSIS AND INTERPRETATION OF FINANCIAL STATEMENTS: CASE STUDIES THESIS SUBMITTED IN PARTIAL FULFILLMENT OF THE REQUIREMENTS FOR THE DEGREE OF Bachelor of Technology in Mining Engineering By SUDIP DAS Roll: 10605038 DEPARTMENT OF MINING ENGINEERING NATIONAL INSTITUTE OF TECHNOLOGY, ROURKELA 2010 ANALYSIS AND INTERPRETATION OF FINANCIAL STATEMENTS: CASE STUDIES THESIS SUBMITTED IN PARTIAL FULFILLMENT OF THE REQUIREMENTS FOR THE DEGREE OF Bachelor of Technology in Mining Engineering By SUDIP DAS Roll: 10605038 Under the guidance of Prof. D.P.TRIPATHY DEPARTMENT OF MINING ENGINEERING NATIONAL INSTITUTE OF TECHNOLOGY, ROURKELA 2010 National Institute of Technology Rourkela CERTIFICATE This is to certify that the thesis entitled “ANALYSIS AND INTERPRETATION FINANCIAL STATEMENTS: CASE STUDIES” submitted by Sri Sudip Das, Roll No: 10605038 in partial fulfillment of the requirements for the award of Bachelor of Technology degree in Mining Engineering at the National Institute of Technology, Rourkela (Deemed University) is an authentic work carried out by him under my supervision and guidance. To the best of my knowledge, the matter embodied in the thesis has not been submitted to any other University/Institute for the award of any Degree or Diploma. Date: (Prof. D.P. TRIPATHY) Dept. of Mining Engineering National Institute of Technology Rourkela-769008 ACKNOWLEDGEMENT I wish to express my deep sense of gratitude and indebtedness...

Words: 21095 - Pages: 85

Premium Essay

Case

...ANALYSIS AND INTERPRETATION OF FINANCIAL STATEMENTS: CASE STUDIES THESIS SUBMITTED IN PARTIAL FULFILLMENT OF THE REQUIREMENTS FOR THE DEGREE OF Bachelor of Technology in Mining Engineering By SUDIP DAS Roll: 10605038 DEPARTMENT OF MINING ENGINEERING NATIONAL INSTITUTE OF TECHNOLOGY, ROURKELA 2010 ANALYSIS AND INTERPRETATION OF FINANCIAL STATEMENTS: CASE STUDIES THESIS SUBMITTED IN PARTIAL FULFILLMENT OF THE REQUIREMENTS FOR THE DEGREE OF Bachelor of Technology in Mining Engineering By SUDIP DAS Roll: 10605038 Under the guidance of Prof. D.P.TRIPATHY DEPARTMENT OF MINING ENGINEERING NATIONAL INSTITUTE OF TECHNOLOGY, ROURKELA 2010 National Institute of Technology Rourkela CERTIFICATE This is to certify that the thesis entitled “ANALYSIS AND INTERPRETATION FINANCIAL STATEMENTS: CASE STUDIES” submitted by Sri Sudip Das, Roll No: 10605038 in partial fulfillment of the requirements for the award of Bachelor of Technology degree in Mining Engineering at the National Institute of Technology, Rourkela (Deemed University) is an authentic work carried out by him under my supervision and guidance. To the best of my knowledge, the matter embodied in the thesis has not been submitted to any other University/Institute for the award of any Degree or Diploma. Date: (Prof. D.P. TRIPATHY) Dept. of Mining Engineering National Institute of Technology Rourkela-769008 ACKNOWLEDGEMENT I wish to express my deep sense of gratitude and indebtedness to Dr. D.P.Tripathy, Department of...

Words: 21095 - Pages: 85

Premium Essay

Presentation on Financial Accounting

...Presentation On Analysis of Financial Statements. Prepared By: Md. Nazmul Hasan. Analysis of Financial Statements What is Financial Statement Analysis: Financial Statements Analysis is an Analysis of the Following Statements: Income Statement Balance Sheet Statement of Owners Equity and Statement of Cash Flow Purpose of Analysis Financial statement analysis helps users make better decisions. Internal Users Managers Officers External Users Shareholders Lenders Customers Financial Statements Are Designed for Analysis Classified Financial Statements Items with certain characteristics are grouped together. Comparative Financial Statements Amounts from several years appear side by side. Consolidated Financial Statements Information for the parent and subsidiary are presented. Results in standardized, meaningful subtotals. Helps identify significant changes and trends. Presented as if the two companies are a single business unit. Tools of Analysis: Dollar & Percentage Changes Component Percentages Trend Percentages Ratios Dollar and Percentage Changes or Horizontal Analysis Dollar Change: Dollar Change = Analysis Period Amount – Base Period Amount Percentage Change: % Percent Change = Dollar Change ÷ Base Period Amount Dollar and Percentage Changes or Horizontal Analysis ABC, Inc. Comparative Balance Sheets December 31, 2005 Assets Current assets: Cash and equivalents Accounts receivable...

Words: 1318 - Pages: 6

Premium Essay

Tata Steel Finace Statement

... 2009 FINANCIAL RATIO ANALYSIS ABHIJIT SAMANTA I N T E R N A T I O N A L S C H O O L O F B U S I N E S S & M E D I A ; K O L K A T A P a g e | 2 FINANCIAL RATIO ANALYSIS OF TATA STEEL 1. Liquidity Ratios:- Liquidity Ratios measures the ability of the firm to meet its short term obligations. They also reflect the firm’s ability to meet financial contingencies that might arise. (A) Current Ratio: - This ratio indicates the firm’s ability to meet its current liabilities. This ratio is of very high importance to the suppliers of short term funds like the bankers and trade creditors. It is measured by: - Current Ratio = Current Assets / Current Liabilities. As per Balance Sheet 31st March 2008 & 2009. (All figures are in crore.) Year Current Asset Current Liabilities Current Ratio 2008 3,613.70 3,855.26 0.94 2009 5,707.05 6,039.86 0.94 Analysis: - The industry norm value of current ratio is 2:1. However it does not mean so that higher current ratio means good company profile. It may signify higher unused cash, inventory which again may result in inventory carrying cost. In both the years the Current ratio for Tata Steel is same. However it does not mean any increase or decrease in current ratio of any company gives the growth profile of the company. P a g e | 3 (B) Quick Ratio:- This ratio is calculated on pre assumption that all the current assets...

Words: 2161 - Pages: 9

Premium Essay

Matsushita Case

...A REPORT ON BALANCE SHEET ANALYSIS OF LANKA BANGLA FINANCE LIMITED AND INTERNATIONAL FINANCE INVESTMENT AND COMMERCE BANK LIMITED Date of submission: 8th November 2015 Submitted to Farzana Lalarukh Associate Professor Department of Finance University of Dhaka Submitted by SL | Name | BBA ID | Remarks | 1 | Sifat sadia | 17-003 | | 2 | Barna Paul | 17-047 | | 3 | Maghla Hossain | 17-061 | | 4 | Saima Sultana | 17-069 | | 5 | Nawsina Arif | 17-085 | | Date of Submission: 8th November 2015 Department of Finance University of Dhaka Letter of Transmittal November 8, 2015 Farzana Lalarukh Associate Professor Department of Finance University of Dhaka Subject: Submission of Report on “Balance Sheet Analysis of LankaBangla Finance Limited and International Finance Investment and Commerce Bank Limited”. Dear Madam, It gives us enormous pleasure to submit the report on Balance Sheet Analysis of Bank and NBFI as per the Advisor’s instruction. We expect this report to be informative as well as comprehensive as per requirement. Working with such a topic was an inspiring experience for us. We believe that the knowledge and the experience we gathered will facilitate us a lot in our future career life. With our limited knowledge, we have tried our level best to prepare the report worthwhile. Your acceptance and appreciation would surely inspire us. For any further explanations about the report, we will be gladly available to clarify the ins and outs. Sincerely, Sifat Sadia...

Words: 5474 - Pages: 22

Premium Essay

Lease

...Convert WRDS OUTPUT Building a Financial Statement Analysis and Valuation Spreadsheet Income Statement-66 This case starts with raw financial statements and then a) develops standardized financial statements, b) constructs a statement of cash flows, c) builds all the key ratios, d) links forecast inputs to future financial statements, and e) builds discounted cash flow and residual income valuation models based on the forecasts. The result is a simplified version of eVal4, the spreadsheet model that is provided with “Equity Valuation and Analysis” by Russell Lundholm and Richard Sloan, but one that you should completely understand (because you built it yourself!). To save you some time, many of the cells are completed; you only need to finish the blue-shaded ones. There are five parts to this case, corresponding to the five tasks listed above. The case requires two files: Building eVal4.xls and General Mills 10-K.pdf. Part A: Standardized Financial Statements The financial statements filed with the SEC are not standardized, meaning that the company is free to report and label line items however they please (within obvious limits). For this reason, there is an intermediary business that takes the filed financial statements and sorts the line items into a predetermined set of accounts. We will explore this important part of the reporting process in this part of the case. 1) Find the “as reported” financial statements in General Mills’s 10-K filing (in the...

Words: 957 - Pages: 4

Premium Essay

Intro to Computers

...Financial Analysis Phillips 66 Toccara Smalls Atlanta intercontinental university BUSN 125- Business Math September 3, 2015 Abstract This paper is an analysis of the financial statement of Phillips 66. The researcher will present horizontal and vertical analysis of the income statement and balance sheet among other things. Introduction This paper presents an analysis of Phillips 66 financial statement. Specifically discussed in this document will be the following: Preparation of Financial Statement, Business Problem Solving, Recovery Methods, Indebtedness, Horizontal Analysis, Vertical Analysis, and Ratios and Percentages. The document will conclude with a summary of this discussion. Preparation of Financial Statement Financial statements will give you a clear and accurate visual of how your business is currently performing, so you have a means of monitoring its progress and identifying opportunities for growth. The type of financial statement that lays out the basis for a fortune 500 company like Phillips 66 include a thrall preparation of the balance sheet, income statement, statement of retained earnings, and statement of cash flows; which are the most important steps in the accounting cycle because it represents the purpose of financial accounting statement (Brook, 2013). Ideally the financial statements are prepared by transferring the account balances on the adjusted trial balance to a set of financial statement templates in order to establish a logistical...

Words: 1188 - Pages: 5

Premium Essay

How Financial Assessments Help Organizations

...How Financial Assessments Help Organizations Managerial Analysis Abstract Financial assessment provides management with the ability to make critical business decisions for their organization; this involves examining existing data to gain insight on the current and future condition of their organization through the balance sheet, income statement. In the book, What Every Manager Should Know about Financial Analysis, Alan Donahue states “The inability to understand and deal with financial data is a severe handicap in the corporate world”, which seems fitting to mention as I discuss in this paper the significance in doing a financial assessment and some of the necessary tools that are needed in order to do a financial assessment. Basic Concept of Financial Analysis for Organizations and its Importance Financial analysis is an assessment of an organization that will determine the organization’s risk and profitability through reported financial information; the two main sources for retrieving such information are the balance sheet and income statement. The balance sheet also provides a wealth of information that enables the organization to determine its stability, vitality, and profitability through utilizing ratios. Ratios can determine the overall performance of the company through such things called liquidity, leverage and profitability. Balance Sheet The balance sheet outlines the the financial and physical resources that a company has avaliable...

Words: 1008 - Pages: 5

Premium Essay

Essay

...Contents Introduction 1  Balance sheet  Income statement Describe two principle financial statements their users, format, frequency and content 2  Financial accounting  Management accounting Compare & contrast financial accounting and management accounting 3 Describe the relevance ,application and limitations of financial ratio analysis with reference to three types of users of financial statement 4 Conclusion 5 1. Introduction. -Finance is one of the most significant elements in order to succeed in business performance. Managers are able to decide ways how they will proceed their business and what extent they will broaden or minimize the scale of their business through various figures of finance. Also, those of things help shareholders to predict organisation's promising. Accounting is a basic tool in figuring out how entity spend asset and how they make a profit or how loss happens. Some specialists such as managers, shareholder, accountants use these information. In accounting, there are some methods of analysing how healthy company's financial statement is. Some types of useful ways will be introduced on this essay and will be explained why accounting and finance is a crucial factors of business. 2 .Describe two principle financial statements(their users ,format, frequency and content)  Balance sheet : it is a summary of the financial position of the business. It mainly consists of three factors which are assets, liabilities...

Words: 1706 - Pages: 7

Premium Essay

Financial Analysis Intro

...transcript of the video presentation for this topic. More downloads and videos are available at http://www.kgaction.com/financial-statement-analysis The  Kaplan  Group   Commercial Collection Agency
 Superior Results Since 1991! www.kgaction.com! 805-541-2639   More Videos and downloads at © The Kaplan Group! http://www.kgaction.com/financial-statement-analysis © The Kaplan Group! The  Kaplan  Group   | Introduction to The Income Statement Hi. This is Dean Kaplan. The Kaplan Group is a commercial collection agency specializing in debt collection of large business to business claims. CREDIT MANAGER SEMINARS This video series introducing you to financial statement analysis is based on the dozens of training seminars I have given to credit industry groups organized by Dun & Bradstreet, the National Association of Credit Management and Riemer Reporting Services. It is applicable to anyone wanting to learn about this topic, although on occasion I will highlight information from the perspective of credit management. 3 FINANCIAL STATEMENTS Cash Flow Statement For the Year Ended December 31, 2011 (000s) Cash Flows From Operating Activities Net Income 397 Depreciation and amortization 318 Unrealized gain on marketable securities Decrease (increase) in deferred taxes (12) Balance Sheet (44) As of December 31, 2011 (000s) Net increase (decrease) in receivables, inventories, prepaids, payables Total Cash Flows...

Words: 11649 - Pages: 47

Premium Essay

Financial Analysis

...Student Number: 10314497 Course Title: MBA (Finance Stream) Lecturer Name: Enda Murphy Module/Subject Code: B9AC106 Module/Subject Title: Financial Analysis Assignment Title: Analysis of Financial Statements No of Words: 3418 (Excluding Citation, Bibliography, Table of Content and Charts) Date of Submission: 12 November, 2015 Table of Content Introduction..............................................................................................................................3 Ratio Analysis of Tata Motors..................................................................................................5 Profitability Ratio.....................................................................................................................5 Gross Profit Margin..................................................................................................................6 Net Profit Margin/Profit for the year (after tax).......................................................................7 Profit before Tax (PBT) Margin................................................................................................8 Return on Equity.......................................................................................................................9 Efficiency Ratio.........................................................................................................................9 Average Receivable Collection Days....................

Words: 4725 - Pages: 19

Premium Essay

Ratio Analysis

...Ratio analysis is a means of making an analysis of a company’s financial statements. There are many different ways to go about this analysis that take into account different factors such as year to year, company to company and also the economies effect on the company. Different kinds of analyses are profitability ratios, liquidity ratios, solvency ratios, measures of managerial effectiveness, and stock market ratios. The most important of the ratios would have to be the profitability ratios. This ratio shows how profitable a company is. This is very helpful information from the stakeholders to the stockholders. Some examples in how these rations are used in the daily decision making process at different companies is they can show one year to a past year and then the company can take into account some other factors such as sales, employees, or even different times of the year to see how the numbers went up or went down. These analyses can also compare two companies that sell the same or almost the same kind of products and tell the company doing the analysis if there are any ways to improve or streamline some of their business practices to make more profit. Liquidity ratios tell a company how capable they are to pay off debts and how fast they can pay back creditors. Profitability ratios tell a company how much of a profit they are taking to the bank. Solvency ratios tell a company shows debts and investments that a company has. The limitations of ratio analysis are that the...

Words: 520 - Pages: 3

Premium Essay

Accounts Tbs

...Financial Statement Analysis Horizontal analysis Vertical analysis Ratio Analysis DuPont Equation Effects of Improving Ratios Limitations of Ratio Analysis Qualitative Factors Comparative Balance Sheet: Vertical Analysis Comparative Balance Sheet: Vertical Analysis Income Statement: Vertical Analysis Comparative Balance Sheet: Horizontal Analysis Comparative Balance Sheet: Horizontal Analysis Income Statement :Horizontal Analysis Balance Sheet: Assets Cash A/R Inventories Total CA Gross FA Less: Deprec. Net FA Total Assets 2012E 85,632 878,000 1,716,480 2,680,112 1,197,160 380,120 817,040 3,497,152 2011 7,282 632,160 1,287,360 1,926,802 1,202,950 263,160 939,790 2,866,592 Balance Sheet: Liabilities and Equity Accts payable Notes payable Accruals Total CL Long-term debt Common stock Retained earnings Total Equity Total L & E 2012E 436,800 300,000 408,000 1,144,800 400,000 1,721,176 231,176 1,952,352 3,497,152 2011 524,160 636,808 489,600 1,650,568 723,432 460,000 32,592 492,592 2,866,592 Income Statement Sales COGS Other expenses EBITDA Deprec. & amort. EBIT Interest exp. EBT Taxes Net income 2012E 7,035,600 5,875,992 550,000 609,608 116,960 492,648 70,008 422,640 169,056 253,584 2011 6,034,000 5,528,000 519,988 (13,988) 116,960 (130,948) 136,012 (266,960) (106,784) (160,176) Other Data No. of shares EPS DPS Stock price Lease pmts 2012E 250,000 $1.014 $0.220 $12.17 $40,000 2011 100,000 -$1.602 $0.110 $2.25 $40,000 Why are ratios useful? Ratios standardize numbers...

Words: 1649 - Pages: 7

Premium Essay

Financial Analysis

...Introduction Financial analysis is the analysis of the financial statements of same company for two or more years or two or more companies for same year. Financial analysis gives the flawless picture of the performance factors of the company and also helps in evaluating and comparing the present as well as past performance of the company. Financial analysis is done with the help of ratio analysis, common size analysis, and comparative analysis. About Company Starbucks is an American global coffeehouse chain and coffee company based in Washington. It is the largest coffeehouse company in worldwide with 20891 stores in 62 countries with highest in the united Sates. The items which are served in Starbucks menu are cold and hot beverages, micro ground instant coffee, whole bean coffee, full-leaf teas, snacks and pastries with a quality which is preferred by all. The first store of Starbucks was opened on March 30, 1971 by three partners Jerry Baldwin, Zev Siegl and Gordon Bowker. Ratio Analysis Ratio Analysis is considered as the significant instrument of the financial analysis. The main purpose of ratio analysis is to develop a meaningful connection between the specific items in the income account or balance sheet. The users consist of investors, managers, investors, long-term creditors and short-term creditors. The managers are interested in knowing the asset utilization and profitability of the company because their promotions and bonus are dependent on the efficiency...

Words: 1291 - Pages: 6

Premium Essay

Analyzing a Business Environment

...Business Analysis 11 By Gloria Rodriguez MTG/521 December 5, 2011 Analyzing a business environment like Chevron’s is important, so that investors can determine if Chevron is a company one can invest in. Researching a company’s business environment is helpful to further secure business decisions. Careful consideration must be taken, and a closer review of historical financial statements is suggested to determine the company’s financial health. One way to determine a company’s health is by reviewing a company’s business environment, analyzing a company’s income statement, balance sheet, and statement of cash flows. Chevron is known to be one of the top profitable Fortune 500 Company. A recent SWOT analysis was completed determining Chevron as good company to invest in. Although, Chevrons SWOT was determined successful the mutual fund manager has to determine if the company is also successful in his or her their finances. There are five areas in a company’s business environment. The five areas of a business environment are economic, technical, competitive, social, and global business. Nickels, McHugh, and McHugh (2010) “Business environment consists of the surrounding factors that either help or hinder the development of businesses.” Businesses surrounded by a stable business environment can function successfully. Businesses that focus on their business environment closely can to make changes accordingly. Nickels, McHugh, and McHugh (2010) “Businesses normally can’t control;...

Words: 1956 - Pages: 8