Difference between revisions of "Manuals/calci/NOMINAL"
| Line 1: | Line 1: | ||
| − | =NOMINAL( | + | <div style="font-size:30px">'''NOMINAL (EffectiveInterestRate,NoOfCompoundingPeriods)'''</div><br/> |
Where | Where | ||
| − | *<math> | + | *<math>EffectiveInterestRate</math> is the effective interest rate, and |
| − | *<math> | + | *<math>NoOfCompoundingPeriods</math> is the number of compounding periods per year. |
| − | NOMINAL() | + | NOMINAL() returns the annual nominal interest rate. |
== Description == | == Description == | ||
| − | NOMINAL( | + | NOMINAL (EffectiveInterestRate,NoOfCompoundingPeriods) |
*Nominal Interest Rate is calculated depending on the effective interest rate and the number of compounding periods per year. | *Nominal Interest Rate is calculated depending on the effective interest rate and the number of compounding periods per year. | ||
Revision as of 17:16, 27 July 2018
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 (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} - 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.
Related Videos
See Also
References