Account Assets: Able Corporation Condensed Balance Sheets 31-Dec Current Assets Property, Plant & Equipment Intangibles Total...

Transcribed Image Text:

Account Assets: Able Corporation Condensed Balance Sheets 31-Dec Current Assets Property, Plant & Equipment Intangibles Total Assets Liabilities & Stockholder's Equity Current Liabilities Long-term Liabilities Stockholders' Equity Total Liabilities & Stockholder's Equity Balance 2017 72,000 95,400 33,600 201,000 40,320 142,500 18,180 201,000 2016 80,000 90,000 40,000 210,000 48,000 150,000 12,000 210,000 I. Prepare a trend analysis of the balance sheet data for Able Corp. using 2016 as a base - in Excel II. Prepare a common size analysis of the balance sheer for Able Corp in columnar format for 2016 - in E Account Assets: Able Corporation Condensed Balance Sheets 31-Dec Current Assets Property, Plant & Equipment Intangibles Total Assets Liabilities & Stockholder's Equity Current Liabilities Long-term Liabilities Stockholders' Equity Total Liabilities & Stockholder's Equity Balance 2017 72,000 95,400 33,600 201,000 40,320 142,500 18,180 201,000 2016 80,000 90,000 40,000 210,000 48,000 150,000 12,000 210,000 I. Prepare a trend analysis of the balance sheet data for Able Corp. using 2016 as a base - in Excel II. Prepare a common size analysis of the balance sheer for Able Corp in columnar format for 2016 - in E