hbs_lat gl gl it gl ca hbs_lat en en gl en gl en gl gl gl en en en en en gl gl ca en gl en gl gl en en en en
Calculates the constant periodic payments for a loan or investment.
This constant, function or object is enabled with the statement Option VBASupport 1 placed before the executable program code in a module.
Pmt( Rate as Double, NPer as Double , PV as Double , [FV as Variant], [Due as Variant] )
A taxa corresponde á taxa de xuro periódica.
NPer é o número total de períodos durante os cales se paga a anualidade.
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.
5 Chamada de procedemento incorrecta
REM ***** BASIC ***** Option VBASUPPORT 1 ' Calculate the monthly payments to 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. Sub ExamplePmt Dim myPmt As Double myPmt = Pmt( 0.1/12, 72, 100000 ) print MyPmt 'is calculated to be -1852,58377757705 End Sub
PMT function in CALC
Funcións financeiras de VBA
Precisamos da súa axuda!
Impressum (Legal Info) | Privacy Policy | Statutes (non-binding English translation) - Satzung (binding German version) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Mozilla Public License v2.0. “LibreOffice” and “The Document Foundation” are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy. LibreOffice was based on OpenOffice.org.
Help content debug info:
This page is: /text/sbasic/shared/03140007.xhp
Title is: Pmt Function [VBA]