Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions