From 9411338fe715ff1c7190ec0761b5b54d40f1f5fb Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Mon, 24 Jul 2017 00:54:24 -0300 Subject: tdf#108678 Help page for VBA function Rate Change-Id: Ied97ddb4654817c705108b77a62dedcf3b001e34 Reviewed-on: https://gerrit.libreoffice.org/40352 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- source/text/sbasic/shared/03140010.xhp | 77 ++++++++++++++++++++++++++ source/text/sbasic/shared/special_vba_func.xhp | 4 +- 2 files changed, 78 insertions(+), 3 deletions(-) create mode 100644 source/text/sbasic/shared/03140010.xhp (limited to 'source/text/sbasic') diff --git a/source/text/sbasic/shared/03140010.xhp b/source/text/sbasic/shared/03140010.xhp new file mode 100644 index 0000000000..30767b7267 --- /dev/null +++ b/source/text/sbasic/shared/03140010.xhp @@ -0,0 +1,77 @@ + + + + + + + Rate Function [Runtime - VBA] + /text/sbasic/shared/03140010.xhp + + + + + + +
+ + Rate function + + + +Rate Function [Runtime - VBA] +Returns the Present Value of an investment resulting from a series of regular payments. +
+ + + +Pmt( NPer as Double, Pmt as Double, PV as Double [FV as Variant], [Due as Variant], [Guess as Variant] ) + + +Double + +NPer is the total number of periods, during which annuity is paid. +Pmt is the regular payment made per period. +PV is the present value of the loan / investment. +FV (optional) is the future value of the loan / investment. +Due (optional) defines whether the payment is due at the beginning or the end of a period. +0 - the payment is due at the end of the period; +1 - the payment is due at the beginning of the period. +Guess(optional) determines the estimated value of the interest with iterative calculation. + + + + +REM ***** BASIC ***** +Option VBASupport 1 +Sub ExampleRate +' Calculate the interest rate required to pay off a loan of $100,000 over +' 6 years, with payments of $1,500, due at the end of each month. + Dim mRate As Double + mRate = Rate( 72, -1500, 100000 ) + print mRate' mRate is calculated to be 0.00213778025343334 +End sub + + +
+RATE function in CALC + +
+ + + \ No newline at end of file diff --git a/source/text/sbasic/shared/special_vba_func.xhp b/source/text/sbasic/shared/special_vba_func.xhp index 39f33a57f9..dd4998ba0d 100644 --- a/source/text/sbasic/shared/special_vba_func.xhp +++ b/source/text/sbasic/shared/special_vba_func.xhp @@ -64,11 +64,9 @@ + - - Rate - SLN -- cgit