Executive Summary reflection

profileASK-18
Balancesheet.xlsx
Home>Business & Finance homework help>Accounting homework help> Executive Summary reflection

Sheet1

XYZ Inc. - Balance Sheet as of June 30, 2001 Horizontal analysis
June 30/96 June 30/97 June 30/98 June 30/99 June 30/00 June 30/01 June 30/96 June 30/97 June 30/98 June 30/99 June 30/00 June 30/01
Current Assets Current Assets
Cash 9,904 18,580 30,706 321,654 7,051 557,321 Cash 88% 210% 3148% -29% 5527%
Accounts receivable 29,370 81,372 185,667 329,550 649,832 526,027 Accounts receivable 177% 532% 1022% 2113% 1691%
Work in progress 5,538 17,329 32,983 15,000 29,678 30,000 Work in progress 213% 496% 171% 436% 442%
Prepaid Expenses 2,382 5,283 21,382 43,292 78,918 80,000 Prepaid Expenses 122% 798% 1717% 3213% 3259%
Total Current assets 47,194 122,564 270,738 709,496 765,479 1,193,348 Total Current assets 160% 474% 1403% 1522% 2429%
Capital Assets (note 1) Capital Assets (note 1)
Net capital assets 25,380 100,372 198,392 395,283 545,997 502,626 Net capital assets 295% 682% 1457% 2051% 1880%
Total Assets 72,574 222,936 469,130 1,104,779 1,311,476 1,695,974 Total Assets 207% 546% 1422% 1707% 2237%
Current Liabilities Current Liabilities
Bank indebtedness 125,000 Bank indebtedness -100%
Accounts payable 18,273 89,283 143,923 304,380 458,261 473,326 Accounts payable 389% 688% 1566% 2408% 2490%
Unearned/ deferred revenue 8,293 21,902 52,394 127,010 214,047 263,014 Unearned/ deferred revenue 164% 532% 1432% 2481% 3072%
Current portion long term debt 29,160 34,992 33,564 Current portion long term debt 20% 15%
Total Current Liabilities 26,566 111,185 196,317 460,550 832,300 769,904 Total Current Liabilities 319% 639% 1634% 3033% 2798%
Long Term Debt (note 2) 115,840 80,848 78,899 Long Term Debt (note 2) -30% -32%
Total Debt 26,566 111,185 196,317 576,390 913,148 848,803 Total Debt 319% 639% 2070% 3337% 3095%
Shareholders Equity Shareholders Equity
Common Shares 40,000 40,000 40,000 40,000 40,000 40,000 Common Shares 0% 0% 0% 0% 0%
Retained earnings 6,008 71,751 232,813 488,389 358,328 807,171 Retained earnings 1094% 3775% 8029% 5864% 13335%
Total Owners Equity 46,008 111,751 272,813 528,389 398,328 847,171 Total Owners Equity 143% 493% 1048% 766% 1741%
Total Liabilities & 72,574 222,936 469,130 1,104,779 1,311,476 1,695,974 Total Liabilities & 207% 546% 1422% 1707% 2237%
Shareholders Equity Shareholders Equity
TEAM ASSIGNMENT
Analyze it using the ratios analysis and prepare a report to the instructor using the following format:
1. Executive Summary to reflect what has been done, and what was observed from the research and analysis
2. Ratio Analysis to reflect the analysis of the figures in the financial statements using financial ratios, cash flow analysis, and trend analysis
3. Your understanding of the company's financial situation