Loose Leaf for Financial Accounting: Information for Decisions
9th Edition
ISBN: 9781260158762
Author: John J Wild
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 13, Problem 3E
Summary Introduction
Concept Introduction:
Horizontal analysis is one of the techniques of financial statement analysis. This analysis is used to evaluate the changes in the amount of financial statements over a period of time. The trend is calculated in the amount as well as in percentage taking the previous period as the basis.
To calculate:the trend % for the given accounts.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Perform an index number trend analysis for all the reported items. Using the year 2018 as the base year.
Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.
Sales
$ 666,761
$ 432,962
$ 344,990
$ 249,090
$ 180,500
Cost of goods sold
329,263
213,901
172,445
124,054
88,445
Accounts receivable
32,138
25,242
23,632
14,547
12,328
Use the statements to calculate trend percentages for all components of both statements using 2013 as the base year and summarizing your findings about the financial health of the company, using the calculations as evidence to support your conclusions.
Chapter 13 Solutions
Loose Leaf for Financial Accounting: Information for Decisions
Ch. 13 - Explain the difference between financial reporting...Ch. 13 - Prob. 2DQCh. 13 - Prob. 3DQCh. 13 - Prob. 4DQCh. 13 - Prob. 5DQCh. 13 - Prob. 6DQCh. 13 - Prob. 7DQCh. 13 - Prob. 8DQCh. 13 - Prob. 9DQCh. 13 - Prob. 10DQ
Ch. 13 - Prob. 11DQCh. 13 - Prob. 12DQCh. 13 - Prob. 13DQCh. 13 - Prob. 14DQCh. 13 - Prob. 15DQCh. 13 - Prob. 16DQCh. 13 - Prob. 17DQCh. 13 - Prob. 1QSCh. 13 - Prob. 2QSCh. 13 - Prob. 3QSCh. 13 - Prob. 4QSCh. 13 - Prob. 5QSCh. 13 - Prob. 6QSCh. 13 - Prob. 7QSCh. 13 - Prob. 8QSCh. 13 - Which of the following gains or losses would...Ch. 13 - Prob. 1ECh. 13 - Prob. 2ECh. 13 - Prob. 3ECh. 13 - Prob. 4ECh. 13 - Prob. 5ECh. 13 - Prob. 6ECh. 13 - Prob. 7ECh. 13 - Prob. 10ECh. 13 - Prob. 12ECh. 13 - Prob. 13ECh. 13 - Prob. 14ECh. 13 - Prob. 15ECh. 13 - Prob. 16ECh. 13 - Prob. 1PSACh. 13 - Prob. 2PSACh. 13 - Prob. 3PSACh. 13 - Prob. 5PSACh. 13 - Prob. 6PSACh. 13 - Selected comparative financial statements of...Ch. 13 - Prob. 2PSBCh. 13 - Prob. 3PSBCh. 13 - Prob. 5PSBCh. 13 - Prob. 6PSBCh. 13 - Prob. 13SPCh. 13 - Prob. 2FSACh. 13 - Prob. 3FSACh. 13 - Prob. 1BTNCh. 13 - Prob. 5BTN
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Compute trend percent for the following accounts using 2018 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percent appears to be favorable or unfavorable. 2022 2021 2020 2019 2018 Sales $282,880 $270,800 $252,600 $234,560 $150,000 Cost of goods sold 128,200 122,080 115,280 106,440 67,000 Accounts receivable 18,100 17,300 16,400 15,200 9,000arrow_forwardCompute trend percents for the following accounts using 2020 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favourable or unfavourable. Sales Cost of goods sold Accounts receivable Numerator: Numerator: 2024 $ 628,449 322,959 30,417 Numerator: 1 ( ( 2024: 2023: 2022: 2021: 2020: Is the trend percent for Net Sales favourable or unfavourable? Trend Percent for Net Sales: 2023 $ 408,084 209,773 23,750 } ( } 2022 2021 $ 334,495 $ 232, 288 173,642 22,846 Denominator: Trend Percent for Cost of Goods Sold: S Denominator: } } 1 1 1 2024: 2023: 2022: 2021: 2020: Is the trend percent for Cost of Goods Sold favourable or unfavourable? 1 Trend Percent for Accounts Receivable: Denominator: 1 2024: 1 2023: 1 2022: } 2021: 1 2020: 1 Is the trend percent for Accounts Receivable favourable or unfavourable? 119,917 13,589 || II II II = 11 "I = Trend percent = 111111 = = = 11 = = = 2020 $ 170,800 87,108 11,683 Trend percent…arrow_forwardConsider the following time series data: Compute MSE using the most recent value as the forecast for the next period. What is the forecast for month 8? Compute MSE using the average of all the data available as the forecast for the next period. What is the forecast for month 8? Which method appears to provide the better forecast?arrow_forward
- For calculating trend percentages any year is selected as a. Current year b. Previous year c. Base year d. None of thesearrow_forwardCompute trend percents for the following accounts using 2020 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favourable or unfavourable. Sales Cost of goods sold Accounts receivable Numerator: 2024 $ 754,236 372,126 36,731 Numerator: 1 2023 $ 499,494 246,502 29,121 Trend Percent for Net Sales: 1 1 1 1 1 1 2024: 2023: 2022: 2021: 2020: Is the trend percent for Net Sales favourable or unfavourable? 2022 $394,857 196,780 27,127 Prev Denominator: Trend Percent for Cost of Goods Sold: 1 Denominator: 5 of 8 2021 $ 265,005 131,752 15,529 = Next > 2020 $ 196,300 96,187 13,407 Trend percent % % % % %arrow_forwardCompute trend percents for the following accounts using 2020 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favourable or unfavourable. 2024 2023 Sales Cost of goods sold Accounts receivable $ 553,119 290,122 26,882 $ 363,894 190,775 21,215 2022 $ 292,284 155,088 20,021 2021 $ 210,276 110,844 12,322 2020 $ 159,300 82,836 10,928 2024: 2023: 2022: 2021: 2020: Numerator: Trend Percent for Net Sales: 1 Is the trend percent for Net Sales favourable or unfavourable? 2024: 2023: 2022: 2021: 2020: Denominator: = Trend percent 0 % 0% 0% 0% 0 % Trend Percent for Cost of Goods Sold: Numerator: Denominator: Is the trend percent for Cost of Goods Sold favourable or unfavourable? = Trend percent 0% 0% 0% 0% 0%arrow_forward
- Considering 2012 as the base year, you are required to compute the trend index for the following items: Revenue, cost of goods sold, total expenses and net earnings. Comment on the trends of each of the items. Total assets, total liabilities and shareholders’ equity. Comment on the trends of each of the items. Cash flow from operation, cash flow from investing, cash flow from financing and closing cash balances. Comment on the trends of each of the items.arrow_forwardCompute trend percents for the following accounts using 2020 as the base year. For each of the three accounts, state whe situation as revealed by the trend percents appears to be favourable or unfavourable. Sales Cost of goods sold Accounts receivable Numerator: 2024 $ 564,662 296,074 27,273 Numerator: 2024: 2023: 2022: 2021: 2020: Is the trend percent for Net Sales favourable or unfavourable? 2023 $364,298 191,135 21,275 1 1 1 Trend Percent for Net Sales: 1 $ 1 1 2022 293,789 156,170. 20,095 Denominator: Trend Percent for Cost of Goods Sold: Denominator: 2024: 2023: 2022: 2021: 2020: is the trend percent for Cost of Goods Sold favourable or unfavourable? 2021 2020 $ 212,122 $ 158,300 111,503 12,430 = 82,316 10,828 Trend percent Trend percent % de 2 % *** % % % % % % % %arrow_forwardCompute trend percents for the following accounts using 2020 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favourable or unfavourable. 2024 2023 2022 2021 2020 Sales $ 521,076 $ 338,361 $ 275,090 $ 187,136 $ 137,600 Cost of goods sold 273,410 177,598 146,097 98,861 71,552 Accounts receivable 25,324 19,760 18,871 10,985 9,412arrow_forward
- Consider the following time series: a. Construct a time series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? b. Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. c. Compute the quarterly forecasts for next year.arrow_forwardCompute the ratios for the current and past year for Dollar Tree In. on the Ratio and Comments worksheet.arrow_forwardCompute increases (decreases) in percents for both Years 6 and 7 by entering all the missing data in the table below. Analyze and interpret any significant results revealed from this trend analysis.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Accounts Receivable and Accounts Payable; Author: The Finance Storyteller;https://www.youtube.com/watch?v=x_aUWbQa878;License: Standard Youtube License