Question
I need this solved in Excel: You have been asked to evaluate a potential acquisition of a smaller privately owned competitor. The acquisition candidate produces
I need this solved in Excel: You have been asked to evaluate a potential acquisition of a smaller privately owned competitor. The acquisition candidate produces an EBITDA of 10% of your current EBITDA ($3,509 million) and is offered to your firm at a price of multiple of 8 times EBITDA (of the acquisition candidate's). Assume the following: Current debt costs you 8% and you can raise additional debt at this rate today. The loan is to be amortized over 7 years. Current return on equity is 15% Current WACC is 10% Tax rate is 30% (constant) 80% of the purchase price is considered depreciable assets to be depreciated over ten years on a straight-line basis with no residual values. Residual value for this operation is to be 2x current EBITDA in year ten. Create an after-tax cash flow analysis to answer the following: Economic analysis: is this a fundamentally sound investment? Using the tax cash flows and no debt (pure equity), is the prospect a positive NPV using ROE as the hurdle rate? positive NPV using ROE as the hurdle rate? Using the after tax cash flows and the firms WACC, is this project desirable? Explain how you came to this conclusion.
Current EBITDA - $3,509 million; Acquisition Candidate's EBITDA -$350.90 (10% of current EBITDA); Purchase price - $2,807 million (8 x candidate's EBITDA);
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started