How do I calculate credit card interest with a formula?

C

Conker10382

I'm trying to create a feature that will allow me to enter my credit card
amount, interest, and monthly payments to find out how long it will take to
pay off. But also allow me to switch it up and enter the number of payments
I want to make to find out the amount my payments should be to pay it off in
that time limit.
 
J

Jim Cone

From the Excel help file...
NPER function...
"Returns the number of periods for an investment based on periodic,
constant payments and a constant interest rate."

PMT function...
"Calculates the payment for a loan based on constant payments and a constant interest rate."
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins - free trial "Calculate Payments" - no registration)



"Conker10382"
wrote in message
I'm trying to create a feature that will allow me to enter my credit card
amount, interest, and monthly payments to find out how long it will take to
pay off.
But also allow me to switch it up and enter the number of payments
I want to make to find out the amount my payments should be to pay it off in
that time limit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating interest due on late loan payments 1
Credit Score 5
How do I track credit card debt on one spreadsheet? 1
how to calculate interest on payments 2
how to calculate a credit card 2
Calulate interest for a loan as payments are received 2
How long will it take to pay off my credit card 3
Need a formula to calculate the number of months to pay off a loan 2

Top