Excel Financial Function to calculate No of Installment (NPER)


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.

Now No of Installment (NPER) is calculating. Example is mentioned under:-

Mr X, retired employee, gets pension $10,000. Present value $1,036,246.19 Rate of interest 10% p.a., CALCULATE No of Installment

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



Pension Amount = ($10,000.00) Per Month (put negative value)
Rate of Interest = 10% Per Year
No of Installment = ?
Present Value = $1,036,246.19

No of Installment = 240 (calculated)

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

In 2007 Excel:- Formula Menu -- Financial -- NPER --
Rate:- 10%/12, PMT:- ($10000.00), PV:- $1,036,246.19
Always Put Negative PMT i.e. Loan or Pension Amount etc


Labels:
Reactions:

Post a Comment

[disqus][facebook]

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget