Hello guys, I have to do an equity report assignment and among other things I need to calculate cost of capital,growth, equity premium etc.. but I'm really having a problem in finding the basic data that I need for the calculations. I also have access to capitaliq and I was wondering if you could give me any advice. For example, for the implied equity premium I need to find the dividend and stock buybacks for the s&p 500 but I can't find it anywhere... I'm desperate.
Feb 17, 2021Feb 17, 2021
WSO Elite Modeling Package
- 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
- Elite instructors from top BB investment banks and private equity megafunds
- Includes Company DB + Video Library Access (1 year)
Related Content
See moreTotal Avg Compensation
March 2021 Investment Banking
-
Director/MD (9) $911
-
Vice President (31) $349
-
Associates (168) $231
-
2nd Year Analyst (98) $151
-
Intern/Summer Associate (93) $145
-
3rd+ Year Analyst (23) $145
-
1st Year Analyst (371) $131
-
Intern/Summer Analyst (308) $82
Upcoming Events See all
-
Mar08
Comments (2)
Hello,
If you're trying to calculate the WACC, my best advice is to look at Aswath Damodaran's website. There's a bunch of stuff (in the form of excel spreadsheets) on there which in my opinion is quite reliable, but take it with a pinch of salt. Here's the link: http://people.stern.nyu.edu/adamodar/New_Home_Page/spreadsh.htm#cf
That's the main list of spreadsheets with info for the kind of calculations you need to do. I would recommend cross-checking your findings with something like the Economic data from the Federal Reserve Bank of St. Louis (https://www.stlouisfed.org/). I believe their data is quite reliable if you're trying to get something like risk-free rates for CAPM for example.
For things like marginal tax rates, search the company's 10-K, and if you still can't find it, you can use the effective tax rate as a proxy. For the D/(D+E) and E/(E+D), CapitalIQ will serve you well because they already give you good estimates of all interest-bearing debt.
Let me know if I can help with anything else
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Want to Unlock by signing in with your social account?