Manuals/calci/ISPMT - Revision history

Devika: /* Related Videos */

2018-11-15T20:58:47Z

Devika at 23:04, 23 July 2018

2018-07-23T23:04:52Z

Devika: /* Description */

2018-07-23T23:03:59Z

Description

Devika at 23:02, 23 July 2018

2018-07-23T23:02:18Z

Jayaram at 10:52, 14 March 2017

2017-03-14T10:52:21Z

Swapna at 19:47, 15 June 2015

2015-06-15T19:47:53Z

Devika: /* References */

2015-05-13T17:29:28Z

References

Devika: /* Description */

2014-03-14T09:16:37Z

Description

Devika at 09:14, 14 March 2014

2014-03-14T09:14:19Z

MassBot1: Created page with "
'''ISPMT(R, per, nper, PV)''' ..."

2013-10-25T02:38:36Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''ISPMT(R, per, nper, PV)'''</font></font></font> ..."

New page

<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''ISPMT(R, per, nper, PV)'''</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'R''''</font></font><font face="Arial, sans-serif"><font size="2"> is the interest rate for the investment, 'per' is the period to find the interest, 'nper' is the total number of payment periods for the investment, and 'PV' is the present value of the investment. </font></font></font>

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

<font color="#000000"><font face="Arial, sans-serif"><font size="2">This function calculates the interest paid during a specific period of an investment. </font></font></font>

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

* <font color="#000000"><font face="Arial, sans-serif"><font size="2">Consistent about the units use for specifying rate and nper. </font></font></font>
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">For all the arguments, to pay out the cash is, represented by negative numbers and the cash you receive, is represented by positive numbers. </font></font></font>

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

ISPMT

</div></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="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| class=" " |
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 12%
| class=" sshl_f " |
| class=" " |
| class=" " |
|- class="even"
| class=" " | Row2
| class="sshl_f" | 1
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| Row3
| class="sshl_f" | 4
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row4
| class="sshl_f" | 6000000
| class=" " |
| class=" " |
| class=" SelectTD SelectTD" |
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
|- class="odd"
| class=" " | Row5
| class="sshl_f" | -540000
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row6
| class="sshl_f " |
<div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| class=" " |
| class=" " |
| class=" " |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----
<div id="5SpaceContent" class="zcontent" align="left">

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

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

<br /><br />

<font color="#000000"><font face="Arial, sans-serif"><font size="2">ISPMT(R, per, nper, PV)</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">12%</font></font></font>

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

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

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

<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=ISPMT(B2,1,B4,B5) is -540000</nowiki></font></font></font>

<br /><br />

</div>
----

@@ Line 29: / Line 29: @@
 ==Related Videos==
-{{#ev:youtube|ycph-5IhabM|280|center|ISPMT}}
+{{#ev:youtube|v=RN3DA2eVM2c|280|center|ISPMT}}
 ==See Also==

@@ Line 5: / Line 5: @@
 *<math>NoOfPaymentPeriods</math> is the total number of payment periods.
 *<math>PresentValue</math> is the at present value.
 ==Description==

@@ Line 9: / Line 9: @@
 *This function calculates the interest paid, during a specific period of a loan or investment.
 *In <math>ISPMT (Rate,Period,NoOfPaymentPeriods,PresentValue)</math>, <math>Rate</math> is the rate of interest for the period.Suppose we are taking  a loan for 8 percent annual interest rate and paying the amount in monthly, then the <math>Rate</math> value is 8%/12.
-*So we have to enter the <math>r</math> value as  8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
+*So we have to enter the <math>Rate</math> value as  8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
 *<math>Period</math> indicates the period and it is lying with in 1 to nper.
 *<math>NoOfPaymentPeriods</math> is the total number of payment periods in an annuity.

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''ISPMT(r,pe,np,pv)'''</div><br/>
+<div style="font-size:30px">'''ISPMT (Rate,Period,NoOfPaymentPeriods,PresentValue)'''</div><br/>
-*<math>r</math>  is the interest rate.
-*<math>pe </math> is the period.
+*<math>Rate</math>  is the interest rate.
-*<math>np</math> is the total number of payment periods.
+*<math>Period</math> is the period.
-*<math>pv</math> is the at present value.
+*<math>NoOfPaymentPeriods</math> is the total number of payment periods.
 ==Description==
 *This function calculates the interest paid, during a specific period of a loan or investment.
