Tutorials Shared by the Internet Community
Total Hits - 32704
Total Votes - 111 votes
Vote Up - 49 votes
Vote Down - 62 votes
Domain - www.functionx.com
Category - MS Access/Functions
Submitted By - Shekhar
Submitted on - 2008-04-15 07:30:20
Microsoft Access provides a series of function destined to perform various types of financially related operations. These functions use common factors depending on the value that is being calculated. Many of these functions deal with investments or loan financing.
The Present Value is the current value of an investment or a loan. For a savings account, a customer could pledge to make a set amount of deposit on a bank account every month. The initial value that the customer deposits or has in the account is the Present Value. The sign of the variable, when passed to a function, depends on the position of the customer. If the customer is making deposits, this value must be negative. If the customer is receiving money (lottery installment, family inheritance, etc), this value should be positive. More detail...