Use Apple’s financial statements in Appendix A to answer the following.
- Using fiscal 2015 as the base year, compute trend percents for fiscal years 2015, 2016, and 2017 for net sales, cost of sales, operating income, other income (expense) net, provision for income taxes, and net income. Round percents to one decimal.
- Compute common-sizepercents for fiscal years 2016 and 2017 for the following categories of assets: (a) total current assets; (b) property, plant and equipment, net; and (c)
goodwill plus acquired intangible assets, net. Round percents to one decimal. - Using current assets as a percent of total assets to measure liquidity, did Apple’s asset makeup become more liquid or less liquid in 2017?
Trend percents:
A horizontal form of analysis which reveals a pattern in data across successive period is known as trend percents. In this analysis items are expressed as a percentage of a base year and items are taken line by line.
Common size percents:
Common size percent is the percent of each account expressed as a percentage of the sales value.
1.
To compute: Year 2013, 2014 and 2015 trend percents for net sales, cost of sales, operating income, other income(expense)net, provision for income taxes and net income of A Company by using 2013 as base year.
Explanation of Solution
To compute trend percents, base amount is required firstly. Base amount is an amount which is predecided.
Formula to calculate trend percent is:
Trend percents are shown below:
Particulars | 2015(%) | 2014(%) | 2013(%) |
Net sales | 136.75 | 106.95 | 100 |
Cost of sales | 131.41 | 105.30 | 100 |
Operating income | 145.37 | 107.15 | 100 |
Other income (expense) net | 111.16 | 84.78 | 100 |
Provision for income taxes | 145.76 | 106.52 | 100 |
Net income | 144.16 | 106.68 | 100 |
Working Notes:
Trend percents for Sales:
Trend percents for Cost of sales:
Trend percents for operating income:
Trend percents for other income (expense) net:
Trend percents for provision for income tax:
Trend percents for net income:
Thus, Except other income (expenses). All other items show increased percents in every year.
2.
To compute: Common size percent of (a) total current assets (b) property, plant and equipment, net and (c) goodwill plus acquired tangible assets, net for A Company for the year 2014 and 2015.
Explanation of Solution
Formula to calculate common size percent is:
Common size percents are shown below:
Particulars | 2015(%) | 2014(%) |
(a) Total current assets | 30.77 | 29.56 |
(b) Property, plant and equipment, net | 7.74 | 8.9 |
(c) Goodwill plus acquired intangible assets, net | 3.10 | 3.78 |
Working notes:
(a) Common size percents of total current assets:
(b) Common size percents of property, plant and equipment, net:
(c) Common size percents of goodwill plus acquired intangible assets, net:
3.
To explain: Changes across the year for the income statement trends computed in part 1 and the balance sheet percents computed in part 2.
Explanation of Solution
- Trend percents of income statement items represent an increased trend. Such as net sales trend percent is 136.75 in the year 2015 and 106.95 in the 2014 same has been increases with 29.8 (136.75-106.95).
- Only other income is reduced in 2014, all other income statement trends show increased numbers.
- Common size percent of balance sheet items shows increase in the current assets of the company. For example total current assets of the company have been increased to 30.77% in 2015 year from 29.56% in 2014.
- Other assets marginaly reduced in 2015 as a percentage of total assets.
Thus, A Company works quite efficiently.
Want to see more full solutions like this?
Chapter 13 Solutions
Gen Combo Ll Financial Accounting Fundamentals; Connect Access Card
- The following select account data is taken from the records of Reese Industries for 2019. A. Use the data provided to compute net sales for 2019. B. Prepare a simple income statement for the year ended December 31, 2019. C. Compute the gross margin for 2019. D. Prepare a multi-step income statement for the year ended December 31, 2019.arrow_forwardFinancial statement data for years ending December 31 for Latchkey Company follows: a. Determine the ratio of sales to assets for 2016 and 2015. b. Does the change in the ratio of sales to assets from 2015 to 2016 indicate a favorable or an unfavorable trend?arrow_forwardThe condensed income statements through income from operations for Dell Inc. and Apple Inc. for recent fiscal years follow (numbers in millions of dollars): Prepare comparative common-sized statements, rounding percents to one decimal place. Interpret the analyses.arrow_forward
- The following data (in millions) are taken from recent financial statements of Nike Inc.: a. Determine the amount of change (in millions) and percent of change in net income for Year 2. Round to one decimal place. b. Determine the percentage relationship between net income and net sales (net income divided by net sales) for Year 2 and Year 1. Round to one decimal place. c. What conclusions can you draw from your analysis?arrow_forwardFinancial Statement Analysis The financial statements for Nike, Inc., are presented in Appendix C at the end of the text. The following additional information (in thousands) is available: Instructions 1. Determine the following measures for the fiscal years ended May 31, 2013 (fiscal 2012), and May 31, 2012 (fiscal 2011), rounding to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory h. Ratio of liabilities to stockholders equity i. Ratio of sales to assets j. Rate earned on total assets, assuming interest expense is 23 million for the year ending May 31, 2013, and 31 million for the year ending May 31, 2012 k. Rate earned on common stockholders equity l. Price-earnings ratio, assuming that the market price was 61.66 per share on May 31, 2013, and 53.10 per share on May 31, 2012 m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forwardReal-world annual report The financial statements for Nike, Inc. (NKE), are presented in Appendix E at the end of the text. The following additional information is available (in thousands): Instructions 1. Determine the following measures for the fiscal years ended May 31, 2017, and May 31, 2016. Round ratios and percentages to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory' h. Ratio of liabilities to stockholders equity i. Asset turnover j. Return on total assets, assuming interest expense is 82 million for the year ending May 31. 2017, and 33 million for the year ending May 31, 2016. k. k. Return on common stockholders equity l. Price-eamings ratio, assuming that the market price was 52.81 per share on May 31, 2017, and 54.35 per share on May 31, 2016. m. m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forward
- Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning