Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

one you get the sustainable and actual growth rates explain the answers you ended up with and what those rates represents. Actual Forecast 2017 2018

one you get the sustainable and actual growth rates explain the answers you ended up with and what those rates represents.
image text in transcribed
Actual Forecast 2017 2018 2019 2020 2021 2022 Sales 582.762 652.693 731017 818.739 916.987 1,027.026 Cost of Goods Sold 240.828 254.550285.096 319.308 357.625 400.540 Gross Profit 341.934 398.143 445.920 499.431 559.362 626.486 Seling, General, & Administrative Exp. 257.507 319.820 358.198 401.182 449.324 503.243 Operating Income Before 84.427 Deprec 78.323 87722 98.249 110,038 123.243 Depreciation & Amortization 25221 20.371 32.896 36.843 41264 46.216 Operating Profit 59 206 48.952 54.826 61.405 68.774 77.027 Interest Expense 16.430 18.636 18.801 18.841 18.733 18.446 Pretax income 42.776 30.316 36.025 42.564 50.041 58.581 Total Income Taxes 14.971 10.611 12.609 14.897 17514 20.503 Net Income 27.805 19.705 23.416 27.667 32.522 38.078 BALANCE SHEET (5 millions) ASSETS Cash & Equivalents 7.152 13.054 14.620 16.375 18.340 20.541 Account Receivable 70.538 84.850 95.032 106.436 119.208 133.513 Inventories 39.033 32.635 36.551 40.937 45.849 51.351 Prepaid Expenses 9.339 9.339 9.339 9.339 9.339 Other Current Assets 27.076 39.162 43.861 49.124 55.019 81.622 Total Current Assets 153.138 179.039 199.403 222 211 247756 276.366 Net Property, Plant,& 81.648 Equipment 97.904 109.652 122.811 137.548 154,054 Intangible Assets 9.415 9.415 9.415 9.415 9.415 9.415 Other Assets 24.642 32,635 36.551 40.937 45.849 51.351 TOTAL ASSETS 268.843 318.993 355.022 395.374 440.568 491.186 LIABILITIES Accounts Payable 43.861 49.124 55.019 61.622 36.951 39.162 31206 32.635 3.663 3.663 36.551 Accrued Expenses Other Current Liabilities 40.937 45.849 51.351 3.663 3.663 3.663 3.663 71.820 75.459 84.075 93.724 104.532 116.636 Total Current Liabilities Long Term Debt 157.720 186.363 188,010 188.414187.327 184.462 21.418 19.581 21.930 24562 27.510 Accrued Wages Total Liabilities 30.811 250.958 281.403 294 015 306.701 319.368 331.908 EQUITY Common Stock Capital Surplus 1702 1702 1702 1702 1.702 1.702 55,513 55.513 55.513 55513 55.513 55.513 Retained Earnings 118.729 138.434 161851 189.517 222.044 260.122 Less: Treasury Stock 158.059 158,059 158.059 158.059 158.059 158.059 Total Equity 17.885 37.590 61007 88.673 121.200 159.278 TOTAL LIABILITIES & EQUITY 268.843 318.993 355.022 395.374 4401568 491.186 Actual Forecast 2017 2018 2019 2020 2021 2022 Sales 582.762 652.693 731017 818.739 916.987 1,027.026 Cost of Goods Sold 240.828 254.550285.096 319.308 357.625 400.540 Gross Profit 341.934 398.143 445.920 499.431 559.362 626.486 Seling, General, & Administrative Exp. 257.507 319.820 358.198 401.182 449.324 503.243 Operating Income Before 84.427 Deprec 78.323 87722 98.249 110,038 123.243 Depreciation & Amortization 25221 20.371 32.896 36.843 41264 46.216 Operating Profit 59 206 48.952 54.826 61.405 68.774 77.027 Interest Expense 16.430 18.636 18.801 18.841 18.733 18.446 Pretax income 42.776 30.316 36.025 42.564 50.041 58.581 Total Income Taxes 14.971 10.611 12.609 14.897 17514 20.503 Net Income 27.805 19.705 23.416 27.667 32.522 38.078 BALANCE SHEET (5 millions) ASSETS Cash & Equivalents 7.152 13.054 14.620 16.375 18.340 20.541 Account Receivable 70.538 84.850 95.032 106.436 119.208 133.513 Inventories 39.033 32.635 36.551 40.937 45.849 51.351 Prepaid Expenses 9.339 9.339 9.339 9.339 9.339 Other Current Assets 27.076 39.162 43.861 49.124 55.019 81.622 Total Current Assets 153.138 179.039 199.403 222 211 247756 276.366 Net Property, Plant,& 81.648 Equipment 97.904 109.652 122.811 137.548 154,054 Intangible Assets 9.415 9.415 9.415 9.415 9.415 9.415 Other Assets 24.642 32,635 36.551 40.937 45.849 51.351 TOTAL ASSETS 268.843 318.993 355.022 395.374 440.568 491.186 LIABILITIES Accounts Payable 43.861 49.124 55.019 61.622 36.951 39.162 31206 32.635 3.663 3.663 36.551 Accrued Expenses Other Current Liabilities 40.937 45.849 51.351 3.663 3.663 3.663 3.663 71.820 75.459 84.075 93.724 104.532 116.636 Total Current Liabilities Long Term Debt 157.720 186.363 188,010 188.414187.327 184.462 21.418 19.581 21.930 24562 27.510 Accrued Wages Total Liabilities 30.811 250.958 281.403 294 015 306.701 319.368 331.908 EQUITY Common Stock Capital Surplus 1702 1702 1702 1702 1.702 1.702 55,513 55.513 55.513 55513 55.513 55.513 Retained Earnings 118.729 138.434 161851 189.517 222.044 260.122 Less: Treasury Stock 158.059 158,059 158.059 158.059 158.059 158.059 Total Equity 17.885 37.590 61007 88.673 121.200 159.278 TOTAL LIABILITIES & EQUITY 268.843 318.993 355.022 395.374 4401568 491.186

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

Step: 3

blur-text-image

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

Evolutionary Finance

Authors: Bartholomew Frederick Dowling

1st Edition

0230502199, 9780230502192

More Books

Students also viewed these Finance questions

Question

What attracts you about this role?

Answered: 1 week ago

Question

How many states in India?

Answered: 1 week ago

Question

HOW IS MARKETING CHANGING WITH ARTIFITIAL INTELIGENCE

Answered: 1 week ago