Financial & Managerial Accounting
14th Edition
ISBN: 9781337119207
Author: Carl Warren, James M. Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 20, Problem 1ADM
A.
To determine
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.
To determine
The earnings before interest, taxes, depreciation, and amortization (EBITDA) for the five segments.
C.
To determine
The EBITDA as a percent of sales (EBITDA margin) for the five segments.
D.
To determine
To interpret: The analysis in EBITDA margin calculated in Part C.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Starship Corporation reported the following geographical segment revenues for a recent and a prior fiscal year:
Recent Year(in millions, rounded)
Prior Year(in millions, rounded)
Americas
$10,479
$8,073
EMEA*
1,217
1,295
China/Asia Pacific
2,396
1,130
Channel Development**
1,731
1,546
Other
2,236
1,695
Total
$18,059
$13,739
*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 all percents to one decimal place. Enter all amounts in millions. If required, use minus sign to indicate the decreasing values.
Starship Corporation
Horizontal Analysis
Recent Year (in millions)
Prior Year (in millions)
Increase (Decrease)Amount
Increase (Decrease)Percent
Americas
$10,479
$8,073
$fill in the blank 15396ff9101df9f_1
fill in the blank 15396ff9101df9f_2%
EMEA
1,217
1,295
fill in the blank 15396ff9101df9f_3
fill…
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumermarket. The company’s current assets, current liabilities, and sales have been reported as follows over thelast five years (Year 5 is the most recent year):Year 5 Year 4 Year 3 Year 2 Year 1Sales ...................................... $NZ2,250,000 $NZ2,160,000 $NZ2,070,000 $NZ1,980,000 $NZ1,800,000Cash ...................................... $NZ 30,000 $NZ 40,000 $NZ 48,000 $NZ 65,000 $NZ 50,000Accounts receivable, net ....... 570,000 510,000 405,000 345,000 300,000Inventory ................................ 750,000 720,000 690,000 660,000 600,000Total current assets ............... $NZ1,350,000 $NZ1,270,000 $NZ1,143,000 $NZ1,070,000 $NZ 950,000Current liabilities .................... $NZ 640,000 $NZ 580,000 $NZ 520,000 $NZ 440,000 $NZ 400,000$NZ stands for New Zealand dollars.Required:1. Express all of the asset, liability, and sales data in trend percentages. (Show percentages for…
X Company, a division of a major oil company, provides various services to the operators of oil fields in the Middle East. Data concerning the most recent year appear below:• Sales- P18,000,000• Net operating ratio- 30%• Average Operating assets- P36,000,000Compute the return on investment (ROI) for X Company.
choices:
• None of the above
• 20%
• 25%
• 15%
Chapter 20 Solutions
Financial & Managerial Accounting
Ch. 20 - What types of costs are customarily included in...Ch. 20 - Which type of manufacturing cost (direct...Ch. 20 - Which of the following costs would be included in...Ch. 20 - In the variable costing income statement, how are...Ch. 20 - Since all costs of operating a business are...Ch. 20 - Discuss how financial data prepared on the basis...Ch. 20 - Why might management analyze product...Ch. 20 - Explain why rewarding sales personnel on the basis...Ch. 20 - Discuss the two factors affecting both sales and...Ch. 20 - How is the quantity factor for an increase or a...
Ch. 20 - Explain why service companies use different...Ch. 20 - Variable costing Marley Company has the following...Ch. 20 - Variable costingproduction exceeds sales Fixed...Ch. 20 - Variable costing sales exceed production The...Ch. 20 - Analyzing income under absorption and variable...Ch. 20 - Contribution margin by segment The following...Ch. 20 - Contribution margin analysis The actual variable...Ch. 20 - Inventory valuation under absorption costing and...Ch. 20 - Income statements under absorption costing and...Ch. 20 - Income statements under absorption costing and...Ch. 20 - Cost of goods manufactured, using variable costing...Ch. 20 - Variable costing income statement On November 30,...Ch. 20 - Absorption costing income statement On March 31....Ch. 20 - Variable costing income statement The following...Ch. 20 - Estimated income statements, using absorption and...Ch. 20 - Variable and absorption costing Ansara Company had...Ch. 20 - Prob. 20.10EXCh. 20 - Prob. 20.11EXCh. 20 - Product profitability analysis Power Train Sports...Ch. 20 - Territory and product profitability analysis Coast...Ch. 20 - Sales territory and salesperson profitability...Ch. 20 - Segment profitability analysis The marketing...Ch. 20 - Prob. 20.16EXCh. 20 - Contribution margin analysis sales Select Audio...Ch. 20 - Prob. 20.18EXCh. 20 - Contribution margin analysis variable costs Based...Ch. 20 - Variable costing income statement for a service...Ch. 20 - Contribution margin reporting and analysis for a...Ch. 20 - Variable costing income statement and contribution...Ch. 20 - Absorption and variable costing income statements...Ch. 20 - Income statements under absorption costing and...Ch. 20 - Absorption and variable costing income statements...Ch. 20 - Salespersons' report and analysis Walthman...Ch. 20 - Segment variable costing income statement and...Ch. 20 - Contribution margin analysis Farr Industries Inc....Ch. 20 - Prob. 20.1BPRCh. 20 - Income statements under absorption costing and...Ch. 20 - Absorption and variable costing income statements...Ch. 20 - Salespersons' report and analysis Pachec Inc....Ch. 20 - Variable costing income statement and effect on...Ch. 20 - Contribution margin analysis Mathews Company...Ch. 20 - Prob. 1ADMCh. 20 - Prob. 2ADMCh. 20 - Apple Inc.: Segment revenue analysis Segment...Ch. 20 - LVMH: Group segment sales and EBITDA analysis LVMH...Ch. 20 - Prob. 20.1TIFCh. 20 - Communication Bon Jager Inc. manufactures and...
Knowledge Booster
Similar questions
- Papa Johns International, Inc. (PZZA), operates over 5,000 restaurants in the United States and 45 countries. The company operates primarily as a franchisor with 4,353 franchised restaurants and 744 company-operated restaurants. Recent data (in millions) for the company-operated and North America franchised restaurants are as follows: a. Determine the profit margin for each segment. Round to one decimal place. b. Determine the investment turnover for each segment. Round to two decimal places. c. Use the DuPont formula to determine the return on investment for each segment. Round to one decimal place. d. Analyze and interpret the results of (a), (b), and (c).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_forwardAmazon.com, Inc. is the worlds leading Internet retailer of merchandise and media. Amazon also designs and sells electronic products, such as e-readers. Netflix, Inc. is the worlds leading Internet television network. Both companies compete in the digital media and streaming space. However, Netflix is more narrowly focused in the digital streaming business than is Amazon. Sales and average book value of fixed assets information (in millions) are provided for Amazon and Netflix for a recent year as follows: a. Compute the fixed asset turnover ratio for each company. Round to one decimal place. b. Which company is more efficient in generating sales from fixed assets? c. Interpret your results.arrow_forward
- Selected operating data for two divisions of Outback Brewing, Ltd., of Australia are given below (thec urrency is the Australian dollar, denoted here as $):DivisionNew SouthQueensland WalesSales ............................................................. $4,000,000 $7,000,000Average operating assets ............................. $2,000,000 $2,000,000Net operating income ................................... $360,000 $420,000Property, plant, and equipment (net) ............ $950,000 $800,000Required:1. Compute the rate of return for each division using the return on investment (ROI) formula stated interms of margin and turnover.2. Which divisional manager seems to be doing the better job? Why?arrow_forwardX Company, a division of a major oil company, provides various services to the operators of oil fields in the Middle East. Data concerning the most recent year appear below:• Sales- P18,000,000• Net operating ratio- 30%• Average Operating assets- P36,000,000Compute the return on investment (ROI) for X Company • 25% • 20% • 15% • None of the abovearrow_forwardAlyeska Services Company, a division of a major oil company, provides various services to the operators of the North Slope oil field in Alaska. Data concerning the most recent year appear below: Sales $ 17,900,000 Net operating income $ 5,200,000 Average operating assets $ 35,400,000 Required: Compute the margin. Note: Round your answer to 2 decimal places. Compute the turnover. Note: Round your answer to 2 decimal places. Compute the return on investment (ROI). Note: Round your intermediate calculations and final answer to 2 decimal places.arrow_forward
- Household Brands Inc. (HBI) manufactures household goods in the United States. The company made two acquisitions in previous years to diversify their product lines. In 2011, HBI acquired cosmetics and consumer electronics companies. HBI is now, in 2020, comprised of three divisions: cosmetics, household, and consumer electronics. The following information (in thousands of dollars) presents operating revenues, operating income, and invested assets of the company over the last three years: Revenue Operating Income Assets Cosmetics 2018 $ 24,500 $ 2,300 $ 10,000 2019 22,500 1,900 10,000 2020 19,600 1,800 9,500 Household 2018 17,400 1,300 7,500 2019 15,300 1,100 8,000 2020 12,500 900 6,500 Electronics 2018 13,500 1,500 4,500 2019 9,500 1,100 4,500…arrow_forwardPresented below is an excerpt from the financial statements of H. J. Heinz Company. Segment and Geographic Data The company is engaged principally in one line of business—processed food products—which represents over 90% of consolidated sales. Information about the business of the companyby geographic area is presented in the table below. There were no material amounts of sales or transfers between geographic areas or betweenaffiliates, and no material amounts of United States export sales. Foreign (in thousands ofU.S. dollars) Domestic UnitedKingdom Canada WesternEurope Other Total Worldwide Sales $2,381,054 $547,527 $216,726 $383,784 $209,354 $1,357,391 $3,738,445 Operating income 246,780 61,282 34,146 29,146 25,111 149,685 396,465 Identifiable assets 1,362,152 265,218 112,620 294,732 143,971 816,541 2,178,693 Capital expenditures 72,712 12,262 13,790 8,253 4,368 38,673 111,385 Depreciation expense 42,279 8,364 3,592 6,355 3,606 21,917 64,196…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 have been reported as follows over the last five years (Year 5 is the most recent year): image $NZ stands for New Zealand dollars. Required: Express all of the asset, liability, and sales data in trend percentages. (Show percentages for each item.) Use Year I as the base year and carry computations to one decimal place. Comment on the results of your analysis.arrow_forward
- Rotorua 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_forwarda) Mashimoto Electric is based in Osaka, Japan. Mashimoto Electric has a subsidiary inSingapore that generates SGD 50 million in annual sales. Any earnings generated by thesubsidiary are reinvested to support its operations. Benzai Electric is the close competitor ofMashimoto Electric. Benzai Electric is a local Japanese company located in Japan with 2 annual export sale to Singapore of about SGD 50 million. Based on the informationprovided, which firm is subject to a higher degree of translation exposure? Justify youranswer with thorough explanation on both companies.b) Diamond Limited, a New Zealand company has an Australian subsidiary that earnedAUD40 million this year. Little Limited, which is also resided in New Zealand has anAustralian subsidiary that earned AUD30 million this year. The subsidiary of DiamondLimited plans to reinvest its earnings in Australia while the subsidiary of Little Limitedplans to remit its earnings to the New Zealand parent. Another New Zealand…arrow_forwardEastlawn Travel has two operating divisions, Tours and Resorts. The two divisions meet the requirements for segment disclosures. Before transactions between the two divisions are considered, revenues and costs are as follows: Revenues Costs Tours $ 35,200,000 19,800,000 The two divisions have an arrangement by which Resorts gives coupons redeemable for tours and Tours gives discount coupons good for stays at a resort. The value of the coupons for the tours redeemed during the past year totaled $5.3 million. The discount coupons redeemed at the resorts totaled $2.2 million. As of the end of the year, all coupons for the current year expired. Tours Resorts Resorts $ 24,200,000 17,600,000 Required: What are the operating profits for each division considering the effects of the costs arising from the joint agreement? Note: Enter your answers in thousands. Operating Profitsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial 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
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning