04060118.xhp (f773ab65) | 04060118.xhp (89ffcff7) |
---|---|
1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file --- 15 unchanged lines hidden (view full) --- 24<helpdocument version="1.0"> 25<meta> 26<topic id="textscalc0104060118xml" indexer="include"> 27<title id="tit" xml-lang="en-US">Financial Functions Part Three</title> 28<filename>/text/scalc/01/04060118.xhp</filename> 29</topic> 30</meta> 31<body> | 1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file --- 15 unchanged lines hidden (view full) --- 24<helpdocument version="1.0"> 25<meta> 26<topic id="textscalc0104060118xml" indexer="include"> 27<title id="tit" xml-lang="en-US">Financial Functions Part Three</title> 28<filename>/text/scalc/01/04060118.xhp</filename> 29</topic> 30</meta> 31<body> |
32<paragraph role="heading" id="hd_id3146780" xml-lang="en-US" level="1" l10n="U" oldref="1">Financial Functions Part Three</paragraph> | 32<paragraph role="heading" id="hd_id3146780" xml-lang="en-US" level="1" l10n="U">Financial Functions Part Three</paragraph> |
33<sort> 34<section id="oddfprice"> 35<bookmark xml-lang="en-US" branch="index" id="bm_id3145112"> 36<bookmark_value>ODDFPRICE function</bookmark_value> 37<bookmark_value>prices;securities with irregular first interest date</bookmark_value> 38</bookmark><comment>mw added one entry</comment> 39<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ODDFPRICE" id="bm_id3146107" localize="false"/> | 33<sort> 34<section id="oddfprice"> 35<bookmark xml-lang="en-US" branch="index" id="bm_id3145112"> 36<bookmark_value>ODDFPRICE function</bookmark_value> 37<bookmark_value>prices;securities with irregular first interest date</bookmark_value> 38</bookmark><comment>mw added one entry</comment> 39<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ODDFPRICE" id="bm_id3146107" localize="false"/> |
40<paragraph role="heading" id="hd_id3145112" xml-lang="en-US" level="2" oldref="71">ODDFPRICE</paragraph> 41<paragraph role="paragraph" id="par_id3147250" xml-lang="en-US" l10n="U" oldref="72"><ahelp hid="HID_AAI_FUNC_ODDFPRICE">Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly.</ahelp></paragraph> 42<paragraph role="heading" id="hd_id3153074" xml-lang="en-US" level="3" l10n="U" oldref="73">Syntax</paragraph> 43<paragraph role="code" id="par_id3146098" xml-lang="en-US" l10n="U" oldref="74">ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency; Basis)</paragraph> 44<paragraph role="paragraph" id="par_id3153337" xml-lang="en-US" l10n="U" oldref="75"> 45<emph>Settlement</emph> is the date of purchase of the security.</paragraph> 46<paragraph role="paragraph" id="par_id3149051" xml-lang="en-US" l10n="U" oldref="76"> 47<emph>Maturity</emph> is the date on which the security matures (expires).</paragraph> 48<paragraph role="paragraph" id="par_id3147297" xml-lang="en-US" l10n="U" oldref="77"> 49<emph>Issue</emph> is the date of issue of the security.</paragraph> 50<paragraph role="paragraph" id="par_id3150393" xml-lang="en-US" l10n="U" oldref="78"> 51<emph>FirstCoupon</emph> is the first interest date of the security.</paragraph> 52<paragraph role="paragraph" id="par_id3147402" xml-lang="en-US" l10n="U" oldref="79"> 53<emph>Rate</emph> is the annual rate of interest.</paragraph> 54<paragraph role="paragraph" id="par_id3151387" xml-lang="en-US" l10n="U" oldref="80"> 55<emph>Yield</emph> is the annual yield of the security.</paragraph> 56<paragraph role="paragraph" id="par_id3153023" xml-lang="en-US" l10n="U" oldref="81"> 57<emph>Redemption</emph> is the redemption value per 100 currency units of par value.</paragraph> 58<paragraph role="paragraph" id="par_id3150539" xml-lang="en-US" l10n="U" oldref="82"> 59<emph>Frequency</emph> is number of interest payments per year (1, 2 or 4).</paragraph> | 40<paragraph role="heading" id="hd_id3145112" xml-lang="en-US" level="2">ODDFPRICE</paragraph> 41<paragraph role="paragraph" id="par_id3147250" xml-lang="en-US" l10n="U"><ahelp hid="HID_AAI_FUNC_ODDFPRICE">Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly.</ahelp></paragraph> 42<paragraph role="heading" id="hd_id3153074" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 43<paragraph role="code" id="par_id3146098" xml-lang="en-US" l10n="U">ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency; Basis)</paragraph> 44<paragraph role="paragraph" id="par_id3153337" xml-lang="en-US" l10n="U"><emph>Settlement</emph> is the date of purchase of the security.</paragraph> 45<paragraph role="paragraph" id="par_id3149051" xml-lang="en-US" l10n="U"><emph>Maturity</emph> is the date on which the security matures (expires).</paragraph> 46<paragraph role="paragraph" id="par_id3147297" xml-lang="en-US" l10n="U"><emph>Issue</emph> is the date of issue of the security.</paragraph> 47<paragraph role="paragraph" id="par_id3150393" xml-lang="en-US" l10n="U"><emph>FirstCoupon</emph> is the first interest date of the security.</paragraph> 48<paragraph role="paragraph" id="par_id3147402" xml-lang="en-US" l10n="U"><emph>Rate</emph> is the annual rate of interest.</paragraph> 49<paragraph role="paragraph" id="par_id3151387" xml-lang="en-US" l10n="U"><emph>Yield</emph> is the annual yield of the security.</paragraph> 50<paragraph role="paragraph" id="par_id3153023" xml-lang="en-US" l10n="U"><emph>Redemption</emph> is the redemption value per 100 currency units of par value.</paragraph> 51<paragraph role="paragraph" id="par_id3150539" xml-lang="en-US" l10n="U"><emph>Frequency</emph> is number of interest payments per year (1, 2 or 4).</paragraph> |
60<embed href="text/scalc/01/func_yearfrac.xhp#basis"/> 61</section> 62<section id="oddfyield"> 63<bookmark xml-lang="en-US" branch="index" id="bm_id3157871"> 64<bookmark_value>ODDFYIELD function</bookmark_value> 65</bookmark> 66<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ODDFYIELD" id="bm_id3149723" localize="false"/> 67<paragraph role="heading" id="hd_id3157871" xml-lang="en-US" level="2" oldref="87">ODDFYIELD</paragraph> --- 251 unchanged lines hidden (view full) --- 319<emph>P</emph> is the number of periods needed for calculating the interest rate.</paragraph> 320<paragraph role="paragraph" id="par_id3159149" xml-lang="en-US" l10n="U" oldref="242"> 321<emph>PV</emph> is the present (current) value. The cash value is the deposit of cash or the current cash value of an allowance in kind. As a deposit value a positive value must be entered; the deposit must not be 0 or <0.</paragraph> 322<paragraph role="paragraph" id="par_id3149771" xml-lang="en-US" l10n="U" oldref="243"> 323<emph>FV</emph> determines what is desired as the cash value of the deposit.</paragraph> 324<paragraph role="heading" id="hd_id3148941" xml-lang="en-US" level="3" l10n="U" oldref="244">Example</paragraph> 325<paragraph role="paragraph" id="par_id3154212" xml-lang="en-US" l10n="U" oldref="245">For four periods (years) and a cash value of 7,500 currency units, the interest rate of the return is to be calculated if the future value is 10,000 currency units.</paragraph> 326<paragraph role="paragraph" id="par_id3150775" xml-lang="en-US" l10n="U" oldref="246"> | 52<embed href="text/scalc/01/func_yearfrac.xhp#basis"/> 53</section> 54<section id="oddfyield"> 55<bookmark xml-lang="en-US" branch="index" id="bm_id3157871"> 56<bookmark_value>ODDFYIELD function</bookmark_value> 57</bookmark> 58<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ODDFYIELD" id="bm_id3149723" localize="false"/> 59<paragraph role="heading" id="hd_id3157871" xml-lang="en-US" level="2" oldref="87">ODDFYIELD</paragraph> --- 251 unchanged lines hidden (view full) --- 311<emph>P</emph> is the number of periods needed for calculating the interest rate.</paragraph> 312<paragraph role="paragraph" id="par_id3159149" xml-lang="en-US" l10n="U" oldref="242"> 313<emph>PV</emph> is the present (current) value. The cash value is the deposit of cash or the current cash value of an allowance in kind. As a deposit value a positive value must be entered; the deposit must not be 0 or <0.</paragraph> 314<paragraph role="paragraph" id="par_id3149771" xml-lang="en-US" l10n="U" oldref="243"> 315<emph>FV</emph> determines what is desired as the cash value of the deposit.</paragraph> 316<paragraph role="heading" id="hd_id3148941" xml-lang="en-US" level="3" l10n="U" oldref="244">Example</paragraph> 317<paragraph role="paragraph" id="par_id3154212" xml-lang="en-US" l10n="U" oldref="245">For four periods (years) and a cash value of 7,500 currency units, the interest rate of the return is to be calculated if the future value is 10,000 currency units.</paragraph> 318<paragraph role="paragraph" id="par_id3150775" xml-lang="en-US" l10n="U" oldref="246"> |
327<item type="input">=RRI(4;7500;10000)</item> = 7.46 %</paragraph> 328<paragraph role="paragraph" id="par_id3145413" xml-lang="en-US" l10n="U" oldref="247">The interest rate must be 7.46 % so that 7,500 currency units will become 10,000 currency units.</paragraph> | 319<item type="input">=RRI(4;7500;10000)</item> = 7.46%</paragraph> 320<paragraph role="paragraph" id="par_id3145413" xml-lang="en-US" l10n="U" oldref="247">The interest rate must be 7.46% so that 7,500 currency units will become 10,000 currency units.</paragraph> |
329</section> 330<section id="rate"> 331<bookmark xml-lang="en-US" branch="index" id="bm_id3154267"> 332<bookmark_value>calculating;constant interest rates</bookmark_value> 333<bookmark_value>constant interest rates</bookmark_value> 334<bookmark_value>RATE function</bookmark_value> 335</bookmark> 336<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZINS" id="bm_id3153581" localize="false"/> --- 281 unchanged lines hidden --- | 321</section> 322<section id="rate"> 323<bookmark xml-lang="en-US" branch="index" id="bm_id3154267"> 324<bookmark_value>calculating;constant interest rates</bookmark_value> 325<bookmark_value>constant interest rates</bookmark_value> 326<bookmark_value>RATE function</bookmark_value> 327</bookmark> 328<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZINS" id="bm_id3153581" localize="false"/> --- 281 unchanged lines hidden --- |