Difference between revisions of "Manuals/calci/NOMINAL"

Latest revision as of 16:27, 22 August 2018

NOMINAL (EffectiveInterestRate,NoOfCompoundingPeriods)

Where

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle EffectiveInterestRate} is the effective interest rate, and
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NoOfCompoundingPeriods} is the number of compounding periods per year.
- NOMINAL() returns the annual nominal interest rate.

Description

NOMINAL (EffectiveInterestRate,NoOfCompoundingPeriods)

Nominal Interest Rate is calculated depending on the effective interest rate and the number of compounding periods per year.
The relationship between Effective Interest Rate and Nominal Interest Rate is as follows -

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ER = (1 + \frac{NominalRate}{nperyear})^{nperyear} - 1 }

where

Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle ER} - Effective Interest Rate

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NominalRate} - Nominal Interest Rate

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle nperyear} - number of compounding periods per year

Arguments Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ER} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle nperyear} should be numeric, else Calci returns #N/A error message.
If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ER} < 0 or if Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle nperyear} < 1, Calci returns #N/A error message.
If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle nperyear} is not an integer, it is truncated.

Examples

Consider the following example that shows the use of NOMINAL function:

5.75%
5

=NOMINAL(A1,A2) displays 0.05622136652263632 as a result.
=NOMINAL("6.10%",6) displays 0.05950499347618399 as a result.

References

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-=NOMINAL(ER, nperyear)=
+<div style="font-size:30px">'''NOMINAL (EffectiveInterestRate,NoOfCompoundingPeriods)'''</div><br/>
 Where
-*<math>ER</math> is the effective interest rate, and
+*<math>EffectiveInterestRate</math> is the effective interest rate, and
-*<math>nperyear</math> is the number of compounding periods per year.
+*<math>NoOfCompoundingPeriods</math> is the number of compounding periods per year.
+**NOMINAL() returns the annual nominal interest rate.
-NOMINAL() calculates the nominal annual interest rate.
 == Description ==
-NOMINAL(ER, nperyear)
+NOMINAL (EffectiveInterestRate,NoOfCompoundingPeriods)
 *Nominal Interest Rate is calculated depending on the effective interest rate and the number of compounding periods per year.
@@ Line 17: / Line 16: @@
 where
-*<math>ER</math> - Effective Interest Rate
+<math>ER</math> - Effective Interest Rate
 <math>NominalRate</math> - Nominal Interest Rate
 <math>nperyear</math> - number of compounding periods per year
 *Arguments <math>ER</math> and <math>nperyear</math> should be numeric, else Calci returns #N/A error message.
 *If <math>ER</math> &lt; 0 or if <math>nperyear</math> &lt; 1, Calci returns #N/A error message.
@@ Line 53: / Line 53: @@
   =NOMINAL(A1,A2) ''displays 0.05622136652263632'' as a result.
   =NOMINAL("6.10%",6) ''displays 0.05950499347618399'' as a result.
+==Related Videos==
+{{#ev:youtube|-3VDp4mmr2s|280|center|NOMINAL Function}}
 == See Also ==
@@ Line 62: / Line 66: @@
 *[http://en.wikipedia.org/wiki/Nominal_interest_rate Nominal Interest Rate]
 *[http://en.wikipedia.org/wiki/Effective_interest_rate Effective Interest Rate]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]