MANAGERIAL ACCOUNTING FUND. W/CONNECT
5th Edition
ISBN: 9781259688713
Author: Wild
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 3E
To determine
Concept introduction:
Financial Statement analysis is done using the components of financial statement. These components are
To calculate:
The trend % for the given accounts using 2011 as base year.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Q. Using 2008 as the base year, prepare a trend analysis of the following data, and tell whether the situation shown by the trends is favorable or unfavorable. (Round your answers to one decimal place.).
2012
2011
2010
2009
2008
Net sales
$25,520
$23,980
$24,200
$22,880
$22,000
Cost of goods sold
17,220
15,400
15,540
14,700
14,000
General and administrative expenses
5,280
5,184
5,088
4,896
4,800
Operating income
3,020
3,396
3,572
3,284
3,200
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
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,000
Chapter 13 Solutions
MANAGERIAL ACCOUNTING FUND. W/CONNECT
Ch. 13 - Prob. 1MCQCh. 13 - Prob. 2MCQCh. 13 - Prob. 3MCQCh. 13 - Prob. 4MCQCh. 13 - Prob. 5MCQCh. 13 - Prob. 1DQCh. 13 - Prob. 2DQCh. 13 - Prob. 3DQCh. 13 - Prob. 4DQCh. 13 - Prob. 5DQ
Ch. 13 - Prob. 6DQCh. 13 - Prob. 7DQCh. 13 - Prob. 8DQCh. 13 - Prob. 9DQCh. 13 - Prob. 10DQCh. 13 - Prob. 11DQCh. 13 - Prob. 12DQCh. 13 - Where on the income statement does a company...Ch. 13 - Prob. 14DQCh. 13 - Prob. 15DQCh. 13 - Prob. 16DQCh. 13 - Use Samsungs financial statements in Appendix A to...Ch. 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 - Prob. 9QSCh. 13 - Prob. 1ECh. 13 - Prob. 2ECh. 13 - Prob. 3ECh. 13 - Prob. 4ECh. 13 - Prob. 5ECh. 13 - Prob. 6ECh. 13 - Prob. 7ECh. 13 - Prob. 8ECh. 13 - Prob. 9ECh. 13 - Prob. 10ECh. 13 - Prob. 11ECh. 13 - Prob. 12ECh. 13 - Prob. 13ECh. 13 - Prob. 14ECh. 13 - Prob. 15ECh. 13 - Prob. 1PSACh. 13 - Prob. 2PSACh. 13 - Prob. 3PSACh. 13 - Selected year-end and financial statement of...Ch. 13 - Prob. 5PSACh. 13 - Prob. 6PSACh. 13 - Prob. 1PSBCh. 13 - Prob. 2PSBCh. 13 - Kato Corporation began the month of June with...Ch. 13 - Prob. 4PSBCh. 13 - Prob. 5PSBCh. 13 - Prob. 6PSBCh. 13 - This serial Problem began in Chapter 1 and...Ch. 13 - Refer to Apples financial statements in appendix A...Ch. 13 - Prob. 2BTNCh. 13 - Prob. 3BTNCh. 13 - Prob. 4BTNCh. 13 - Prob. 5BTNCh. 13 - Prob. 6BTNCh. 13 - Prob. 7BTNCh. 13 - Prob. 8BTNCh. 13 - Prob. 9BTN
Knowledge Booster
Similar questions
- Compute trend percentages for the following items taken from the financial statements of Lopez Plumbing over a five-year period. Treat 2014 as the base year. State whether the trends are favorable or unfavorable. (Dollar amounts are stated in thousands.) 2018 2017 2016 2015 2014 Sales $81,400 $74,000 $61,500 $59,000 $50,000 Cost of Goods Sold 58,500 48,000 40,500 37,000 30,000arrow_forwardhe following data represents the annual sales of a Digitech Automation products SAOG. Year 2014 2015 2016 2017 2018 Sales (in Millions) OMR 380 440 520 396 514 Use method of least squares to calculate the trend values and the forecast for the future period. Which of the following is the annual sales forecast for the year 2019 using least squares method? a. 539.6 Million OMR b. 584.4 Million OMR c. 606.8 Million OMR d. 562 Million OMRarrow_forwardRefer to the following mentioned data. Net sales Cost of products sold Gross margin 2017 2016 2015 Required: a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.) (In millions) 2016 2017 2015 $34,894 $30,411 $26,113 14,318 13,376 13,767 $20,576 $17,035 $12,346 Cost of goods sold Gross profit 58.94 % % % b. Assume that Campbell's net sales for the first four months of 2018 totaled $12.79 billion. Calculate an estimated cost of goods sold and gross profit for the four months, using the gross profit ratio for 2017. (Round Intermediate calculations to 2 decimal places. Enter your answers in millions rounded to nearest whole number (1.e., 5,000,000 should be entered as 5).) million millionarrow_forward
- Sales Cost of goods sold Accounts receivable 2021 $ 676,574 333,971 32,679 2020 $ 439,334 216,824 25,657 2019 $ 340,569 170,229 23,363 2018 $ 237,330 117,892 13,860 2017 $ 175,800 86,142 12,060 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. 2021: 2020: 2019: 2018: 2017: Trend Percent for Net Sales: Numerator: Denominator: = Trend percent = % Is the trend percent for Net Sales favorable or unfavorable? 2021: 2020: 2019: 2018: 2017: Trend Percent for Cost of Goods Sold: Numerator: Denominator: Trend percent Is the trend percent for Cost of Goods Sold favorable or unfavorable? %arrow_forwardComputing and analyzing trend percents LO P1 2021 2020 2019 2018 2017 Sales $ 446,122 $ 293,501 $ 242,563 $ 173,880 $ 128,800 Cost of goods sold 221,100 145,365 122,206 87,101 63,112 Accounts receivable 21,592 17,140 16,664 10,137 8,784 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.arrow_forwardRefer to the following mentioned data. Net sales Cost of products sold Gross margin (In millions) 2017 2016 $34,954 $30, 040 14,274 13, 395 $20, 680 $16, 645 2017 2016 2015 Required: a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.) 2015 $26, 091 13, 655 $12, 436 59.16 % 55.41 % 47.66 %arrow_forward
- Use the following information for the Quick Studies below. (Algo) ($ thousands) Net sales Current Year $ 802,213 393,339 Prior Year $ 453,350 134,505 Cost of goods sold QS 13-7 (Algo) Trend percents LO P1 Determine the Prior Year and Current Year trend percents for net sales using the Prior Year as the base year. (Enter the answers in thousands of dollars.) Current Year: Prior Year: Numerator: Trend Percent for Net Sales: 1 1 1 Denominator: = = = Trend Percent 0% 0 %arrow_forwardRefer to the following mentioned data. (In millions) 2015 $26,512 13,307 2017 2016 $34,736 14,970 Net sales $30,142 Cost of products sold 13,615 Gross margin $19,766 $16,527 $13, 205 Required: a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.) 2017 2016 2015 b. Assume that Campbell's net sales for the first four months of 2018 totaled $12.15 billion. Calculate an estimated cost of goods sold and gross profit for the four months, using the gross profit ratio for 2017. (Round intermediate calculations to 2 decimal places. Enter your answers in millions rounded to nearest whole number (i.e.., 5,000,000 should be entered as 5).) Cost of goods sold million Gross profit millionarrow_forward! Required information Use the following information for the Quick Studies below. (Algo) ($ thousands) Net sales Current Year $ 803,470 394,775 Prior Year $ 455,095 135,878 Cost of goods sold QS 17-7 (Algo) Trend percents LO P1 Determine the Prior Year and Current Year trend percents for net sales using the Prior Year as the base year. (Enter the answers in thousands of dollars.) Current Year: Prior Year: Numerator: Trend Percent for Net Sales: 1 1 1 1 Denominator: = = = Trend Percent 0 % 0 %arrow_forward
- Calculate the Trend Analysis from the following information of Kamanga Invest-Trust Bank Ltd., taking 2010 as a base year and interpret them (in thousands). Year Deposits Advances Profits 2010 2011 2012 2013 2014 2015 20,559,498 26,645,251 31,980,696 37,299,877 40,845,783 44,042,730 9,714,728 12,550,440 15,883,495 17,726,607 19,599,764 19,599,764 350,311 406,287 504,020 553,525 637,634 806,755arrow_forward2021 2020 2019 2018 2017 $ 394,032 199,466 19,071 $ 262,688 132,894 15,394 $ 205,225 $ 150,348 76,774 8,780 $ 112,200 56,100 Sales Cost of goods sold Accounts receivable 106,013 14,058 7,708 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. Trend Percent for Net Sales: Numerator: Denominator: Trend percent 2021: % 2020: % 2019: % %3D 2018: % = 2017: % Is the trend percent for Net Sales favorable or unfavorable? Trend Percent for Cost of Goods Sold: Numerator: Denominator: Trend percent %3D 2021: % 2020: % 2019: % %3D 2018: % = 2017: %3D Is the trend percent for Cost of Goods Sold favorable or unfavorable? Trend Percent for Accounts Receivable: Numerator: Denominator: Trend percent %3D 2021: % 2020: % %3D 2019: % = 2018: % 2017: % %3D Is the trend percent for Accounts Receivable favorable or unfavorable? II II IL || IIarrow_forward1. Angel Trading presents the following sales figures in terms of units. 2014 10 000 2015 11 650 2016 12 395 2017 14 670 2018 18 485 2019 Required: Determine the projected sales on 2019 using either simple moving average or arithmetic geometric curve.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:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial 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