XYZ Inc is a CRM software company. Evaluate the financial statement for XYZ Inc and write a report following the table of contents below. 1.0 Ratio Analysis 1.1 XYZ Financial Situation - A Graphical Look 1.2 Industry Ratio Comparisons 1.3 Recommendations: 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. June 30/06 June 30/07 June 30/08 June 30/09 June 30/10 June 30/11 Current Assets Cash Accounts receivable Work in progress Prepaid Expenses Total Current assets 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 Capital Assets (note 1) Net capital assets 0.00 74,992.00 98,020.00 196,891.00 150,714.00 -43,371.00 Total Assets 0.00 150,362.00 246,194.00 635,649.00 206,697.00 206,697.00 384,498.00 Current Liabilities Bank indebtedness Accounts payable Unearned/ deferred revenue Current portion long term debt Total Current Liabilities 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 54,640.00 160,457.00 30,492.00 74,616.00 0.00 29,160.00 85,132.00 264,233.00 125,000.00 153,881.00 87,037.00 5,832.00 371,750.00 125,000.00 15,065.00 48,967,00 -1,428.00 -62,396.00 Long Term Debt (note 2) 0.00 0.00 0.00 115,840.00 -34,992.00 -1,949.00 Total Debt 0.00 84,619.00 85.132.00 380,073.00 336.758.00 -64,345.00 Shareholders Equity Common Shares 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Retained earnings 0.00 65,743.00 161,062.00 255,576.00 130,061.00 448,844.00 Total Owners Equity 0.00 65,743.00 161,062.00 255,576.00 130,061.00 448,844.00 0.00 Total Liabilities & Shareholders Equity 150,362.00 246,194.00 635,649.00 206,697.00 384,499.00 XYZ Inc is a CRM software company. Evaluate the financial statement for XYZ Inc and write a report following the table of contents below. 1.0 Ratio Analysis 1.1 XYZ Financial Situation - A Graphical Look 1.2 Industry Ratio Comparisons 1.3 Recommendations: 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. June 30/06 June 30/07 June 30/08 June 30/09 June 30/10 June 30/11 Current Assets Cash Accounts receivable Work in progress Prepaid Expenses Total Current assets 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 Capital Assets (note 1) Net capital assets 0.00 74,992.00 98,020.00 196,891.00 150,714.00 -43,371.00 Total Assets 0.00 150,362.00 246,194.00 635,649.00 206,697.00 206,697.00 384,498.00 Current Liabilities Bank indebtedness Accounts payable Unearned/ deferred revenue Current portion long term debt Total Current Liabilities 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 54,640.00 160,457.00 30,492.00 74,616.00 0.00 29,160.00 85,132.00 264,233.00 125,000.00 153,881.00 87,037.00 5,832.00 371,750.00 125,000.00 15,065.00 48,967,00 -1,428.00 -62,396.00 Long Term Debt (note 2) 0.00 0.00 0.00 115,840.00 -34,992.00 -1,949.00 Total Debt 0.00 84,619.00 85.132.00 380,073.00 336.758.00 -64,345.00 Shareholders Equity Common Shares 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Retained earnings 0.00 65,743.00 161,062.00 255,576.00 130,061.00 448,844.00 Total Owners Equity 0.00 65,743.00 161,062.00 255,576.00 130,061.00 448,844.00 0.00 Total Liabilities & Shareholders Equity 150,362.00 246,194.00 635,649.00 206,697.00 384,499.00
