DDB Function | Microsoft.VisualBasic.Financial |
DDB(cost, salvage, life, period[, factor]) |
|
cost required; Double
The initial cost of the asset
salvage required; Double
The value of the asset at the end of life
life required; Double
Length of life of the asset
period required; Double
Period for which the depreciation is to be calculated
factor optional; Double
The rate at which the asset balance declines. If omitted, 2 (double-declining method) is assumed; however, the documentation doesn't mention what other values are supported or what they mean
Double representing the depreciation of an asset
Returns a Double representing the depreciation of an asset for a specific time period. This is done using the double-declining balance method or another method that you specify using the factor argument.
The double-declining balance calculates depreciation at a differential rate, which varies inversely with the age of the asset. Depreciation is highest at the beginning of an asset's life and declines over time.
FV Function | Microsoft.VisualBasic.Financial |
FV(rate, nper, pmt[, pv [, due]]) |
|
rate required; Double
The interest rate per period
nper required; Integer
The number of payment periods in the annuity
pmt required; Double
The payment made in each period
pv optional; Variant
The present value of the loan or annuity
due optional; Constant of the DueDate enumeration
Specifies whether payments are due at the start or the end of the period. The value can be DueDate.BegOfPeriod or DueDate.EndOfPeriod (the default).
A Double specifying the future value of an annuity
Calculates the future value of an annuity (either an investment or loan) based on a regular number of payments of a fixed value and a static interest rate over the period of the annuity.
IPmt Function | Microsoft.VisualBasic.Financial |
IPmt(rate, per, nper, pv[, fv[, due]]) |
|
rate required; Double
The interest rate per period.
per required; Double
The period for which a payment is to be computed.
nper required; Double
The total number of payment periods.
pv required; Double
The present value of a series of future payments.
fv optional; Double
The future value or cash balance after the final payment. If omitted, the default value is 0.
due optional; DueDate enumeration
A value indicating when payments are due. DueDate.EndOfPeriod (or 0) indicates that payments are due at the end of the payment period; DueDate. BegOfPeriod (or 1) indicates that payments are due at the beginning of the period. If omitted, the default value is DueDate.EndOfPeriod.
A Double representing the interest payment
Computes the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate. An annuity is a series of fixed cash payments made over a period of time. It can be either a loan payment or an investment.
IRR Function | Microsoft.VisualBasic.Financial |
IRR(valuearray( )[, guess]) |
|
valuearray( ) required; array of Double
An array of cash flow values
guess optional; Double
Estimated value to be returned by the function
A Double representing the internal rate of return
Calculates the internal rate of return for a series of periodic cash flows (payments and receipts).
The internal rate of return is the interest rate generated by an investment consisting of payments and receipts that occur at regular intervals. It is generally compared to a "hurdle rate," or a minimum return, to determine whether a particular investment should be made.
MIRR Function | Microsoft.VisualBasic.Financial |
MIRR(valuearray( ), financerate, reinvestrate) |
|
valuearray( ) required; Array of Double
An array of cash flow values
financerate required; Double
The interest rate paid as the cost of financing
reinvestrate required; Double
The interest rate received on gains from cash investment
A Double representing the modified internal rate of return
Calculates the modified internal rate of return, which is the internal rate of return when payments and receipts are financed at different rates.
NPer Function | Microsoft.VisualBasic.Financial |
NPer(rate, pmt, pv [, fv [, due]]) |
|
rate required; Double
The interest rate per period.
pmt required; Double
The payment to be made each period.
pv required; Double
The present value of the series of future payments or receipts.
fv optional; Double
The future value of the series of payments or receipts. If omitted, the default value is 0.
due optional; DueDate enumeration
A value indicating when payments are due. DueDate.EndOfPeriod (0) indicates that payments are due at the end of the payment period, and DueDate. BegOfPeriod (1) indicates that payments are due at the beginning of the period. If omitted, the default value is 0.
A Double indicating the number of payments
Determines the number of payment periods for an annuity based on fixed periodic payments and a fixed interest rate.
NPV Function | Microsoft.VisualBasic.Financial |
NPV(rate, valuearray( ) ) |
|
rate required; Double
The discount rate over the period, expressed as a decimal
valuearray( ) required; Double
An array of cash flow values
A Double specifying the net present value
Calculates the net present value of an investment based on a series of periodic variable cash flows (payments and receipts) and a discount rate.
The net present value is the value today of a series of future cash flows discounted at some rate back to the first day of the investment period.
Pmt Function | Microsoft.VisualBasic.Financial |
Pmt(rate, nper, pv[, fv[, due]]) |
|
rate required; Double
The interest rate per period.
nper required; Double
The total number of payment periods.
pv required; Double
The present value of the series of future payments.
fv optional; Double
The future value or cash balance after the final payment.
due optional; DueDate enumeration
A value indicating when payments are due. EndOfPeriod (0) indicates that payments are due at the end of the payment period; BegOfPeriod (1) indicates that payments are due at the beginning of the period. If omitted, the default value is 0.
A Double representing the monthly payment
Calculates the payment for an annuity based on periodic, fixed payments and a fixed interest rate. An annuity can be either a loan or an investment.
PPmt Function | Microsoft.VisualBasic.Financial |
PPmt(rate, per, nper, pv[, fv[, due]]) |
|
rate required; Double
The interest rate per period.
per required; Double
The period for which a payment is to be computed.
nper required; Double
The total number of payment periods.
pv required; Double
The present value of a series of future payments.
fv optional; Object
The future value or cash balance after the final payment. If omitted, the default value is 0.
due optional; DueDate enumeration
A value indicating when payments are due. It can be either DueDate.EndOfPeriod, for payments due at the end of the period, or DueDate.BegOfPeriod for payments due at the beginning of the period. The default value is DueDate.EndOfPeriod.
A Double representing the principal paid in a given payment
Computes the payment of principal for a given period of an annuity, based on periodic, fixed payments and a fixed interest rate. An annuity is a series of fixed cash payments made over a period of time. It can be either a loan payment or an investment.
PV Function | Microsoft.VisualBasic.Financial |
PV(rate, nper, pmt[, fv [, due]]) |
|
rate required; Double
The interest rate per period
nper required; Integer
The number of payment periods in the annuity
pmt required; Double
The payment made in each period
fv optional; Double
The future value of the loan or annuity
due optional; DueDate
Either DueDate.BegOfPeriod or DueDate.EndOfPeriod
A Double specifying the present value of an annuity
Calculates the present value of an annuity (either an investment or loan) based on a regular number of future payments of a fixed value and a fixed interest rate. The present value is the current value of a future stream of equal cash flows discounted at some fixed interest rate.
Rate Function | Microsoft.VisualBasic.Financial |
Rate(nper, pmt, pv[, fv[, due[, guess]]]) |
|
nper required; Double
The total number of periods in the annuity.
pmt required; Double
The payment amount per period.
pv required; Double
The present value of the payments or future receipts.
fv optional; Double
The future value or cash balance after the final payment. If omitted, its value defaults to 0.
due optional; DueDate enumeration
A flag indicating whether payments are due at the beginning of the payment period (a value of DueDate.BegOfPeriod) or at the end of the payment period (a value of DueDate.EndOfPeriod, the default).
guess optional; Double
An estimate of the value to be returned by the function. If omitted, its value defaults to .1 (10%).
A Double representing the interest rate per period
Calculates the interest rate for an annuity (a loan or an investment) that consists of fixed payments over a known duration.
SLN Function | Microsoft.VisualBasic.Financial |
SLN(cost, salvage, life) |
|
cost required; Double
The initial cost of the asset
salvage required; Double
The value of the asset at the end of its useful life
life required; Double
The length of the useful life of the asset
A Double representing depreciation per period
Computes the straight-line depreciation of an asset for a single period
SYD Function | Microsoft.VisualBasic.Financial |
SYD(cost, salvage, life, period ) |
|
cost required; Double
The initial cost of the asset
salvage required; Double
The value of the asset at the end of its useful life
life required; Double
The length of the useful life of the asset
period required; Double
The period whose depreciation is to be calculated
A Double giving the sum-of-years depreciation of an asset for a given period
Computes the sum-of-years' digits depreciation of an asset for a specified period. The sum-of-years' digits method allocates a larger amount of the depreciation in the earlier years of the asset.