Simple interest is the least complex of the interest calculation types and assumes that there is no interest earned on your interest. In other words, there is no compounding of interest within these calculations.

Discount interest is where interest is computed on the face value of the loan and is subtracted from the face value at the start of the loan, i.e. the proceeds of the loan are "discounted". The borrower is given less then the face value of the loan but pays back the full face amount of the loan and is charged interest on the face amount for the full time period. Discounted interest thus uses a larger base on which to calculate interest then does simple interest which uses the initial amount rather then the final amount due to repay the loan.

These function convert interest rates, calculate per period interest rates and totals the total number of periods in a given investment.

Compound interest is earning interest on interest because at the end of each period, the interest earned is added to the principal or face value. When reviewing these functions, note that the period interest rate and number of total periods is automatically calculated. Furthermore, an assumption is made that the interest computation period is the same as the periodic payment for annuities (i.e. only simple annuities are considered) and that the payments are at the end of the period.

These functions include various annuity evaluation calculations. Note: that unless explicitly called "AnnuityDue" all functions assume that all annuity payments are made at the end of the each period.

These functions include various annuity evaluation functions. Note: that these functions assume that all annuity payments are made at the beginning of the each period.

These functions facilitate the calculation of Net Present Value, Payback Period and other capital budgeting type calculations.

These functions provide the ability to calculate yields of maturity, current market bond price and bond duration and other related functions.

These functions perform various financial calculations formatted and named in a way similar to the financial "@" functions contained within the 1-2-3 Spreadsheet Software. Functions PMT, FV, FVDue, PVDue, NPV, IRR, Rate and TERM.

Return to the FinLib Main Page
FinLib Routines