Instruction:
You need to work on the mini-projects in Excel. Your final mini-project report should be well-organized and typed in a Word file. Are required to submit both your Word report and Excel files to the instructor using the mini-project submission tool in Blackboard. The style and organization of the project accounts for 10 points.
Mini-Project : Weighted Average Cost of Capital (80 points):
Find 2017 financial statements for Amazon.Com from UHV Mergent Online database, Yahoo! Finance, Google Finance, or other finance sources.
(1) Estimate the weights of capital (debt, preferred stock, and common stock) for the company.
(2) Estimate the before-tax and after-tax component cost of debt for the firm.
(3) Estimate the component cost of preferred stock (if applicable) for the firm.
(4) Estimate the component cost of common equity using CAPM for the firm.
(5) Compute the firm's weighted average cost of capital (WACC). Discuss your findings.