-*In <math>ISPMT(r,pe,np,pv)</math>, <math>r</math> is the rate of interest for the period.Suppose we are taking  a loan for 8 percent annual interest rate and paying the amount in monthly, then the <math>r</math> value is 8%/12.
+*In <math>ISPMT (Rate,Period,NoOfPaymentPeriods,PresentValue)</math>, <math>Rate</math> is the rate of interest for the period.Suppose we are taking  a loan for 8 percent annual interest rate and paying the amount in monthly, then the <math>Rate</math> value is 8%/12.
 *So we have to enter the <math>r</math> value as  8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
-*<math>pe</math> indicates the period and it is lying with in 1 to nper.
+*<math>Period</math> indicates the period and it is lying with in 1 to nper.
-*<math>np</math> is the total number of payment periods in an annuity.
+*<math>NoOfPaymentPeriods</math> is the total number of payment periods in an annuity.
-*<math>pv</math> is the present value-the total amount that a series of future payments is worth now.
+*<math>PresentValue</math> is the present value-the total amount that a series of future payments is worth now.
 *The arguments rate and the nper  are expressed in the correct units.
     months = 12 * years; monthly rate = annual rate / 12

← Older revision		Revision as of 10:52, 14 March 2017
Line 36:		Line 36:
	==References==		==References==
	*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ISPMT_function ISPMT]		*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ISPMT_function ISPMT]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 24: / Line 24: @@
 #=ISPMT(9%,2,4,350000) = -15750
 #=ISPMT(9%/12,3,4*12,350000) = -2460.9375
 ==See Also==

← Older revision		Revision as of 17:29, 13 May 2015
Line 31:		Line 31:

	==References==		==References==
		+	*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ISPMT_function ISPMT]

@@ Line 7: / Line 7: @@
 ==Description==
 *This function calculates the interest paid, during a specific period of a loan or investment.
-*In ISPMT(r,pe,np,pv), r is the rate of interest for the period.Suppose we are taking  a loan for 8 percent annual interest rate and paying the amount in monthly, then the r value is 8%/12.
+*In <math>ISPMT(r,pe,np,pv)</math>, <math>r</math> is the rate of interest for the period.Suppose we are taking  a loan for 8 percent annual interest rate and paying the amount in monthly, then the <math>r</math> value is 8%/12.
-*So we have to enter the r value as  8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
+*So we have to enter the <math>r</math> value as  8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
-*pe indicates the period and it is lying with in 1 to nper.
+*<math>pe</math> indicates the period and it is lying with in 1 to nper.
-*np is the total number of payment periods in an annuity.
+*<math>np</math> is the total number of payment periods in an annuity.
-*pv is the present value-the total amount that a series of future payments is worth now.
+*<math>pv</math> is the present value-the total amount that a series of future payments is worth now.
 *The arguments rate and the nper  are expressed in the correct units.
-* months = 12 * years; monthly rate = annual rate / 12
+   months = 12 * years; monthly rate = annual rate / 12
-  quarters = 4 * years; quarterly rate = annual rate / 4 .
+   quarters = 4 * years; quarterly rate = annual rate / 4 .
 *The returned values are negative which is representing the cash we pay out like deposits to savings or other withdrawals.
 *Also the returned values are positive which is representing the  cash we receive like dividend checks and other deposits.
 *This function give result as error when
          Any one  of the arguments are not recognised as numeric values.
 ==Examples==

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''ISPMT(R, per, nper, PV)'''</font></font></font>
+<div style="font-size:30px">'''ISPMT(r,pe,np,pv)'''</div><br/>
-<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'R''''</font></font><font face="Arial, sans-serif"><font size="2"> is the interest rate for the investment, 'per' is the period to find the interest, 'nper' is the total number of payment periods for the investment, and 'PV' is the present value of the investment. </font></font></font>
+==Description==
-<font color="#000000"><font face="Arial, sans-serif"><font size="2">This function calculates the interest paid during a specific period of an investment. </font></font></font>
+==Examples==
-</div>
+==See Also==
-----
+*[[Manuals/calci/FV  | FV ]]
-<div id="7SpaceContent" class="zcontent" align="left">
+*[[Manuals/calci/IPMT  | IPMT ]]
-* <font color="#000000"><font face="Arial, sans-serif"><font size="2">Consistent about the units use for specifying rate and nper. </font></font></font>
+==References==

Manuals/calci/ISPMT - Revision history

Devika: /* Related Videos */

Devika at 23:04, 23 July 2018

Devika: /* Description */

Devika at 23:02, 23 July 2018

Jayaram at 10:52, 14 March 2017

Swapna at 19:47, 15 June 2015

Devika: /* References */

Devika: /* Description */

Devika at 09:14, 14 March 2014

MassBot1: Created page with " '''ISPMT(R, per, nper, PV)''' ..."

MassBot1: Created page with "
'''ISPMT(R, per, nper, PV)''' ..."