Free Essay

Ratio Analysis

In:

Submitted By jmbishop
Words 2256
Pages 10
Tanglewood Stores - Case 2 This print version free essay Tanglewood Stores - Case 2.

Category: Business

Autor: reviewessays 18 July 2010

Words: 6001 | Pages: 25

Tanglewood stores

Case two

Conduct an analysis of Tanglewood's staffing data and determine if their current staffing practices are sufficient to meet their ongoing needs, or if there will be problems in adequately staffing the organization in the near future.

Recommend how Tanglewood should design its overall staffing mission and strategy based on their upcoming needs.

Calculate representation statistics for various jobs within a single Tanglewood department store to determine where the most critical problems exist.

Recommend what you would do in light of the information you obtain in the calculation of various demographic statistics both for this specific store and for the chain as a whole.

Specific Assignment Details

For the store manager group, you will analyze the information and prepare a report showing the results of the Markov analysis and the EEO investigation. The Director asked you to address these questions in your written report:

1. Currently the organization expects that their forecast for labor requirements is essentially constant from the previous year. Based on this assumption complete the five stages of the planning process:

a. Currently the organization expects that their forecast for labor requirements is essentially constant from the previous year. This means the forecast for next year will be taken as given.

b. Fill in the empty cells in the forecast of labor availabilities in Table 1.1.

c. Conduct an environmental scan. Based on the environmental data, what factors in the environment suggest Tanglewood might have difficulty filling their vacancies in the future?

d. Compute year end totals for each job in Table 1.1 and do a gap analysis to determine where shortages will occur in the next year.

e. Develop a preliminary statement of the action plan for hiring for Washington next year. This should be an overview of the number of individuals needed to meet projected staffing levels for various positions that can be given to store managers. Make sure that your recommendations take the strategic staffing levels issues from the introductory case into account.

2. Examine the percentages of employee representation across demographic categories for Tanglewood and the available labor market for Table 1.3. Are there any particular classes or jobs where the representation within Tanglewood appears to be out of line with the available workforce? What does the pattern suggest to you?

3. Based on your analysis and the affirmative action plan, do you think the company should engage in a specific strategy to change their recruiting and promotion practices? Do you think it is realistic for the company to try to meet their affirmative action goals in this process in a single year? What are the pros and cons of using internal promotions vs. external hiring to rectify the problems with gender and ethnicity representation in supervisory positions?

4. In addition to the specific targets for employee representation for the Spokane flagship location, Tanglewood wants to use this opportunity to establish estimates for the entire chain's staffing policy regarding demographic representation of the workforce. How do you think individual stores can respond to overarching organizational objectives? Prepare a memo to be disseminated to the individual stores that gives a sense of your targets for the organization as a whole, and also gives the stores advice on how they can assist in narrowing any representation gaps you find through their recruiting, hiring, and promotion practices.

Case Analysis

Human resource planning

1. Determining future human resource requirements

Future HR requirements represent the number and types of employees that the organization will need in the future to produce its goods and services. The requirements represent the organizations desired work force of the future. Statistical techniques like Ratio analysis and regression analysis are generally used to forecast HR requirements. In this case study the estimates for coming year's labor requirement is identical to the current year because of stability of the store. Therefore they need 1200 individuals to work as shift leaders, 850 individuals as department manager, 150 individuals as Assistant store manager, 50 individuals as store manager for the coming year.

2. Determining future human resource availabilities

Availability projections focus on the organization's current internal workforce. Their concern is with estimating the numbers and types of current employees that will be available in the future. More specifically, these estimates are concerned with the loss or exit of employees from the organization, the resulting distribution of employees who remain within the organization's internal labor market and the number of accessions during the planning time frame.

Markov Analysis to Forecast Availabilities

| | | |current year | | | | |

|Transition probability | |1 |2 |3 |4 |5 |Exit |

|Matrix | | | | | | | |

| | | | | | | | |

|Store associate | |0.43 |0.06 |0 |0 |0 |0.51 |

|Shift leader | |0 |0.54 |0.16 |0 |0 |0.3 |

|Department manager | |0 |0 |0.64 |0.06 |0 |0.3 |

|Assistant store manager | |0 |0 |0.06 |0.52 |0.08 |0.34 |

|Store manager | |0 |0 |0 |0 |0.66 |0.34 |

| | | |Next year | | | | |

