Income statements for Siam Foods, Inc. from 2014 to 2016 appear below.Siam Foods, Inc.Annual Income StatementsFor the Years 2014 to 2016 ($ in millions)2014RevenueVariable CostsFixed Costsa.2015 20162,544 2,848 3,2761,908 2,136 2,45712812812858411546918828115266Earnings Before Interest and TaxesInterest ExpenseIncome Before Income TaxesProvision for Income TaxesNet IncomePreferred Dividend15Net Income Available to Common Shareholders 221Shares OutstandingEarnings Per ShareTax Rate508115393157236691115576230346153311501501501.47 1.78 2.2040.00% 40.00% 40.00%Enter the data into your worksheet and calculate the degree ofoperating leverage for each year.b. Calculate the degree of financial leverage for each year.c. Calculate the degree of combined leverage for each of the three years.Does it appear that Siam Food's leverage measures have beenincreasing or decreasing over this period?d. Create a line chart that shows how the various leverage measures havechanged over this three-year period.

Answered: Image /qna-images/answer/9919a2c4-d0bf-4046-aa23-30e1c38d72e3.jpg

Income statements for Siam Foods, Inc. from 2014 to 2016 appear below. Siam Foods, Inc. Annual Income Statements For the Years 2014 to 2016 ($ in millions) 2014 2015 2016 Revenue Variable Costs Fixed Costs Earnings Before Interest and Taxes Interest Expense Income Before Income Taxes Provision for Income Taxes Net Income Preferred Dividend Net Income Available to Common Shareholders_221 Shares Outstanding Earnings Per Share Tax Rate 2,544 2,848 3,276 1,908 2,136 2,457 128 128 128 584 691 115 115 393 469 576 157 188 230 236 281 346 15 15 15 266 331 508 115 150 150 150 1.47 1.78 2.20 40.00% 40.00% 40.00% Enter the data into your worksheet and calculate the degree of operating leverage for each year. b. Calculate the degree of financial leverage for each year. c. Calculate the degree of combined leverage for each of the three years. Does it appear that Siam Food's leverage measures have been increasing or decreasing over this period? d. Create a line chart that shows how the various leverage measures have changed over this three-year period.

Income statements for Siam Foods, Inc. from 2014 to 2016 appear below. Siam Foods, Inc. Annual Income Statements For the Years 2014 to 2016 ($ in millions) 2014 2015 2016 Revenue Variable Costs Fixed Costs Earnings Before Interest and Taxes Interest Expense Income Before Income Taxes Provision for Income Taxes Net Income Preferred Dividend Net Income Available to Common Shareholders_221 Shares Outstanding Earnings Per Share Tax Rate 2,544 2,848 3,276 1,908 2,136 2,457 128 128 128 584 691 115 115 393 469 576 157 188 230 236 281 346 15 15 15 266 331 508 115 150 150 150 1.47 1.78 2.20 40.00% 40.00% 40.00% Enter the data into your worksheet and calculate the degree of operating leverage for each year. b. Calculate the degree of financial leverage for each year. c. Calculate the degree of combined leverage for each of the three years. Does it appear that Siam Food's leverage measures have been increasing or decreasing over this period? d. Create a line chart that shows how the various leverage measures have changed over this three-year period.

Financial Reporting, Financial Statement Analysis and Valuation

8th Edition

ISBN:9781285190907

Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Chapter4: Profitability Analysis

Section: Chapter Questions

Problem 23PC

See similar textbooks

Similar questions

