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.:
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.