Finance Evaluate the financial statement for XYZ Inc and write a report of maximum 8 pages following the table of contents below. 1.0 Executive Summary 1.1 Introduction 2.0 Ratio Analysis 3.0 XYZ Financial Situation A Graphical Look 4.0 Industry Ratio Comparisons 5.0 Recommendations 6.0 References/Index XYZ Inc is a CRM software company. The recommendations section must cover the positive and the negative issues you discovered from reading the financial statements. You will say what the company should do to change some of the problems or build up some of the strengths. AutoSave OFF XYZ Financial Statements.xls - Compatibility Home Insert Draw Page Layout Formulas Data Review View Tell me X Arial v 10 ' ab Wrap Text Number === Sou Paste B I U Av Merge & Center $ % ) 08 133 fx B D E F G H 1 June 30/06 June 30/07 June 30/08 June 30/09 June 30/10 June 30/11 0.00 0.00 0.00 0.00 0.00 8,676.00 52,002.00 11,791.00 2,901.00 75,370.00 12,126.00 290,948.00 -314,603.00 550,270.00 104,295.00 143,883.00 320,282.00 123,805.00 15,654.00 -17,983.00 14,678.00 322.00 16,099.00 21,910.00 35,626.00 1,082.00 148,174.00 438,758.00 55,983.00 427,869.00 3.46 0.00 74,992.00 98,020.00 196,891.00 150,714.00 -43,371.00 0.00 150,362.00 246,194.00 635,649.00 206,697.00 384,498.00 1 2 3 Current Assets 4 Cash 5 Accounts receivable 6 Work in progress 7 Prepaid Expenses 8 Total Current assets 9 10 Capital Assets (note 1) 11 Net capital assets 12 13 Total Assets 14 15 16 Current Liabilities 17 Bank indebtedness 18 Accounts payable 19 Unearned/ deferred revenue 20 Current portion long term debt 21 Total Current Liabilities 22 23 Long Term Debt (note 2) 24 25 Total Debt 26 27 Shareholders Equity 28 Common Shares 29 Retained earnings 30 Total Owners Equity 31 32 Total Liabilities & 33 Shareholders Equity 34 0.00 0.00 0.00 0.00 0.00 71,010.00 13,609.00 0.00 84,619.00 0.00 0.00 125,000.00 -125,000.00 54,640.00 160,457.00 153,881.00 15,065.00 30,492.00 74,616.00 87,037.00 48,967.00 0.00 29,160.00 5,832.00 -1,428.00 85,132.00 264,233.00 371,750.00 -62,396.00 0.00 0.00 0.00 115,840.00 -34,992.00 -1,949.00 0.00 84,619.00 85,132.00 380,073.00 336,758.00 -64,345.00 0.00 0.00 0.00 0.00 65,743.00 65,743.00 0.00 0.00 0.00 0.00 161,062.00 255,576.00 -130,061.00 448,844.00 161,062.00 255,576.00 -130,061.00 448,844.00 0.00 150,362.00 246,194.00 635,649.00 206,697.00 384,499.00