Question: (i) Perform both a Vertical and Horizontal Trend analysis on the following Income Statement. 2016 2015 Sales 1,300,000 1,250,000 Cost of Goods Sold 950,000 925,000

(i) Perform both a Vertical and Horizontal Trend analysis on the following Income Statement.

2016 2015
Sales 1,300,000 1,250,000
Cost of Goods Sold 950,000 925,000
Gross Profit 350,000 325,000
Marketing Expense 17,000 23,000
Insurance Expense 25,000 33,000
Depreciation expense 75,000 75,000
Total Operating Expenses 117,000 131,000
Income from operations (EBIT) 233,000 194,000
Interest expense 175,000 125,000
Income before taxes (EBT) 58,000 69,000
Income taxes 23,200 27,600
Net Income 34,800 41,400

(ii) Calculate the following Ratios and comment on whether the ratio has gotten better or worse in 2016 vs 2015.

Current Ratio
Quick Ratio
Debt to Assets
Times Int Earned
Avg Collection
Inventory Turn
Profit Margin
Return on Assets
Return on Equity

2016 2015
Current Assets 37,618 93,457
Current Liabilities 31,987 35,563
Inventory 4,673 17,899
Total Debt 44,274 42,979
Total Assets 285,198 41,988
EBIT 49,662 10,282
Interest Expenses 14,235 580
Accounts Receivable 14,214 15,533
Sales 288,137 280,515
COGS 11,925 11,676
Profit 40,620 45,335
Total Equity 57,098 90,010

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!