PLEASE ANSWER USING :

1 - EXCEL

2 - DISPLAY FUNCTIONS/CELLS USED AND PROVIDE ORGANIZED SOLUTION EXPLAINING ANSWER

I WILL UPVOTE YOUR ANSWER

Film A's current market value is $250 million and Firm B's market value is $210 million. Both are all-equity firms. Firm A is going to pay $230 million to acquire Firm B. The total value of synergy is $60 million. What is the NPV (in millions) of this acquisition for Firm A? $20 $40 $80 $30