Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Balance sheet Diagram Do Complete Balance sheet Analysis. Ratio analysis to reflect the analysis of the figures in the balance sheet using financial ratios and

image text in transcribed

Balance sheet Diagram

image text in transcribed

Do Complete Balance sheet Analysis.

Ratio analysis to reflect the analysis of the figures in the balance sheet using financial ratios and trend analysis.

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 12,126.00 290,948.00 -314,603.00 52,002.00 104,295.00 143,883.00 320,282.00 11,791.00 15,654.00 -17,983.00 14,678.00 2,901.00 16,099.00 21,910.00 35,626.00 75,370.00 148,174.00 438,758.00 55,983.00 550,270.00 123,805.00 322.00 1,082.00 427,869.00 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 384,498.00 Current Liabilities Bank indebtedness Accounts payable Unearned/ deferred revenue Current portion long term der Total Current Liabilities 0.00 0.00 0.00 0.00 0.00 0.00 71,010.00 54,640.00 13,609.00 30,492.00 0.00 0.00 84,619.00 85,132.00 0.00 160,457.00 74,616.00 29,160.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 Retained earnings Total Owners Equity 0.00 0.00 0.00 0.00 0.00 65,743.00 161,062.00 65,743.00 161,062.00 0.00 255,576.00 255,576.00 0.00 -130,061.00 -130,061.00 0.00 448,844.00 448,844.00 0.00 150,362.00 246,194.00 Total Liabilities & Shareholders Equity 635,649.00 206,697.00 384,499.00 XYZ Inc. - Balance Sheet as of June 30, 2001 June 30/96 June 30/97 June 30/98 June 30/99 June 30/00 June 30/01 Current Assets Cash Accounts receivable Work in progress Prepaid Expenses Total Current assets 9,904 29,370 5,538 2,382 47,194 18,580 81,372 17,329 5,283 122,564 30,706 185,667 32,983 21,382 270,738 321,654 329,550 15,000 43,292 709,496 7,051 649,832 29,678 78,918 765,479 557,321 526,027 30,000 80,000 1,193,348 Capital Assets (note 1) Net capital assets 25,380 100,372 198,392 395,283 545,997 502,626 Total Assets 72,574 222,936 469,130 1,104,779 1,311,476 1,695,974 Current Liabilities Bank indebtedness Accounts payable Unearned/ deferred revenue Current portion long term debt Total Current Liabilities 18,273 8,293 89,283 21,902 143,923 52,394 304,380 127,010 29,160 460,550 125,000 458,261 214,047 34,992 832,300 473,326 263,014 33,564 769,904 26,566 111,185 196,317 Long Term Debt (note 2) 115,840 80,848 78,899 Total Debt 26,566 111,185 196,317 576,390 913,148 848,803 Shareholders Equity Common Shares Retained earnings Total Owners Equity 40,000 6,008 46,008 40,000 71,751 111,751 40,000 232,813 272,813 40,000 488,389 528,389 40,000 358,328 398,328 40,000 807,171 847,171 72,574 222,936 469,130 1,104,779 1,311,476 1,695,974 Total Liabilities & Shareholders Equity 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 12,126.00 290,948.00 -314,603.00 52,002.00 104,295.00 143,883.00 320,282.00 11,791.00 15,654.00 -17,983.00 14,678.00 2,901.00 16,099.00 21,910.00 35,626.00 75,370.00 148,174.00 438,758.00 55,983.00 550,270.00 123,805.00 322.00 1,082.00 427,869.00 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 384,498.00 Current Liabilities Bank indebtedness Accounts payable Unearned/ deferred revenue Current portion long term der Total Current Liabilities 0.00 0.00 0.00 0.00 0.00 0.00 71,010.00 54,640.00 13,609.00 30,492.00 0.00 0.00 84,619.00 85,132.00 0.00 160,457.00 74,616.00 29,160.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 Retained earnings Total Owners Equity 0.00 0.00 0.00 0.00 0.00 65,743.00 161,062.00 65,743.00 161,062.00 0.00 255,576.00 255,576.00 0.00 -130,061.00 -130,061.00 0.00 448,844.00 448,844.00 0.00 150,362.00 246,194.00 Total Liabilities & Shareholders Equity 635,649.00 206,697.00 384,499.00 XYZ Inc. - Balance Sheet as of June 30, 2001 June 30/96 June 30/97 June 30/98 June 30/99 June 30/00 June 30/01 Current Assets Cash Accounts receivable Work in progress Prepaid Expenses Total Current assets 9,904 29,370 5,538 2,382 47,194 18,580 81,372 17,329 5,283 122,564 30,706 185,667 32,983 21,382 270,738 321,654 329,550 15,000 43,292 709,496 7,051 649,832 29,678 78,918 765,479 557,321 526,027 30,000 80,000 1,193,348 Capital Assets (note 1) Net capital assets 25,380 100,372 198,392 395,283 545,997 502,626 Total Assets 72,574 222,936 469,130 1,104,779 1,311,476 1,695,974 Current Liabilities Bank indebtedness Accounts payable Unearned/ deferred revenue Current portion long term debt Total Current Liabilities 18,273 8,293 89,283 21,902 143,923 52,394 304,380 127,010 29,160 460,550 125,000 458,261 214,047 34,992 832,300 473,326 263,014 33,564 769,904 26,566 111,185 196,317 Long Term Debt (note 2) 115,840 80,848 78,899 Total Debt 26,566 111,185 196,317 576,390 913,148 848,803 Shareholders Equity Common Shares Retained earnings Total Owners Equity 40,000 6,008 46,008 40,000 71,751 111,751 40,000 232,813 272,813 40,000 488,389 528,389 40,000 358,328 398,328 40,000 807,171 847,171 72,574 222,936 469,130 1,104,779 1,311,476 1,695,974 Total Liabilities & Shareholders Equity

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Assurance services an integrated approach

Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley

15th edition

978-0133125634, 9780133423815, 133125637, 133423816, 978-0133125689

More Books

Students also viewed these Accounting questions

Question

=+b) What would you recommend doing next to help improve the model?

Answered: 1 week ago