answer in excel with formula

Ex. 3 Company A is considering acquiring company B. \begin{tabular}{|r|c|c|} \hline Present value of Company A & 30 & mn \\ \hline Present value of Company B & 75 & mn \\ \hline Cost saving from merger of A and B & 22 & mn \\ \hline Price A pay for B & 80 & mn \\ \hline \end{tabular} The present value of company B increase by EUR 7mn on the back of rumors about the potential merger. Calculate the adjusted goodwill and adjusted gain for the shareholders of company A and shareholders of Company B after the rumors