| | | |(projected) | | | | |

|Forecast Availabilities |Current work |1 |2 |3 |4 |5 |Exit |

| |force | | | | | | |

|Store associate |8500 |3655 |510 |0 |0 |0 |4335 |

|Shift leader |1200 |0 |648 |192 |0 |0 |360 |

|Department manager |850 |0 |0 |544 |51 |0 |255 |

|Assistant store manager |150 |0 |0 |9 |78 |12 |51 |

|Store manager |50 |0 |0 |0 |0 |33 |17 |

| | |3655 |1158 |745 |129 |45 | |

By referring to these figures, and the remainder of the transition probabilities in the matrix, an organization can begin to understand the workings of the unit's internal labor market. Tangelwood has used internal promotions to fill many openings for the department managers, assistant store managers and store managers. 16% of shift leaders will be promoted to the rank of department manager, 6% of department managers will be promoted to assistant store manager and 8% of assistant store manager will be promoted as store manager. The above table clearly indicates the labor forecast. To estimate the labor forecast the proportion of individuals for the next year is multiplied by the current work force.

Vacancy Analysis

|Job category and level |Current work force |Requirements |Availabilities |Reconciliation and gaps |

|Store associate |8500 |8500 |3655 |-4845 (shortage) |

|Shift leader |1200 |1200 |1158 |-42 (shortage) |

|Department manager |850 |850 | | |

| | | |745 |-105(shortage) |

|Assistant store manager |150 |150 | | |

| | | |129 |-21 (shortage) |

|Store manager |50 |50 |45 |-5 (shortage) |

| |10750 |10750 |5732 |-5018(shortage) |

The reconciliation and gaps shows the number of vacancy position in tanglewood store.

3. Conducting external and internal environmental scanning

External scanning is applied to the process of tracking trends and developments in the outside world, documenting their implications for the management of human resources, and ensuring that these implications receive attention in the HRP process. The environment for staffing managerial employees in Tanglewood store is complex. The organization must plan to put considerable time and money into attracting and retaining the needed talent or into developing alternative means of accomplishing its business plan. Planners must be out and about in their organizations, taking advantage of opportunities to learn what is going on.

Informal discussions with key managers can help, as can employee attitude surveys, special surveys, and the monitoring of key indictors such as employee performance, absenteeism, and turnover. Internally, tanglewood has relied on its experienced employees as a major source of talent. This internal staffing strategy has seen as a real strength , because the possibility of being promoted is believed to increase retention of lower level employees.

4. Reconciling requirements and availabilities - that is determining gaps

The reconciliation and gap determination process represents the results of bringing together requirements and availability forecasts with the results of external and internal environmental scanning. Gap figures must be decided on and entered into the column, and the likely reasons for the gaps need to be identified. A relatively large shortage is projected for store associate due to a mild expansion in requirements coupled with a substantial drop in availabilities. This is mainly because of excessive exit rate. The current focus of staffing is to fill the vacant positions. During the planning phase target are set for the number of individuals who need to be hired. The calculation of gap is done in the following table.

|Job category and level|Current work |Requirements |Availabilities |Reconciliation and gaps |Action Planning |

| |force | | | | |

|Store associate |8500 |8500 |3655 |-4845 (shortage) |Staffing activities |

|Shift leader |1200 |1200 |1158 |-42 (shortage) | |

|Department manager |850 |850 | | |Recruitment |

| | | |745 |-105(shortage) |Selection |

| | | | | |Employment |

|Assistant store |150 |150 | | |Other HR activities |

|manager | | |129 |-21 (shortage) | |

|Store manager |50 |50 |45 |-5 (shortage) |Compensation |

| | | | | |Training and |

| | | | | |development |

| |10750 |10750 |5732 |-5018(shortage) | |

5. Developing action plans to close the projected gaps

Action planning involves four basic sequential steps: set objectives, generate alternative activities, assess alternative activities, and choose alternative activities. Movement through these steps is a logical outgrowth of HRP and is greatly enhanced by its occurrence.

Staffing objective:

Quantitative targets should be expressed in head count for each job category/level and will be very close in magnitude to the identified gaps. A forecast shortage of 4845 employees as store associates, should be transformed into a staffing objective of 4845 accessions to be achieved by the end of the forecasting time interval.

For external staffing objectives, these may be stated in terms of averages, such as average educational level for new hires and average scores on ability testes. Ideally, the tanglewood stores have conducted job analysis and have available formal job specifications that it can use to guide it in establishing qualitative objectives. The gaps can be filled by means of new hires, promotions, transfers, demotions etc.

Generating alternative staffing activities:

Both short and long term options for shortages involving a combination of staffing and workload management is possible. Short term options include better utilization of current employees, acquiring additional employees on a short term basis (Seasonal employees). Long term options include staffing up with additional employees ( recall former employees, transfer in employees from other departments, new permanent hires), skill enhancement .

Assessing and choosing alternatives:

The goal of such assessment is to identify one or more preferred activities. A preferred activity is one offering the highest likelihood of attaining the staffing objective, within the time limit established, at the least cost and with the fewest negative side effects. For the past several years, tanglewood store have been confronted with a set of favorable economic condition which has led to substantial job expansion, low unemployment, and high employee turnover. The result has been persistent employee shortages and constant understaffing relative to workload needs. At the higher level core workforce should be used and the flexible work force can be used at the entry level.

Employee representation across demographic categories:

The problem of selection planning is made considerably more complex because of Equal Employment opportunity requirements that fall on organizations that do business with the federal government. When the proportion of protected classes being hired or currently employed falls below the proportion in the labor market, may indicate intentional or unintentional discrimination in hiring and promotion. The store associates and shift leaders are considered as the retail sales person in the study. The ethnicity is analysed by means of census report 2000.

According to EEO Residence Data Results for Spokane, WA MSA , census-2000

Total retail sales person in that area is reported to be 6495 of which 3040 are male and 3449 are female employees. Majority of retail sales person are from White non Hispanic community. 92.1% are white non Hispanic, 2.4% Hispanic, 1.4% Asian Non Hispanic, and 1.1% Black Hispanic community. The employee representation was restricted to store associates, shift leaders and department manager. Assistant store manager and store managers were not taken for the study.

Developing Affirmative Action Plan:

Affirmative action plans are an extension and application of general HR and staffing planning. AAPs have three basic components, namely, utilization analysis, staffing goals and timetables, and action plans. Revised order no.4, which applies to federal contractors, specifies requirements fir each of these three components. Diversity programs are organizational initiatives to help effectively manage a diverse work force. Such programs have the potential for successfully working in tandem with AAPs by contributing to the attraction and retention of AAP targeted people. Tanglewood internal staffing policy as recently articulated from central management is to retain current representation and current work force. The primary goal for this year is to focus on gender representation. The tanglewood store will want to establish a goal of moving their demographic representation in line with the available work force. Utilization analysis is critical in an AAP because through it are derived the numerical standards ie. Available percentage for women and minorities against which the organizations representation is evaluated. Comparing incumbency to availability and annual placement goals indicates that the number is determined on the basis of the eight factors contained in Revised order no. 4. The factors for women are similar to the minorities.

Legality of AAPs

1. The plan should have as its purpose the remedying of specific and identifiable effects of past discrimination

2. There should be definite underutilization of women or minorities currently in the organization

3. Regarding non minority and male employees, the plan should not unsettle their legitimate expectations

4. The plan should be temporary, and eliminated once affirmative action goals have been achieved

5. All candidates for positions should be qualified for those positions

6. The plan should include organizational enforcement mechanisms, as well as a grievance procedure.

Similar Documents

Premium Essay

Ratio Analysis

...Ratio Analysis Memo Principles of Accounting II ACC/291 Ratio Analysis Memo For the first ratio of solvency debt to total assets one must take the total debt Kroger owns 20,440.7 and divide it by the total assets 24,651.5. Once this is done Kroger has a debt to total assets ratio of .83, which means that 83% of Kroger's assets are financed by creditors. This is a not a good debt to assets ratio because Kroger only owns 17% of its assets out right. Kroger has a high debt to asset ratio which can be negative, but could also be less expensive then obtaining funds with equity. Carrying a high debt to assets ratio comes with risk, because the company must pay on its obligations or risk creditors seizing assets. Companies with low debt to assets ratios tend to have many shareholders that they must share profits with. The key to running a quality company is balancing that with assets to build a balanced financial backing planned for future acquisitions. Kroger's times interest earned calculation is done by taking the net income 1,496.5 plus interest expense -462 plus tax expense 793.8 which gives 1827.8 for a total. Then after this calculation is done one must divide it by the interest expense 462 which gives 3.9 for a times interest earned. The times interest earned ratio shows Kroger's ability to pay interest payments on loans when they come due. Kroger's 3.9 times interest earned ratio shows that Kroger can pay its interest 3.9 times with its income. This high number helps...

