Power BI Template - Weighted Average Cost of Capital
Originally published: 09/06/2020 07:14
Last version published: 10/06/2020 07:26
Publication number: ELQ-22510-3
View all versions & Certificate

Power BI Template - Weighted Average Cost of Capital

Power BI Finance Tool - Calculate your Weighted Average Cost of Capital

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 %

Debt to Equity ratio
Cost of Equity %
After Tax Cost of Debt %
Weighted Average Cost of Equity %
Weighted Average Cost of Debt %

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

This Best Practice includes
1 Power BI Template

Acquire business license for $49.00

Add to cart

Add to bookmarks


0.0 / 5 (0 votes)

please wait...