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