Tuesday, November 16, 2010

Financial Calcuation with Excel

The Excel spreadsheet has excellent formulas to make financial calculations. They are available under the Formula tab >> Financial.

You can use the following formulas

FV - future value
PV - present value
NPER - number of period
RATE- interest rate
PMT - amount of yearly payment
Type - 1 (pay at beginning of year), 0 (pay at end of year) and 0.5 (may monthly throughout the year).

It allows you to find out the FV or PV of a single payment or a stream of regular payments, or to calculate the yield or number of periods.

When you attend my talk on financial planning or insuring your financial secruity, I will demonstrate how to use these formulas (for people who are not familiar).

Tan Kin Lian

No comments:

Blog Archive