Answered step by step
Verified Expert Solution
Question
1 Approved Answer
use excel please show Formulas Siam Foods, Inc. Annual Income Statements For the Years 2018 to 2020 (S in millions) 2018 2019 Revenue 7.632 8,544
use excel please show Formulas
Siam Foods, Inc. Annual Income Statements For the Years 2018 to 2020 (S in millions) 2018 2019 Revenue 7.632 8,544 Variable Costs 5,724 6,408 Fixed Costs 512 512 Earnings Before Interest and Taxes 1,396 1,624 Interest Expense 240 240 Income Before Income Taxes 1,156 1,384 Provision for Income Taxes 289 346 Net Income 1.038 Preferred Dividend 15 15 Net Income Available to Common Shareholders 852 1,023 2020 9,828 7.371 512 1,945 240 1,705 426 1,279 15 1,264 867 Shares Outstanding Earnings per Share Tax Rate 300 2.84 25% 300 3.41 25% 300 4.21 25% A. 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. Siam Foods, Inc. Annual Income Statements For the Years 2018 to 2020 (S in millions) 2018 2019 Revenue 7.632 8,544 Variable Costs 5,724 6,408 Fixed Costs 512 512 Earnings Before Interest and Taxes 1,396 1,624 Interest Expense 240 240 Income Before Income Taxes 1,156 1,384 Provision for Income Taxes 289 346 Net Income 1.038 Preferred Dividend 15 15 Net Income Available to Common Shareholders 852 1,023 2020 9,828 7.371 512 1,945 240 1,705 426 1,279 15 1,264 867 Shares Outstanding Earnings per Share Tax Rate 300 2.84 25% 300 3.41 25% 300 4.21 25% A. 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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started