Q3.a Q3.b Please calculate Greene Sales sustainable and actual growth rates from 2018 through 2022. Note that actual rates are based on a flat growth rate assumption during this period. What seems to be the main financing issue for the firm during this period? Does the firm seem to be actively responding to this problem by changing its PM, AT or FL? Is the firm's finacial leverage increasing or decreasing during this period? What would you recommend to the firm in addressing its main financing problem you've identified above! a. 2018 2019 2020 2021 2022 Sales Cost of Goods Sold Gross Profit Selling, General, & Administrative Exp. Operating Income Before Deprec. Depreciation & Amortization Operating Profit Interest Expense Pretax Income Total Income Taxes Net Income Greene Sales Co INCOME STATEMENT (S millions) Actual 2017 2018 2019 582.762 652.693 731.017 240.828 254.550 285.096 341.934 398.143 445.920 257.507 319.820 358.198 84.427 78.323 87.722 25.221 29.371 32.896 59.206 48.952 54.826 16.430 18.636 18.801 42.776 30.316 36,025 14.971 10.611 12.609 27.805 19.705 23.416 Forecast 2020 818.739 319.308 499,431 401.182 98.249 36,843 61.405 18.841 42.564 14.897 27.667 2021 916.987 357.625 559.362 449.324 110,038 41.264 68.774 18.733 50.041 17.514 32.527 2022 1,027.026 400.540 626.486 503.243 123.243 46.216 77.027 18.446 58.581 20.503 38.078 Profit margin Retention ratio Asset tumover Financial leverage Sustainable growth rate Actual growth rate Sustainable - actual growth rate b BALANCE SHEET (5 millions) ASSETS Cash & Equivalents Account Receivable Inventories Prepaid Expenses Other Current Assets Total Current Assets Net Property, Plant, & Equipment Intangible Assets Other Assets TOTAL ASSETS 7.152 70.538 39.033 9.339 27.076 153.138 81.648 9.415 24.642 268.843 13.054 84.850 32.635 9.339 39.162 179.039 97.904 9.415 32.635 318.993 14.620 95.032 36.551 9,339 43.861 199.403 109.652 9.415 36.551 355.022 16.375 106.436 40.937 9.339 49.124 222.211 122.811 9.415 40.937 395.374 18.340 119.208 45.849 9.339 55.019 247.756 137.548 9.415 45.849 440.568 20.541 133.513 51.351 9.339 61.622 276.366 154.054 9.415 51.351 491.186 LIABILITIES Accounts Payable Accrued Expenses Other Current Liabilities Total Current Liabilities Long Term Debt Accrued Wages Total Liabilities 36.951 31.206 3.663 71.820 157.720 21.418 250.958 39.162 32.635 3.663 75.459 186.363 19.581 281.403 43.861 36,551 3.663 84.075 188.010 21.930 294.015 49.124 40.937 3.663 93.724 188.414 24.562 306,701 55.019 45.849 3.663 104.532 187.327 27.510 319.368 61.622 51.351 3.663 116.636 184.462 30.811 331.908 EQUITY Common Stock Capital Surplus Retained Eamings Less: Treasury Stock Total Equity 1.702 55.513 118.729 158.059 17.885 1.702 55.513 138,434 158,059 37.590 1.702 55.513 161.851 158.059 61.007 1.702 SS.S13 189.517 158,059 88.673 1.702 55.513 222.044 158.059 121.200 1.702 55.513 260.122 158,059 159.278 TOTAL LIABILITIES & EQUITY 268,843 318.993 355.022 395,374 440.568 491.186 Q3.a Q3.b Please calculate Greene Sales sustainable and actual growth rates from 2018 through 2022. Note that actual rates are based on a flat growth rate assumption during this period. What seems to be the main financing issue for the firm during this period? Does the firm seem to be actively responding to this problem by changing its PM, AT or FL? Is the firm's finacial leverage increasing or decreasing during this period? What would you recommend to the firm in addressing its main financing problem you've identified above! a. 2018 2019 2020 2021 2022 Sales Cost of Goods Sold Gross Profit Selling, General, & Administrative Exp. Operating Income Before Deprec. Depreciation & Amortization Operating Profit Interest Expense Pretax Income Total Income Taxes Net Income Greene Sales Co INCOME STATEMENT (S millions) Actual 2017 2018 2019 582.762 652.693 731.017 240.828 254.550 285.096 341.934 398.143 445.920 257.507 319.820 358.198 84.427 78.323 87.722 25.221 29.371 32.896 59.206 48.952 54.826 16.430 18.636 18.801 42.776 30.316 36,025 14.971 10.611 12.609 27.805 19.705 23.416 Forecast 2020 818.739 319.308 499,431 401.182 98.249 36,843 61.405 18.841 42.564 14.897 27.667 2021 916.987 357.625 559.362 449.324 110,038 41.264 68.774 18.733 50.041 17.514 32.527 2022 1,027.026 400.540 626.486 503.243 123.243 46.216 77.027 18.446 58.581 20.503 38.078 Profit margin Retention ratio Asset tumover Financial leverage Sustainable growth rate Actual growth rate Sustainable - actual growth rate b BALANCE SHEET (5 millions) ASSETS Cash & Equivalents Account Receivable Inventories Prepaid Expenses Other Current Assets Total Current Assets Net Property, Plant, & Equipment Intangible Assets Other Assets TOTAL ASSETS 7.152 70.538 39.033 9.339 27.076 153.138 81.648 9.415 24.642 268.843 13.054 84.850 32.635 9.339 39.162 179.039 97.904 9.415 32.635 318.993 14.620 95.032 36.551 9,339 43.861 199.403 109.652 9.415 36.551 355.022 16.375 106.436 40.937 9.339 49.124 222.211 122.811 9.415 40.937 395.374 18.340 119.208 45.849 9.339 55.019 247.756 137.548 9.415 45.849 440.568 20.541 133.513 51.351 9.339 61.622 276.366 154.054 9.415 51.351 491.186 LIABILITIES Accounts Payable Accrued Expenses Other Current Liabilities Total Current Liabilities Long Term Debt Accrued Wages Total Liabilities 36.951 31.206 3.663 71.820 157.720 21.418 250.958 39.162 32.635 3.663 75.459 186.363 19.581 281.403 43.861 36,551 3.663 84.075 188.010 21.930 294.015 49.124 40.937 3.663 93.724 188.414 24.562 306,701 55.019 45.849 3.663 104.532 187.327 27.510 319.368 61.622 51.351 3.663 116.636 184.462 30.811 331.908 EQUITY Common Stock Capital Surplus Retained Eamings Less: Treasury Stock Total Equity 1.702 55.513 118.729 158.059 17.885 1.702 55.513 138,434 158,059 37.590 1.702 55.513 161.851 158.059 61.007 1.702 SS.S13 189.517 158,059 88.673 1.702 55.513 222.044 158.059 121.200 1.702 55.513 260.122 158,059 159.278 TOTAL LIABILITIES & EQUITY 268,843 318.993 355.022 395,374 440.568 491.186