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 ---