2024 M&A Modeling / Mergers & Acquisitions (M&A) Modeling Exam Answers from Wall Street Prep PASS A+

2024 M&A Modeling / Mergers & Acquisitions (M&A) Modeling Exam Answers from Wall Street Prep PASS A+ Which of the following OFFSET functions when applied correctly in cell H10 allows the user to fill down cells H11-17 with CTRL+D? A. =OFFSET(I10,0,$H$7-1) B. =OFFSET(I10,1,$H$7-1) C. =OFFSET(I10,0,H7-1) D. =OFFSET(I10,0,$H$7) - ANSWER-A. =OFFSET(I10,0,$H$7-1) Given the above screenshot, which of the following is the correct percentage change in acquirer NPV per Share (round to 1 decimal place)? -10.3% 1.7% 1.5% 0.2% - ANSWER-1.7% What is the correct formula for Goodwill? A. Market value of acquirer - net identifiable assets of target B. Price paid - fair market value of net identifiable assets of target C. Market value of acquirer - fair market value of target D. Book value of target's equity + Adjustments - ANSWER-B. Price paid - fair market value of net identifiable assets of target ABC Co. is considering an acquisition of XYZ Co. for a cash offer that values XYZ at 20% higher than its current market capitalization. Given the above data, calculate the takeover premium in dollar terms (Round to the closest dollar). ABC Co. Stock Price $26.00 XYZ Co. Stock Price $10.00 ABC Co. Cash $2,000,000 XYZ Co. Cash $1,500,000 ABC Co. Shares Outstanding 300,000 XYZ Co. Shares Outstanding 150,000 A. $400,000 B. $250,000 C. $300,000 D. $315,000 - ANSWER-C. $300,000 Given the data in the above table, calculate equity value per share of this hypothetical company. (Round to 2 decimal points) Shares outstandin