Introduction to Financial Statements in Power BI
Nikisha Alcindor
Investor and Data Scientist

| Company 1 | Values |
|---|---|
| Revenue | $300 |
| Expenses | $200 |
| Profit | $100 |

| Company 2 | Values |
|---|---|
| Revenue | $300 |
| Expenses | $400 |
| Profit | -$100 |

Gross Revenue
Net Revenue
Gross Profit
Net Profit
Gross Revenue (Gross Sales)
Example
$100Gross Revenue = 10 x $100 = $1000
Net Revenue = Gross Revenue - Discounts - Returns Example
$100, but need to return the money for 1 damaged juicer.Net Revenue = 1000 - $0 - 100 = 900
Gross profit = Net Revenue - COGS Example
$100 with a cost of $60, but need to return the money for 1 damaged juicer.Gross profit = $900 - $600 = $300
Net profit = Gross profit - Expenses Example
$50.Net profit = $300 - $50 - $50 = $200
Gross Revenue
Gross Revenue = 10 x $100 = $1000Net Revenue
Net Revenue = Gross Revenue - Discounts - Returns$1000 - $0 $100 = $900Gross Profit
Gross profit = Net Revenue - COGS$900 - $600 = $300Net Profit
Net profit = Gross profit - Expenses$300 - $100 = $200

Introduction to Financial Statements in Power BI