The Projected financial statements should be done in Excel and included with your submission. *You will need to make necessary adjustments for material non-recurring or unusual income or expenses as well as off-balance sheet assets or liabilities, among others as covered in the course. The adjustment will improve comparability and ensure accurate representation of the organization's economic performance. Be sure to identify important assumptions regarding the companies, industry and business environment, and other important assumptions for estimates and forecasts, including their business strategies. Show calculations for peir 1 for projected finanical statement

Breakdown 2/28/2019 2/28/2018 2/28/2017 > Assets 656,290 772,319 843,082 Liabilities and stockholders' eq... Liabilities Current Liabilities Current Debt 2,000 2,000 2,000 Accounts Payable 121,969 71,279 68,981 Taxes payable 302 2,301 26,058 Accrued liabilities 85,811 81,854 106,048 Deferred revenues 37,655 55,281 60,398 Total Current Liabilities 269,465 237,129 291,303 Non-current liabilities Long Term Debt 245,624 197,906 199,077 Deferred revenues 1,933 2,516 3,522 Other long-term liabilities 37,923 38,686 35,851 Total non-current liabilities 297,296 257,620 259.751 Total Liabilities 566,761 494,749 551,054 Stockholders' Equity Common Stock 125 125 125 Retained Earnings 534,419 726,232 737,165 Accumulated other comprehe... -7,861 -7,477 -7,414 Total stockholders' equity 89,529 277,570 292,028 Total liabilities and stockholde... 656,290 772,319 843,082 TTM 2/28/2019 2/28/2018 2/28/2017 Breakdown vCash flows from operating activ.. Net Income -310,021 -198.833 11.626 30.129 Depreciation & amortization 57.499 59,523 61.430 60,504 Deferred income taxes 627 -3,071 6,012 -19,645 Stock based compensation 2,337 2.756 3.809 8,228 Change in working capital 12,048 33,043 -21,596 20.095 Inventory 59.398 -540 53.536 4.883 Accounts Payable -53.588 32,249 -33.829 -5.697 Other working capital -221,346 -135.242 12.557 71.557 Other non-cash items 9.986 3,615 2.111 8.301 Net cash provided by operatin. -206.308 -98,798 65,806 115.738 Cash flows from investing activi... Investments in property, planta... -15,038 -36,444 -53.249 -44,181 Purchases of investments - 1.126 -6.927 -26,082 -2.375 Sales/Maturities of investments 3,812 12,063 27.562 3,409 Net cash used for investing act... -11.399 -29,250 -51.609 -43,073 Cash flows from financing activi... Debt repayment -157.000 -2,000 -10.000 -40.000 Common stock repurchased -10.000 -10.566 Dividends Paid 0 -22.294 -22.501 Other financing activites -1,170 -1.291 312 Net cash used privided by (use... 157.926 48.230 -33.278 -33,426 Net change in cash -60,032 -80,501 - 19,081 39.239 Cash at beginning of period 71.109 135 379 154.460 115.221 Cash at end of period 11.328 54,878 135,379 154,460 Free Cash Flow Operating Cash Flow -206,308 -98,798 65,806 115.738 Capital Expenditure - 15.038 -36.444 -53.249 -44.181 Free Cash Flow -221.346 -135.242 12.557 71.557 Income Statement All numbers in thousands A Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown TTM 2/28/2019 2/28/2018 2/28/2017 Total Revenue 1,389.836 1,552.938 1,798,522 1,828,446 Cost of Revenue 1,043,142 1,102,035 1,140,372 1,131,138 Gross Profit 346,694 450,903 658,150 697,308 > Operating Expenses 634,960 638,988 630,481 642,446 Operating Income or Loss -288,266 -188,085 27,669 54,862 Interest Expense 20,507 15,294 12,362 12,073 Income Before Tax -307,291 -201,379 17,897 45,259 Income Tax Expense 2,730 -2,546 6,271 15,130 Income from Continuing Operations -310,021 -198,833 11,626 30,129 Net Income -310,021 -198,833 11,626 30,129 Net Income available to common s... -310,021 -198,833 11,626 30,129 Basic EPS -49.20 2.80 7.40 Diluted EPS -49.20 2.80 7.40 Basic Average Shares 4,035 4,011 4,046 Diluted Average Shares 4,035 4,013 4,049 EBITDA -126,562 91,689 117,836 Breakdown 2/28/2019 2/28/2018 2/28/2017 > Assets 656,290 772,319 843,082 Liabilities and stockholders' eq... Liabilities Current Liabilities Current Debt 2,000 2,000 2,000 Accounts Payable 121,969 71,279 68,981 Taxes payable 302 2,301 26,058 Accrued liabilities 85,811 81,854 106,048 Deferred revenues 37,655 55,281 60,398 Total Current Liabilities 269,465 237,129 291,303 Non-current liabilities Long Term Debt 245,624 197,906 199,077 Deferred revenues 1,933 2,516 3,522 Other long-term liabilities 37,923 38,686 35,851 Total non-current liabilities 297,296 257,620 259.751 Total Liabilities 566,761 494,749 551,054 Stockholders' Equity Common Stock 125 125 125 Retained Earnings 534,419 726,232 737,165 Accumulated other comprehe... -7,861 -7,477 -7,414 Total stockholders' equity 89,529 277,570 292,028 Total liabilities and stockholde... 656,290 772,319 843,082 TTM 2/28/2019 2/28/2018 2/28/2017 Breakdown vCash flows from operating activ.. Net Income -310,021 -198.833 11.626 30.129 Depreciation & amortization 57.499 59,523 61.430 60,504 Deferred income taxes 627 -3,071 6,012 -19,645 Stock based compensation 2,337 2.756 3.809 8,228 Change in working capital 12,048 33,043 -21,596 20.095 Inventory 59.398 -540 53.536 4.883 Accounts Payable -53.588 32,249 -33.829 -5.697 Other working capital -221,346 -135.242 12.557 71.557 Other non-cash items 9.986 3,615 2.111 8.301 Net cash provided by operatin. -206.308 -98,798 65,806 115.738 Cash flows from investing activi... Investments in property, planta... -15,038 -36,444 -53.249 -44,181 Purchases of investments - 1.126 -6.927 -26,082 -2.375 Sales/Maturities of investments 3,812 12,063 27.562 3,409 Net cash used for investing act... -11.399 -29,250 -51.609 -43,073 Cash flows from financing activi... Debt repayment -157.000 -2,000 -10.000 -40.000 Common stock repurchased -10.000 -10.566 Dividends Paid 0 -22.294 -22.501 Other financing activites -1,170 -1.291 312 Net cash used privided by (use... 157.926 48.230 -33.278 -33,426 Net change in cash -60,032 -80,501 - 19,081 39.239 Cash at beginning of period 71.109 135 379 154.460 115.221 Cash at end of period 11.328 54,878 135,379 154,460 Free Cash Flow Operating Cash Flow -206,308 -98,798 65,806 115.738 Capital Expenditure - 15.038 -36.444 -53.249 -44.181 Free Cash Flow -221.346 -135.242 12.557 71.557 Income Statement All numbers in thousands A Get access to 40+ years of historical data with Yahoo Finance Premium. Learn more Breakdown TTM 2/28/2019 2/28/2018 2/28/2017 Total Revenue 1,389.836 1,552.938 1,798,522 1,828,446 Cost of Revenue 1,043,142 1,102,035 1,140,372 1,131,138 Gross Profit 346,694 450,903 658,150 697,308 > Operating Expenses 634,960 638,988 630,481 642,446 Operating Income or Loss -288,266 -188,085 27,669 54,862 Interest Expense 20,507 15,294 12,362 12,073 Income Before Tax -307,291 -201,379 17,897 45,259 Income Tax Expense 2,730 -2,546 6,271 15,130 Income from Continuing Operations -310,021 -198,833 11,626 30,129 Net Income -310,021 -198,833 11,626 30,129 Net Income available to common s... -310,021 -198,833 11,626 30,129 Basic EPS -49.20 2.80 7.40 Diluted EPS -49.20 2.80 7.40 Basic Average Shares 4,035 4,011 4,046 Diluted Average Shares 4,035 4,013 4,049 EBITDA -126,562 91,689 117,836