Please show excel calculation, not just the answer question d and e.

Higgs Bassoon Corporation is a custom manufacturer of bassoons and other wind instruments. Its current value of operations, which is also its value of debt plus equity, is estimated to be $200 million. Higgs has $110 million face value, zero coupon debt that is due in 3 years. The risk-free rate is 5%, and the standard deviation of returns for similar companies is 60%. The owners of Higgs Bassoon view their equity investment as an option and would like to know the value of their investment. a. Using the Black-Scholes Option Pricing Model, how much is the equity worth? Black-Scholes Option Pricing Model Total Value of Firm Face Value of Debt Risk Free rate Maturity of debt (years) Standard Dev 200,000,000 this is the current value of operations 110,000,000 0.05 3 0.6 this is sigma--also known as volatility d1 d2 N(di) N(d2) Call Price Equity Value 1.2392 use the formula from the text 0.2000 use the formula from the text 0.8924 use the Normsdist function in the function wizard 0.5793 $ 123,636,102.69 million b. How much is the debt worth today? What is its yield? Debt valueTotal Value Equity Value- Debt yield $76,363,897.31 million 12.937% c. How much would the equity value and the yield on the debt change if Fethe's management were able to use risk management techniques to reduce its volatility to 45 percent? Can you explain this? Equity value at 60% volatility Equity value at 45% volatility Percent change 123,636,103 million 114,529,025 million 7.4% million d. Graph the cost of debt versus the face value of debt for values of the face value from $0.5 to $8 million. Cost of Debt hint: use a data table Face Value of Debt Cost of Debt 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 120.00% 100 .00% 80.00% 60.00% 40.00% 20.00% 0.00% 10 20 30 40 50 6070 80 90 100 110 1 b. Graph the values of debt and equity for volatilities from 0.10 to 0.90 when the face value of the debt is $2 million. Value of Equity Value of Debt Volatility Face Value of Debt 110000000.00 Volatility Face Value of Debt 110000000.00 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 Higgs Bassoon Corporation is a custom manufacturer of bassoons and other wind instruments. Its current value of operations, which is also its value of debt plus equity, is estimated to be $200 million. Higgs has $110 million face value, zero coupon debt that is due in 3 years. The risk-free rate is 5%, and the standard deviation of returns for similar companies is 60%. The owners of Higgs Bassoon view their equity investment as an option and would like to know the value of their investment. a. Using the Black-Scholes Option Pricing Model, how much is the equity worth? Black-Scholes Option Pricing Model Total Value of Firm Face Value of Debt Risk Free rate Maturity of debt (years) Standard Dev 200,000,000 this is the current value of operations 110,000,000 0.05 3 0.6 this is sigma--also known as volatility d1 d2 N(di) N(d2) Call Price Equity Value 1.2392 use the formula from the text 0.2000 use the formula from the text 0.8924 use the Normsdist function in the function wizard 0.5793 $ 123,636,102.69 million b. How much is the debt worth today? What is its yield? Debt valueTotal Value Equity Value- Debt yield $76,363,897.31 million 12.937% c. How much would the equity value and the yield on the debt change if Fethe's management were able to use risk management techniques to reduce its volatility to 45 percent? Can you explain this? Equity value at 60% volatility Equity value at 45% volatility Percent change 123,636,103 million 114,529,025 million 7.4% million d. Graph the cost of debt versus the face value of debt for values of the face value from $0.5 to $8 million. Cost of Debt hint: use a data table Face Value of Debt Cost of Debt 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 120.00% 100 .00% 80.00% 60.00% 40.00% 20.00% 0.00% 10 20 30 40 50 6070 80 90 100 110 1 b. Graph the values of debt and equity for volatilities from 0.10 to 0.90 when the face value of the debt is $2 million. Value of Equity Value of Debt Volatility Face Value of Debt 110000000.00 Volatility Face Value of Debt 110000000.00 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9