Please help solve. Data from #1 attached. Thanks (:

ETH Income Statement ETH Balance Sheet Ethan Allen Interiors Inc Balance Sheet (Industrial) res in millions of U.S. Dollar, except per share items Jun 15 Jun 14 Jun 13 Jun 12 Jun 16 Assets Cash Only 52.659 76.182 109.176 72.60 79.721 Total Short Term Investments 0.000 2.198 18.153 15.529 9.005 Short-Term Receivables 9.467 12.547 12.426 12.277 14.919 Inventories 162.323 151.916 146.275 137.256 155.739 23.408 282.792 23.755 22.907 Other Current Assets 27.83 19.599 270.674 Total Current Assets Property, Plant &Equipment - Gross Accumulated Depreciation Net Property, Plant& Equipment Other Long-Term Assets Total Assets 305.629 248.204 260.570 598.264 594.912 601.709 594.385 587.368 324.649 317.877 313.553 302.713 291.673 273.615 277.035 288.156 291.672 295.695 55.590 59.599 60.649 65.043 66.301 607.308 654.434 577.409 617.285 644.788 Liabilities&Shareholders' Equity 3.34 3.00 ST Debt&Curr. Portion LT Debt 0.250 0.501 0.480 24.320 27.315 Accounts Payable 15.437 18.946 22.995 Other Current Liabilities 104.909 118.682 111.226 109.464 123.512 Total Current Liabilities Long-Term Debt 136.047] 140.969 123.347 132.939 151.077 38.837 74.227 130.411 130.809 154.250 Other Liabilities 23.023 21.577 17.593 20.509 19.180 Total Liabilities 286.967 236.773 282.928 322.920 185.207 0.486 Common Stock Par/Carry Value Additional Paid-In Capital/Capital Surplus 0.489 0.489 0.486 0.485 361.165 374.972 370.914 365.733 363.938 553.083 Retained Earnings Treasury Stock and Other Deductions from Equity Total Shareholders' Equity Total Liabilities & Shareholders' Equity 646.315 607.079 584.395 542.918 582.700 629.574 607.947 583.150 583.147 321.868 370.535 607.308 392.202 367.467 334.357 577,409 654.434 617.285 644.788 Source: FactSet Fundamentals ETH Income Statement ETH Balance Sheet Ethan Allen Interiors Inc. Income Statement (Industrial) in millions of U.S. Dollar, except per share items Jun 12 729.373 Jun '16 Jun '15 Jun '14 Jun 13 Sales 794.202 754.600 746.659 729.083 Cost of Goods Sold (COGS) inel. D&A Gross Income 351.966 343.437 340.163 330.734 339.085 442.236 390.288 411.163 406.496 398.349 337.912 SG&A Expense EBIT (Operating Income) Interest Expense 353.057 345.229 336.860 340.676 69.636 7.540 89.179 65.934 49.612 60.437 5.957 1.618 8.778 9.020 Other Income Net 0.395 1.206 0.306 0.562 -1.485 nusual Expense - Net Pretax Income 0,000 4.500 0.000 0.000 -0.085 62.402 50.174 87.956 56.683 41.239 Income Taxes Net Income 17.696 31.319 19.54 19.471 -8.455 49.694 56.637 32.478 42.931 37.142 EPS (recurring) EPS (diluted) Diluted Shares Outstanding Total Shares Outstanding Dividends per Share Payout Ratio 1.47 171 2.00 1.38 1.11 2.00 1.27 1.47 1.71 28.32 29.18 29.28 29.24 29.11 27.75 28.4 28.93 28.9 28.84 0.62 0.36 0.50 0.40 0.30 39.37 27.21 17.54 31.00 32.43 68.19 49,61 EBITDA 108.53 85.08 87.57 78.45 EBIT 65.93 69.64 60.44 89.18 Depreciation& Amortization Expense 17.93 18.58 19.35 19.14 18.0 Source : FactSet Fundamentals 2. Use the same data as in Problem Recalculate the percentage of sales income statement, but this time . use the TREND function to forecast other income and interest expense. b. Recalculate the percentage of sales balance sheet, but this time use the TREND function to forecast cash, other long-term assets, and other liabilities Do these new values appear to be more realistic than the original values? Does this make sense for each of these items? Might other income statement or balance sheet items be forecasted in this way? . ETH Income Statement ETH Balance Sheet Ethan Allen Interiors Inc Balance Sheet (Industrial) res in millions of U.S. Dollar, except per share items Jun 15 Jun 14 Jun 13 Jun 12 Jun 16 Assets Cash Only 52.659 76.182 109.176 72.60 79.721 Total Short Term Investments 0.000 2.198 18.153 15.529 9.005 Short-Term Receivables 9.467 12.547 12.426 12.277 14.919 Inventories 162.323 151.916 146.275 137.256 155.739 23.408 282.792 23.755 22.907 Other Current Assets 27.83 19.599 270.674 Total Current Assets Property, Plant &Equipment - Gross Accumulated Depreciation Net Property, Plant& Equipment Other Long-Term Assets Total Assets 305.629 248.204 260.570 598.264 594.912 601.709 594.385 587.368 324.649 317.877 313.553 302.713 291.673 273.615 277.035 288.156 291.672 295.695 55.590 59.599 60.649 65.043 66.301 607.308 654.434 577.409 617.285 644.788 Liabilities&Shareholders' Equity 3.34 3.00 ST Debt&Curr. Portion LT Debt 0.250 0.501 0.480 24.320 27.315 Accounts Payable 15.437 18.946 22.995 Other Current Liabilities 104.909 118.682 111.226 109.464 123.512 Total Current Liabilities Long-Term Debt 136.047] 140.969 123.347 132.939 151.077 38.837 74.227 130.411 130.809 154.250 Other Liabilities 23.023 21.577 17.593 20.509 19.180 Total Liabilities 286.967 236.773 282.928 322.920 185.207 0.486 Common Stock Par/Carry Value Additional Paid-In Capital/Capital Surplus 0.489 0.489 0.486 0.485 361.165 374.972 370.914 365.733 363.938 553.083 Retained Earnings Treasury Stock and Other Deductions from Equity Total Shareholders' Equity Total Liabilities & Shareholders' Equity 646.315 607.079 584.395 542.918 582.700 629.574 607.947 583.150 583.147 321.868 370.535 607.308 392.202 367.467 334.357 577,409 654.434 617.285 644.788 Source: FactSet Fundamentals ETH Income Statement ETH Balance Sheet Ethan Allen Interiors Inc. Income Statement (Industrial) in millions of U.S. Dollar, except per share items Jun 12 729.373 Jun '16 Jun '15 Jun '14 Jun 13 Sales 794.202 754.600 746.659 729.083 Cost of Goods Sold (COGS) inel. D&A Gross Income 351.966 343.437 340.163 330.734 339.085 442.236 390.288 411.163 406.496 398.349 337.912 SG&A Expense EBIT (Operating Income) Interest Expense 353.057 345.229 336.860 340.676 69.636 7.540 89.179 65.934 49.612 60.437 5.957 1.618 8.778 9.020 Other Income Net 0.395 1.206 0.306 0.562 -1.485 nusual Expense - Net Pretax Income 0,000 4.500 0.000 0.000 -0.085 62.402 50.174 87.956 56.683 41.239 Income Taxes Net Income 17.696 31.319 19.54 19.471 -8.455 49.694 56.637 32.478 42.931 37.142 EPS (recurring) EPS (diluted) Diluted Shares Outstanding Total Shares Outstanding Dividends per Share Payout Ratio 1.47 171 2.00 1.38 1.11 2.00 1.27 1.47 1.71 28.32 29.18 29.28 29.24 29.11 27.75 28.4 28.93 28.9 28.84 0.62 0.36 0.50 0.40 0.30 39.37 27.21 17.54 31.00 32.43 68.19 49,61 EBITDA 108.53 85.08 87.57 78.45 EBIT 65.93 69.64 60.44 89.18 Depreciation& Amortization Expense 17.93 18.58 19.35 19.14 18.0 Source : FactSet Fundamentals 2. Use the same data as in Problem Recalculate the percentage of sales income statement, but this time . use the TREND function to forecast other income and interest expense. b. Recalculate the percentage of sales balance sheet, but this time use the TREND function to forecast cash, other long-term assets, and other liabilities Do these new values appear to be more realistic than the original values? Does this make sense for each of these items? Might other income statement or balance sheet items be forecasted in this way