Two Plus Two Newer Archives  

Go Back   Two Plus Two Newer Archives > Other Topics > Computer Technical Help

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 11-13-2007, 03:37 PM
Meech Meech is offline
Senior Member
 
Join Date: Nov 2004
Location: Meechigan
Posts: 1,159
Default Re: Excel translation needed

PMT(rate,nper,pv,fv,type)

Rate is the interest rate per period. For example, if you obtain an automobile loan at a 10 percent annual interest rate and make monthly payments, your interest rate per month is 10%/12, or 0.83%. You would enter 10%/12, or 0.83%, or 0.0083, into the formula as the rate.

Nper is the total number of payment periods in an annuity. For example, if you get a four-year car loan and make monthly payments, your loan has 4*12 (or 48) periods. You would enter 48 into the formula for nper.

Pv is the present value, or the total amount that a series of future payments is worth now; also known as the principal.

Fv is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.

Type is the number 0 (zero) or 1 and indicates when payments are due.

Set type equal to If payments are due
0 or omitted At the end of the period
1 At the beginning of the period
Reply With Quote
  #3  
Old 11-13-2007, 03:52 PM
bwana devil bwana devil is offline
Senior Member
 
Join Date: Feb 2004
Location: austin
Posts: 4,617
Default Re: Excel translation needed

whoa, much more than i was expecting.

thank you. that makes sense to me now.
Reply With Quote
  #4  
Old 11-13-2007, 04:15 PM
Meech Meech is offline
Senior Member
 
Join Date: Nov 2004
Location: Meechigan
Posts: 1,159
Default Re: Excel translation needed

Copy & Paste baby.
Reply With Quote
  #5  
Old 11-13-2007, 07:24 PM
CORed CORed is offline
Senior Member
 
Join Date: Sep 2002
Posts: 4,798
Default Re: Excel translation needed

[ QUOTE ]
Copy & Paste baby.

[/ QUOTE ]

OP just couldn't handle dealing with that damn paperclip.
Reply With Quote
Reply

Thread Tools
Display Modes

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:21 AM.


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