For a free downloadable Excel template, go to bojanfin.com/
---------------------------------------------------------
WACC CALCULATION: never been easier.
𝗖𝗢𝗦𝗧 𝗢𝗙 𝗘𝗤𝗨𝗜𝗧𝗬
Risk free rates database
Equity risk premiums database
Unlevered betas database
Cost of debt database
Insert risk free rate
Insert equity risk premium
Input unlevered industry beta
Input gearing ratio
Calculate relevered industry beta
Enter corporate tax rate
Subtotals in cost of equity calculation
Input size premium risk
Input specific risk
Calculate cost of equity
𝗖𝗢𝗦𝗧 𝗢𝗙 𝗗𝗘𝗕𝗧
Enter cost of debt pre tax
Calculate cost of debt after tax
Calculate gearing ratio for weighting cost of debt toward cost of equity
𝗪𝗔𝗖𝗖 𝗖𝗔𝗟𝗖𝗨𝗟𝗔𝗧𝗜𝗢𝗡
Add adjustments if any
WACC Calculation completed
📌WACC Calculation Model is part of my full Finance Modeling Pack.
Check what is inside here and grab 50+ modeling spreadsheets followed by detailed guidelines.
👉 bojanfin.com/
✔ 𝟲𝗵+ of Video Materials (35 Lessons in 5 Modules)
✔ 𝟱𝟬+ Finance Models in Excel
✔ 𝟯𝟯𝟬+ Pages of Instructions in PDF
✔ 𝟯𝟬+ Bonus Materials
✔ 𝟭𝟬+ Languages subtitle
Негізгі бет WACC CALCULATION MODEL
Пікірлер: 1