FV Function [VBA]

Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).

यस k, कार्य वा वस्तुले प्रयोगयोग्य कार्यक्रम कोडमा एक मोड्युलमा प्रयोग गरिएको Option VBASupport 1 विधानसहितका अगाडि सक्षम गरिएको छ।

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

Double

दरआवधिक ब्याज दर हो ।

NPER अवधिहरू(भुक्तानी अवधि)को जम्मा सङ्ख्या हो ।

PMTवार्षिकी प्रत्येक अवधिमा तिरिने नियमित भुक्तानी हो।

PV (वैकल्पिक) लगानीको (वर्तमान) नगद मान हो।

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.

Sub ExampleFV
 Dim myFV As Double
 myFV = =FV(0.04, 2, 750, 2500)
 Print myFV ' returns 4234.00 currency units. The value at the end of the investment is 4234.00 currency units.
End Sub