please help solve LT debt
Forecast WASTE CONTROL CONCEPTS CORPORATION ($000) Actual Actual Actual Actual Actual 2015 2016 2017 2018 2019 Income Statement Revenue $ 250,000.0 $ 268,000.0 $ 284,000.0 $ 300,000.0 $ 315,000.0 Forecast 2020 Forecast 2021 Forecast 2022 Forecast 2024 2023 $ 409,500.0 $ 429,975.0 $ 451,473.8 $ 474,047.4 $ 497,749.8 Cost of services Gross profit 155,500.0 94,500.0 166,000.0 102,000.0 177,835.0 106,165.0 188,900.0 111,100.0 197,250.0 117,750.0 255,937.5 153,562.5 268,734.4 161,240.6 282,171.1 169,302.7 296,279.6 177,767.8 311,093.6 186,656.2 SG&A expense Depreciation expense Total expenses 25,500.0 20,325.0 45,825.0 26,700.0 22,415.0 49,115.0 28,700.0 21,900.0 50,600.0 29,600.0 22,550.0 52,150.0 30,760.0 24,195.0 54,955.0 38,902.5 30,712.5 69,615.0 40,847.6 32,248.1 73,095.8 42,890.0 33,860.5 76,750.5 45,034.5 35,553.6 80,588.1 47,286.2 37,331.2 84,617.5 EBIT Interest Expense Pretax Profit Tax 48,675.0 52,885.0 4,875.0 4,687.5 43,800.0 48,197.5 10,950.0 12,049.4 $ 32,850.0 $ 36,148.1 55,565.0 58,950.0 62,795.0 4,312.5 3,937.5 3,562.5 51,252.5 55,012.5 59,232.5 12,813.1 13,753.1 14,808.1 $ 38,439.4 $ 41,259.4 $ 44,424.4 $ 83,947.5 88,144.9 92,552.1 4,125.0 4,125.0 4,125.0 79,822.5 84,019.9 88,427.1 19,955.6 21,005.0 22,106.8 59,866.9 $ 63,014.9 $ 66,320.3 97,179.7 102,038.7 4,125.0 4,125.0 Calculate on average balance 93,054.7 97,913.7 23,263.7 24,478.4 $ 69,791.0 $ 73,435.3 F Net Income $ Balance Sheet Cash Accounts receivable Inventory Total current assets 5,000.0 $ 24,300.0 5,200.0 34,500.0 9,939.4 $ 24,800.0 5,500.0 40,239.4 14,996.3 $ 17,819.1 $ 23,326.4 $ 26,245.0 26,900.0 29,200.0 5,900.0 6,460.0 6,640.0 47,141.3 51,179.1 59,166.4 10,000.0 $ 10,000.0 $ 10,000.0 $ 10,000.0 $ 39,267.1 41,230.5 43,292.0 45,456.6 8,531.3 8,957.8 9,405.7 9,876.0 57,798.4 60,188.3 62,697.7 65,332.6 10,000.0 47,729.4 10,369.8 68,099.2 Net fixed assets Other long-term assets Total Assets 205,000.0 2,000.0 241,500.0 207,300.0 2,500.0 250,039.4 209,500.0 2,500.0 259,141.3 213,900.0 3,000.0 268,079.1 216,115.0 3,250.0 278,531.4 226,920.8 4,095.0 288,814.1 238,266.8 4,299.8 302,754.8 250,180.1 4,514.7 317,392.6 262,689.1 4,740.5 332,762.2 275,823.6 4,977.5 348,900.3 $ Balance Sheet Cash Accounts receivable Inventory Total current assets 5,000.0 $ 24,300.0 5,200.0 34,500.0 9,939.4 $ 14,996.3 $ 17,819.1 $ 23,326.4 $ 24,800.0 26,245.0 26,900.0 29,200.0 5,500.0 5,900.0 6,460.0 6,640.0 40,239.4 47,141.3 51,179.1 59,166.4 10,000.0 $ 10,000.0 $ 10,000.0 $ 10,000.0 $ 10,000.0 39.267.1 41,230.5 43,292.0 45,456.6 47,729.4 8,531.3 8,957.8 9,405.7 9,876.0 10,369.8 57,798.4 60,188.3 62,697.7 65,332.6 68,099.2 Net fixed assets Other long-term assets Total Assets 205,000.0 2,000.0 241,500.0 207,300.0 2,500.0 250,039.4 209,500.0 2,500.0 259,141.3 213,900.0 3,000.0 268,079.1 216, 115.0 3,250.0 278,531.4 226,920.8 4,095.0 288,814.1 238,266.8 4,299.8 302,754.8 250,180.1 4,514.7 317,392.6 262,689.1 4,740.5 332,762.2 275,823.6 4,977.5 348,900.3 Accounts Payable Accrued Expenses Total Current Liabilities 21,750.0 3,150.0 24,900.0 23,570.0 3,525.0 27,095.0 25,600.0 3,765.0 29,365.0 26,505.0 4,020.0 30,525.0 27,900.0 4,300.0 32,200.0 29,295.0 5,118.8 34,413.8 30,759.8 5,374.7 36,134,4 32,297.7 5,643.4 37,941.2 33,912.6 5,925.6 39,838.2 35,608.3 6,221.9 41,830.1 Salve for debt level Debt - long-term Other long-term liabilities Total Liabilities 65,000.0 3,500.0 93,400.0 60,000.0 4,000.0 91,095.0 55,000.0 4,300.0 88,665.0 50,000.0 4,700.0 85,225.0 45,000.0 5,150.0 82,350.0 24,445.9 3,839.1 28,285.0 4,031,0 4,232.6 4,444.2 4,666.4 Common stock Retained earnings Total Liabilities and Equity 30,000.0 30,000.0 30,000.0 30,000.0 30,000.0 118,100.0 128,944.4 140,476.3 152,854.1 166,181.4 $ 241,500.0 $ 250,039.4 $ 259,141.3 $ 268,079.1 $ 278,531.4 $ 30,000.0 30,000.0 30,000.0 30,000.0 30,000.0 196,114.8 227,622.3 260,782.4 295,678.0 332,395.6 288,814.1 $ 302,754.8 $ 317,392.6 $ 332,762.2 $ 348,900.3 Revenue growth rate n/a 7.2% 6.0% 5.6% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 62.2% 10.2% 8.1% 61.9% 10.0% 8.4% 62.6% 10.1% 7.7% 63.0% 9.9% 7.5% 62.6% 9.8% 7.7% 62.5% 9.5% 7.5% 62.5% 9.5% 7.5% 62.5% 9.5% 7.5% 62.5% 9.5% 7.5% 62.5% 9.5% 7.5% Percentage of Revenue Cost of services SG&A expense Depreciation Ratios Days sales in accounts receivable Inventory turnover Other long-term assets % of revenue Days days cost of services (COS) in accounts payat Accrued expense as a % of COS Other long-term liabilities as a % of cos Dividend payout Net capital spending as a % of revenue Tax rate Interest rate 35.0 29.9 0.8% 51.1 2.0% 1.4% 70.0% 10.0% 25.0% 7.5% 33.3 30.2 0.9% 51.8 2.1% 1.5% 70.0% 9.2% 25.0% 7.5% 33.3 30.1 0.9% 52.5 2.1% 1.5% 70.0% 8.5% 25.0% 7.5% 32.3 29.2 1.0% 51.2 2.1% 1.6% 70.0% 9.0% 25.0% 7.5% 33.4 29.7 1.0% 51.6 2.2% 1.6% 70.0% 8.4% 25.0% 7.5% 35.0 30.0 1.0% 50.0 2.0% 1.5% 50.0% 8.0% 25.0% 7.5% 35.0 30.0 1.0% 50.0 2.0% 1.5% 50.0% 8.0% 25.0% 7.5% 35.0 30.0 1.0% 50.0 2.0% 1.5% 50.0% 8.0% 25.0% 7.5% 35.0 30.0 1.0% 50.0 2.0% 1.5% 50.0% 8.0% 25.0% 7.5% 35.0 30.0 1.0% 50.0 2.0% 1.5% 50.0% 8.0% 25.0% 7.5% Note: Blue cells are assumptions Forecast WASTE CONTROL CONCEPTS CORPORATION ($000) Actual Actual Actual Actual Actual 2015 2016 2017 2018 2019 Income Statement Revenue $ 250,000.0 $ 268,000.0 $ 284,000.0 $ 300,000.0 $ 315,000.0 Forecast 2020 Forecast 2021 Forecast 2022 Forecast 2024 2023 $ 409,500.0 $ 429,975.0 $ 451,473.8 $ 474,047.4 $ 497,749.8 Cost of services Gross profit 155,500.0 94,500.0 166,000.0 102,000.0 177,835.0 106,165.0 188,900.0 111,100.0 197,250.0 117,750.0 255,937.5 153,562.5 268,734.4 161,240.6 282,171.1 169,302.7 296,279.6 177,767.8 311,093.6 186,656.2 SG&A expense Depreciation expense Total expenses 25,500.0 20,325.0 45,825.0 26,700.0 22,415.0 49,115.0 28,700.0 21,900.0 50,600.0 29,600.0 22,550.0 52,150.0 30,760.0 24,195.0 54,955.0 38,902.5 30,712.5 69,615.0 40,847.6 32,248.1 73,095.8 42,890.0 33,860.5 76,750.5 45,034.5 35,553.6 80,588.1 47,286.2 37,331.2 84,617.5 EBIT Interest Expense Pretax Profit Tax 48,675.0 52,885.0 4,875.0 4,687.5 43,800.0 48,197.5 10,950.0 12,049.4 $ 32,850.0 $ 36,148.1 55,565.0 58,950.0 62,795.0 4,312.5 3,937.5 3,562.5 51,252.5 55,012.5 59,232.5 12,813.1 13,753.1 14,808.1 $ 38,439.4 $ 41,259.4 $ 44,424.4 $ 83,947.5 88,144.9 92,552.1 4,125.0 4,125.0 4,125.0 79,822.5 84,019.9 88,427.1 19,955.6 21,005.0 22,106.8 59,866.9 $ 63,014.9 $ 66,320.3 97,179.7 102,038.7 4,125.0 4,125.0 Calculate on average balance 93,054.7 97,913.7 23,263.7 24,478.4 $ 69,791.0 $ 73,435.3 F Net Income $ Balance Sheet Cash Accounts receivable Inventory Total current assets 5,000.0 $ 24,300.0 5,200.0 34,500.0 9,939.4 $ 24,800.0 5,500.0 40,239.4 14,996.3 $ 17,819.1 $ 23,326.4 $ 26,245.0 26,900.0 29,200.0 5,900.0 6,460.0 6,640.0 47,141.3 51,179.1 59,166.4 10,000.0 $ 10,000.0 $ 10,000.0 $ 10,000.0 $ 39,267.1 41,230.5 43,292.0 45,456.6 8,531.3 8,957.8 9,405.7 9,876.0 57,798.4 60,188.3 62,697.7 65,332.6 10,000.0 47,729.4 10,369.8 68,099.2 Net fixed assets Other long-term assets Total Assets 205,000.0 2,000.0 241,500.0 207,300.0 2,500.0 250,039.4 209,500.0 2,500.0 259,141.3 213,900.0 3,000.0 268,079.1 216,115.0 3,250.0 278,531.4 226,920.8 4,095.0 288,814.1 238,266.8 4,299.8 302,754.8 250,180.1 4,514.7 317,392.6 262,689.1 4,740.5 332,762.2 275,823.6 4,977.5 348,900.3 $ Balance Sheet Cash Accounts receivable Inventory Total current assets 5,000.0 $ 24,300.0 5,200.0 34,500.0 9,939.4 $ 14,996.3 $ 17,819.1 $ 23,326.4 $ 24,800.0 26,245.0 26,900.0 29,200.0 5,500.0 5,900.0 6,460.0 6,640.0 40,239.4 47,141.3 51,179.1 59,166.4 10,000.0 $ 10,000.0 $ 10,000.0 $ 10,000.0 $ 10,000.0 39.267.1 41,230.5 43,292.0 45,456.6 47,729.4 8,531.3 8,957.8 9,405.7 9,876.0 10,369.8 57,798.4 60,188.3 62,697.7 65,332.6 68,099.2 Net fixed assets Other long-term assets Total Assets 205,000.0 2,000.0 241,500.0 207,300.0 2,500.0 250,039.4 209,500.0 2,500.0 259,141.3 213,900.0 3,000.0 268,079.1 216, 115.0 3,250.0 278,531.4 226,920.8 4,095.0 288,814.1 238,266.8 4,299.8 302,754.8 250,180.1 4,514.7 317,392.6 262,689.1 4,740.5 332,762.2 275,823.6 4,977.5 348,900.3 Accounts Payable Accrued Expenses Total Current Liabilities 21,750.0 3,150.0 24,900.0 23,570.0 3,525.0 27,095.0 25,600.0 3,765.0 29,365.0 26,505.0 4,020.0 30,525.0 27,900.0 4,300.0 32,200.0 29,295.0 5,118.8 34,413.8 30,759.8 5,374.7 36,134,4 32,297.7 5,643.4 37,941.2 33,912.6 5,925.6 39,838.2 35,608.3 6,221.9 41,830.1 Salve for debt level Debt - long-term Other long-term liabilities Total Liabilities 65,000.0 3,500.0 93,400.0 60,000.0 4,000.0 91,095.0 55,000.0 4,300.0 88,665.0 50,000.0 4,700.0 85,225.0 45,000.0 5,150.0 82,350.0 24,445.9 3,839.1 28,285.0 4,031,0 4,232.6 4,444.2 4,666.4 Common stock Retained earnings Total Liabilities and Equity 30,000.0 30,000.0 30,000.0 30,000.0 30,000.0 118,100.0 128,944.4 140,476.3 152,854.1 166,181.4 $ 241,500.0 $ 250,039.4 $ 259,141.3 $ 268,079.1 $ 278,531.4 $ 30,000.0 30,000.0 30,000.0 30,000.0 30,000.0 196,114.8 227,622.3 260,782.4 295,678.0 332,395.6 288,814.1 $ 302,754.8 $ 317,392.6 $ 332,762.2 $ 348,900.3 Revenue growth rate n/a 7.2% 6.0% 5.6% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 62.2% 10.2% 8.1% 61.9% 10.0% 8.4% 62.6% 10.1% 7.7% 63.0% 9.9% 7.5% 62.6% 9.8% 7.7% 62.5% 9.5% 7.5% 62.5% 9.5% 7.5% 62.5% 9.5% 7.5% 62.5% 9.5% 7.5% 62.5% 9.5% 7.5% Percentage of Revenue Cost of services SG&A expense Depreciation Ratios Days sales in accounts receivable Inventory turnover Other long-term assets % of revenue Days days cost of services (COS) in accounts payat Accrued expense as a % of COS Other long-term liabilities as a % of cos Dividend payout Net capital spending as a % of revenue Tax rate Interest rate 35.0 29.9 0.8% 51.1 2.0% 1.4% 70.0% 10.0% 25.0% 7.5% 33.3 30.2 0.9% 51.8 2.1% 1.5% 70.0% 9.2% 25.0% 7.5% 33.3 30.1 0.9% 52.5 2.1% 1.5% 70.0% 8.5% 25.0% 7.5% 32.3 29.2 1.0% 51.2 2.1% 1.6% 70.0% 9.0% 25.0% 7.5% 33.4 29.7 1.0% 51.6 2.2% 1.6% 70.0% 8.4% 25.0% 7.5% 35.0 30.0 1.0% 50.0 2.0% 1.5% 50.0% 8.0% 25.0% 7.5% 35.0 30.0 1.0% 50.0 2.0% 1.5% 50.0% 8.0% 25.0% 7.5% 35.0 30.0 1.0% 50.0 2.0% 1.5% 50.0% 8.0% 25.0% 7.5% 35.0 30.0 1.0% 50.0 2.0% 1.5% 50.0% 8.0% 25.0% 7.5% 35.0 30.0 1.0% 50.0 2.0% 1.5% 50.0% 8.0% 25.0% 7.5% Note: Blue cells are assumptions
