A.
Vertical analysis
Vertical analysis is the method of financial statement analysis, and it is useful for evaluating company’s performance and financial condition. Vertical analysis is helpful for analyzing the changes in the financial statements over the time, and comparing each item on a financial statement with a total amount from the same statement.
EBITDA:
EBITA is operating income that is expressed by adding back
To prepare: A vertical analysis of the sales as a percent of total sales for the five segments.
B.
The earnings before interest, taxes, depreciation, and amortization (EBITDA) for the five segments.
C.
The EBITDA as a percent of sales (EBITDA margin) for the five segments.
D.
To interpret: The analysis in EBITDA margin calculated in Part C.
Trending nowThis is a popular solution!
Chapter 20 Solutions
CengageNOWv2, 2 terms Printed Access Card for Warren/Reeve/Duchac’s Financial & Managerial Accounting, 14th
- Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company's current assets, current liabilities, and sales have been reported as follows over the last five years (Year 5 is the most recent year): Year 1 Year 2 Year 3 Year 4 Year 5 Sales $4,546,750 $4,760,520 $5,009,460 $5,429,040 $5,695,160 $ $ 2$ 2$ 87,970 513,073 895,198 $ 73,368 572,803 907,666 Cash 90,291 401,499 815,059 95,951 417,195 869,228 92,001 448,219 832,208 Accounts receivable, net Inventory Total current assets $1,306,849 $1,382,374 $1,372,428 $1,496,241 $1,553,837 Current liabilities $ 318,258 $ 335,298 $ 335,856 $ 325,402 $ 399,778 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales % % % % % Current assets: Cash Accounts receivable Inventory Total current…arrow_forwardRotorua Products, Limited, of New Zealand markets agricultural products for the burgeoning Asian consumer market The company's current assets, current liabilities, and sales over the last five years (Year 5 is the most recent year) are as follows: Year 1 Year 2 Year 3 Year 4 Yeae S Sales $ 4,600, 790e $4,921,690 5 96,916 426, 158 70, 711 $1.393,785 $5,015,37e $ 5,543,20 S 17,60 $5,650,520 Cash Accounts receivable, net Inventory Total current assets $.95,408 407,016 507,300 451,111 833, 392 $1,371,80) 5 78,245 562,006 B4, 150 $1,479,622 $1,311,000 $1,549,3 Current 1labilities 5 302,390 5 327,119 $ 328,044 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year (Round your percentage answers to 1 decimal plece (ie., 0.1234 should be entered as 12.3).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales Current assets Cash Accounts receivable, net Inventory Total current assets Current labilitiesarrow_forwardStarbucks Corporation reported the following geographical segment revenues for a recent and a prior fiscal year: Recent Year Prior Year (in millions, rounded) (in millions, rounded) Americas $13,293 $11,980 EMEA* 1,217 1,295 China/Asia Pacific 2,396 1,130 Channel Development** 1,731 1,546 Other 526 497 $19,163 $16448 Total *Europe, Middle East, and Africa **Sells packaged coffee and teas globally a. Prepare a horizontal analysis of the segment data using the prior year as the base year. Round whole percents to one decimal place. b. Prepare a vertical analysis of the segment data. Round whole percents to one decimal place. c. What conclusions can be drawn from your analyses?arrow_forward
- Sales revenue HK$112,000 Gain on sale of plant assets 33,600 Selling and administrative expenses 11,200 Cost of goods sold 61,600 Interest expense 5,600 Income tax rate 20 % Determine (a) Income from operations HK$enter a hong kong dollar amountarrow_forwardPayton Company has the following segment revenues for the two most recent fiscal years. Segment China Canada Other countries Total revenues Segment Prepare a vertical analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place. China Canada Other countries Current Year (in millions) $750 338 214 $1,302 Total revenues Payton Company Vertical Analysis Current Year Amount (in millions) $750 338 214 $1,302 Current Year Percent % Prior Year (in millions) $650 245 165 $1,060 % Prior Year Amount (in millions) $650 245 165 $1,060 Prior Year Percent % %arrow_forwardRotorua Products, Limited, of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company’s current assets, current liabilities, and sales over the last five years (Year 5 is the most recent year) are as follows: Year 1 Year 2 Year 3 Year 4 Year 5 Sales $ 4,632,090 $ 4,889,470 $ 4,994,970 $ 5,440,450 $ 5,736,120 Cash $ 83,883 $ 107,036 $ 94,610 $ 88,260 $ 66,503 Accounts receivable, net 416,977 435,170 442,184 501,060 565,287 Inventory 805,509 868,062 819,753 892,341 915,826 Total current assets $ 1,306,369 $ 1,410,268 $ 1,356,547 $ 1,481,661 $ 1,547,616 Current liabilities $ 303,521 $ 335,136 $ 338,848 $ 335,371 $ 392,801 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)arrow_forward
- Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company’s current assets, current liabilities, and sales over the last five years (Year 5 is the most recent year) are as follows: Year 1 Year 2 Year 3 Year 4 Year 5 Sales $ 4,617,010 $ 4,754,310 $ 5,081,970 $ 5,459,390 $ 5,735,870 Cash $ 92,753 $ 90,069 $ 93,105 $ 80,319 $ 78,860 Accounts receivable, net 404,289 421,258 440,963 511,995 567,286 Inventory 808,517 867,939 816,543 882,341 903,474 Total current assets $ 1,305,559 $ 1,379,266 $ 1,350,611 $ 1,474,655 $ 1,549,620 Current liabilities $ 312,169 $ 333,151 $ 342,274 $ 318,352 $ 403,812 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year.arrow_forwardChinglish Dirk (A), Chinglish Dirk Company (Hong Kong) exports razor blades to its wholly owned parent company, Torrington Edge (Great Britain). Hong Kong tax rates are 18% and British tax rates are 33%. The markup was 15% and the sales volume was 2,500 units Chinglish calculates its profit per container as follows (all values in British pounds) Corporate management of Torrington Edge is considering repositioning profits within the multinational company What happens to the profits of Chinglish Dirk and Torrington Edge, and the consolidated results of both, if the markup at Chinglish was increased to 20% and the markup at Torrington was reduced to 10%? What is the impact of this repositioning on consolidated after-tax profit and total tax payments? Calculate the profits of Chinglish Dirk and Torrington Edge, and the consolidated results of both, if the markup at Chinglish was increased to 20% and the markup at Torrington was reduced to 10% in the following table: (Round to the nearest…arrow_forwardPayton Company has the following segment revenues for the two most recent years. Segment Current Year (in millions) Prior Year (in millions) United States. $840 $625 Canada 338 354 Other countries 215 167 Total revenues $1,393 $1,146 Prepare a horizontal analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place. For amount or percentage decreases, enter a minus sign. Payton Company Horizontal Analysis Current Year Prior Year Amount Increase Percent Increase Segment (in millions) (in millions) (Decrease) (Decrease) United States $840 $625 $ Canada 338 354 | Other countries 215 167 Total revenues $1,393 61,146 (Previous Next 12:5 a 》 @b盾动急 12/11arrow_forward
- Payton Company has the following segment revenues for the two most recent years. Segment Current Year (in millions) Prior Year (in millions) United States $820.00 $605.00 Canada 331.00 345.00 Other countries 215.50 173.50 Total revenues $1,366.50 $1,123.50 Required: Prepare a horizontal analysis of the segment data. Negative amount should be indicated by the minus sign. Calculate the percentage to four decimal places, then round your answer to one decimal place.arrow_forwardDeere Company (DE) manufactures and distributes farm and construction machinery that it sells around the world. In addition to its manufacturing operations, Deeres credit division loans money to customers to finance the purchase of their farm and construction equipment. The following information is available for three recent years (in millions except per-share amounts): 1. Calculate the following ratios for each year. Round ratios and percentages to one decimal place, except for per-share amounts, which should be rounded to the nearest cent. a. Return on total assets b. Return on stockholders' equity c. Earnings per share d. Dividend yield e. Price-earnings ratio 2. Based on these data, evaluate Deeres profitability.arrow_forwardRotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company's current assets, current liabilities, and sales over the last five years (Year 5 is the most recent year) are as follows: Year 1 Year 2 Year 3 Year 4 Year 5 Sales $1,800, 000 $1,980,000 $2,070,000 $2,160,000 $2, 250, 000 50,000 300,000 600,000 Cash $4 24 Accounts receivable, net Inventory 65,000 345,000 660,000 48,000 405,000 40,000 510,000 30,000 570,000 750,000 $1,350,000 690,000 720,000 Total current assets $ 950,000 $1,070,000 $1,143,000 $1,270,000 Current liabilities $ 400,000 $ 440,000 $ 520,000 $ 580,000 $ 640,000 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales % % % % % Current assets: % % % % Cash % % % Accounts receivable, net % % % Inventory % % % % %…arrow_forward
- Financial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. 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