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
FUNDAMENTAL ACCT PRIN CONNECT ACCESS
- I want to correct answer general accounting questionarrow_forwardGive me answer general accounting questionarrow_forward1: Armand Giroux (single; 0 federal withholding allowances) earned weekly gross pay of $1,500. For each period, he makes a 401(k) retirement plan contribution of 8% of gross pay. The city in which he works (he lives elsewhere) levies a tax of 1% of an employee's taxable pay (which is the same for federal and local income tax withholding) on residents and 0.60% of an employee's taxable pay on nonresidents. Federal income tax withholding = $ State income tax withholding = $ Local income tax withholding = $ 144.10 69.00 8.28 2: Peter Quigley (married; 8 federal withholding allowances) earned weekly gross pay of $2,350. He contributed $100 to a flexible spending account during the period. The city in which he lives and works levies a tax of 2.7% of an employee's taxable pay (which is the same for federal and local income tax withholding) on residents and 1.9% of an employee's taxable pay on nonresidents. Federal income tax withholding = $ State income tax withholding = $ Local income tax…arrow_forward
- Check my work mode: This sh so hat is correct or incorrect for the work you have compl it does not indicate completion. Return to questi 1.5 9 points You've collected the following information about Fender, Incorporated: Sales Net income Dividends Total debt Total equity $ 170,000 $ 12,800 $ 8,400 $ 68,000 $ 56,000 a. What is the sustainable growth rate for the company? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. b. If it does grow at this rate, how much new borrowing will take place in the coming year, assuming a constant debt-equity ratio? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. c. What growth rate could be supported with no outside financing at all? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. × Answer is complete but not entirely correct. a. Sustainable growth rate b.…arrow_forwardOn December 31, 2018, Blackpink Company, a financing institution lent ₱15,000,000 to YG Corp. due 3 years after. The loan is supported by an 12% note receivable. Based on the company’s initial estimates the present value of the 12 months expected credit loss (ECL) discounted at 10% is at 2,000,000. The probability of default (PD) is at 7%. Blackpink Company was able to collect interest as it became due at the end of 2019. There was no evidence of significant increase in credit risk by the end 2019 and that the receivable is determined to have “low credit risk”. There were no changes in its initial estimate of the 12 months expected credit loss either. By the end of 2020, Blackpink Company was able to collect interest as it became due. Based on available forward-looking information (determinable without undue cost or effort), however, there is evidence that there was a significant increase in credit risk by the end of 2020. Blackpink Company therefore had to change its basis…arrow_forwardOn December 31, 2018, Blackpink Company, a financing institution lent ₱15,000,000 to YG Corp. due 3 years after. The loan is supported by an 12% note receivable. Based on the company’s initial estimates the present value of the 12 months expected credit loss (ECL) discounted at 10% is at 2,000,000. The probability of default (PD) is at 7%. Blackpink Company was able to collect interest as it became due at the end of 2019. There was no evidence of significant increase in credit risk by the end 2019 and that the receivable is determined to have “low credit risk”. There were no changes in its initial estimate of the 12 months expected credit loss either. By the end of 2020, Blackpink Company was able to collect interest as it became due. Based on available forward-looking information (determinable without undue cost or effort), however, there is evidence that there was a significant increase in credit risk by the end of 2020. Blackpink Company therefore had to change its basis…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)