Below is a list of standard Cube formulas.
⚠️ To create or review these in your Cube, modify dimension names and formulas based on the mapped naming of your Chart of Accounts to Cube.
Income Statement Formulas
|
Gross Profit |
"Income"-"Cost of Goods Sold" |
|
Gross Margin |
"Gross Profit" / "Income" |
|
Ebitda |
"Gross Profit"-"Expense" |
|
EBIT |
"EBITDA"-"Depreciation & Amortization Expense" |
|
EBT |
"EBIT"+"Other Income"-"Other Expense" |
|
Net Income |
"EBIT"-"Income Tax Expense" |
Balance Sheet Formulas
|
Retained Earnings (f) |
<RUNNING_TOTAL("Net Income")> - <YEAR_TO_DATE("Net Income")> |
|
Net Income (BS) |
<YEAR_TO_DATE("Net Income")> |
Cash Flow Formulas
⚙️ These formulas are set to rollup type (SUM) other than the beginning cash balance.
🗓️ For months ago formulas, the calculation logic should be set to “Calculate Leaf Values, Then Sum”
🔦 Be sure to account for your Cube's naming conventions.
|
Retained Earnings (f) |
<RUNNING_TOTAL("Net Income")> - <YEAR_TO_DATE("Net Income")> |
|
Net Income (BS) |
<YEAR_TO_DATE("Net Income")> |
|
Chg in Current Assets |
<MONTHS_AGO("Current Assets",1)>-"Current Assets" |
|
Change in Net PP&E |
<MONTHS_AGO("Fixed Asset",1)>-"Fixed Asset" |
|
Change in Net Other Assets |
<MONTHS_AGO("Other Asset",1)>-"Other Asset" |
|
Change in Long-Term Debt |
"Long Term Liability"-<MONTHS_AGO("Long Term Liability",1)> |
|
Beginning Cash Balance |
"Capital Stock"-<MONTHS_AGO("Capital Stock",1)> |
|
Beginning Cash Balance |
<MONTHS_AGO("Bank",1)> |
|
Change in Cash |
"Operating Cash Flow"+"Investing Cash Flow"+"Financing Cash Flow" |