WASTE CONTROL CONCEPTS CORPORATION

$($$$000)$

Actual Actual Actual Actual Actual Forecast Forecast Forecast Forecast Forecast

$2019202020212022202320242025202620272028$

Income Statement

Revenue $$250,000\mathrm{.}0$ $$268,000\mathrm{.}0$ $$284,000\mathrm{.}0$ $$300,000\mathrm{.}0$ $$315,000\mathrm{.}0$

Cost of services $155,500\mathrm{.}0166,000\mathrm{.}0177,835\mathrm{.}0188,900\mathrm{.}0197,250\mathrm{.}0$

Gross profit $94,500\mathrm{.}0102,000\mathrm{.}0106,165\mathrm{.}0111,100\mathrm{.}0117,750\mathrm{.}0$

Depreciation expense $20,325\mathrm{.}022,415\mathrm{.}021,900\mathrm{.}022,550\mathrm{.}024,195\mathrm{.}0$

SG&A expense $25,500\mathrm{.}026,700\mathrm{.}028,700\mathrm{.}029,600\mathrm{.}030,760\mathrm{.}0$

Total expenses $45,825\mathrm{.}049,115\mathrm{.}050,600\mathrm{.}052,150\mathrm{.}054,955\mathrm{.}0$

EBIT $48,675\mathrm{.}052,885\mathrm{.}055,565\mathrm{.}058,950\mathrm{.}062,795\mathrm{.}0$

Interest Expense $4,875\mathrm{.}04,687\mathrm{.}54,312\mathrm{.}53,937\mathrm{.}53,562\mathrm{.}5$ Calculate on average balance

Pretax Profit $43,800\mathrm{.}048,197\mathrm{.}551,252\mathrm{.}555,012\mathrm{.}559,232\mathrm{.}5$

Tax $10,950\mathrm{.}012,049\mathrm{.}412,813\mathrm{.}113,753\mathrm{.}114,808\mathrm{.}1$

Net Income $$32,850\mathrm{.}0$ $$36,148\mathrm{.}1$ $$38,439\mathrm{.}4$ $$41,259\mathrm{.}4$ $$44,424\mathrm{.}4$

Balance Sheet

Cash $$5,000\mathrm{.}0$ $$9,939\mathrm{.}4$ $$14,996\mathrm{.}3$ $$17,819\mathrm{.}1$ $$23,326\mathrm{.}4$ $$10,000\mathrm{.}0$ $$10,000\mathrm{.}0$ $$10,000\mathrm{.}0$ $$10,000\mathrm{.}0$ $$10,000\mathrm{.}0$

Accounts receivable $24,300\mathrm{.}024,800\mathrm{.}026,245\mathrm{.}026,900\mathrm{.}029,200\mathrm{.}0$

Inventory $5,200\mathrm{.}05,500\mathrm{.}05,900\mathrm{.}06,460\mathrm{.}06,640\mathrm{.}0$

Total current assets $34,500\mathrm{.}040,239\mathrm{.}447,141\mathrm{.}351,179\mathrm{.}159,166\mathrm{.}4$

Property, Plant, and Equipment $-$ net $205,000\mathrm{.}0207,300\mathrm{.}0209,500\mathrm{.}0213,900\mathrm{.}0216,115\mathrm{.}0$

Other long$-$term assets $2,000\mathrm{.}02,500\mathrm{.}02,500\mathrm{.}03,000\mathrm{.}03,250\mathrm{.}0$

Total Assets $241,500\mathrm{.}0250,039\mathrm{.}4259,141\mathrm{.}3268,079\mathrm{.}1278,531\mathrm{.}4$

Accounts Payable $21,750\mathrm{.}023,570\mathrm{.}025,600\mathrm{.}026,505\mathrm{.}027,900\mathrm{.}0$

Accrued Expenses $3,150\mathrm{.}03,525\mathrm{.}03,765\mathrm{.}04,020\mathrm{.}04,300\mathrm{.}0$

Total Current Liabilities $24,900\mathrm{.}027,095\mathrm{.}029,365\mathrm{.}030,525\mathrm{.}032,200\mathrm{.}0$

Debt $-$ long$-$term $65,000\mathrm{.}060,000\mathrm{.}055,000\mathrm{.}050,000\mathrm{.}045,000\mathrm{.}0$ Solve for debt level

Other long$-$term liabilities $3,500\mathrm{.}04,000\mathrm{.}04,300\mathrm{.}04,700\mathrm{.}05,150\mathrm{.}0$

Total Liabilities $93,400\mathrm{.}091,095\mathrm{.}088,665\mathrm{.}085,225\mathrm{.}082,350\mathrm{.}0$

Common stock $30,000\mathrm{.}030,000\mathrm{.}030,000\mathrm{.}030,000\mathrm{.}030,000\mathrm{.}030,000\mathrm{.}030,000\mathrm{.}030,000\mathrm{.}030,000\mathrm{.}030,000\mathrm{.}0$

Retained earnings $118,100\mathrm{.}0128,944\mathrm{.}4140,476\mathrm{.}3152,854\mathrm{.}1166,181\mathrm{.}4$

Total Liabilities and Equity $$241,500\mathrm{.}0$ $$250,039\mathrm{.}4$ $$259,141\mathrm{.}3$ $$268,079\mathrm{.}1$ $$278,531\mathrm{.}4$

Revenue growth rate n$/$a $7\mathrm{.}2\%6\mathrm{.}0\%5\mathrm{.}6\%5\mathrm{.}0\%$

Common Size

Revenue