2017 1,061,500 702,670 358,830 2016 892,680 545,820 346,860 2015 972,840 589,200

Question

2017 1,061,500 702,670 358,830 2016 892,680 545,820 346,860 2015 972,840 589,200 383,640 2014 850,857 472,800 378,057 2013 784,200 435,600 348,600 Sales Cost of Goods Sold Gross Profit from Sales Operating Expenses Net Income 305,600 53,230 247,050 99,810 227,300 156,340 212,100 165,957 182,100 166,500 Additional selected data: 2014 2016 1,552,700 478,700 2015 1,522,700 452,600 2013 Total Assets Total Liabilities 2017 1,558,200 525,600 1,486,200 1,342,900 401,500 387,900 Required 1. Prepare a trend analysis using 2013 as the base year. (Round percentage to one decimal point) 2. Comment on favorable and unfavorable trends shown in the analysis

Explanation / Answer

1) Formula for % = (Current Year - Base Year) / Base Year

2) The Trends is Unfavorable as there is a decline in the net income in the year 2017

Particulars 2017 2016 2015 2014 2013 Sales 135.4 113.8 124.1 108.5 100 Less : Cost of Goods Sold 161.3 125.3 135.3 108.5 100 Gross Profit 102.9 99.5 110.1 108.5 100 Less : Operating Expenses 167.8 135.7 124.8 116.5 100 Net Income 31.9 59.9 93.9 99.7 100

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.