Click here to Skip to main content
15,891,751 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I need to write PMT fomula in visual c# 2010, can tell me anyone how to I write it, I need to make some calculations :D
Posted
Comments
Sergey Alexandrovich Kryukov 28-Dec-11 18:06pm    
Excuse me, could you tell us -- what's "PMT formula"? This is an abbreviation; how can you expect everyone knew what is that?
Thank you,
--SA
Taulant Loshi 14-Dec-12 19:08pm    
Sorry I did not seen this before but however I'm going to answer you :)

The =Pmt function returns the payment amount for a loan based on an interest rate and a constant payment schedule.

This is the Syntax:

Pmt( interest_rate, number_payments, PV, FV, Type )

interest_rate is the interest rate for the loan.

number_payments is the number of payments for the loan.

PV is the present value or principal of the loan.

FV is optional. It is the future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the Pmt function assumes a FV value of 0.

Type is optional. It indicates when the payments are due.
1 means payment are due at the beginning of each period (each month, for example)
0 means payment at the end of each period.

Let's see an eg:

This example returns the monthly payment on a $5,000 loan at an annual rate of 7.5%. The loan is paid off in 2 years (That is: 2 x 12). All payments are made at the beginning of the period.

=Pmt(7.5%/12, 2*12, 5000, 0, 1)

The 1 at the end means the installment is paid at the start of every month.

In Plain English:
7.5 (interest rate) divided 12 (monthly interest rate) for 2 years (2*12 months) for a loan of 5000, each payment is made at the start of the period.
Sergey Alexandrovich Kryukov 14-Dec-12 22:57pm    
Do 'P', 'M' and 'T' mean something :-)
--SA
Taulant Loshi 16-Dec-12 9:40am    
sorry I don't know the syntax of PMT :$

 
Share this answer
 
Comments
Wendelius 28-Dec-11 17:32pm    
That was easy :) 5'ed
Sergey Alexandrovich Kryukov 16-Dec-12 14:00pm    
Yes, a 5.
—SA
Since this sound like a homework, if you have to implement it by yourself, I think it's quite nicely explained here[^]
 
Share this answer
 
Comments
Taulant Loshi 28-Dec-11 17:41pm    
no it's not a homework It's for my project, I'm making a loan calculator so I need to know it how to write :D
Wendelius 28-Dec-11 17:46pm    
Ok, in that case I think Ravi's answer will help you a lot :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900