IPmt Function [VBA]

Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.

warning

This constant, function or object is enabled with the statement Option VBASupport 1 placed before the executable program code in a module.


Syntax:


IPmt(Rate as Double, Per as Double, NPer as Double, PV as Double, [FV as Variant], [Due as Variant])

Return value:

Double

Parameters:

αž’αžαŸ’αžšαžΆ αž‡αžΆβ€‹αž’αžαŸ’αžšαžΆβ€‹αž€αžΆαžšβ€‹αž”αŸ’αžšαžΆαž€αŸ‹β€‹αžαžΆαž˜β€‹αž€αžΆαž›β€‹αž€αŸ†αžŽαžαŸ‹Β αŸ”

Per is the period, for which the compound interest is calculated. Period=NPER if compound interest for the last period is calculated.

NPer αž‚αžΊβ€‹αž‡αžΆβ€‹αž…αŸ†αž“αž½αž“β€‹αžšαž™αŸˆαž–αŸαž›β€‹αžŸαžšαž»αž” αž€αŸ†αž‘αž»αž„β€‹αžŠαŸ‚αž›β€‹β€‹αž”αŸ’αžšαžΆαž€αŸ‹β€‹αž”αŸ’αžšαž…αžΆαŸ†β€‹αžαŸ’αž„αŸƒβ€‹αžŽαžΆαž˜αž½αž™β€‹αžαŸ’αžšαžΌαžœβ€‹αž…αŸ†αžŽαžΆαž™Β αŸ”

PV αž‡αžΆβ€‹αžαž˜αŸ’αž›αŸƒβ€‹αžŸαžΆαž…αŸ‹β€‹αž”αŸ’αžšαžΆαž€αŸ‹β€‹αž”αž…αŸ’αž…αž»αž”αŸ’αž”αž“αŸ’αž“β€‹αž€αŸ’αž“αž»αž„β€‹αž›αŸ†αžŠαžΆαž”αŸ‹β€‹αž€αžΆαžšβ€‹αž”αž„αŸ‹β€‹αž”αŸ’αžšαžΆαž€αŸ‹Β αŸ”

FV (αžŸαŸ’αžšαŸαž…β€‹αž…αž·αžαŸ’αž) αž‡αžΆβ€‹αžαž˜αŸ’αž›αŸƒβ€‹αžŠαŸ‚αž›β€‹αž…αž„αŸ‹β€‹αž”αžΆαž“ (αžαž˜αŸ’αž›αŸƒβ€‹αž”αž…αŸ’αž…αž»αž”αŸ’αž”αž“αŸ’αž“) αž“αŸ…β€‹αž”αŸ†αžŽαžΆαž…αŸ‹β€‹αž’αŸ†αž‘αž»αž„αž–αŸαž›Β αŸ”

Due (optional) is the due date for the periodic payments.

0 - the payment is due at the end of the period;

1 - the payment is due at the beginning of the period.

Error codes:

5 αž€αžΆαžšβ€‹αž αŸ…β€‹αž”αŸ‚αž”αž”αž‘β€‹αž˜αž·αž“β€‹αžαŸ’αžšαžΉαž˜αžαŸ’αžšαžΌαžœ

Example:


Sub ExampleIPmt
 Dim myIPmt As Double
 myIPmt = IPmt(0.05,5,7,15000)
 Print myIPmt ' returns -352.97 currency units. The compound interest during the fifth period (year) is 352.97 currency units.
End Sub

Please support us!