NOMINAL function

NOMINAL(Rate, NumberOfPeriods) NOMINAL(Rate; NumberOfPeriods)

Rate

Number or { Number }

The effective interest rate.

Number or { Number }

The number of times interest is credited or compounded during the period that the nominal rate applies to.

Number or { Number }

A nominal interest rate.

Returns a nominal interest rate given the effective compounded interest rate.

NOMINAL(6%, 4)NOMINAL(6%; 4)

Returns roughly 5.87%, which is the nominal rate for an investment with a effective rate of 6% per annum, compounded quarterly.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.