MERGERS AND ACQUISITIONS (M&A) MADELING
EXAM QUESTIONS AND CORRECT DETAILED
ANSWERS LATEST UPDATES 2025-2026 (VERIFIED
ANSWERS) ALREADY GRADED 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 data in the above table, calculate the forecasted amount for
accounts receivable in 2018 assuming the current period has 365 days.
(Round to the closest whole number)
Forecasted Revenue for 2018
800,000
Forecasted Cost of Goods Sold for 2018
100,000
Inventory Days
, 9 days
Accounts Receivable Days
10 days
Accounts Receivable for 2017
19,000
A. 19,624
B. 21,918
C. 23,513
D. 20,651 - ANSWER-B. 21,918
Given the above repayment schedule and information, what will be the
closing balance of senior debt A in the year 2020?
$0
$30,000
$15,000
$90,000 - ANSWER-$30,000
Complete the sources of cash table given the above screenshot. What is
the correct value in cell C2?
$120,513
$130,135
EXAM QUESTIONS AND CORRECT DETAILED
ANSWERS LATEST UPDATES 2025-2026 (VERIFIED
ANSWERS) ALREADY GRADED 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 data in the above table, calculate the forecasted amount for
accounts receivable in 2018 assuming the current period has 365 days.
(Round to the closest whole number)
Forecasted Revenue for 2018
800,000
Forecasted Cost of Goods Sold for 2018
100,000
Inventory Days
, 9 days
Accounts Receivable Days
10 days
Accounts Receivable for 2017
19,000
A. 19,624
B. 21,918
C. 23,513
D. 20,651 - ANSWER-B. 21,918
Given the above repayment schedule and information, what will be the
closing balance of senior debt A in the year 2020?
$0
$30,000
$15,000
$90,000 - ANSWER-$30,000
Complete the sources of cash table given the above screenshot. What is
the correct value in cell C2?
$120,513
$130,135