Download the following excel file: Transaction Costs Evaluation - Question.xlsx 11 Total transaction costs, based on the assumptions provided, are expected to be: $18,382 $19,002 $22,002 $19,895 20% 5% 50% 50% 1 Corporate Finance Institute. All rights reserved. 2 Transaction Costs Qualified Assessment 3 All Amounts Denominated in US$MM Unless otherwise Stated 4 5 Acquisition Assumptions 6 7 Acquisition of Walmart by Amazon 8 9 Acquisition Structure Assumptions 10 Acquisition Premium 11 Equity Issuance Discount (to Current Price) 12 13 % Debt Financing 14 % Equity Financing 15 16 Acquirer and Target Assumptions 17 18 19 Share Price ($/sh.) 20 Fully Diluted Shares Outstanding (MM) 21 Cash and Cash Equivalents 22 Total Debt 23 24 Transaction Costs Information 25 Equity Financing Fees 26 Debt Financing Fees 27 Other Transaction Costs 28 Target Debt Early Redemption Premium 29 30 31 32 Question (Information) Amazon Acquirer $3,099.40 518 $37,466 $91,401 Walmart Target $140.50 2,863 $16,906 $70,242 5.5% 15% $3,000 3.0%