Two Plus Two Newer Archives  

Go Back   Two Plus Two Newer Archives > Other Topics > Computer Technical Help
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-13-2007, 03:12 PM
bwana devil bwana devil is offline
Senior Member
 
Join Date: Feb 2004
Location: austin
Posts: 4,617
Default Excel translation needed

i have the formula and want to know what it all means. the formula calculates a monthly payment on a loan. the formula is:

=PMT((C1*0.01)/12,C3*12,C2,0)

where
PMT = monthly payment
C1 = interest rate as a whole number
C2 = loan amount
C3 = length of loan in years

what does the first 12 and the 0 mean? also, i dont understand the english translation/logic of this formula.

original formula can be found here

thanks.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 11:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.