Use Excel to solve any financial calculations Use the Dell Technologies Inc Form 10K for

Question

Use Excel to solve any financial calculations.

Use the Dell Technologies, Inc. Form 10-K for

the fiscal year ended February 1, 2019 to answer the computation questions. Use the stock price of $51.32, which is the closing stock price at June 14, 2019 for the stock price. Use 2.125% as the risk free rate. Use 5% as the market risk premium. Use 6% as the yield to maturity on the long-term debt. Use 1.08 as the beta. The financial statements may be found after the Report of Independent Registered Public Accounting Firm. Total assets on the balance sheet should be $111,820 million at February 1, 2019. Long-term debt amount should be $49,201 million at February 1, 2019.

The following computations should be made for Dell Technologies, Inc.:

Market capitalization

Cost of equity

Cost of debt

Weighted average cost of capital

How would I figure out the above computations? I’m not sure what the formulas would be.

Finance