Financial calculations

There are several specialized functions available on the calculator. The functions are:

  • FinVar
  • FinancialTotal
  • PctFinVar

FinVar

The Financial Variance (FinVar) function is a specialized calculation that determines if the variance is favorable or unfavorable using the account type and natural sign. The rules are:

  • The formula result is not adjusted for account type PR (Revenue) when the natural sign is a credit.
  • The formula result is multiplied by -1 when the account type is PR (Revenue) and the natural sign is a debit.
  • The formula result is multiplied by -1 when the account type is PE (Expense) and the natural sign is a debit.
  • The formula result is not adjusted when the account type is PE (Expenses) and the natural sign is a credit.
  • The formula result is not adjusted when the account type is BA (Assets) and the natural sign is a debit.
  • The formula result is multiplied by -1 when the account type is BA (Assets) and the natural sign is a credit.
  • The formula result is not adjusted when the account type is BL (Liabilities) and the natural sign is a debit.
  • The formula result is multiplied by -1 when the account type is BL (Liabilities) and the natural sign is a credit.
  • The formula result is not adjusted when the account type is BE (Equity) and the natural sign is a credit.
  • The formula result is multiplied by -1 when the account type is BE (Equity) and the natural sign is a debit.

The syntax is:

FinVar(P1, P2)

P1 is the variance base value. P2 is the value to be compared against the base value.

FinancialTotal

The FinancialTotal function is a specialized summation calculation that leverages dimension knowledge to return a meaningful value. The consolidation process rules are followed as appropriate. The rules are:

  • Balance Sheet schedule lines are not summed across period, year, or merged period year; the final argument is returned.
  • Profit and Loss schedule lines are summed across period, year or merged period year.
  • Formula schedule lines are not summed across period or year; no value is returned.
  • Schedule lines combined with the YTD accumulation method member are not summed across period or year; the final argument is returned.
  • Schedule lines with the Consolidate attribute set to No are not summed across period or year; no value is returned.
  • The Currency, Accumulation method, Adjusted state, and Rate set dimensions are not valid argument dimensions.

PctFinVar

The Percent Financial Variance (PctFinVar) function expresses the result of the FinVar function as a percentage.