In this project, the student will find and discern the appropriate data to determine a realistic assessment of the weighted average cost of capital for a firm of his/her choosing. The student will need to search for data from several sources, use subjective judgment to determine which data to use or discard, use subjective judgment to determine whi

In this project, the student will find and discern the appropriate data to determine a realistic assessment of the weighted average cost of capital for a firm of his/her choosing.

The student will need to search for data from several sources, use subjective judgment to determine which data to use or discard, use subjective judgment to determine which calculation gives a more acceptable estimate and make some simplifying assumptions.

The purpose of the projects is to show some of the sources of measurement errors in financial analysis, to introduce the diverse sources of publicly available financial information and to develop skill in analysis in situations where there are too much or too little data.

My chosen company is Wal-Mart and all data is attached. You need to write 6-8 pages report that explain the provided data and the insights that we have gotten and how did we get them or what do they mean. It should be a full report with introduction, body and conclusion.

The organization of the paper should be as follows:

  1. Introduction
  2. Equation with data and descriptions:Pages showing equations with data and brief description. Detailed descriptions, tables of data and excel sheets etc will be in the appendix.
  3. Cost of Equity (Common Stock
  4. Beta  from Regression and two Betas from analysts
  5. Beta Chosen for CAPM and why
  6. Capital Assets Pricing Model (include how determined RF and[ RM  or (RM – RF)]
  7. Discounted Cash Flow (DCF) (only if dividends – include how determined growth rate)
  8. Own-Bond-Yield-plus-Judgmental-Risk-Premium (include how determine risk premium)
  9. Cost of Preferred Stock
  10. Cost of Debt (make sure to include table that lists all bond issues with weighted average cost of debt)
  11. Market Value of Debt (will have calculated above, but will need to add any long term leases from balance sheet to get total market value of debt)
  12. Market Value of Equity
  13. 13. Market Value of Preferred Stock
  14. Value of Firm
  15. Firm’s Tax Rate (explain how determined)
  16. Weight for Equity
  17. Weight for Preferred Stock
  18. Weight for Debt
  19. WACC (Weighted Average Cost of Capital)
  20. Conclusion
  21. Assumptions: including but not limited to RF , RM,  Rm – RF. growth rate of dividends. This page should have a brief description of how you came up with the estimates with spreadsheets, etc. to be put in the appendix.
  22. Appendix: Appendix should include all relevant data including debt data from Morningstar, calculations of weighted average cost of debt, stock returns, betas from analysts, beta regression      analysis, method/sourcing for RF and RM, growth rates for dividends, different methods to determine tax rates, etc.
  23. References

Order This Solution

Ask your homework question

 

INDIVIDUAL APPROACH:
Chat with every writer who applies to your request, and view their skills and portfolio. Make the choice that’s right for you.
MANAGE YOUR ORDER:
Monitor progress and see any changes made. Have full control over every phase of the process.
COMMUNICATE:
Ask your writer questions and provide your ideas about your paper. Produce the exact result that you want.
ENJOY THE OUTCOME:
Get everything done on time with high quality. Writing papers is much simpler with us.

Ask your homework question

 

© 2017 theacademicessays. All Rights Reserved. Design & Developed by theacademicessays.
Loading...