Able Corporation
Condensed Balance Sheets
31-Dec
Account
Assets:
Current Assets
Balance
2017
2016
72,000
80,000
Property, Plant & Equipment
95,400
90,000
Intangibles
33,600
40,000
Total Assets
201,000
210,000
Liabilities & Stockholder's Equity
Current Liabilities
40,320
48,000
Long-term Liabilities
142,500
150,000
Stockholders' Equity
18,180
12,000
Total Liabilities & Stockholder's Equity
201,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