Financial Analysis
| | Ratio | Working | 2009 | Working | 2010 | 1 | Return on Equity(ROE) | PBIT x 100Average Owners Equity | 398000 x 100(390000 + 430000)/2 | 97.07% | 292000 x 100(430000 + 527300)/2 | 61% | 2 | Return on Assets(ROA) | PBIT x 100Average Total Assets -CL | 398000 x 100[(1000000 + 1015000)– (165000 + 152200)]/2 | 46.88% | 292.000 x 100[(1015000 + 1126300)-( 152200 + 174000)]/2 | 32.18% | 3 | Net Profit Margin(NP%) | PBIT x 100Sales | 398000 x 1002180000 | 18.26% | 292000 x 1002232000 | 13.08% | 4 | Gross Profit Margin(GP%) | Gross Profit x 100Sales | 1350000 x 1002180000 | 61.93% | 1282000 x 1002232000 | 57.44% | 5 | Asset Turnover | SalesAverage Total Assets – CL | 2180000[(1000000 + 1015000)– (165000 + 152200)]/2 | $2.57 | 2.232.000[(1015000 + 1126300)–(152200 + 174000)]/2 | $2.46 | 6 | Fixed assets Turnover | SalesAverage Fixed assets | 2180000(790000 + 799000)/2 | $2.74 | 2232000(799000 + 788300)/2 | $2.81 | 7 | Working Capital Turnover | SalesAverage Working Capital | 2180000[(177000 + 191000)]–( 165000 + 152200)]/2 | $85.83 | 2.232.000[(191000 + 308300) –(152200 + 174000)]/2 | $25.83 | 8 | Current ratio | Current AssetsCurrent Liabilities | 191000152200 | 1.26 times | 308000174000 | 1.77times | 9 | Acid test ratio | CA – (Inventory + Prepayments)Current Liabilities | 191000 - (27000 + 2000)152200 | 1.06times | 308000 - (25000+4000)174000 | 1.6times | 10 | Inventory Turnover | Average Inventory x 365Cost of sales | (24000 + 27000)/2 x 365830000 | 11.2 days | (27000 + 25000)/2 x365950000 | 10days | 11 | AverageCollection Period | Average Accts. Rec x 365Credit sales | (90000 + 80000)/2 x 3652180000 x 60% | 23.7 days | (80000 + 130000)/2 x 3652232000 x 60% | 28.62 days | 12 | AveragePaybackPeriod | Average Accts. Pay x 365Purchases | (50000 + 43500)/2 x 365833000 | 20.48Days | (43500 + 61000)/2 x 365948000 | 20.12 days | 13 | EPS | Profit after taxNo of Ordinary shares
Bibliography: Barry, E. and Jamie, E. (2009) Financial accounting and reporting. 13th ed. Harlow: Pearson Education, pp. 164-254. Bayldon, R., Woods, A. and Zafiris, N. (1984) A note on the 'pyramid ' technique of financial ratio analysis of firms ' performance Charles, H.G. (2009) Financial Reporting and Analysis: Using Financial Accounting Information. 11th ed. Masan, OH45040, USA: South-western Cengage Learning, pp. 177 to 297. Flex monitoring team. (2005) Financial Indicators for Critical Access Hospitals. Flex Monitoring Team Briefing Paper No. 7. Available from: <http://www.flexmonitoring.org/documents/BriefingPaper7_FinancialIndicators.pdf> Jonathan, A.H Martin, F. and Fernando, A. (2002) Financial statement analysis. 3rd ed. MA01923, USA:John Wiley & Sons,Inc, pp.168-177. Marina-Eliza, S. (2009) Do financial factors affect the capital–labour ratio: Evidence from UK firm-level data. Journal of banking and finance, 33(10), pp.1932-1947. Michigan State University Extension. (2002) Statistical and ratio analysis. Available from : < http://web1.msue.msu.edu/imp/modtd/33300009.html> NGFY CYMRU. (2009) Ratio Analysis—Limitations. Available from:< http://www.ngfl-cymru.org.uk/ratios_limitations.pdf> Noel, C., John, U Peter, H. and Marco, M. (ed.). (2006) Accouting and financial management: Developments in the international hospitality industry. Burlington, MA01803: Elsevier Butterworth–Heinemann, pp. 153-171. Sudarsanam, P.S. and Taffler, R.J. (1995) Financial ratio proportionality and inter-temporal stability: An empirical analysis. Journal of banking and finance, 19 (1), pp. 45-60. Peter, J.H. (1995) Accounting and Finance for the International Hospitality Industry. Woburn MA: 01801-20411995, Butter worth-Heinemann, pp. 1 to 16. Pauline, W. (2011) Financial and management accounting. 5th ed. Harlow: Pearson Education, pp. 339-408. Ronnie, J.C., William, S. and Christopher, W. (2002) Financial Decisions “Enron: Market Exploitation and Correction”. Houston, Texas. Available from: < http://financialdecisionsonline.org/current/clayton.pdf>