answer in excel using formula

Ex. 6 \begin{tabular}{l|c|l|l|} \hline Closing share price Z & 36 & EUR per share (at closing day of acquisition date) \\ \hline Number of shares outstandin & 500,000 & & \\ \hline Equity of company Z & 1,800,000 & EUR mn \\ \hline Debt of company Z & 1,550,000 & EUR mn \\ \hline Cash of company Z & 300,000 & EUR mn \\ \hline Total Annual Revenue & 1,900,000 & EUR mn \\ \hline \end{tabular} Considering that the industry average ratio EV/ RM (enterprise Value to revenue multiple) is of 1.5x, would you advise the acquisition of company Z