04060118.xhp (52ac0773) | 04060118.xhp (7f63c140) |
---|---|
1<?xml version="1.0" encoding="UTF-8"?> | 1<?xml version="1.0" encoding="UTF-8"?> |
2<helpdocument version="1.0"> 3 | 2 |
4<!--*********************************************************** | 3<!--*********************************************************** |
5 * | 4 * |
6 * Licensed to the Apache Software Foundation (ASF) under one 7 * or more contributor license agreements. See the NOTICE file 8 * distributed with this work for additional information 9 * regarding copyright ownership. The ASF licenses this file 10 * to you under the Apache License, Version 2.0 (the 11 * "License"); you may not use this file except in compliance 12 * with the License. You may obtain a copy of the License at | 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 9 * to you under the Apache License, Version 2.0 (the 10 * "License"); you may not use this file except in compliance 11 * with the License. You may obtain a copy of the License at |
13 * | 12 * |
14 * http://www.apache.org/licenses/LICENSE-2.0 | 13 * http://www.apache.org/licenses/LICENSE-2.0 |
15 * | 14 * |
16 * Unless required by applicable law or agreed to in writing, 17 * software distributed under the License is distributed on an 18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19 * KIND, either express or implied. See the License for the 20 * specific language governing permissions and limitations 21 * under the License. | 15 * Unless required by applicable law or agreed to in writing, 16 * software distributed under the License is distributed on an 17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18 * KIND, either express or implied. See the License for the 19 * specific language governing permissions and limitations 20 * under the License. |
22 * | 21 * |
23 ***********************************************************--> 24 | 22 ***********************************************************--> 23 |
25 26 27 | 24<helpdocument version="1.0"> |
28<meta> 29<topic id="textscalc0104060118xml" indexer="include"> 30<title id="tit" xml-lang="en-US">Financial Functions Part Three</title> 31<filename>/text/scalc/01/04060118.xhp</filename> 32</topic> 33</meta> 34<body> 35<paragraph role="heading" id="hd_id3146780" xml-lang="en-US" level="1" l10n="U" oldref="1">Financial Functions Part Three</paragraph> --- 240 unchanged lines hidden (view full) --- 276</tablecell> 277<tablecell> 278<paragraph role="paragraph" id="par_id3147495" xml-lang="en-US" l10n="U" oldref="211">1000</paragraph> 279</tablecell> 280<tablecell> 281</tablecell> 282</tablerow> 283</table> | 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> --- 240 unchanged lines hidden (view full) --- 273</tablecell> 274<tablecell> 275<paragraph role="paragraph" id="par_id3147495" xml-lang="en-US" l10n="U" oldref="211">1000</paragraph> 276</tablecell> 277<tablecell> 278</tablecell> 279</tablerow> 280</table> |
284 | |
285<paragraph role="paragraph" id="par_id3152793" xml-lang="en-US" l10n="U" oldref="212">=XIRR(B1:B5; A1:A5; 0.1) returns 0.1828.</paragraph> 286</section> 287<section id="xnpv"> 288<bookmark xml-lang="en-US" branch="index" id="bm_id3149198"><bookmark_value>XNPV function</bookmark_value> 289</bookmark> 290<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_XNPV" id="bm_id3151172" localize="false"/> 291<paragraph role="heading" id="hd_id3149198" xml-lang="en-US" level="2" oldref="213">XNPV</paragraph> 292<paragraph role="paragraph" id="par_id3153904" xml-lang="en-US" l10n="U" oldref="214"><ahelp hid="HID_AAI_FUNC_XNPV">Calculates the capital value (net present value)for a list of payments which take place on different dates.</ahelp> The calculation is based on a 365 days per year basis, ignoring leap years.</paragraph> --- 309 unchanged lines hidden --- | 281<paragraph role="paragraph" id="par_id3152793" xml-lang="en-US" l10n="U" oldref="212">=XIRR(B1:B5; A1:A5; 0.1) returns 0.1828.</paragraph> 282</section> 283<section id="xnpv"> 284<bookmark xml-lang="en-US" branch="index" id="bm_id3149198"><bookmark_value>XNPV function</bookmark_value> 285</bookmark> 286<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_XNPV" id="bm_id3151172" localize="false"/> 287<paragraph role="heading" id="hd_id3149198" xml-lang="en-US" level="2" oldref="213">XNPV</paragraph> 288<paragraph role="paragraph" id="par_id3153904" xml-lang="en-US" l10n="U" oldref="214"><ahelp hid="HID_AAI_FUNC_XNPV">Calculates the capital value (net present value)for a list of payments which take place on different dates.</ahelp> The calculation is based on a 365 days per year basis, ignoring leap years.</paragraph> --- 309 unchanged lines hidden --- |