Words: 328 - Pages: 2

Premium Essay

Ratio Analysis

...A Report on Ratio Analysis of BRAC Bank 1.0 Introduction 1.1 Origin of the Report To be an efficient business executive, a student of business study must have practical knowledge about the financial activities of any business organization. Financial Management (FIN 301) course is giving the theoretical knowledge of financial management activities but only theoretical knowledge cannot make students efficient. Ms. Nasreen Sultana, course instructor for this course gave an assignment on 28 November, to write a business report on ratio analysis of BRAC bank as a part of the study of this course. 1.2 Purpose of the Report Purpose of the report is to know financial performance of BRAC bank. This report will help to gather knowledge about financial performance of the bank and the improvement and decline in performance compared to the previous year. 1.3 Scope of the Report This report has been prepared only covering financial area of the bank with giving emphasize on ratio analysis taking data from annual report of the bank. 1.4 Methodology: For preparing this report, information has been mainly collected from the annual report of the BRAC bank and the bank's website. The various ratio analysis are used in the report, which were collected from the annual reports, and financial statements and the ratios that are not found in the annual report directly are calculated from the information provided in the annual reports. Ten ratios have been selected to judge the various...

Words: 2709 - Pages: 11

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

Ratio Analysis

...Liquidity ratios Liquidity ratios measure the ability of a company to repay its short-term debts and meet unexpected cash needs. Current ratio. The current ratio is also called the working capital ratio, as working capital is the difference between current assets and current liabilities. This ratio measures the ability of a company to pay its current obligations using current assets. The current ratio is calculated by dividing current assets by current liabilities. 20X1 20X0 Current assets $38,366 $38,294 Current liabilities 27,945 30,347 Current ratio 1.4 : 1 1.3 : 1 This ratio indicates the company has more current assets than current liabilities. Different industries have different levels of expected liquidity. Whether the ratio is considered adequate coverage depends on the type of business, the components of its current assets, and the ability of the company to generate cash from its receivables and by selling inventory. Acid-test ratio. The acid-test ratio is also called the quick ratio. Quick assets are defined as cash, marketable (or short-term) securities, and accounts receivable and notes receivable, net of the allowances for doubtful accounts. These assets are considered to be very liquid (easy to obtain cash from the assets) and therefore, available for immediate use to pay obligations. The acid-test ratio is calculated by dividing quick assets by current liabilities. ...

Words: 812 - Pages: 4

Premium Essay

Ratio Analysis

...Title: The analysis of Profitability and Liquidity management of Bangladesh Steel Re-Rolling Mills Limited. (The Comparative Ratio analysis of the Financial Statement between 2011 and 2012). Abstract: Liquidity and its management determines to a great extent the growth and profitability of a firm. This is because either inadequate liquidity or excess liquidity may be injurious to the smooth operations of the organization. This seeming controversy has attracted a lot of interest in the subject of liquidity management. The present study aims to reveal the Comparative analysis of liquidity and profitability of Bangladesh Steel Re-Rolling Mills Limited so that the company has to maintain this relationship while in conducting day to day operations. The results show that there is a significant impact of only liquid ratio on ROA while insignificant on ROE and EPS; the results also show that ROE is no significant effected by three ratios current ratio, quick ratio and liquid ratio while EPS is greatly affected by current ratios, quick ratios and liquid ratio. The main results of the study demonstrate that each ratio has a significant effect on the financial positions of enterprise with differing amounts and that along with the liquidity ratios in the first place. Profitability ratios also play an important role in the financial positions of enterprises. Every stakeholder has interest in the liquidity position of a company. Suppliers of goods will check the liquidity of the company...

Words: 3131 - Pages: 13

Premium Essay

Ratio Analysis

