please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS

Barney Corp is operating in a country K where the corporate tax is 30%, personal income tax on bond investment is 25% while the personal tax on stock is 29%. Assume the firms earnings before interest and taxes is $2,400,000 and cost of equity with zero debt is 8%.

(a) If Barney current has $8 million total market value of debt financing, what would be the market value of the company of Barney Corp in this country K?

(b) What is the proportion of debt (wd) and equity (ws) financing for Barney Corp with financial leverage?

PLEASE HELP WITH EXCEL STEP-BY-STEP (IN FULL detail) much appreciated **IMPORTANT** I WANT TO LEARN