Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Practical Auditing

Authors: Ernest Evan Spicer, Ernest Charles Pegler

17th Edition

0406678014, 9780406678010

More Books

Students also viewed these Accounting questions

Question

3. List your top 10 film mentors.

Answered: 1 week ago