|ECalcPad home||Download ECalcPad free||DataOdyssey Projects home||DataOdyssey Express - Data Mining made easy||EasySql4Fox - VFP adapt to SQL(MySQL,ORACLE) quickly|
Functions. Mortgage calculation sample.
When an "Expression" cell is selected, toolbar button is enabled. Click it to call the list of available functions.
Select the needed function from the list and click "Select". The function will be inserted into current expression position. Almost all functions have an argument and some functions have several arguments described in the list. If you know the name and syntax of the needed function just type it into expression cell without calling the list.
There are two types of functions: mathematical and financial. Here is a sample of a popular mortgage calculation.
Input values are described as first lines. Three functions are used here:
PAYMENT(nPrincipal, nInterestRate, nPayments) - calculation of a monthly loan payment. Initial data: beginning principal of the loan, interest rate per period (if monthly payments are made on the loan but the interest rate is annual, divide the annual interest rate by 12), and total number of payments as years*12
FV(nPayment, nInterestRate, nPeriods) - returns the future value of a financial investment. Given: constant periodic payment (monthly in our sample), the periodic interest rate (if the interest rate is annual but the payments are made monthly, divide the annual interest rate by 12) , and the number of periods over which payments are made. FV( ) assumes that the periodic payments are made at the end of each period.
PV(nPayment, nInterestRate, nTotalPayments) - returns the present value of an investment.
Mortgage calculation is included into the program as a sample pattern.
See a more powerfull tools of mortgage calculation here.