Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 how to count monthly payment?, help me please

views
     
clieman
post Sep 24 2008, 12:42 AM

Enthusiast
*****
Senior Member
731 posts

Joined: Nov 2006
From: Shah Alam


Use Excel. The function is PMT(rate,nper,pv,{fv,type})

Rate is in %, nper is number of years X 12, PV is your loan. The result will be a negative value which is your monthly installment.

You can ignore the parameters in {}. Look up Excel help if you need more example.

 

Change to:
| Lo-Fi Version
0.0154sec    0.61    6 queries    GZIP Disabled
Time is now: 16th December 2025 - 09:15 PM