Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5 points You are leading a team on a M&A deal. Suddenly your analyst has disappeared and you have the following unfinished spreadsheet. The acquirer

image text in transcribed
image text in transcribed
5 points You are leading a team on a M&A deal. Suddenly your analyst has disappeared and you have the following unfinished spreadsheet. The acquirer and the target are assumed to have zero growth. Now it is up to you to finish this job. You also believe that the tax rate will be 20% when this merger closes, so you are using 20% as the corporate tax rate in this calculation. Antw Acquirer Target Combined Sales 500 120 620 200 60 260 Operating Expenses Annual cost savings 40 EBIT 300 717 EBIT(1-1) 240 18 18 48 Depreciation 40 20 ISIRS ??? 30 40 ??? Gross Plant & Equipment 10 un 5 772 Change in Working Capital Free Cash Flow to Firm 240 23 722 8.00% 996 896 Discount rate 3000 255.56 Firm Value 27? 1000 100 1100 Long term debt 2000 155.56 237 Equity value 240 23 ?2? Free Cash Flow to Firm Discount rate 8.00% 9% 8% Firm Value 3000 255.56 ??? Long term debt 1000 100 1100 Equity value 2000 155.56 ?3? ?1? is 22? is 73? is The synergy of this merger is The maximum offer you can make is

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

Principles Of Finance With Excel

Authors: Simon Benninga, Tal Mofkadi

3rd Edition

0190296380, 9780190296384

More Books

Students also viewed these Finance questions