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
$100
Gross 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
= $1000
Net Revenue
Net Revenue
= Gross Revenue
- Discounts
- Returns
$1000
- $0
$100
= $900
Gross Profit
Gross profit
= Net Revenue
- COGS
$900
- $600
= $300
Net Profit
Net profit
= Gross profit
- Expenses
$300
- $100
= $200
Introduction to Financial Statements in Power BI