Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you help me to do this income statment on excel with formulas(on excel) for finance analysis Income Statement All numbers in thousands Breakdown TTM

can you help me to do this income statment on excel with formulas(on excel) for finance analysis
image text in transcribed
image text in transcribed
Income Statement All numbers in thousands Breakdown TTM 12/30/2020 12/30/2019 12/30/2018 12/30/2017 > Total Revenue 2,138,296 1,385.951 1,230,593 1,088,205 1,023,513 Cost of Revenue 861,016 636,003 613,537 528,051 506,292 Gross Profit 1,277,280 749,948 617,056 560.154 517,221 > Operating Expense 668,502 514,753 488,407 495,028 494,601 Operating Income 608,778 235,195 128,649 65,126 22,620 > Net Non Operating Interest Inc.. - 13,240 -6,527 -8.035 326 1 > Other Income Expense -21,225 21.689 1,292 -295 -4,441 Pretax income 574,313 206,979 119.322 65,157 18,180 Tax Provision -179,858 -105,882 -175 14,720 7.942 > Net Income Common Stockhold... 754,171 312,861 119.497 69,216 -5,294 Diluted NI Available to Com Stock... 754,171 312,861 119,497 -69.216 -5.294 Basic EPS 4.64 1.70 - 1.01 -0.07 Diluted EPS 4.56 1.66 - 1.01 -0.07 Basic Average Shares 67386 70.357 68,421 72,255 Diluted Average Shares 68.544 71.771 68.421 72.255 Total Operating income as Reported 587.707 214.124 128.649 62.944 17.336 Total Operating Income as Reported 587,707 214,124 128,649 62,944 17,336 Total Expenses 1,529,518 1,150,756 1,101,944 1,023,079 1,000,893 Net Income from Continuing & Dis.. 754,171 312,861 119,497 50,437 10.238 Normalized Income 766,680 329,066 120.463 51,106 13,071 Interest Income 739 215 601 1,281 870 Interest Expense 13,979 6,742 8,636 955 869 Net Interest Income -13,240 -6.527 -8,035 326 1 EBIT 588,292 213.721 127.958 66,112 19.049 EBITDA 619,492 Reconciled Cost of Revenue 861,016 636,003 613,537 528,051 506,292 Reconciled Depreciation 31,200 27.619 24.213 29,250 33.130 Net Income from Continuing Oper... 754,171 312,861 119,497 50,437 10.238 Total Unusual Items Excluding Goo... 20,849 -22.199 -1,323 -864 -4.721 Total Unusual Items -20,849 -22,199 -1.323 -864 4.721 Normalized EBITDA 640.341 263,539 153,494 96.226 56.9 do Tax Rate for Calcs 0 0 0 0 0 Tax Effect of Unusual Items -8.340 -5.994 -357.21 -195.264 -1.898

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

Principles Of Managerial Finance

Authors: Chad J. Zutter, Scott Smart

16th Edition

0136945880, 978-0136945888

More Books

Students also viewed these Finance questions

Question

Compare and contrast long-term and short-term orientation cultures

Answered: 1 week ago

Question

Discuss the research behind the notion of a pancultural self

Answered: 1 week ago