n SalvageValue is the value of the asset at the end of its useful life (also a Double).
n LifeOfProduct is an Integer that specifies the length of the useful life of the product
(usually months or years).
n DepreciationPeriod is a Double that specifies the period for which the depreciation
is calculated.
460
Programming Microsoft Access Part II
n NPV(): Returns a Double floating-point value representing the net present value of an
investment. The syntax of NPV is:
NPV(DiscountRate, CashFlowArray())
where:
n DiscountRate is the discount rate (expressed as a Double floating-point number)
applied over the length of the period.
n CashFlowArray() is an array of Double floating point numbers representing the
cash flow values.
n FV(): Returns the future value of an annuity based on periodic, fixed payment and fixed
interest rate. The syntax is:
FV(Rate, PaymentPeriods, Payment [, PresentValue] [, Type])
where:
n Rate is a Double specifying the interest rate paid per period. If the interest rate is
specified on an annual basis, but payments are made every month, divide the interest
rate by 12 to get the interest rate per month.
Pages:
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975