Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Actions 1 Forecast P&L for 2021 of site on actuals tab and apply assumptions below. Re-calc totals, %'s as needed to ensure math works. Hide
Actions 1 Forecast P&L for 2021 of site on actuals tab and apply assumptions below. Re-calc totals, %'s as needed to ensure math works. Hide the site tabs you are not working on. 2 Apply / show any relevant metrics (ie margins, percent of sales, EBITDA %) 3 Compare and show full year 2021 forecast vs Site Plan with variances of dollars and percents. Show plan to right of actual. 4 Summarize and provide your assessment of site situation with any recommendation below. 50 words or less. 5 Add your name to end of file name Assumptions Revenue 2% growth each month, then -5% for Nov and Dec COGS apply YTD percent of sale SG&A apply April forward for each month All others run YTD rate or April forward using your best judgement. Assessment P&L Summary by Month e Act Business Unit Total Actual - USD Jun, 2021 1.537.293 Aug, 2021 1.599 399 May, 2021 1,507,150 D Sep, 2021 1.631.387 Oct, 2021 1,664015 Jan, 2021 1,089,062 31,334 78,693 1,199,089 Jul, 2021 1,568,038 D Nov, 2021 1.580.814 Feb. 2021 1.328.036 52.749 75, 191 1,455,975 Mar, 2021 1,566,144 107.877 95,638 1,769,660 Apr, 2021 1,477,598 90.986 78, 205 1,646,789 Dec, 2021 1,501, 773 D Trade Gross Sales Other Revenues Intercompany Revenue Gross Revenue D D D D D D 2021 5,460,839 282,947 327,727 6,071,513 D D D D D D D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D D D D D D D D Sales Returns Sales Discounts Sales Discounts & Allowances Net Revenue 0 (211) (211) 1,198,878 (658) (658) 1,455, 317 0 (248) (248) 1,769,412 0 (103) (103) 1,646,686 0 (1,220) (1,220) 6,070,292 D D D D D D 0 D 0 0 0 0 0 0 0 0 D D D D D D D 935,446 38.787 n D D D D D D D 0 0 0 0 0 0 0 0 0 0 0 0 0 571,342 62,298 394,745 116,014 180,60B 115,090 200,559 22.096 660,988 30.792 326,302 124,892 262,545 93.883 295,864 19,669 0 0 0 0 0 0 0 0 0 0 D D D D Material Direct Costs - Subcontracting Direct Costs - Labor - VOH Salaries & Benefits VOH Other FOH Salaries & Benefits FOH Other FOH Engineering Salaries FOH Engineering Other Other COGS Expenses COGS Gross Margin GM as % of Not Revenue D D 794,057 25,949 348,766 123,684 228, 160 127,136 211,056 23,016 0 0 1,881,822 (112,410) -6% D 0 D D D D D 323,477 112,330 322,251 125,959 100,619 17,905 0 0 1,976,773 (330,088) -20% 0 0 D 0 0 0 D D 0 0 0 D 0 0 0% 2,961,833 157,826 1.393,291 476,919 993,563 462,068 808,098 82,685 0 0 7,336,284 (1,265,991) -21% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D 0 D D D D D D D D D D 0 1,662,753 (463,875) -39% 1,814,936 (359,618) -25% D D 0% D 0 D D D D D 0% 0% 0% 0% 0% 090 D D D D D D D 45,758 3,376 20,272 12,297 21,436 D 26,800 2,765 14,809 9,528 2.691 D 392 2,227 5,130 12,423 7,089 D D 0 0 0 D D D 0 0 0 D D 0 0 0 0 0 0 0 0 D D 0 0 0 0 D D D 0 0 0 D D 0 D D Executive Sales and Marketing Engineering Accounting Information Technology Hurran Resources Corporate Supply Chain Administration Other Selling, General & Administrative SGA as percent of Net Revenue Operating Income Operating Income as % of Net Sales D D 4,934 1,791 29,728 17,683 8,458 D 68 1,492 64,154 4% (423,772) -29% 0 0 0 D 0 0 0 D D D 0 D 0 0 0 D D 0 0 0 0 0 0 0 0 0 0 77,884 10.158 69,940 51,931 39,575 0 6,712 (3,531) 252,770 4% (1.518,761) -25% 0 0 D 6,336 216 63,145 4% (175,555) -10% D 308 (5,239) 22,331 1% (352,418) -21% 0 D 0 0 0 D D 0 103,140 9% (567,015) -47% D D 0% 0% 0% 0% 0% 0% 0 0 0 O 0% O 0% 0% 0 0 0% 0% 0% 0 0% 0 0% 0% 0% D D D D D D D D D D D D Interest Income Interest on API Loan D D D D D D D D D D D D D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O 0 0 0 4,934 1,791 29,728 17,683 8,458 26,800 2,765 14,809 9,528 2,691 392 2,227 5,130 12,423 7,089 0 0 45,758 3,376 20,272 12,297 21,436 0 0 0 0 0 0 0 0 0 0 0 0 Executive Sales and Marketing Engineering Accounting Information Technology Human Resources Corporate Supply Chain Administration Other Selling, General & Administrative SGA as percent of Net Revenue Operating Income Operating Income as % of Net Sales 0 0 0 0 0 0 0 0 0 O O O O O 0 0 77,884 10,158 69,940 51,931 39,675 0 6,712 (3,531) 252,770 4% (1,518,761) -25% 0 68 0 0 0 0 0 0 0 6,336 216 63,145 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,492 64,154 4% (423,772) -29% 308 (5,239) 22,331 1% (352,418) -21% 4% 0% 0% 0% 0% 0% 0% 103,140 9% (567,015) -47% 0% 0% 0 0 0 0 0 0 0 0 (175,555) -10% 0% 0% 0% 0% 0% 0% 0% 0% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Interest Income Interest API Loan Dividend Income Miscellaneous Income Other Income O O O O 0 O O O 0 O O 0 0 0 0 0 0 0 0 0 0 0 0 0 5,625 5,625 5,625 5,625 0 0 0 0 0 0 0 0 151,685 0 0 0 0 0 0 109,852 0 0 0 0 0 0 0 0 27,463 0 (66,795) 45,084 0 O O O O O 0 0 0 0 0 0 (13,326) 11,265 6, 207 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Amortization Expense Interest Expense Other Miscellaneous Expenses Foreign Exchange (Gain) Loss Earnings From Subsidiaries Other Expenses Pretax Income Income Taxes Net Income Total Addbacks - EBITDA EBITDA EBITDA as % of Net Revenue 151,685 0 34,742 7,093 0 193,521 (611,668) 0 (611,668) 0 (367,718) -25% (220,981) 0 18,727 (47,120) 0 (249,375) 73,820 0 73,820 0 (119,501) -7% 0 0 0 0 0 0 0 0 0 0 0 0 0 157,893 (724,908) 0 (724,908) 0 (510,961) -43% 0 0 5,753 (358,171) 0 (358,171) 0 (296,364) -18% 0 0 0 0 0 0 0 0 107,791 (1,620,927) 0 (1,620,927) 0 (1,294,545) -21% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0% 0% 0% 0% 0% 0% 0% API Heat Transfer Inc. P&L Summary by Month e plan Business Unit Total Plan - USD Trade Gross Sales Other Revenues Intercompany Revenue Gross Revenue Jan, 2021 1,014,988 44,575 38,876 1,098,439 Feb, 2021 1,057.476 39,017 38,314 1,134,807 Mar, 2021 1.752,422 44,471 41,843 1,838,736 Apr, 2021 1,873,305 46,065 42,470 1,961,840 May, 2021 1,842.559 46,989 42,932 1,932,480 Jun, 2021 1,684,333 50.761 44,242 1.779,336 Jul, 2021 1.764,825 57,404 45,553 1,867,782 Aug, 2021 2.072,445 68,206 49,094 2 189.745 Sep, 2021 2,074,478 69,368 48,930 2,192,77 Oct, 2021 1.895,500 68,509 47,299 2,011,316 Nov, 2021 1,685,848 65,458 45,03 1,796,336 Dec, 2021 1,326,139 45,341 40,392 1.411,872 2021 20.044,326 646,164 524,975 21,215,465 D D 0 0 Sales Returns Sales Discounts Sales Discounts & Allowances Net Revenue o (262) (262) ) 1,098, 177 0 (234) (234) 1,134,573 0 (271) (271) 1,838,465 (278) (278) 1,961,562 D (284) (284) 1,932, 196 (300) (300) 1,779,036 0 (330) (330 1,867,452 (395) (395) 2,189,350 0 (395) (395) 2,192,381 0 (380) (380) 2,010,936 0 (350) (350) 1.795,986 o (271) (271) 1.411,601 (3.750) (3,750) 21,211,715 Material Direct Costs - Subcontracting Direct Costs - Labor VOH Salaries & Benefits VOH Other FOH Salaries & Benefits FOH Other FOH Engineering Salaries FOH Engineering Other Other COGS Expenses COGS Gross Margin GM as % of Net Revenue 559,031 48,824 255,217 86,803 174,853 123,845 188,721 21,618 0 8,000 1,466,912 (368,735) -34% 563, 183 47.210 253,33% 85,364 151,887 127,500 188,721 21,618 0 8,000 1,446,818 (312,245) -20% 856,8BE 56,158 361,545 98,930 198,602 143,309 188,721 21,618 0 8.000 1,933,769 (95,304) -5% 846,259 54,013 374,BBE 93,147 184,610 120.998 188,721 21,618 0 8,000 1,892,252 69,310 813,863 55,219 382.844 91.891 187,615 115.727 188,721 21.618 0 8,000 1,865,498 66,698 3% 762,378 58,427 349, 159 86.813 180,078 120.998 188.721 21,618 0 8.000 1,776,192 2,844 0% 799,436 62,303 370.01 92,365 181.996 123,106 189.721 21,618 0 8,000 1,847,565 19,889 1% 955,886 69,198 412,609 107,467 205,626 123,106 188,721 21,618 0 8.000 2,092,231 97,119 4% 955,071 68,821 419,441 106.941 213,387 123,106 188,721 21,618 0 8,000 2,105,106 87,275 4% 853,270 67.890 392,153 99.347 203,834 117,718 188,721 21,618 0 8,000 1,952,551 58,385 3% 749,504 61,365 341,356 89,621 174,604 123, 106 188,721 21,618 0 8,000 1,757,895 38,091 2% 572,787 48,425 278,432 79,514 144,729 128,495 188,721 21,618 0 8,000 1,470,721 (59,120) 4% 9.287,554 697,853 4,190,995 1.118,203 2,201,821 1.491,015 2,264,652 259,416 0 96,000 21,607,509 (395,794) -2% 0 0 0 0 0 0 a D 0 0 0 0 0 0 D 0 D 0 0 0 0 0 0 0 0 Executive Sales and Marketing Engineering Accounting Information Technology Human Resources Corporate Supply Chain 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a D 0 0 0 0 D D 0 0 0 0 0 o 0 0 0 a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D D 0 0 0 U U U U 0 0 0 0 0 0 0 0 0 0 0 o oo O O O 0 0 0 oooole 0 0 0 Information Technology Human Resources Corporate Supply Chain Administration Other Selling, General & Administrative SGA as percent of Net Revenue Operating Income Operating Income as % of Net Sales 0 0 0 0 0 0 0 0 0 0 0 010 0 0 0 0 0 0 0 0 0 0 0% 0% 0% 0% 0% 0 0% 69,310 4% 0% (312,245) -28% (368,735) -34% (95,304) -5% 0% 66,698 3% 0% 2,844 0% 0% 19,889 1% 0% 97,119 4% 87,275 4% 0% 58,385 3% 38,091 2% 0% (59,120) -4% (395,794) -2% 0 0 0 0 0 0 ooo 0 0 0 0 0 Interest Income Interest on API Loan Dividend Income Miscellaneous Income Other Income 0 O O O O 0 Ooo 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O O Oo oo O O O O O 0 o o o o o Oo oo O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Amortization Expense Interest Expense Other Miscellaneous Expenses Foreign Exchange (Gain) Loss Earnings From Subsidiaries Other Expenses Pretax Income Income Taxes Net Income Total Addbacks - EBITDA EBITDA EBITDA as % of Net Revenue 0 (395,794) (312,245) (95,304) 69,310 66,698 2,844 97,119 87,275 58,385 38,091 (59,120) 0 0 0 0 0 0 0 0 0 0 0 (312,245) (95,304) 69,310 66,698 2,844 97,119 58,385 (368,735) 0 (368,735) 0 (309,970) -28% 19,889 0 19,889 0 78,654 4% 0 0 0 0 0 0 0 87,275 0 146,040 7% 38,091 0 96,856 5% (59,120) 0 (355) -0% (395,794) 0 309,386 1% (253,480) -22% (36,539) -2% 128,075 7% 125,463 6% 61,609 3% 155,884 7% 117,150 6% Actions 1 Forecast P&L for 2021 of site on actuals tab and apply assumptions below. Re-calc totals, %'s as needed to ensure math works. Hide the site tabs you are not working on. 2 Apply / show any relevant metrics (ie margins, percent of sales, EBITDA %) 3 Compare and show full year 2021 forecast vs Site Plan with variances of dollars and percents. Show plan to right of actual. 4 Summarize and provide your assessment of site situation with any recommendation below. 50 words or less. 5 Add your name to end of file name Assumptions Revenue 2% growth each month, then -5% for Nov and Dec COGS apply YTD percent of sale SG&A apply April forward for each month All others run YTD rate or April forward using your best judgement. Assessment P&L Summary by Month e Act Business Unit Total Actual - USD Jun, 2021 1.537.293 Aug, 2021 1.599 399 May, 2021 1,507,150 D Sep, 2021 1.631.387 Oct, 2021 1,664015 Jan, 2021 1,089,062 31,334 78,693 1,199,089 Jul, 2021 1,568,038 D Nov, 2021 1.580.814 Feb. 2021 1.328.036 52.749 75, 191 1,455,975 Mar, 2021 1,566,144 107.877 95,638 1,769,660 Apr, 2021 1,477,598 90.986 78, 205 1,646,789 Dec, 2021 1,501, 773 D Trade Gross Sales Other Revenues Intercompany Revenue Gross Revenue D D D D D D 2021 5,460,839 282,947 327,727 6,071,513 D D D D D D D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D D D D D D D D Sales Returns Sales Discounts Sales Discounts & Allowances Net Revenue 0 (211) (211) 1,198,878 (658) (658) 1,455, 317 0 (248) (248) 1,769,412 0 (103) (103) 1,646,686 0 (1,220) (1,220) 6,070,292 D D D D D D 0 D 0 0 0 0 0 0 0 0 D D D D D D D 935,446 38.787 n D D D D D D D 0 0 0 0 0 0 0 0 0 0 0 0 0 571,342 62,298 394,745 116,014 180,60B 115,090 200,559 22.096 660,988 30.792 326,302 124,892 262,545 93.883 295,864 19,669 0 0 0 0 0 0 0 0 0 0 D D D D Material Direct Costs - Subcontracting Direct Costs - Labor - VOH Salaries & Benefits VOH Other FOH Salaries & Benefits FOH Other FOH Engineering Salaries FOH Engineering Other Other COGS Expenses COGS Gross Margin GM as % of Not Revenue D D 794,057 25,949 348,766 123,684 228, 160 127,136 211,056 23,016 0 0 1,881,822 (112,410) -6% D 0 D D D D D 323,477 112,330 322,251 125,959 100,619 17,905 0 0 1,976,773 (330,088) -20% 0 0 D 0 0 0 D D 0 0 0 D 0 0 0% 2,961,833 157,826 1.393,291 476,919 993,563 462,068 808,098 82,685 0 0 7,336,284 (1,265,991) -21% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D 0 D D D D D D D D D D 0 1,662,753 (463,875) -39% 1,814,936 (359,618) -25% D D 0% D 0 D D D D D 0% 0% 0% 0% 0% 090 D D D D D D D 45,758 3,376 20,272 12,297 21,436 D 26,800 2,765 14,809 9,528 2.691 D 392 2,227 5,130 12,423 7,089 D D 0 0 0 D D D 0 0 0 D D 0 0 0 0 0 0 0 0 D D 0 0 0 0 D D D 0 0 0 D D 0 D D Executive Sales and Marketing Engineering Accounting Information Technology Hurran Resources Corporate Supply Chain Administration Other Selling, General & Administrative SGA as percent of Net Revenue Operating Income Operating Income as % of Net Sales D D 4,934 1,791 29,728 17,683 8,458 D 68 1,492 64,154 4% (423,772) -29% 0 0 0 D 0 0 0 D D D 0 D 0 0 0 D D 0 0 0 0 0 0 0 0 0 0 77,884 10.158 69,940 51,931 39,575 0 6,712 (3,531) 252,770 4% (1.518,761) -25% 0 0 D 6,336 216 63,145 4% (175,555) -10% D 308 (5,239) 22,331 1% (352,418) -21% 0 D 0 0 0 D D 0 103,140 9% (567,015) -47% D D 0% 0% 0% 0% 0% 0% 0 0 0 O 0% O 0% 0% 0 0 0% 0% 0% 0 0% 0 0% 0% 0% D D D D D D D D D D D D Interest Income Interest on API Loan D D D D D D D D D D D D D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O 0 0 0 4,934 1,791 29,728 17,683 8,458 26,800 2,765 14,809 9,528 2,691 392 2,227 5,130 12,423 7,089 0 0 45,758 3,376 20,272 12,297 21,436 0 0 0 0 0 0 0 0 0 0 0 0 Executive Sales and Marketing Engineering Accounting Information Technology Human Resources Corporate Supply Chain Administration Other Selling, General & Administrative SGA as percent of Net Revenue Operating Income Operating Income as % of Net Sales 0 0 0 0 0 0 0 0 0 O O O O O 0 0 77,884 10,158 69,940 51,931 39,675 0 6,712 (3,531) 252,770 4% (1,518,761) -25% 0 68 0 0 0 0 0 0 0 6,336 216 63,145 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,492 64,154 4% (423,772) -29% 308 (5,239) 22,331 1% (352,418) -21% 4% 0% 0% 0% 0% 0% 0% 103,140 9% (567,015) -47% 0% 0% 0 0 0 0 0 0 0 0 (175,555) -10% 0% 0% 0% 0% 0% 0% 0% 0% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Interest Income Interest API Loan Dividend Income Miscellaneous Income Other Income O O O O 0 O O O 0 O O 0 0 0 0 0 0 0 0 0 0 0 0 0 5,625 5,625 5,625 5,625 0 0 0 0 0 0 0 0 151,685 0 0 0 0 0 0 109,852 0 0 0 0 0 0 0 0 27,463 0 (66,795) 45,084 0 O O O O O 0 0 0 0 0 0 (13,326) 11,265 6, 207 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Amortization Expense Interest Expense Other Miscellaneous Expenses Foreign Exchange (Gain) Loss Earnings From Subsidiaries Other Expenses Pretax Income Income Taxes Net Income Total Addbacks - EBITDA EBITDA EBITDA as % of Net Revenue 151,685 0 34,742 7,093 0 193,521 (611,668) 0 (611,668) 0 (367,718) -25% (220,981) 0 18,727 (47,120) 0 (249,375) 73,820 0 73,820 0 (119,501) -7% 0 0 0 0 0 0 0 0 0 0 0 0 0 157,893 (724,908) 0 (724,908) 0 (510,961) -43% 0 0 5,753 (358,171) 0 (358,171) 0 (296,364) -18% 0 0 0 0 0 0 0 0 107,791 (1,620,927) 0 (1,620,927) 0 (1,294,545) -21% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0% 0% 0% 0% 0% 0% 0% API Heat Transfer Inc. P&L Summary by Month e plan Business Unit Total Plan - USD Trade Gross Sales Other Revenues Intercompany Revenue Gross Revenue Jan, 2021 1,014,988 44,575 38,876 1,098,439 Feb, 2021 1,057.476 39,017 38,314 1,134,807 Mar, 2021 1.752,422 44,471 41,843 1,838,736 Apr, 2021 1,873,305 46,065 42,470 1,961,840 May, 2021 1,842.559 46,989 42,932 1,932,480 Jun, 2021 1,684,333 50.761 44,242 1.779,336 Jul, 2021 1.764,825 57,404 45,553 1,867,782 Aug, 2021 2.072,445 68,206 49,094 2 189.745 Sep, 2021 2,074,478 69,368 48,930 2,192,77 Oct, 2021 1.895,500 68,509 47,299 2,011,316 Nov, 2021 1,685,848 65,458 45,03 1,796,336 Dec, 2021 1,326,139 45,341 40,392 1.411,872 2021 20.044,326 646,164 524,975 21,215,465 D D 0 0 Sales Returns Sales Discounts Sales Discounts & Allowances Net Revenue o (262) (262) ) 1,098, 177 0 (234) (234) 1,134,573 0 (271) (271) 1,838,465 (278) (278) 1,961,562 D (284) (284) 1,932, 196 (300) (300) 1,779,036 0 (330) (330 1,867,452 (395) (395) 2,189,350 0 (395) (395) 2,192,381 0 (380) (380) 2,010,936 0 (350) (350) 1.795,986 o (271) (271) 1.411,601 (3.750) (3,750) 21,211,715 Material Direct Costs - Subcontracting Direct Costs - Labor VOH Salaries & Benefits VOH Other FOH Salaries & Benefits FOH Other FOH Engineering Salaries FOH Engineering Other Other COGS Expenses COGS Gross Margin GM as % of Net Revenue 559,031 48,824 255,217 86,803 174,853 123,845 188,721 21,618 0 8,000 1,466,912 (368,735) -34% 563, 183 47.210 253,33% 85,364 151,887 127,500 188,721 21,618 0 8,000 1,446,818 (312,245) -20% 856,8BE 56,158 361,545 98,930 198,602 143,309 188,721 21,618 0 8.000 1,933,769 (95,304) -5% 846,259 54,013 374,BBE 93,147 184,610 120.998 188,721 21,618 0 8,000 1,892,252 69,310 813,863 55,219 382.844 91.891 187,615 115.727 188,721 21.618 0 8,000 1,865,498 66,698 3% 762,378 58,427 349, 159 86.813 180,078 120.998 188.721 21,618 0 8.000 1,776,192 2,844 0% 799,436 62,303 370.01 92,365 181.996 123,106 189.721 21,618 0 8,000 1,847,565 19,889 1% 955,886 69,198 412,609 107,467 205,626 123,106 188,721 21,618 0 8.000 2,092,231 97,119 4% 955,071 68,821 419,441 106.941 213,387 123,106 188,721 21,618 0 8,000 2,105,106 87,275 4% 853,270 67.890 392,153 99.347 203,834 117,718 188,721 21,618 0 8,000 1,952,551 58,385 3% 749,504 61,365 341,356 89,621 174,604 123, 106 188,721 21,618 0 8,000 1,757,895 38,091 2% 572,787 48,425 278,432 79,514 144,729 128,495 188,721 21,618 0 8,000 1,470,721 (59,120) 4% 9.287,554 697,853 4,190,995 1.118,203 2,201,821 1.491,015 2,264,652 259,416 0 96,000 21,607,509 (395,794) -2% 0 0 0 0 0 0 a D 0 0 0 0 0 0 D 0 D 0 0 0 0 0 0 0 0 Executive Sales and Marketing Engineering Accounting Information Technology Human Resources Corporate Supply Chain 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a D 0 0 0 0 D D 0 0 0 0 0 o 0 0 0 a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D D 0 0 0 U U U U 0 0 0 0 0 0 0 0 0 0 0 o oo O O O 0 0 0 oooole 0 0 0 Information Technology Human Resources Corporate Supply Chain Administration Other Selling, General & Administrative SGA as percent of Net Revenue Operating Income Operating Income as % of Net Sales 0 0 0 0 0 0 0 0 0 0 0 010 0 0 0 0 0 0 0 0 0 0 0% 0% 0% 0% 0% 0 0% 69,310 4% 0% (312,245) -28% (368,735) -34% (95,304) -5% 0% 66,698 3% 0% 2,844 0% 0% 19,889 1% 0% 97,119 4% 87,275 4% 0% 58,385 3% 38,091 2% 0% (59,120) -4% (395,794) -2% 0 0 0 0 0 0 ooo 0 0 0 0 0 Interest Income Interest on API Loan Dividend Income Miscellaneous Income Other Income 0 O O O O 0 Ooo 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O O Oo oo O O O O O 0 o o o o o Oo oo O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Amortization Expense Interest Expense Other Miscellaneous Expenses Foreign Exchange (Gain) Loss Earnings From Subsidiaries Other Expenses Pretax Income Income Taxes Net Income Total Addbacks - EBITDA EBITDA EBITDA as % of Net Revenue 0 (395,794) (312,245) (95,304) 69,310 66,698 2,844 97,119 87,275 58,385 38,091 (59,120) 0 0 0 0 0 0 0 0 0 0 0 (312,245) (95,304) 69,310 66,698 2,844 97,119 58,385 (368,735) 0 (368,735) 0 (309,970) -28% 19,889 0 19,889 0 78,654 4% 0 0 0 0 0 0 0 87,275 0 146,040 7% 38,091 0 96,856 5% (59,120) 0 (355) -0% (395,794) 0 309,386 1% (253,480) -22% (36,539) -2% 128,075 7% 125,463 6% 61,609 3% 155,884 7% 117,150 6%
Step 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