Λογιστικές συναρτήσεις

Η Visual Basic παρέχει μια σειρά από συναρτήσεις για υπολογισμούς λογιστικής φύσης σύμφωνα με τον παρακάτω πίνακα:

Υπολογισμός	Συνάρτηση
Calculate the future value of an annuity based on periodic, fixed payments and a fixed interest rate.	FV(rate, nper, pmt[, pv[, type]])
Calculate the depreciation of an asset for a specific time period using the double-declining balance method or some other method you specify.	DDB(cost, salvage, life, period[, factor])
Calculate the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.	IPmt(rate, per, nper, pv[, fv[, type]])
Calculate the internal rate of return for a series of periodic cash flows (payments and receipts).	IRR(values()[, guess])
Calculate the modified internal rate of return for a series of periodic cash flows (payments and receipts).	MIRR(values(), finance_rate, reinvest_rate)
Calculate the number of periods for an annuity based on periodic, fixed payments and a fixed interest rate.	NPer(rate, pmt, pv[, fv[, type]])
Calculate the net present value of an investment based on a series of periodic cash flows (payments and receipts) and a discount rate.	NPV(rate, values())
Calculate the payment for an annuity based on periodic, fixed payments and a fixed interest rate.	Pmt(rate, nper, pv[, fv[, type]])
Calculate the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.	PPmt(rate, per, nper, pv[, fv[, type]])
Calculate the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate.	PV(rate, nper, pmt[, fv[, type]])
Calculate the interest rate per period for an annuity.	Rate(nper, pmt, pv[, fv[, type[, guess]]])
Calculate the straight-line depreciation of an asset for a single period.	SLN(cost, salvage, life)
Calculate the sum-of-years' digits depreciation of an asset for a specified period.	SYD(cost, salvage, life, period)