Financial Modelling in Power BI

Table of Contents

1. Introduction
2. Introduction to Power BI
3. Best Practice Methodology
4. Financial Statements Theory
5. Control Accounts
6. Getting Started
7. Creating Parameters
8. Calculating Sales
9. Formatting Matrix Visualizations
10. Calculating COGS (Part 1)
11. VAR Variables
12. Calculating Inventory (FIFO)
13. Average Inventory Calculation
14. Calculating COGS (Part 2)
15. Calculating Operating Expenditure (Opex)
16. Calculating Capital Expenditure (Capex)
17. Calculating Debt
18. Calculating Interest
19. Income Statement (Part 1)
20. Calculating Tax (Part 1)
21. Recursion Aversion
22. Calculating Tax (Part 2)
23. Income Statement (Part 2)
24. Calculating Equity and Dividends
25. Cash Flow Statement
26. Balance Sheet
27. And Finally