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.


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