Can you help me solve this problem by excel and show formula in details? Your work must match with the answers. Thanks!

Company A with excess cash is considering the acquisition of company B.

Company A estimates of B's earnings potential if it comes under A's management (in millions of dollars). The interest expense listed here includes the interest (1) on B's existing debt, (2) on new debt that A would issue to help finance the acquisition, and (3) on new debt expected to be issued over time to help finance expansion within the new "B division," the code name given to the target firm. The retentions represent earnings that will be reinvested within the B division to help finance its growth.

Company B currently uses 35% debt financing, and it pays federal-plus-state taxes at a 35% rate. Security analysts estimate B's beta to be 1.36. If the acquisition were to take place, A's would increase B's debt ratio to 40%, which would increase B's beta to 1.48. Further, because company A is highly profitable, taxes on the consolidated firm would be 40%. Depreciation cash flows would have to be reinvested within the division to replace worn-out equipment.

You estimate the risk-free rate to be 4% and the market risk premium to be 8%. You also estimate that cash flows after 2021 will grow at a constant rate of 6%. The after tax cost of debt is 7%.

The table presents estimates of the company B's data for merger analysis.

1. What is cash flow for year 2018 (The cash flow to be used for merger analysis)? 12,400,000

2. What is the cash flow for year 2021 (The cash flow to be used for merger analysis)? 75,343,089.43

2021 130,000,000 92,000,000 9,000,000 2018 60,000,000 30,000,000 2019 80,000,000 50,000,000 6,000,000 2020 100,000,000 75,000,000 8,000,000 Net Sales COGS Selling & Admin 4,000,000 Expenses Interest Expense 2,000,000 3,000,000 5,000,000 4,000,000 Necessary Retained EarningS 2,000,000 7,000,000 9,000,000 8,000,000