Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need formula for G to K, or tell me how to calculate it thanks! - 2021 current revenue levels will increase at an annual

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedI need formula for G to K, or tell me how to calculate it

thanks!

- 2021 current revenue levels will increase at an annual rate of 4.5% - The acquisition of Harbor will add $100.0 million of incremental revenue in 2022 and it will increase at an annual rate of 5.0% thereafter - Cost of services will be 64% of revenue - SG\&A expense will be 10% of revenue in 2022 and 2023 and then decrease to 9.5% thereafter - Depreciation expense will be 7.0% of revenue - Interest expense for 2022 will be based on the 2022 debt balance. Thereafter, interest expense will be based on the average debt balance of the prior year and current year. The interest rate on debt over the projection period will be 8.0% - Tax rate of 25.0% Balance Sheet - Constant operating cash level of $15.0 million - Accounts receivable DSO of 35 days - Inventory turnover of 30x (inventory consists of recyclable materials resold) - Other long-term assets at 1.0% of revenue - Accounts payable days cost of sales (COS) of 45 days - Accrued expense 2.2% of COS - Other long-term liabilities 2.5% of COS - Dividend payout ratio to be maintained at 70% - Maintenance capital expenditures of 8.5% of revenue - Expansion capital expenditures are the cost of the acquisition in 2022, no expansion capx beyond 2022 - ESC has 12 million shares outstanding r 2022 calculate on 2022 debt balance, thereafter calculate on average balance - 2021 current revenue levels will increase at an annual rate of 4.5% - The acquisition of Harbor will add $100.0 million of incremental revenue in 2022 and it will increase at an annual rate of 5.0% thereafter - Cost of services will be 64% of revenue - SG\&A expense will be 10% of revenue in 2022 and 2023 and then decrease to 9.5% thereafter - Depreciation expense will be 7.0% of revenue - Interest expense for 2022 will be based on the 2022 debt balance. Thereafter, interest expense will be based on the average debt balance of the prior year and current year. The interest rate on debt over the projection period will be 8.0% - Tax rate of 25.0% Balance Sheet - Constant operating cash level of $15.0 million - Accounts receivable DSO of 35 days - Inventory turnover of 30x (inventory consists of recyclable materials resold) - Other long-term assets at 1.0% of revenue - Accounts payable days cost of sales (COS) of 45 days - Accrued expense 2.2% of COS - Other long-term liabilities 2.5% of COS - Dividend payout ratio to be maintained at 70% - Maintenance capital expenditures of 8.5% of revenue - Expansion capital expenditures are the cost of the acquisition in 2022, no expansion capx beyond 2022 - ESC has 12 million shares outstanding r 2022 calculate on 2022 debt balance, thereafter calculate on average balance

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

Free Dollar For College For Dummies

Authors: David Rosen, Caryn Mladen

1st Edition

0764554670, 978-0764554674

More Books

Students also viewed these Finance questions

Question

10. Describe the relationship between communication and power.

Answered: 1 week ago