From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- .../source/text/sbasic/shared/03140008.xhp | 82 ++++++++++++++++++++++ 1 file changed, 82 insertions(+) create mode 100644 helpcontent2/source/text/sbasic/shared/03140008.xhp (limited to 'helpcontent2/source/text/sbasic/shared/03140008.xhp') diff --git a/helpcontent2/source/text/sbasic/shared/03140008.xhp b/helpcontent2/source/text/sbasic/shared/03140008.xhp new file mode 100644 index 000000000..c9694aa3e --- /dev/null +++ b/helpcontent2/source/text/sbasic/shared/03140008.xhp @@ -0,0 +1,82 @@ + + + + + + + PPmt Function [VBA] + /text/sbasic/shared/03140008.xhp + + + + + + +
+ + PPmt function + + + +PPmt Function [VBA] +Returns for a given period the payment on the principal for an investment that is based on periodic and constant payments and a constant interest rate. +
+ + + +Pmt( Rate as Double, Per as Double, NPer as Double, PV as Double, [FV as Variant], [Due as Variant] ) + + +Double + +Rate is the periodic interest rate. +Per The period number for which you want to calculate the principal payment (must be an integer between 1 and Nper). +NPer is the total number of periods, during which annuity is paid. +PV is the (present) cash value of an 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. + + + + +REM ***** BASIC ***** +Option VBASupport 1 +Sub ExamplePPmt +' Calculate the principal payments during months 4 & 5, for a loan that is to be paid in full +' over 6 years. Interest is 10% per year and payments are made at the end of the month. +Dim ppMth4 As Double +Dim ppMth5 As Double +' Principal payment during month 4: +ppMth4 = PPmt( 0.1/12, 4, 72, 100000 ) +print ppMth4 ' ppMth4 is calculated to be -1044,94463903636. +' Principal payment during month 5: +ppMth5 = PPmt( 0.1/12, 5, 72, 100000 ) +print ppMth5' ppMth5 is calculated to be -1053,65251102833. +End Sub + + +
+PPMT function in CALC + +
+ + + \ No newline at end of file -- cgit v1.2.3