Power BI Template - Weighted Average Cost of Capital

Description
Use this dynamic Power BI tool to project the Weighted Average Cost of Capital using variables.

A great tool to project WACC based on assumptions by the user.

All designed within Power BI with no Excel data required - uses simple Data Analysis Expressions (DAX) to arrive at outcome.

Variables available:
Debt to Total Capitalisation %
Risk Free Rate %
Equity Risk Premium %
Leveraged Beta
Cost of Debt %
Tax Rate %

Calculations:
Debt to Equity ratio
Cost of Equity %
After Tax Cost of Debt %
Weighted Average Cost of Equity %
Weighted Average Cost of Debt %
WACC

Proudly developed by Arno Wakfer CA, FMVA, CBCA from Educatio.

Link to release on LinkedIn - https://www.linkedin.com/posts/arnowakfer_powerbi-activity-6675278425948872704-qa4J

About the Developer

Chartered Accountant by profession
Full member of Chartered Accountants of Australia and New Zealand
Board member of the Global Corporate Finance Society

Career Experience

• 15 yrs Commercial Finance
• International Exp in South Africa & Australia
• CFO at Top rated Business School in Africa (GIBS)
• Led Finance teams at global giants like Dimension Data & Autodesk
• General Management exp having managed two businesses in Australia

2 Years Experience in Power BI (DA-100 Exam Microsoft Certification in progress)

Qualification and Education

Chartered Accountant with CA ANZ
Certified Financial Modeller and Valuation Analyst with CFI
Certified Banking and Credit Analyst with CFI