Manuals/calci/NOMINAL

From ZCubes Wiki
Revision as of 20:40, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font face="Arial, sans-serif"><font size="2"><font color="#484848">'''NOMINAL'''</font><font color="#484848">(</font><fo...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
NOMINAL(ER, nper)

Where 'ER'is the effective interest rate and 'nper' is the number of compounding periods per year.

 This function calculates the nominal annual interest rate, given the effective rate and the number of compounding periods per year.
 
  • NOMINAL shows the error value. When either argument is nonnumeric or ER ≤ 0 or nper <1
  • NOMINAL is shown in the following equation:

NOMINAL

 

Lets see an example,

NOMINAL(ER, nper)

B

6.234%

5

=NOMINAL(B2,B3) is 0.0608

Syntax
Remarks
Examples
Description
Column1 Column2 Column3 Column4
Row1 6.234%
Row2 5
Row3 0.060841
Row4
Row5
Row6
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/NOMINAL&oldid=517"