Changes

Jump to navigation Jump to search

Manuals/calci/EFFECT (view source)

Revision as of 02:34, 25 October 2013

3,368 bytes added ,  02:34, 25 October 2013
Created page with "<div id="6SpaceContent" class="zcontent" align="left">  <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">EFFECT(nom rate, npy)</font></font>'''</font..."
<div id="6SpaceContent" class="zcontent" align="left"> 

<font color="#000000">'''<font face="Arial, sans-serif"><font size="2">EFFECT(nom rate, npy)</font></font>'''</font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">Where ;nom rate' is the nominal interest rate and 'npy' is the number of compounding periods per year.</font></font></font>

</div>
----
<div id="1SpaceContent" class="zcontent" align="left"> 

<font color="#000000"><font face="Arial, sans-serif"><font size="2">This function find outs the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.</font></font></font>

</div>
----
<div id="7SpaceContent" class="zcontent" align="left"> 

* <font color="#000000"><font face="Arial, sans-serif"><font size="2">Arguments should be numeric.</font></font></font>
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">EFFECT returns the error value, when nom rate ≤ 0 or npy &lt; 1.</font></font></font>
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">EFFECT is calculated as follows: </font></font></font>

<font color="#000000"></font>

<br /><br />

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

EFFECT

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left"> 

<font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">EFFECT(nom rate, npy)</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''B'''</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">6%</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">3</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=EFFECT(B2,B3) is 0.0612</nowiki></font></font></font>

<br />

</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="5SpaceContent" class="zcontent" align="left">

{| id="TABLE6" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 6%
| class=" " |
|
|
|- class="even"
| class=" " | Row2
| class="sshl_f" | 3
|
|
|
|- class="odd"
| Row3
| class="sshl_f" | 0.061208
|
|
|
|- class="even"
| Row4
| class=" " |
|
|
|
|- class="odd"
| class=" " | Row5
|
|
|
|
|- class="even"
| Row6
|
|
|
| class="SelectTD SelectTD" |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----
<div id="9SpaceContent" class="zcontent" align="left"><div>[[Image:15.JPG|100%px|http://store.zcubes.com/33975CA25A304262905E768B19753F5D/Uploaded/15.JPG]]</div></div>
----
MassBot1
Bots, writer
193,448

edits

Retrieved from "http://wiki.zcubes.com/Special:MobileDiff/384"

Navigation menu