FUNDAMENTAL ACCT PRIN TEXT+CONNECT CODE
15th Edition
ISBN: 9781265564483
Author: Wild
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 17, Problem 1APSA
Requirement-1:
To determine
To calculate: The trend analysis for income statements and
Requirement-1:
Expert Solution

Answer to Problem 1APSA
Solution: The trend analysis for income statements and balance sheet is as follows:
HAROUN COMPANY | |||||||
Comparative Income Statements Trend analysis | |||||||
2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | |
Sales | 182.5% | 161.2% | 147.6% | 136.2% | 127.8% | 119.6% | 100.0% |
Cost of Goods Sold | 212.6% | 176.1% | 153.9% | 136.9% | 128.3% | 121.2% | 100.0% |
Gross Profit | 131.0% | 135.7% | 136.8% | 135.1% | 126.9% | 117.0% | 100.0% |
Operating Expenses | 279.7% | 216.9% | 198.3% | 144.1% | 123.7% | 122.0% | 100.0% |
Net Income | 52.7% | 92.9% | 104.5% | 130.4% | 128.6% | 114.3% | 100.0% |
HAROUN COMPANY | |||||||
Comparative Balance Sheets Trend analysis | |||||||
2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | |
Assets: | |||||||
Cash (A) | 65.2% | 87.6% | 92.1% | 94.4% | 98.9% | 96.6% | 100.0% |
226.9% | 238.0% | 215.7% | 166.7% | 147.2% | 139.8% | 100.0% | |
Merchandise Inventory (C) | 298.9% | 221.8% | 195.8% | 167.8% | 152.2% | 131.7% | 100.0% |
Other Current Assets (D) | 400.0% | 355.6% | 155.6% | 377.8% | 311.1% | 311.1% | 100.0% |
Long Term Investments (E) | 0.0% | 0.0% | 0.0% | 100.0% | 100.0% | 100.0% | 100.0% |
Plant assets, net (F) | 278.6% | 277.8% | 241.7% | 130.2% | 134.9% | 118.6% | 100.0% |
Total Assets (G) | 246.8% | 222.3% | 195.4% | 144.4% | 138.6% | 124.0% | 100.0% |
Liabilities and Equity: | |||||||
Current Liabilities (H) | 432.6% | 369.5% | 254.6% | 217.7% | 193.6% | 185.1% | 100.0% |
Long term Liabilities (I) | 323.5% | 285.0% | 278.0% | 142.5% | 145.0% | 155.0% | 100.0% |
Common Stock (J) | 153.8% | 153.8% | 153.8% | 130.8% | 130.8% | 100.0% | 100.0% |
Other paid in capital (K) | 166.7% | 166.7% | 166.7% | 113.3% | 113.3% | 100.0% | 100.0% |
213.2% | 179.2% | 137.7% | 124.5% | 109.4% | 91.2% | 100.0% | |
Total Liabilities and Equity (M) | 246.8% | 222.3% | 195.4% | 144.4% | 138.6% | 124.0% | 100.0% |
Explanation of Solution
The trend analysis for income statements and balance sheet is explained as follows:
HAROUN COMPANY | |||||||
Comparative Income Statements Trend analysis | |||||||
($ thousands) | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 |
Sales (A) | 1694 | 1496 | 1370 | 1264 | 1186 | 1110 | 928 |
Trend % = A / 928 | 182.5% | 161.2% | 147.6% | 136.2% | 127.8% | 119.6% | 100.0% |
Cost of Goods Sold (B) | 1246 | 1032 | 902 | 802 | 752 | 710 | 586 |
Trend % = B / 586 | 212.6% | 176.1% | 153.9% | 136.9% | 128.3% | 121.2% | 100.0% |
Gross Profit (C) | 448 | 464 | 468 | 462 | 434 | 400 | 342 |
Trend % = C / 342 | 131.0% | 135.7% | 136.8% | 135.1% | 126.9% | 117.0% | 100.0% |
Operating Expenses (D) | 330 | 256 | 234 | 170 | 146 | 144 | 118 |
Trend % = D / 118 | 279.7% | 216.9% | 198.3% | 144.1% | 123.7% | 122.0% | 100.0% |
Net Income (E) | 118 | 208 | 234 | 292 | 288 | 256 | 224 |
Trend % = E / 224 | 52.7% | 92.9% | 104.5% | 130.4% | 128.6% | 114.3% | 100.0% |
HAROUN COMPANY | |||||||
Comparative Balance Sheets Trend analysis | |||||||
($ thousands) | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 |
Assets: | |||||||
Cash (A) | 58 | 78 | 82 | 84 | 88 | 86 | 89 |
Trend % = A / 89 | 65.2% | 87.6% | 92.1% | 94.4% | 98.9% | 96.6% | 100.0% |
Accounts receivables, net (B) | 490 | 514 | 466 | 360 | 318 | 302 | 216 |
Trend % = B / 216 | 226.9% | 238.0% | 215.7% | 166.7% | 147.2% | 139.8% | 100.0% |
Merchandise Inventory (C) | 1838 | 1364 | 1204 | 1032 | 936 | 810 | 615 |
Trend % = C / 615 | 298.9% | 221.8% | 195.8% | 167.8% | 152.2% | 131.7% | 100.0% |
Other Current Assets (D) | 36 | 32 | 14 | 34 | 28 | 28 | 9 |
Trend % = D / 9 | 400.0% | 355.6% | 155.6% | 377.8% | 311.1% | 311.1% | 100.0% |
Long Term Investments (E) | 0 | 0 | 0 | 146 | 146 | 146 | 146 |
Trend % = E / 146 | 0.0% | 0.0% | 0.0% | 100.0% | 100.0% | 100.0% | 100.0% |
Plant assets, net (F) | 2020 | 2014 | 1752 | 944 | 978 | 860 | 725 |
Trend % = F / 725 | 278.6% | 277.8% | 241.7% | 130.2% | 134.9% | 118.6% | 100.0% |
Total Assets (G) | 4442 | 4002 | 3518 | 2600 | 2494 | 2232 | 1800 |
Trend % = G / 1805 | 246.8% | 222.3% | 195.4% | 144.4% | 138.6% | 124.0% | 100.0% |
Liabilities and Equity: | |||||||
Current Liabilities (H) | 1220 | 1042 | 718 | 614 | 546 | 522 | 282 |
Trend % = H / 282 | 432.6% | 369.5% | 254.6% | 217.7% | 193.6% | 185.1% | 100.0% |
Long term Liabilities (I) | 1294 | 1140 | 1112 | 570 | 580 | 620 | 400 |
Trend % = I / 400 | 323.5% | 285.0% | 278.0% | 142.5% | 145.0% | 155.0% | 100.0% |
Common Stock (J) | 1000 | 1000 | 1000 | 850 | 850 | 650 | 650 |
Trend % = J / 650 | 153.8% | 153.8% | 153.8% | 130.8% | 130.8% | 100.0% | 100.0% |
Other paid in capital (K) | 250 | 250 | 250 | 170 | 170 | 150 | 150 |
Trend % = K / 150 | 166.7% | 166.7% | 166.7% | 113.3% | 113.3% | 100.0% | 100.0% |
Retained Earnings (L) | 678 | 570 | 438 | 396 | 348 | 290 | 318 |
Trend % = L / 318 | 213.2% | 179.2% | 137.7% | 124.5% | 109.4% | 91.2% | 100.0% |
Total Liabilities and Equity (M) | 4442 | 4002 | 3518 | 2600 | 2494 | 2232 | 1800 |
Trend % = M / 1804 | 246.8% | 222.3% | 195.4% | 144.4% | 138.6% | 124.0% | 100.0% |
Conclusion
Hence, Horizontal Analysis is used to analyses the trend of a particular item of a statement.
Requirement-2:
To determine
To analyze: The trends of the financial statements
Requirement-2:
Expert Solution

Answer to Problem 1APSA
Solution: The Analysis of trends of the financial statements is as follows:
- Income Statement shows the increasing trend for sales revenues during the years and mix trend for the net income.
- Balance sheet shows the Increasing trend for total assets.
Explanation of Solution
The Analysis of trends of the financial statements is explained as follows:
- Income Statement shows the increasing trend for sales revenues during the years and mix trend for the net income. The net income shows the increasing trend from year 2009 to 2012 but a decreasing trend from year 2012 to 2015.
- Balance sheet shows the Increasing trend for total assets from the year 2009 to 2015.
Conclusion
Hence, Horizontal Analysis is used to analyses the trend of a particular item of a statement.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Please give me answer with accounting
Please give me true answer this financial accounting question
Calculate the actual variable overhead
Chapter 17 Solutions
FUNDAMENTAL ACCT PRIN TEXT+CONNECT CODE
Ch. 17 - Prob. 1DQCh. 17 - What is the difference between comparative...Ch. 17 - Prob. 3DQCh. 17 - Prob. 4DQCh. 17 - Prob. 5DQCh. 17 - Prob. 6DQCh. 17 - Prob. 7DQCh. 17 - Prob. 8DQCh. 17 - Prob. 9DQCh. 17 - How does inventory turnover provide information...
Ch. 17 - What ratios would you compute to evaluate...Ch. 17 - Why would a company’s return on total assets be...Ch. 17 - Prob. 13DQCh. 17 - Prob. 14DQCh. 17 - Prob. 15DQCh. 17 - Prob. 16DQCh. 17 - Prob. 17DQCh. 17 - Prob. 1QSCh. 17 - Prob. 2QSCh. 17 - Prob. 3QSCh. 17 - Prob. 4QSCh. 17 - Refer to the information in QS17-4. Use that...Ch. 17 - Prob. 6QSCh. 17 - Prob. 7QSCh. 17 - Prob. 8QSCh. 17 - Prob. 9QSCh. 17 - Prob. 1ECh. 17 - Exercise 17-2
Identifying financial...Ch. 17 - Prob. 3ECh. 17 - Prob. 4ECh. 17 - Prob. 5ECh. 17 - Prob. 6ECh. 17 - Prob. 7ECh. 17 - Prob. 8ECh. 17 - Prob. 9ECh. 17 - Prob. 10ECh. 17 - Prob. 11ECh. 17 - Prob. 12ECh. 17 - Prob. 13ECh. 17 - Prob. 14ECh. 17 - Prob. 15ECh. 17 - Prob. 1APSACh. 17 - Prob. 2APSACh. 17 - Prob. 3APSACh. 17 - Prob. 4APSACh. 17 - Prob. 5APSACh. 17 - Prob. 6APSACh. 17 - Prob. 1BPSBCh. 17 - Prob. 2BPSBCh. 17 - Prob. 3BPSBCh. 17 - Prob. 4BPSBCh. 17 - Prob. 5BPSBCh. 17 - Prob. 6BPSBCh. 17 - Prob. 17SPCh. 17 - Prob. 1BTNCh. 17 - Prob. 2BTNCh. 17 - Prob. 3BTNCh. 17 - Prob. 4BTNCh. 17 - Prob. 5BTNCh. 17 - Prob. 6BTNCh. 17 - Prob. 7BTNCh. 17 - Prob. 8BTNCh. 17 - Prob. 9BTN
Knowledge Booster
Similar questions
- The Work in Process inventory account of a manufacturing firm shows a balance of $4,200 at the end of the accounting period. The job cost sheets of two uncompleted jobs show charges of $700 and $600 for materials, and charges of $800 and $900 for direct labor. From this information, it appears that the company is using a predetermined overhead rate, as a percentage of direct labor costs, of _. a) 100% b) 70.6% c) 120% d) 60.8% helparrow_forwardFinancial Accountingarrow_forwardThe ending balance of the direct materials?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education