Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedThis 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 754

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_2

Step: 3

blur-text-image_3

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

Life Audit Journal What Is My Why

Authors: A S

1st Edition

B08F6TXV7Z, 9798672209692

More Books

Students also viewed these Accounting questions

Question

2. What are your challenges in the creative process?

Answered: 1 week ago