| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate credit card interest with a formula?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I calculate credit card interest with a formula?
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I calculate credit card interest with a formula?
Thanks Jim. I'll try that out.
"Jim Cone" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate a credit card | Excel Discussion (Misc queries) | |||
| Credit Card # | Setting up and Configuration of Excel | |||
| How long will it take to pay off my credit card | Excel Discussion (Misc queries) | |||
| Formula to figure credit card payments | Excel Worksheet Functions | |||
| Calculating credit card debt, interest , and payments | Excel Worksheet Functions | |||
Linear Mode
