Financial Ratio Analysis

As part of the system of financial control in an organisation, it will be necessary to have ways of measuring the progress of the enterprise, so that managers know how well the company concerned is doing.

The financial situation of a company will obviously affect its share price.The answer to some of the following questions can be obtained from accounting reports produced by the company:i. Is the company profitable?ii. Is the company growing?iii. Does the company have satisfactory liquidity?iv. Is the company’s gearing level acceptable?v.

We Will Write a Custom Case Study Specifically
For You For Only $13.90/page!

order now

What is the company’s dividend policy?The usual way of interpreting accounting reports is to calculate and then to analyse certain ratios (Ratio Analysis). The key to obtain meaningful information from ration analysis is comparison (that is, comparing ratios over time within the same business to establish whether the business is improving or declining, and comparing ratios between similar businesses to see whether the company you are analysing is better or worse than average within its own business sector.Ratio analysis on its own is not sufficient for interpreting company accounts, and there are other items of information, which should be looked at. These include the following:i. Comments in the Chairman’s report and the director’s reportii.

The age and nature of the company’s assetsiii. Current and future developments in the company’s markets, at home and overseasiv. Recent acquisitions or disposals of a subsidiary by the companyv. The cash flow statement (where required by FRS 1)1.1.

1 Limitations and Strength of Financial RatiosFinancial Ratios are used to compare actual results with something else. The comparison may be against a budget or a desire target, or perhaps against a previous period’s results in order to detect trends. On the order hand, an entity’s results may be compared with the results of another entity using ratios in order to ascertain whether current actual results are better or worse than those of other similar business units.Limitations* On their own, they do not provide information to enable managers to gauge performance or make control decisions. It is necessary to provide budgeted or targeted ratios, ratios of previous accounting periods, or ratios of other companies or divisions, as a tool for comparison.* Ambiguity arises when defining the ratios used.

For example, should earnings be ‘before tax’ or ‘after tax’?* Ratios compared over a period of time at historical cost will not be properly comparable where inflation in price has occurred during the period, unless an adjustment is made to the ratios to make allowance for price level differences.* The ratios of different companies cannot be properly compared where each company employs different accounting policies.StrengthsDespite of the limitations, it provides a useful tool for management, shareholders and any interested parties to assess the performance of the business. Other strengths are as follows:* It summarises relationships and results relevant to an organisation’s performance.* It allows year-to-year performance comparison.* It allows performance comparisons of organisations in the same industry.

* It allows trends to emerge and hence predictions to be made.1.2 Analysis Report for Jin Yang LtdJIN YANG LTDREPORTTo: Mr Tom Tan, Managing DirectorFrom: AccountantDate: 7 May 2002Subject: Performance appraisal for the years 1998 to 2001We have based on the summarised accounts obtained for the years 1998 to 2001 and interpreted the accounts using Financial Ratios. We have prepared an appendix of ratios (see Appendix 1), a trend analysis report (see Appendix 2) and a set formulas of the ratios used (see Appendix 3).Profitability RatiosThe Return on Capital Employed (ROCE) and the Return on Owners’ Equity (ROE or ROOE) has gradually increased by 4.

7% from 15.77% in 1998 to 20.47% in 2001 and by 4.67% from 8.03% in 1998 to 12.

70% in 2001, respectively. It shows that the business is profitable with it resources fairly utilised, as the higher ROCE the more profitable the business.The Operating Profit margin only increases marginally by 0.02% from 11.62% in 1998 to 11.

64% in 2001, despite of the dip by 0.64% in 2000. Although Sales has increase by 33% since 1998, the cost has also increased substantially. The increase in cost could also be due to the increase in the number of employees being employed, which leads to an increase in employees’ remuneration.It will be good if we are given the Gross Profit (GP), so that we could calculate that GP margin and differentiate whether the increase in cost is due to an increase in Cost of Sales or Operating expenses. The profit margins measure the quality of the business, as the higher the margin the higher quality of the business.

On the other hand, low margin could be due to high cost of production, where it cannot enjoy the economic of scale and could also be due to intense competition from competitors, where it may need grant sales discount to increase it’s competitiveness.The Net Profit margin has increase by 1.3% from 5.92% in 1998 to 7.22% in 2001, despite of the dip by 0.

14% in 2000. The increase is due reduction in corporate tax by 11% in 2001. In overall, the company has an average profitability.Liquidity RatiosThe Current ratio and Quick ratio have shown substantial decreases by 0.53% from 1.

92% in 1998 to 1.39% in 2001 and by 0.37% from 1.02% in 1998 to 0.65% in 2001, where the ideal ratios level should be at least ‘2’ and ‘1’ respectively.Both ratios measure the business ability to generate cash and repay short term debt using its current assets.

In the case of the Quick ratio, it has excluded stock in the calculation, as stock is regarded as illiquid and it is impossible to convert the stock into cash within relatively short period of time.As for Jin Yang Ltd, it is showing signs of having liquidity problem based on the declining ratios. The tremendous increase in sales, stock, debtors and creditors, shown in the accounts, indicated an over trading situation in the company.Efficiency RatiosThe Debtors Turnover period has increase substantially by 17.21 days from 60.

30 days in 1998 to 77.51 days in 2001. It shows slow payments from debtors, which eventually causes liquidity problem to the company.Change of credit terms and giving discount for early settlements might help Jin Yang Ltd to solve its liquidity problem. Therefore, the company can also pay its creditors on time, avoiding any legal issues for non-payments.We would not be able to discuss further on the Efficiency of the company (that is, Creditors Turnover period and Stock Turnover Period), as we are not given the sufficient information from the trading account, like Purchases, Stock and Cost of Sales.

The following ratios have shown in general that the company has fairly utilised it assets in generating it’s sales:The Working Capital Turnover has substantially increases by 3.18 times from 4.48 times in 1998 to 7.66 times in 2001.The Assets Turnover has gradually increases by 0.4 times from 1.

36 times in 1998 to 1.76 times in 2001.The Fixed Assets Turnover has gradually increases by 0.33 times from 1.95 times in 1998 to 2.28 times in 2001.

Investors’ RatiosThe Earnings per share has substantially increases by $0.09 from $0.15 in 1998 to $0.24 in 2001.The Dividend Cover is expressed as the dividend being 1.16 times (in year 2001) covered by the profits, whereas in 1998 it is expressed as the dividend being 1.

08 times covered by the profits. This is an indication that as the company is retaining a larger portion of its profit in year 2001, the company is growing and this will lead to growth in prospects and dividend in future.We are unable to appraise further on the Price Earning ratio and Dividend Yield, as the market value of the share is not given for the four year.Looking at the Trend analysis (Appendix 2), the percentage change in sales has decrease from 12% in 1999 to 8% in 2001 and the percentage change in profit after tax has increase substantially from 18% in 1999 to 35% in 2001, due to the decline in corporate tax.In conclusion, from the above, the company is going into a liquidity problem due to over trading and expanding too rapidly, although it seems profitable.

The company could be more profitable with enough cash flow, if it employs a good management team. And if not for the decline in corporate tax, the company might not have a substantial increase in profit in year 2001.Furthermore, lacking important information has lead to an incomplete performance appraisal for Jin Yang Ltd. But in view of the Gearing of the company (that is, Debt Ratio, where Total Liabilities / Total Assets) has substantially increases by 19.93% from 52.20% in 1998 to 77.

13% in 2001. It indicated that the company is having some cash flow problem, where they are unable to pay off their creditors on time due to slow collection in debt.In addition, there are limitation to compare ratios over a period of time at historical cost will not be properly comparable where inflation in price has occurred during the period, unless an adjustment is made to the ratios to make allowance for price level differences.� Appendix 1 – Financial RatiosJIN YANG LTDAPPENDIX 1FINANCIAL RATIOS1998199920002001Profitability RatiosROCE (%)15.7718.2818.

2020.47ROE or ROOE (%)8.039.449.5712.70Operating Profit Margin (%)11.

6212.0710.9811.64Net Profit Margin (%)5.926.235.

787.22Liquidity RatiosCurrent Ratio1.921.651.501.

39Quick Ratio (Acid Test)1.020.830.690.65Efficiency RatiosDebtors Turnover Period (in Days)60.

3066.0470.9477.51Working Capital Turnover (in Times)4.485.616.

737.66Assets Turnover (in Times)1.361.511.661.76Fixed Assets Turnover (in Times)1.

952.072.202.28Investors’ RatiosEarnings per Share (EPS) (in $)0.150.180.

180.24Dividend Cover (in Times)

16Gearing RatioDebt Ratio (%)52.2060.5966.2772.13� Appendix 2 – Trend Analysis (Historical Summaries)Trend AnalysisHistorical SummariesJin Yang Ltd’s Four Year Record($’000)1998199920002001Sales506,000566,720623,390673,260Profit after Tax29,94035,31036,02048,630Reserve172,910174,220176,240182,870a.Percentage changesSales12%10%8%Profit after Tax18%2%35%Reserve1%1%4%a.

Index numberSales100112110108Profit after Tax100118102135Reserve100101101104� Appendix 3 – Financial Ratios (Formulas)Profitability Ratios (measured in Percentage)1Return on Capital Employed (ROCE)=Profit before interest and tax (PBIT)x100%Capital Employed *[*where, Capital Employed = Total Assets – Current Liabilities]2Return on Equity (ROE) or=Profit after interest, tax and Preference Dividendx100%Return on Owner’s Equity (ROOE)Ordinary Share Capital and Reserve3Return on Shareholder’s Fund (ROSF)=Profit before taxx100%Ordinary Share Capital and Reserve4Profit Margin on Sales=Operating Profitx100%(Operating Profit Margin)Sales5Gross Profit Margin=Gross profitx100%Sales6Net Profit Margin=Net Profitx100%SalesLiquidity Ratios7Current Ratio=Current AssetsCurrent Liabilities8Quick Ratio / Acid Test Ratio=Current Assets less StockCurrent LiabilitiesEfficiency Ratios (measured in Days or in Times)9Stock Turnover Period=Average Stockx365 daysCost of SalesStock Turnover=Cost of SalesAverage Stock10Debtors Turnover Period=Average Debtorsx365 daysSalesDebtors Turnover=SalesAverage Debtors11Creditors Turnover Period=Average Creditorsx365 daysPurchaseCreditors Turnover=PurchaseAverage Creditors12Working Capital Turnover=SalesNet Current Assets13Assets Turnover=SalesCapital Employed14Fixed Assets Turnover=SalesFixed AssetsGearing Ratios (measured in Percentage or in Times)15Gearing Ratio=Prior Charge Capital #x100%Equity ; Preference Share Capital ; Reserve + Total Long Term Debt[# where, Prior Charge Capital = Total Long Term Debt + Preference Share Capital]orTotal Liabilities less Current Liabilitiesx100%Capital Employed16Debt Equity Ratio=Prior Charge Capitalx100%Ordinary Share Capital and Reserve17Debt Ratio=Total Debt (Liabilities)x100%Total Assets18Interest Cover=Profit before interest and TaxInterest ChargeInvestors’ Ratios (Shareholders’ Ratios) (measured in Percentage or in Times)19Earnings per Share (EPS)=Earnings ^Number of Ordinary Shares[ ^ where, Earnings = Net Profit after Tax and Preference Dividend]20Dividend Yield=Gross Dividend per Ordinary Sharex100%Current Market Value of the Share21Dividend Cover=EPSDividend per Ordinary Shareor=Net Profit/(Loss) attributed to Ordinary ShareholdersNet Dividend on Ordinary Share22Price / Earnings Ratio=Market Value of the ShareEPS2. “Accrual accounting is preferable to cash flow accounting”2.1 IntroductionAlthough financial numbers do not lie, they are subjected to different accounting methods that can lead to different interpretations of a company’s financial position.There are two basic methods for keeping track of sales income and the money paid out for expenses: Cash accounting and Accrual Accounting. Typically, businesses with revenue of more than a few million dollars choose accrual accounting to handle the greater financial complexity that company face.

Choosing the right accounting method can make the difference between an accurate reading of Profit & Loss and a conceptual figure that leaves a non-financial person without a clue. Accounting can also make the difference between knowing when the business has sufficient cash flow in the bank to cover an expense and when it does not. Knowing how much money the business actually has on hand might be a good clue as to whether it has budgeted enough to pay expenses between the times when it’s customers to pay their bills.Going forward, we will discuss further between Accrual accounting and Cash flow accounting, where there are potential timing differences in recognising revenues and expenses.2.

2 Defining Accrual accounting2.2.1 Accrual accountingIt is very important to grasp the principle, which is applied in nearly all businesses’ accounts, that accounts are not prepared on a cash basis but on an accrual (or earnings) basis. That is, a sale or purchase is dealt with in the year in which it is made, even if cash changes hands in a later year. This is important because most businesses, even if they do not sell on credit, make purchases on credit.

If cash flow accounting is used, than accounts do not present a true picture of the business’s activities in any given period. Accountants call this convention an application the accruals concept.It differs from cash flow accounting, which recognises transactions when cash has been received or paid. In preparing financial statements for an accounting period using accrual accounting, there will inevitably be some estimation and uncertainly in respect of transactions. The reader of the financial statements therefore cannot have the same high level of confidence in these statements as in those using cash flow accounting.2.

2.2 ‘Accrual’ conceptThe ‘Accrual’ or ‘Matching’ concept, which is described in SSAP 2 as follows:”Revenues and costs are accrued (that is, recognised as they are earned or incurred, not as money is received or paid), matched with one another so far as their relationship can be established or justifiably assumed, and dealt with in the profit and loss account of the period to which they relate… Revenue and profits dealt with in the profit and loss account of the period are matched with associated costs and expenses by including in the same account the cost incurred in earning them (so far as these are material and identifiable).”The Companies Act 1985 gives legal recognition to the accruals concept, stating that: ‘All income and charges relating to the financial year to which the accounts relate shall be taken into account, without regard to the date of receipt or payment.

‘ This has the effect, as we have seen, of requiring businesses to take credit for sales and purchases when made, rather than when paid for, and also to carry unsold stock forward in the balance sheet rather than to deduct its cost from profit for the period.2.2.3 Revenue RecognitionAccrual accounting is based on the matching of cost with the revenue they generate. It is crucially important under this convention that we can establish the point at which revenue may be recognised so that the correct treatment can be applied to the related costs. For example, the costs of producing an item of finished goods should be carried as an asset in the balance sheet until such time as it is sold; they should be written off as a charge to the trading account.

Revenue is generally recognised as earned at the point of sales, because at that point four criteria will generally have been met:-i. The product or service has been provided to the buyer.ii. The buyer has recognised his liability to pay for the goods and services provided. The Converse of this is that the seller has recognised that ownership of goods has passed from himself to the buyer.

iii. The buyer has indicated his willingness to hand over cash or other assets in settlement of his liability.iv. The monetary value of the goods or services has been established.2.2.

4 Example for ‘Accrual’ conceptEmma has a business printing and selling T-shirts. In May 20X7 she makes the following purchases and sales,Invoice date Numbers bought/sold Amount Date PaidPurchase $7.5.X7 20 100 1.6.X7Sales8.

5.X7 4 40 1.6.X712.5.

X7 6 60 1.6.X723.5.X7 10 100 1.

7.X7What is Emma’s profit for May?Solution:Cash basis $Sales 0Purchases 0Profit/Loss 0Accrual basisSales ($40+$60+$100) 200Purchase 100Profit/Loss 100Obviously, the accruals basis gives a truer picture than the cash basis. Emma has no cash to show for her efforts until June but her customers are legally bound to pay her and she is legally bound to pay for her purchases.2.3 Defining Cash flow accounting2.

3.1 Cash flow accountingIt is a system of accounting that the records only the cash payments and receipts relating to transactions made by a business, rather than when the money is earned or when expenses are incurred, as in accrual accounting. It is claimed to be easier to understand and less arbitrary in its allocation processes than accrual accounting. It may be used in place of or in addition to accrual accounting and is reflected in a cash flow statement.In layman terms, under the Cash flow accounting, revenue is recognised when cash is received and expense is recognised when cash is paid.

2.3.2 Advantages and disadvantages of cash flow accountingThe advantages of cash flow accounting are as follows:i. Survival in business depends on the ability to generate cash. Cash flow accounting directs attention towards these critical issues.

ii. Cash flow is more comprehensive than ‘profit’, which is dependent on accounting conventions and concepts.iii. Creditors (long and short-term) are more interested in an entity’s abilities to repay them than in its profitability. Whereas ‘profits’ might indicate that cash is likely to be available, cash flow accounting is more direct with its message.iv.

Cash flow reporting provides a better means of comparing the results of different companies than traditional profit reporting.v. Cash flow reporting satisfies the needs of all users better:a. For management, it provides the sort of information on which decisions should be taken: (in management accounting, ‘relevant costs’ to a decision are future cash flow); traditional profit accounting does not help with decisions making.b. For shareholders and auditors, cash flow accounting can provide a satisfactory basis for stewardship accounting.

c. As describe previously, the information needs of creditors and employees will be better served by cash flow Cash flow forecasts are easier to prepare, as well as more useful, than profit forecasts.vii.

They can in some respects be audited more easily than accounts based on the accruals concept.viii. The accrual concept is confusing, and cash flows are more easily understood.ix. Cash flow accounting should be both retrospective, and also include a forecast for the future.

This is of great information value to all users of accounting information.x. Forecasts can subsequently be monitored by the publication of variance statements, which compare actual cash flow against the forecast.The main disadvantages of cash flow accounting are essentially the advantages of accruals accounting (proper matching of related items) See 2.2.

4. There is also the practical problem that few businesses keep historical cash flow information in the form needed to prepare a historical cash flow statement and therefore, extra record keeping is likely to be necessary.2.4 ConclusionCash flow information is relevant as a basis for making internal management decisions in relation to both fixed assets and working capital; and for stewardship and accountability. Cash flow information is also reliable being objective, consistent, prudent and neutral.

However, professional accounting practice requires reports to external users to be on an accrual accounting basis. This is because the accrual accounting profit figure is a better predictor for investors of the future cash flows likely to arise from the dividends paid to them by the business, and of any capital gain on disposal of their investments. It could also be argued that the cash flow may not be a fair representation of the commercial substance of transactions; e.g. if a business allowed a year’s credit to all its customers, there would be no income recorded.In comparison with the Financial Accounting Standards Board (FASB) in the United States of America, the accounting profession generally supports the views of the FASB that accrual accounting provides a better indication of an enterprise’s present and continuing ability to generate favourable cash flows than information limited to the financial aspects of cash receipts and payments.Even the International Accounting Standards Committee (IASC) supported the FASB view in 1989 when it stated that Financial Statements prepared on an accrual basis inform users not only of past transactions involving the payment and receipt of cash, but also of obligations to pay cash in the future and of resources that represent cash to be received in the future, and that they provide the type of information about past transactions and other events that is most useful in making economic decisions.