Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Download and use the 2021 Intel Form 10-K which can be found at the following Web site SEC.gov Answer the following questions for Intel: a)

Download and use the 2021 Intel Form 10-K which can be found at the following Web site SEC.gov Answer the following questions for Intel: a) Using the 2021 Consolidated Statements of Income, analyze the profitability by preparing a common-size income statement for the past three years. Use the Income statement on page 72 of the 10k. Present Each line item in the income statement as a percentage of revenue. Include both the actual income numbers and percentages in your table. 200 b) Identify gross margin from your common sized income statement calculations. Evaluate the company's 2021 gross margin and compare to prior two years. What does your analysis indicate as far as trend? Note the change year to year (ie. Simple subtraction 2021-2020) c) Calculate EBITDA for the past three years. We have not gone through the Cash Flow Statement yet, but you can find both depreciation and amortization on the cash flow statement for use in your calculation of EBITDA. EBITDA = OPERATING INCOME + DEPRECIATION + AMORTIZATION. d) Calculate EBITDA margin for the past three years (2021-2019). EBITDA/Revenue. Evaluate the company's 2021 EBITDA margin by comparing your calculation for 2020. How does this compare to the change in Gross Margin you calculated in item(b)? e) Calculate Debt/EBITDA for the past three years using your EBITDA calculation from item(d) and short term + long term DEBT from the Balance Sheet. Intel reports the current portion of long-term debt as short-term debt. Does Intel have low leverage risk (under 3x)? How does Intel compare to the average risk of investment grade corporations of 2.25x? How has the leverage ratio changed over the three-year period?
image text in transcribed
Download and use the 2021 Intel Form 10 -K which can be found at the following Web site SEC.gov Answer the following questions for intel: a) Using the 2021 consolidated Statements of Income, analyze the profitability by preparing a common-size income statement for the past three years. Use the income statement on page 72 of the 10k. Present Each line item in the income statement as a percentage of revenue. Include both the actual income numbers and percentages in your table. b) Identify gross margin from your common sized income statement calculations. Evaluate the company's 2021 gross margin and compare to prior two years. What does your analysis indicate as far as trend? Note the change year to year (ie. Simple subtraction 2021-2020) c) Calculate EBITDA for the past three years. We have not gone through the Cash Flow Statement yet, but you can find both depreciation and amortization on the cash flow statement for use in your calculation of EBITDA. EBITDA = OPERATING INCOME + DEPRECIATION + AMORTIZATION. d) Calculate EBITDA margin for the past three years (2021-2019). EBITDA/Revenue. Evaluate the company's 2021 EBITDA margin by comparing your calculation for 2020 . How does this compare to the change in Gross Margin you calculated in Item(b)? e) Calculate Debt/EBITDA for the past three years using your EBITDA calculation from item(d) and short term + long term DEBT from the Balance Sheet. Intel reports the current portion of long-term debt as short-term debt. Does Intel have low leverage risk (under 3x )? How does Intel compare to the average risk of investment grade corporations of 2.252 How has the leverage ratio changed over the three-vear period? Download and use the 2021 Intel Form 10 -K which can be found at the following Web site SEC.gov Answer the following questions for intel: a) Using the 2021 consolidated Statements of Income, analyze the profitability by preparing a common-size income statement for the past three years. Use the income statement on page 72 of the 10k. Present Each line item in the income statement as a percentage of revenue. Include both the actual income numbers and percentages in your table. b) Identify gross margin from your common sized income statement calculations. Evaluate the company's 2021 gross margin and compare to prior two years. What does your analysis indicate as far as trend? Note the change year to year (ie. Simple subtraction 2021-2020) c) Calculate EBITDA for the past three years. We have not gone through the Cash Flow Statement yet, but you can find both depreciation and amortization on the cash flow statement for use in your calculation of EBITDA. EBITDA = OPERATING INCOME + DEPRECIATION + AMORTIZATION. d) Calculate EBITDA margin for the past three years (2021-2019). EBITDA/Revenue. Evaluate the company's 2021 EBITDA margin by comparing your calculation for 2020 . How does this compare to the change in Gross Margin you calculated in Item(b)? e) Calculate Debt/EBITDA for the past three years using your EBITDA calculation from item(d) and short term + long term DEBT from the Balance Sheet. Intel reports the current portion of long-term debt as short-term debt. Does Intel have low leverage risk (under 3x )? How does Intel compare to the average risk of investment grade corporations of 2.252 How has the leverage ratio changed over the three-vear period

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

More Books

Students also viewed these Finance questions