-
-
Save zachlim98/2d24dba53e5d4ffc2ef0b909ea60ce82 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
beta = profile.loc["beta"] #get beta of stock from stock profile | |
mktCap = quote.loc["marketCap"] #market cap of stock | |
totdebt = bs.loc["totalDebt",year] #total debt | |
sharesOut = quote.loc["sharesOutstanding"] | |
pg = 0.025 #perpetural growth | |
wacklist = [] | |
for i,d in enumerate(["2015","2016","2017","2018","2019"]): | |
Rd = ins.loc["interestExpense", d]/totdebt*(1-(ins.loc["incomeTaxExpense",d]/ins.loc["incomeBeforeTax",d])) | |
Re = rfr + (beta*(10 - rfr)) | |
wacc = float(((Rd)*(totdebt/(mktCap + totdebt)) + (Re)*(1-(totdebt/(mktCap + totdebt))))/100) | |
wacklist.append(Wacc) | |
wacc_stdd = np.std(wacklist) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment