Formualizer Docs
ReferenceFunctionsFinancial Functions

NOMINAL

Converts an effective annual rate into a nominal annual rate.

Summary

This is the inverse-style transformation of EFFECT for a chosen compounding frequency.

Remarks

  • effect_rate is annual effective yield; npery is periods per year.
  • npery is truncated to an integer before computation.
  • Sign convention is not cash-flow based; this function converts annual rate representation.
  • Returns #NUM! when effect_rate <= 0 or npery < 1.
  • Result formula: npery * ((1 + effect_rate)^(1/npery) - 1).

Examples

Example
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
null
Example
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
null

FAQ

Is NOMINAL an exact inverse of EFFECT?

It is the corresponding transformation for the same integer npery; both functions require positive rates and npery >= 1.

Runtime metadata

Category

Financial

Signature

NOMINAL(arg1: Number, arg2: Number)

Arity

min 2, max 2

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/financial/tvm.rs

MIRR

MIRR: Calculates modified internal rate of return with separate finance and reinvest rates.

NPER

NPER: Calculates the number of periods needed to satisfy a cash-flow target.

On this page

SummaryRemarksExamplesRelated functionsFAQIs NOMINAL an exact inverse of EFFECT?Runtime metadata