...RATIO ANALYSIS. Current ratio Current ratio compares the current assets and the current liabilities in a company. The higher the ratio the better the performance. Total limited. in 2008- 1.24 in 2009-1.12 This states that total in 2008 has a higher ratio than its next year. This shows that their liability has increased. Kenya oil company limited. In 2008- 1.30 In 2009- 1.30 Here it can be stated that in both years the company drew with the ratios. Quick ratio- the best ratio is 1:1. anything below this level requires further analysis of receivables to understand how the company turns them to cash. The quick ratio for Kenya oil are closer to each other rather than total where one is higher that the other. Total 0.89 (2008) and 0.63(2009) Kenya oil 0.63(2008) and 0.62(2009). Efficiency ratios Asset turnover- this is how a company is using its assets. Total and Kenya oils liabilities are increasing faster than the assets arising therefore the ratio is falling. Both companies should control their liabilities. Inventory turn over ratio This is how fast a company sells its inventory over a financial period. The higher the ratio, the faster the turnover. This shows good company performance. Kenya oil has a better inventory turnover than Total. Since Kenya oil has a higher sales turnover volume. It takes less time to sell the oil than Total. Profitability Ratios Net Profit Ratio: The net profit ratio tells us the amount of net profit of turnover a business...

Words: 888 - Pages: 4

Premium Essay

Ratio Analysis

...(max. 250 words) interpreting selected liquidity ratios. 1. Companies  Last name begins with the letters o A through M: CVS o N through Z: Eli Lilly You can work individually or in a group of not more than 3. If you work in a group, one group member must send the Academic Coach, Ms. Linda Anderson, a message stating who is in the group, AND the name of the member who would submit the assignment. THE SUBMISSION FROM THE DESIGNATED MEMBER ALONE WILL BE GRADED. If your last names fall in both categories (eg. Anderson and Surysekar), your message to Ms. Anderson should also include your choice of the company (CVS or Eli Lilly). If group work, both members will get the same score for this assignment. 2. Ratios to compute and interpret (only the following 4 liquidity ratios, defined in page 704 of the text):     Current ratio Current cash debt coverage ratio Inventory turnover Accounts receivable turnover 3. Time period: Years 2009, 2010, 2011 4. Source: Company Annual Report  CVS o o o Reinventing Pharmacy for Better Health CVS Annual Report Pharmacy Innovation In a Changing Health Care Environment  Eli Lilly o o o 2009 Annual Report 2011 Annual Report Getting There: The Lilly Promise 5. Requirements: a. Required ratios in the following table: Your name: ________________ Company name: CVS or Eli Lilly RATIO CURRENT RATIO CURRENT CASH DEBT COVERAGE RATIO INVENTORY TURNOVER ACCOUNTS RECEIVABLE TURNOVER ...

Words: 390 - Pages: 2

Premium Essay

Ratio Analysis

...Performance evaluation and ratio analysis of Pharmaceutical Company in Bangladesh Faruk Hossan Md Ahsan Habib Supervisor: José Ferraz Nunes Examiner: Bengt Kjellén Master‟s thesis in international Business 15 ECTS Department of Economic and Informatics University West Spring term 2010 0 ABSTRACT The thesis applies performance evaluation of pharmaceutical company in Bangladesh. It means evaluate how well the company performs. The main aim is achieved through ratio analysis of two pharmaceutical (Beximco and Square pharmaceutical) companies in Bangladesh. The main data collection from the annual financial reports on Beximco and square pharmaceutical companies in 2007 to 2008.Different financial ratio are evaluated such liquidity ratios, asset management ratios, profitability ratios, market value ratios, debt management ratios and finally measure the best performance between two companies. The mathematical calculation was establish for ratio analysis between two companies from 2007-2008.It is most important factors for performance evaluation. The graphical analysis and comparisons are applies between two companies for measurement of all types of financial ratio analysis. Liquidity ratio is conveying the ability to repay short-term creditors and it total cash. It determines perform of short term creditor of both pharmaceutical companies under the three categories such as current ratio, quick ratio and cash ratio. Asset management ratio is measurement how to effectively...

Words: 12872 - Pages: 52

Premium Essay

Ratio Analysis

