MS Excel Financial Function is very helpful to calculate No of Installment (NPER), Present Value (PV) of any future cash flows, Future Value (FV), Amount per Installment given or receive (PMT), Net Present Value (NPV) of any project, Rate of Interest etc.
These types of financial measurement is very important for managerial decision making process, finance decision making process, accounts department and more.

First Installment Amount (PMT) is calculating. Example is mentioned under:-

Say, Mr X, retired employee, gets pension $10,000. Present value $1,036,246.19 Get pension for 20 years. Rate of Interest:- 10% pa. Calculate PMT

Answer:-
VIEW PICTURE AND SOLUTION (click on picture to view full size)
or VIEW UNDER MENTIONED VIDEO TUTORIAL


Pension Amount = ?
Rate of Interest = 10% Per Year
No of Installment = 240 20 years & 12 months each
Present Value = $1,036,246.19

PMT(Monthly Pay) = ($10,000.00) (calculated)

In 2003 Excel:- Insert Menu -- Function -- Select Financial -- Select PMT -- Ok -- PV:- ($1,036,246.19), NPER:- 240, Rate:- 10%/12, FV:- $15,187,376.74

In 2007 Excel:- Formula Menu --> Financial --> PMT -->
PV:- ($1,036,246.19), NPER:- 240, Rate:- 10%/12, FV:- $15,187,376.74
NEGATIVE PMT VALUE CALCULATE


Stay Connected With Free Updates

Subscribe via Email
You can leave a response, or trackback from your own site.

Pijush Roy, Founder & Author of "Share Your Knowledge", is a young freelance blogger, a reader, a painter, .....read more


Followers

IMPORTANT LINK/URLs

m