In the income statement below, ABC Trade Inc. wants to find the resulting net income for the year 2018 (in million). What is the right amount? Income Statement ($ Million) Year End 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost of Sales (679.10) (659.00) (681.30) (667.00) Gross Operating Income Selling & Administration (339.70) (348.60) (351.20) (373.30) Depreciation (47.50) (52.00) (55.90) (75.20) Other Income/Expenses 11.80 7.60 7.00 8.20 Earnings Before Interest and Taxes Interest Income 1.30 1.40 1.70 2.00 Interest Expense (16.20) (15.10) (20.50) (23.70) Pre Tax Income Income Taxes (56.80) (64.20) (67.50) (72.60) Net Income Dividends (38.30) (38.70) (39.80) (40.10) Addition to Retained Earnings Group of answer choices 121.8 108.7 132.7 132.8 No choice given
Computing NOPAT, NOPM and RNOA Selected information from the financial statements of GoPro, Inc. is provided below: ($ thousands) Revenue Operating income Net interest expense and other nonoperating expense Net income Operating assets Operating liabilities 2014 $ 121,573 2013 $ 64,157 Assume a statutory tax rate of 35%. a. Compute GoPro's net operating profit after taxes (NOPAT) for 2014 and 2013. Round answers to the nearest whole number. 2014 2013 2014 2013 $1,392,450 $984,725 b. Compute GoPro's net operating profit margin (NOPM) for each year. Round answers to one decimal place. (Ex: 0.2345 = 23.5%) 8.7% 6.5 % 187,035 98,703 6,032 7,357 125,888 60,758 815,643 439,716 276,487 254,227 33.6% c. Compute GoPro's return on net operating assets (RNOA) for 2014. Round answers to one decimal place. (Ex: 0.2345 = 23.5%) 2014
Given the historical income statement of Mega Trade Inc., how much would be added to the company's retained earning for the year 2016 (in millions)? Income Statement ($ Million) Income Statement ( $ Million) Year End 2015 2016 2017 2019 Sales 1, 234,90 1,251.40 1,300.40 1,334.40 Cost of Sales -679.1 -659 -681.3 -667 Gross Operating Income Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income / Expenses 11.8 7.6 7 8.2 Earnings Before Interest and Taxes Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Pre Tax Income Income Taxes -56.8 -64.2 -67.5 -72.6 Net Income Dividends -38.3 -38.7 -39.8 -40.1
The financial data of Mammoth corporation for the year ended 31st December,2020 is as followsParticulars Variable expense as percentage of sales 66.67Interest Expense ($) 200DOL 5DFL 3Income tax rate 0.35Requirement:a) Prepare income statement for company.
The preliminary 2018 income statement of Alexian Systems, Inc., is presented below:ALEXIAN SYSTEMS, INC.Income StatementFor the Year Ended December 31, 2018($ in millions, except earnings per share)Revenues and gains:Net sales $ 425Interest 3Other income 126Total revenues and gains 554Expenses:Cost of goods sold 270Selling and administrative 154Income taxes 52Total expenses 476Net Income $ 78Earnings per share $3.90Additional Information:1. Selling and administrative expenses include $26 million in restructuring costs.2. Included in other income is $120 million in income from a discontinued operation. This consists of $90 million in operating income and a $30 million gain on disposal. The remaining $6 million is from the gain onsale of investments.3. Cost of goods sold was increased by $5 million to correct an error in the calculation of 2017’s ending inventory. The amount is material.Required:For each of the three additional facts listed in the additional information, discuss the…
K McDaniel and Associates, Inc. reported the following amounts on its 2024 income statement: Year Ended December 31, 2024 Net income Income tax expense Interest expense $ 22,950 6,600 3,000 What was McDaniel's times-interest-earned ratio for 2024? OA. 7.65 OB. 10.85 OC. 9.85 OD. 8.65 point(s) possible ...
Crane Company's 2025 financial statements contain the following selected data: Income taxes Interest expense Net income $43000 20000 3.1 times. 6.2 times. 5.2 times. 4.1 times. 61000 Crane's times interest earned for 2025 is
The following are the financial statement JNC Ltd. for the year ended 31 March 2020: JNC Ltd. Income statement For the year ended 31 March 2020 $”M” Revenue 1276.50 Cost of sales (907.00) 369.50 Distribution costs (62.50) Administrative expenses (132.00) 175.00 Interest received 12.50 Interest paid (37.50) 150.00 Tax (70.00) Profit after tax 80.00 JNC Ltd. Statement of financial position as at 31 March 2020 2019 $”M” $”M” ASSETS: Non- current assets: Property, plant and equipment 190 152.5 Intangible assets 125 100 Investments 12.5 Current assets: Inventories 75 51 Receivables 195 157.5 Short-term investment 25 Cash in hand 1 0.5 Total assets 611 474 Equity and liabilities: Equity: Share capital (10 million ordinary shares of $ 10 per value) 100 75 Share premium 80 75 Revolution reserve 50 45.5 Retained earnings 130 90 Non-current liabilities: Loan 85 25…
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 Sales $ 1,625.0 $ 2017 1,300.0 Operating costs excluding depreciation and amortization 1,300.0 1,105.0 EBITDA $ 325.0 $ 195.0 Depreciation and amortization 39.0 31.0 Earnings before interest and taxes (EBIT) $ 286.0 $ 164.0 Interest 36.0 29.0 Earnings before taxes (EBT) $ 250.0 $ 135.0 Taxes (40%) 100.0 54.0 Net income $ 150.0 $ 81.0 Common dividends $ 135.0 $ 65.0 Powell Panther Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2018 Assets Cash and equivalents $ 23.0 $ 2017 18.0 Accounts receivable 164.0 143.0 Inventories 343.0 312.0 Total current assets $ 530.0 $ 473.0 Net plant and equipment 390.0 312.0 Total assets $ 920.0 $ 785.0 Liabilities and Equity…
The following are the financial statement Quick Ltd. for the year ended 31st December 2020: Quick Ltd. Income statement For year ended 31st December 2020 $”000” Revenue 1276.50 Cost of sales (907.00) 369.50 Distribution costs (62.50) Administrative expenses (132.00) 175.00 Interest received 12.50 Interest paid (37.50) Profit before tax 150.00 Tax (70.00) Profit after tax 80.00 Quick Ltd. Statement of financial position as at 31 December 2020 2019 $”000” $”000d” ASSETS: Non- current assets: Property, plant and equipment 190 152.5 Intangible assets 125 100 Investments 12.5 Current assets: Inventories 75 51 Receivables 195 157.5 Short-term investment 25 Cash in hand 1 0.5 Total assets 611 474 Equity and liabilities: Equity: Share capital 100 75 Share premium 80 75 Revolution reserve 50 45.5 Retained earnings 130 90 Non-current liabilities: Loan 85 25…
Do the calculations in excel, attach excel screenshots and explain the steps and formulas used for solving the problem. Following are the particulars available
Using the information below calculate the ROC of the company Years Revenue ($M) Net Income ($M) 2012 221.8 2.9 2013 473.8 20.2 2014 627.7 36.4 2015 947.8 45.0 2016 1,015.5 50.3 2017 1,046.2 64.9 2018 1,293.2 90.4 Years Total Assets ($M) Fixed Assets ($M) Current Assets ($M) Total Equity ($M) Retained Earnings ($M) 2012 430 286 144 293 12.8 2013 956 501 455 558 33.0 2014 922 668 324 620 69.4 2015 1103 796 307 665 114.4 2016 1120 835 285 729 164.7 2017 1294 738 556 805 229.6 2018 2053 703 1350 934 320