![Loose Leaf For Fundamental Accounting Principles Format: Loose-leaf](https://www.bartleby.com/isbn_cover_images/9781260158557/9781260158557_smallCoverImage.jpg)
Concept Introduction:
Financial Statement analysis is done using the components of financial statement. These components are
Requirement-1:
To Calculate:
Trend Percents for all components of both statements using 2013 as base year
![Check Mark](/static/check-mark.png)
Answer to Problem 1APSA
Trend Percents for all components of both statements using 2013 as base year are as follows:
HAROUN COMPANY | |||||||
Comparative Income Statement Trend % | |||||||
For the Years Ended December 31 | |||||||
$ thousands | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 |
Sales Trend % | 182.5% | 161.2% | 147.6% | 136.2% | 127.8% | 119.6% | 100.0% |
Cost of Goods Sold Trend % | 212.6% | 176.1% | 153.9% | 136.9% | 128.3% | 121.2% | 100.0% |
Gross profit Trend % | 131.0% | 135.7% | 136.8% | 135.1% | 126.9% | 117.0% | 100.0% |
Operating expenses Trend % | 279.7% | 216.9% | 198.3% | 144.1% | 123.7% | 122.0% | 100.0% |
Net income Trend % | 52.7% | 92.9% | 104.5% | 130.4% | 128.6% | 114.3% | 100.0% |
HAROUN COMPANY | |||||||
Comparative Year End Balance Sheet Trend % | |||||||
$ thousands | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 |
Assets: | |||||||
Cash Trend % | 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 Trend % | 298.9% | 221.8% | 195.8% | 167.8% | 152.2% | 131.7% | 100.0% |
Other Current assets Trend % | 400.0% | 355.6% | 155.6% | 377.8% | 311.1% | 311.1% | 100.0% |
Long term Investments Trend % | 0.0% | 0.0% | 0.0% | 100.0% | 100.0% | 100.0% | 100.0% |
Plant Assets, net Trend % | 278.6% | 277.8% | 241.7% | 130.2% | 134.9% | 118.6% | 100.0% |
Total Assets Trend % | 246.8% | 222.3% | 195.4% | 144.4% | 138.6% | 124.0% | 100.0% |
Liabilities and Equity: | |||||||
Current Liabilities Trend % | 432.6% | 369.5% | 254.6% | 324.1% | 193.6% | 185.1% | 100.0% |
Long term liabilities Trend % | 323.5% | 285.0% | 278.0% | 142.5% | 145.0% | 155.0% | 100.0% |
Common Stock Trend % | 153.8% | 153.8% | 153.8% | 130.8% | 130.8% | 100.0% | 100.0% |
Other Paid in capital Trend % | 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 Trend % | 246.8% | 222.3% | 195.4% | 144.4% | 138.6% | 124.0% | 100.0% |
Explanation of Solution
Trend Percents for all components of both statements using 2013 as base year are calculated as follows:
HAROUN COMPANY | |||||||
Comparative Income Statement Trend % | |||||||
For the Years Ended December 31 | |||||||
$ thousands | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 |
Sales | 1694 | 1496 | 1370 | 1264 | 1186 | 1110 | 928 |
Sales Trend % | 182.5% | 161.2% | 147.6% | 136.2% | 127.8% | 119.6% | 100.0% |
Cost of Goods Sold | 1246 | 1032 | 902 | 802 | 752 | 710 | 586 |
Cost of Goods Sold Trend % | 212.6% | 176.1% | 153.9% | 136.9% | 128.3% | 121.2% | 100.0% |
Gross profit | 448 | 464 | 468 | 462 | 434 | 400 | 342 |
Gross profit Trend % | 131.0% | 135.7% | 136.8% | 135.1% | 126.9% | 117.0% | 100.0% |
Operating expenses | 330 | 256 | 234 | 170 | 146 | 144 | 118 |
Operating expenses Trend % | 279.7% | 216.9% | 198.3% | 144.1% | 123.7% | 122.0% | 100.0% |
Net income | 118 | 208 | 234 | 292 | 288 | 256 | 224 |
Net income Trend % | 52.7% | 92.9% | 104.5% | 130.4% | 128.6% | 114.3% | 100.0% |
HAROUN COMPANY | |||||||
Comparative Year End Balance Sheet Trend % | |||||||
$ thousands | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 |
Assets: | |||||||
Cash | 58 | 78 | 82 | 84 | 88 | 86 | 89 |
Cash Trend % | 65.2% | 87.6% | 92.1% | 94.4% | 98.9% | 96.6% | 100.0% |
Accounts Receivable, net | 490 | 514 | 466 | 360 | 318 | 302 | 216 |
Accounts Receivable, net Trend % | 226.9% | 238.0% | 215.7% | 166.7% | 147.2% | 139.8% | 100.0% |
Merchandise Inventory | 1838 | 1364 | 1204 | 1032 | 936 | 810 | 615 |
Merchandise Inventory Trend % | 298.9% | 221.8% | 195.8% | 167.8% | 152.2% | 131.7% | 100.0% |
Other Current assets | 36 | 32 | 14 | 34 | 28 | 28 | 9 |
Other Current assets Trend % | 400.0% | 355.6% | 155.6% | 377.8% | 311.1% | 311.1% | 100.0% |
Long term Investments | 0 | 0 | 0 | 146 | 146 | 146 | 146 |
Long term Investments Trend % | 0.0% | 0.0% | 0.0% | 100.0% | 100.0% | 100.0% | 100.0% |
Plant Assets, net | 2020 | 2014 | 1752 | 944 | 978 | 860 | 725 |
Plant Assets, net Trend % | 278.6% | 277.8% | 241.7% | 130.2% | 134.9% | 118.6% | 100.0% |
Total Assets | 4442 | 4002 | 3518 | 2600 | 2494 | 2232 | 1800 |
Total Assets Trend % | 246.8% | 222.3% | 195.4% | 144.4% | 138.6% | 124.0% | 100.0% |
Liabilities and Equity: | |||||||
Current Liabilities | 1220 | 1042 | 718 | 914 | 546 | 522 | 282 |
Current Liabilities Trend % | 432.6% | 369.5% | 254.6% | 324.1% | 193.6% | 185.1% | 100.0% |
Long term liabilities | 1294 | 1140 | 1112 | 570 | 580 | 620 | 400 |
Long term liabilities Trend % | 323.5% | 285.0% | 278.0% | 142.5% | 145.0% | 155.0% | 100.0% |
Common Stock | 1000 | 1000 | 1000 | 850 | 850 | 650 | 650 |
Common Stock Trend % | 153.8% | 153.8% | 153.8% | 130.8% | 130.8% | 100.0% | 100.0% |
Other Paid in capital | 250 | 250 | 250 | 170 | 170 | 150 | 150 |
Other Paid in capital Trend % | 166.7% | 166.7% | 166.7% | 113.3% | 113.3% | 100.0% | 100.0% |
Retained earnings | 678 | 570 | 438 | 396 | 348 | 290 | 318 |
Retained earnings Trend % | 213.2% | 179.2% | 137.7% | 124.5% | 109.4% | 91.2% | 100.0% |
Total Liabilities and equity | 4442 | 4002 | 3518 | 2600 | 2494 | 2232 | 1800 |
Total Liabilities and equity Trend % | 246.8% | 222.3% | 195.4% | 144.4% | 138.6% | 124.0% | 100.0% |
Concept Introduction:
Financial Statement analysis is done using the components of financial statement. These components are Balance sheet, Income statement, Statement of Cash flows etc. Annual report of a company contains financial statement of that year and previous year for comparison. If the company has subsidiaries or segments, the financial statement shall be consolidated for whole business of the company.
Requirement-2:
To Indicate:
- If sales grow steadily over this period
- If net income as grow over the past years
- If inventory increased over this period
![Check Mark](/static/check-mark.png)
Answer to Problem 1APSA
- Sales grew steadily over this period
- Net income did not grow over the past years
- Inventory has increased over this period
Explanation of Solution
The explanation for each trend is shows as below:
$ thousands | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 |
Sales Trend % | 182.5% | 161.2% | 147.6% | 136.2% | 127.8% | 119.6% | 100.0% |
$ thousands | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 |
Net income Trend % | 52.7% | 92.9% | 104.5% | 130.4% | 128.6% | 114.3% | 100.0% |
$ thousands | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 |
Merchandise Inventory Trend % | 298.9% | 221.8% | 195.8% | 167.8% | 152.2% | 131.7% | 100.0% |
Hence,
- Sales grew steadily over this period
- Net income did not grow over the past years
- Inventory has increased over this period
Want to see more full solutions like this?
Chapter 17 Solutions
Loose Leaf For Fundamental Accounting Principles Format: Loose-leaf
- Give this question financial accountingarrow_forward1.3 1.2.5 za When using a computerised accounting system, the paper work will be reduced in the organisation. Calculate the omitting figures: Enter only the answer next to the question number (1.3.1-1.3.5) in the NOTE. Round off to TWO decimals. VAT report of Comfy shoes as at 30 April 2021 OUTPUT TAX INPUT TAX NETT TAX Tax Gross Tax(15%) Gross (15%) Standard 75 614,04 1.3.1 Capital 1.3.2 9 893,36 94 924,94 Tax (15%) 1.3.3 Gross 484 782,70 75 849,08 -9 893,36 -75 849,08 Bad Debts TOTAL 1.3.4 4 400,00 1 922,27 14 737,42 -1 348,36 1.3.5 (5 x 2) (10arrow_forwardNonearrow_forward
- What was her capital gains yield? General accountingarrow_forwardL.L. Bean operates two factories that produce its popular Bean boots (also known as "duck boots") in its home state of Maine. Since L.L. Bean prides itself on manufacturing its boots in Maine and not outsourcing, backorders for its boots can be high. In 2014, L.L. Bean sold about 450,000 pairs of the boots. At one point during 2014, it had a backorder level of about 100,000 pairs of boots. L.L. Bean can manufacture about 2,200 pairs of its duck boots each day with its factories running 24/7. In 2015, L.L. Bean expects to sell more than 500,000 pairs of its duck boots. As of late November 2015, the backorder quantity for Bean Boots was estimated to be about 50,000 pairs. Question:arrow_forwardWhat was her capital gains yield?arrow_forward
- 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
![Text book image](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)