Use the list of common formulas below to help you start adding formulas in Cube. Have additional formulas you use that aren't in our common formulas list? Use the supported operations table to write your own formulas.
Common formulas
Modify dimension names in the formulas below to exactly match your dimensions in 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
Two important notes for common cash flow formulas:
- The rollup account type for these formulas is set to sum rather than the beginning cash balance. Learn more about the rollup account type here.
- For any formula using <MONTHS_AGO>, the rollup logic should be set to Calculate Leaf Values, Then Sum. Learn more about rollup logic for formulas here.
|
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" |
Supported Operations
| Operation | Expression | Example | Recommended Rollup Logic |
| Add | + | "Revenue" + "Discounts" | Sum leaf values, then calculate |
| Subtract | - | "Revenue" - "COGS" | Sum leaf values, then calculate |
| Multiple | * | "Revenue"*3 | Sum leaf values, then calculate |
| Divide | / |
"COGS"/2 |
Sum leaf values, then calculate |
| Exponent | ^ | "Churn" ^2 | Sum leaf values, then calculate |
| Months Ago | <MONTHS_AGO("_",#months)> | <MONTHS_AGO("Principal",1)> | Calculate leaf values, then sum |
| Running Total | <RUNNING_TOTAL("_")> | <RUNNING_TOTAL("New ARR")> | Calculate leaf values, then sum |
| Year to Date | <YEAR_TO_DATE("_")> | <YEAR_TO_DATE("New ARR")> | Calculate leaf values, then sum |