Changes

Manuals/calci/DURATION (view source)

Revision as of 22:06, 26 November 2013

471 bytes removed , 22:06, 26 November 2013

no edit summary

Line 24: Line 24:

For Quarterly payment, frequency = 4.

−

*'basis' value is optional. If omitted, Calci assumes to be 0.

+

*'basis' value is optional. If omitted, Calci assumes it to be 0.

Below table shows the use of 'basis' values:

Line 31: Line 31:

! Basis !! Description

|-

−

| 0 || USD*30/360

+

| 0 || US(NASD) 30/360

|-

| 1 || Actual/actual

Line 42: Line 42:

|}

−

*If 'basis' value other than 0 to 4, Calci displays an error message.

+

*If 'basis' value is other than 0 to 4, Calci displays an error message.

== Examples ==

+

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

Line 50: Line 52:

{| id="TABLE3" class="SpreadSheet blue"

|- class="even"

+

| class=" " | September 10, 2010

+

| class=" " |

+

| class=" " |

−

~~| class=" " | Column1~~

−

~~| class=" " | Column2~~

−

~~| class=" " | Column3~~

−

~~| Column4~~

|- class="odd"

−

| class=" ~~" | Row1~~

+

| class="sshl_f" | September 10, 2016

−

~~| class="~~ " | September 10, ~~2010~~

+

| class=" " |

−

| class=" ~~sshl_f~~ " |

| class=" " |

|- class="even"

−

| class=" " | ~~Row2~~

+

| class=" " | 6%

−

~~| class="sshl_f" | September 10, 2016~~

| class=" " |

|- class="odd"

−

~~| Row3~~

+

| class=" " | 9.0%

−

| class="~~SelectTd~~ " | 6%

| class=" " |

|- class="even"

−

~~| Row4~~

+

| class=" " | 2

−

| class=" " | ~~9.0%~~

| class=" " |

|- class="odd"

−

| class=" " | ~~Row5~~

+

| class=" " | 1

−

| class=" " | 2

+

| class=" " | 5.0458

| class=" " |

−

~~| class=" " |~~

−

~~|- class="even"~~

−

~~| Row6~~

−

~~| class="sshl_f " | 1~~

−

~~| class="sshl_f sshl_f " | 5.0458~~

−

~~| class=" sshl_f " |~~

−

~~| class=" SelectTD SelectTD" |~~

|}

Swapna

writer

2,661

edits