Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is a company with fiscal year ending in December. Calculate the LTM EBITDA for this company at the end of July 2017. Show your
This is a company with fiscal year ending in December. Calculate the LTM EBITDA for this company at the end of July 2017. Show your calculations. These are screen shots of the companies quarterly and yearly income statements to use for your calculation
38,537 6,213 DEC '15 DEC '16 DEC '17 DEC '18 365 Days 366 Days 365 Days 365 Days 47,011 45,462 54,722 34,915 29,481 32,552 38,375 31,873 26,448 29,674 35,609 3,042 3,033 2,878 2,766 2,705 2,707 2.555 2,435 337 326 323 331 12,096 9,056 12,910 16,347 7,070 6,637 6,841 7,328 2,119 1,951 1,842 1,850 4,951 4,686 4,999 5,478 337 304 391 351 4,689 2,115 5,678 8,668 237 148 71 15 65 74 122 195 172 74 -51 - 180 501 499 522 401 515 506 522 401 1,267 Sales Cost of Goods Sold (COGS) incl. D&A COGS excluding D&A Depreciation & Amortization Expense Depreciation Amortization of Intangibles Gross Income SG&A Expense Research & Development Other SG&A Other Operating Expense EBIT (Operating Income) Nonoperating Income - Net Nonoperating Interest Income Other Income (Expense) Interest Expense Gross Interest Expense Unusual Expense - Net Impairments Goodwill Restructuring Expense Unrealized Valuation Gain/Loss Hedges/Derivatives Other Intangibles Pretax Income Income Taxes Equity in Earnings of Affiliates Consolidated Net Income Minority Interest Net Income Net Income available to Common DEC 15 MAR '16 JUN '16 SEP 16 DEC '16 MAR 17 JUN '17 SEP '17 DEC '17 MAR '18 92 Days 91 Days 91 Days 92 Days 92 Days 90 Days 91 Days 92 Days 92 Days 90 Days 11,030 9,461 10,342 9,160 9,574 9,822 11,331 11,413 12,896 12,859 8,328 6,935 7,522 6,616 7,568 6,923 7,929 7,798 9,088 8,700 7,554 6,195 6,768 5,855 6,789 7,209 7,075 8,363 8,019 774 740 754 761 779 710 720 723 725 681 692 658 672 679 699 631 640 641 643 598 82 82 82 82 80 79 80 82 82 83 2,702 2,526 2,820 2,544 2,006 2,899 3,402 3,615 3,808 4,159 1,820 1,596 1,591 1,445 2,005 1,486 1,762 1,715 1,878 1,719 553 508 468 453 522 425 458 461 498 443 1,088 1,123 992 1,483 1,061 1,304 1,254 1,380 1,276 300 236 304 294 273 311 285 303 302 267 582 694 925 805 -272 1,102 1,355 1,597 1,628 2,173 58 -21 100 26 43 53 37 95 -118 131 0 0 0 0 0 22 32 32 36 36 58 -21 100 26 43 31 5 63 -154 95 127 129 124 121 120 116 101 124 127 129 124 119 121 120 116 165 101 726 181 157 324 1,000 745 113 53 234 69 595 - 0 0 0 0 595 0 0 0 0 0 694 198 139 324 395 752 169 90 245 69 -32 17 -18 0 -10 7 56 37 11 0 48 21 -21 -11 -11 6 56 37 11 -2 16 4 3 11 1 1 - 2 -210 365 739 383 -1,348 289 1,159 1,523 1,111 2,134 -128 92 96 -180 90 361 470 2,418 -1 -1 -2 4 -5 5 8 8 5 -83 272 553 283 -1,167 194 803 1,061 -1,299 1,667 4 3 0 4 2 2 0 2 -87 271 550 283 -1,171 192 802 1,059 -1,299 1,665 -87 271 550 283 -1,171 192 802 1,059 -1,299 1,665 124 119 165 14 7 0 Sales Cost of Goods Sold (COGS) incl. D&A COGS excluding D&A Depreciation & Amortization Expense Depreciation Amortization of Intangibles Gross Income SG&A Expense Research & Development Other SG&A Other Operating Expense EBIT (Operating Income) Nonoperating Income - Net Nonoperating Interest Income Other Income (Expense) Interest Expense Gross Interest Expense Interest Capitalized Unusual Expense - Net Impairments Goodwill Financial Fixed Assets Restructuring Expense Unrealized Valuation Gain/Loss Hedges/Derivatives Other Intangibles Excpl Chrgs - Others Restructuring of Debt Pretax Income Income Taxes Income Taxes - Current Domestic Income Taxes - Current Foreign Income Taxes - Deferred Domestic Income Taxes - Deferred Foreign Equity in Earnings of Affiliates Consolidated Net Income Minority Interest Net Income Net Income available to Common 0 460 986 0 1,625 595 1,145 0 0 0 595 0 0 898 -88 1,019 -11 1,256 111 111 386 -74 - 114 -74 184 472 -22 11 - 26 1 1 1 139 4,082 3,439 916 7,822 1,698 192 -95 718 567 656 187 3,339 1,002 1,124 1,230 1,291 216 -373 -323 - 108 66 -17 4 -6 16 759 24 6,148 2,523 -59 11 5 1 8 -67 -67 2,512 2,512 754 6,147 6,147 754 38,537 6,213 DEC '15 DEC '16 DEC '17 DEC '18 365 Days 366 Days 365 Days 365 Days 47,011 45,462 54,722 34,915 29,481 32,552 38,375 31,873 26,448 29,674 35,609 3,042 3,033 2,878 2,766 2,705 2,707 2.555 2,435 337 326 323 331 12,096 9,056 12,910 16,347 7,070 6,637 6,841 7,328 2,119 1,951 1,842 1,850 4,951 4,686 4,999 5,478 337 304 391 351 4,689 2,115 5,678 8,668 237 148 71 15 65 74 122 195 172 74 -51 - 180 501 499 522 401 515 506 522 401 1,267 Sales Cost of Goods Sold (COGS) incl. D&A COGS excluding D&A Depreciation & Amortization Expense Depreciation Amortization of Intangibles Gross Income SG&A Expense Research & Development Other SG&A Other Operating Expense EBIT (Operating Income) Nonoperating Income - Net Nonoperating Interest Income Other Income (Expense) Interest Expense Gross Interest Expense Unusual Expense - Net Impairments Goodwill Restructuring Expense Unrealized Valuation Gain/Loss Hedges/Derivatives Other Intangibles Pretax Income Income Taxes Equity in Earnings of Affiliates Consolidated Net Income Minority Interest Net Income Net Income available to Common DEC 15 MAR '16 JUN '16 SEP 16 DEC '16 MAR 17 JUN '17 SEP '17 DEC '17 MAR '18 92 Days 91 Days 91 Days 92 Days 92 Days 90 Days 91 Days 92 Days 92 Days 90 Days 11,030 9,461 10,342 9,160 9,574 9,822 11,331 11,413 12,896 12,859 8,328 6,935 7,522 6,616 7,568 6,923 7,929 7,798 9,088 8,700 7,554 6,195 6,768 5,855 6,789 7,209 7,075 8,363 8,019 774 740 754 761 779 710 720 723 725 681 692 658 672 679 699 631 640 641 643 598 82 82 82 82 80 79 80 82 82 83 2,702 2,526 2,820 2,544 2,006 2,899 3,402 3,615 3,808 4,159 1,820 1,596 1,591 1,445 2,005 1,486 1,762 1,715 1,878 1,719 553 508 468 453 522 425 458 461 498 443 1,088 1,123 992 1,483 1,061 1,304 1,254 1,380 1,276 300 236 304 294 273 311 285 303 302 267 582 694 925 805 -272 1,102 1,355 1,597 1,628 2,173 58 -21 100 26 43 53 37 95 -118 131 0 0 0 0 0 22 32 32 36 36 58 -21 100 26 43 31 5 63 -154 95 127 129 124 121 120 116 101 124 127 129 124 119 121 120 116 165 101 726 181 157 324 1,000 745 113 53 234 69 595 - 0 0 0 0 595 0 0 0 0 0 694 198 139 324 395 752 169 90 245 69 -32 17 -18 0 -10 7 56 37 11 0 48 21 -21 -11 -11 6 56 37 11 -2 16 4 3 11 1 1 - 2 -210 365 739 383 -1,348 289 1,159 1,523 1,111 2,134 -128 92 96 -180 90 361 470 2,418 -1 -1 -2 4 -5 5 8 8 5 -83 272 553 283 -1,167 194 803 1,061 -1,299 1,667 4 3 0 4 2 2 0 2 -87 271 550 283 -1,171 192 802 1,059 -1,299 1,665 -87 271 550 283 -1,171 192 802 1,059 -1,299 1,665 124 119 165 14 7 0 Sales Cost of Goods Sold (COGS) incl. D&A COGS excluding D&A Depreciation & Amortization Expense Depreciation Amortization of Intangibles Gross Income SG&A Expense Research & Development Other SG&A Other Operating Expense EBIT (Operating Income) Nonoperating Income - Net Nonoperating Interest Income Other Income (Expense) Interest Expense Gross Interest Expense Interest Capitalized Unusual Expense - Net Impairments Goodwill Financial Fixed Assets Restructuring Expense Unrealized Valuation Gain/Loss Hedges/Derivatives Other Intangibles Excpl Chrgs - Others Restructuring of Debt Pretax Income Income Taxes Income Taxes - Current Domestic Income Taxes - Current Foreign Income Taxes - Deferred Domestic Income Taxes - Deferred Foreign Equity in Earnings of Affiliates Consolidated Net Income Minority Interest Net Income Net Income available to Common 0 460 986 0 1,625 595 1,145 0 0 0 595 0 0 898 -88 1,019 -11 1,256 111 111 386 -74 - 114 -74 184 472 -22 11 - 26 1 1 1 139 4,082 3,439 916 7,822 1,698 192 -95 718 567 656 187 3,339 1,002 1,124 1,230 1,291 216 -373 -323 - 108 66 -17 4 -6 16 759 24 6,148 2,523 -59 11 5 1 8 -67 -67 2,512 2,512 754 6,147 6,147 754Step 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