...[pic] (A Term Paper submitted as a partial requirement for the fulfilment of the course FB-507; Managerial Finance; in the Department of Banking, University of Dhaka) Department of Banking [pic] Ratio Analysis & Trend Analysis Submitted by Muzahidur Reza Chowdhury EMBA program, 18th batch Department of banking University of Dhaka Department of Banking [pic] Letter of Transmittal December 22, 2011 To Md. Muzahidul Islam Professor, Department of Banking, University of Dhaka. Subject: Submission of the Term Paper for course No. FB- 507, Managerial Finance. Dear Sir, With due respect, We draw your kind attention to the fact that to prepare a Term Paper and submitting the same as an academic requirement of all the EMBA students of FB- 507, Managerial Finance, Fall Semester 2011. It is a pleasure for us to present our Term Paper before you on “Ratio & Trend Analysis of Grameenphone Ltd & Teletalk Bangladesh Limited”. We have tried Our best in preparing this Term Paper and left no stone unturned to make the report a vivid and comprehensive one in spite of a number of limitations. We sincerely believe that it will serve the required purposes. We will always be obliged to furnish any clarification regarding this Term Paper, if required. Your Sincerely Muzahidur Reza Chowdhur Batch-18th CONTENTS |Acknowledgement ...

Words: 3662 - Pages: 15

Premium Essay

Ratio Analysis

...RATIO ANALYSIS Meaning and definition of ratio analysis: Ratio analysis is a widely used tool of financial analysis. It is defined as the systematic use of ratio to interpret the financial statements so that the strength and weaknesses of a firm as well as its historical performance and current financial condition can be determined. The term ratio refers to the numerical or quantitative relationship between two variables. Significance or Importance of ratio analysis: • It helps in evaluating the firms performance: With the help of ratio analysis conclusion can be drawn regarding several aspects such as financial health, profitability and operational efficiency of the undertaking. Ratio points out the operating efficiency of the firm i.e. whether the management has utilized the firm’s assets correctly, to increase the investor’s wealth. It ensures a fair return to its owners and secures optimum utilization of firms assets • It helps in inter-firm comparison: Ratio analysis helps in inter-firm comparison by providing necessary data. An interfirm comparison indicates relative position.It provides the relevant data for the comparison of the performance of different departments. If comparison shows a variance, the possible reasons of variations may be identified and if results are negative, the action may be intiated immediately to bring them in line. • It simplifies financial statement: The information given in the basic financial statements serves no useful Purpose unless it s interrupted...

Words: 1629 - Pages: 7

Premium Essay

Ratio Analysis

...Beximco Pharmaceuticals Ltd. (Ratio Analysis) 2009-2010 The overall purpose of financial statement analysis is to known a company’s performance to that of other in its industry. Financial ratio should be examined relative to the economy the companies industry, the companies’ main competitor and the companies past relative ratios. The specific ratios can be divided into 4 categories, depending on the purpose of the analysis: A. Profitability Ratios. B. Asset Utilization Ratios. C. Liquidity Ratios. D. Debt Utilization Ratios. E. Market Value Ratios. A. Profitability Ratios Net Income (i) Profit Margin = ------------------- X 100 Sales 1051648808 In the year 2010, The Profit Margin = ------------------- X 100 = 16.20% 6490847353 624740307 In the year 2009, The Profit Margin = ------------------ X 100 = 12.83% 4868254915 Analysis : Here, 2010 Annual year profit margin is higher than 2009 Annual year indicating that 2009 Annual year sales are too low. According to debt ratio 2009 year has a great proportion of debt than the 2010 year & the times interest earned ratio shows the 2009 year interest payments on its debt are not covered as well as the rest of 2010 Annual year. This is one of the reason that 2009 annual year profit margin...

Words: 1277 - Pages: 6

Premium Essay

Ratio Analysis

...CONTENTS S.No. Title Page No. | ACKNOWLDGEMENTS 3 List of Tables 4 Chapter 1. Introduction 5 1.1 Theoretical background 8 1.1.1 Use and significance of Ratio Analysis 8 1.1.2 Limitations 11 1.1.3 Classifications of ratios 13 1.2 Research Methodology 33 1.2.1 Need for the study 33 1.2.2 Scope of the study 33 1.2.3 Objectives of the study 33 1.2.4 Data sources 34 1.2.5 Limitations 34 Chapter 2. Profiles 35 2.1 Company profile 36 Chapter 3. Review of Literature 55 Chapter 4. Data Analysis 59 Chapter 5. Findings 86 Chapter 6. Suggestions 88 * Bibliography 90 LIST OF TABLES Sl. No | Table No | Title of the tables | Page No | 12345678910111213141516171819202122 | 4.14.24.34.44.54.64.74.84.94.104.114.124.134.144.154.164.174.184.194.204.214.22 | Current RatioQuick RatioCash RatioNetworking capital RatioDebt RatioDebt...

Words: 12309 - Pages: 50

Premium Essay

Ratio Analysis

...A Report on the Ratio Analysis of Lafarge Surma Cement Ltd. Date of submission: 18/08/2015 Course: FIN254.15 Prepared for: Ahmed Ameya Prapan Lecturer, School of Business, North South University. Prepared By: Ifraha Fairuz Binte Ilias ID# 142 0352 030 Afsara Afia ID# 142 0025 030 Asma-ul-Husna ID# 132 0374 030 Ashrafur Rahman ID# 132 0309 030 Table of Contents Title | Page No. | Introduction | 04 | Ratio Analysis | 05-39 | Time Series Analysis | 05-21 | Liquidity Ratio | 05-07 | Activity Ratio | 07-11 | Debt Ratio | 12-13 | Profitability Ratio | 14-18 | Market Ratio | 19-21 | Cross sectional Analysis | 22-38 | Liquidity Ratio | 22-23 | Activity Ratio | 24-28 | Debt Ratio | 29-30 | Profitability Ratio | 31-35 | Market Ratio | 36-38 | All over Performance at a Glance | 39 | Free Cash Flow | 40 | DuPont & Extended DuPont System | 41-42 | Conclusion | 43 | Introduction Ratio analysis is a method of analyzing data to determine the overall financial strength of a business. Ratio analysis is based on line items in financial statements like the balance sheet, income statement and cash flow statement;...

Words: 6719 - Pages: 27

Premium Essay

Ratio Analysis

...Ratio Analysis   Solve the problem below, calculate the ratios, interpret the results against the industry average, and fill in the table on the worksheet. Then, provide an analysis of how those results can be used by the business to improve its performance.    Balance Sheet as of December 31, 2010 | Gary and Company | Cash   | $45 |   | Accounts payables   | $45 | Receivables     | 66 |   | Notes payables  | 45 | Inventory | 159 |   | Other current liabilities  | 21 | Marketable securities | 33 |   | Total current liabilities | $111 | Total current assets  | $303 |   |   |   | Net fixed assets   | 147 |   | Long Term Liabilities |   | Total Assets   | $450 |   | Long-term debt   | 24 |   |   | Total Liabilities  | $135 |   |   |   |   |   |   | Owners Equity |   |   |   | Common stock | $114 |   |   | Retained earnings | 201 |   |   | Total stockholders’ equity | 315 |   |   |   | Total liabilities and equity | $450 |       Income Statement Year 2010 |   |   | Net sales | $795 | Cost of goods sold  | 660 | Gross profit   | 135 | Selling expenses   | 73.5 | Depreciation | 12 | EBIT | 49.5 | Interest expense   | 4.5 | EBT | 45 | Taxes (40%)   | 18 | Net income | 27 |     1. Calculate the following ratios AND interpret the result against the industry average: Ratio | Your Answer | Industry Average | Your Interpretation (Good-Fair-Low-Poor) | Profit margin on sales |   | 3% |   | Return on assets |   | 9% |   | Receivable turnover |   | 16X |   |...

Words: 607 - Pages: 3

Premium Essay

Ratio Analysis

...Application of Transmittal May 10 , 2012 Course instructor School of Business, Southeast University Subject: Letter of transmittal. Dear Sir, Please find enclosed with this letter the report of “Beximco Pharmaceuticals, Ltd” that you wanted as partial requirement for the course of “Course”. The name of my project is " Ratio Analysis of a company." I collected all the relevant information and the annual report 2001, I go through from “Beximco Pharmaceuticals, Ltd.” I thing that is the report contains the information that you need to get an idea about the “Ratio Analysis”. If you need any clarification or any further information I would be happy to provide it to you. Yours sincerely, Md. Sakhawat Hossain Acknowledgements At first our thanks go to Mr. School of Business, Southeast University, Bangladesh For handing us this report which we found to be a rather interesting topic to work on. We are going to get help to many people in the context of preparing this report and some of the persons have been very helpful and cooperative with information and suggestions. In this regard we would like to thank Mr. C.H.Rahman is the managing director of the company who is the pioneer person in the country in the Pharmaceuticals sector and I have worked hard to prepare this report. So by this way I could finish the report properly and on time. Introduction Square Pharmaceuticals Ltd. is a renowned company in Bangladesh. It is a flagship company in the pharmaceutical...

Words: 6369 - Pages: 26