Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Need Excel formula for Credit Card Interest Caculation

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 21-01-2012
Member
 
Join Date: Jan 2012
Posts: 61
Need Excel formula for Credit Card Interest Caculation

I am 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 me 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 fpr my payments that should be to pay it off in that time limit. Thanks

Reply With Quote
  #2  
Old 21-01-2012
Member
 
Join Date: Jun 2011
Posts: 796
Re: Need Excel formula for Credit Card Interest Caculation

From the Excel help file., try to search for NPER function. This will help you to find "Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate." Second one is PMT function. This will help you to calculate the payment for a loan based on constant payments and a constant interest rate.
Reply With Quote
  #3  
Old 21-01-2012
Member
 
Join Date: May 2011
Posts: 445
Re: Need Excel formula for Credit Card Interest Caculation

There is a template for the question that you have asked which can help you. Download the below Credit Card Payment Calculator template and fill up the information as per you need. It will give you a easy to use report and information on Credit Card Interest rate. The second link provides you detailed help on creating your own play payment methods in Microsoft Excel.
Credit Card Payment Calculator

Plan payments and savings with Excel
Reply With Quote
  #4  
Old 10-05-2012
Member
 
Join Date: Jan 2006
Posts: 6,915
Re: Need Excel formula for Credit Card Interest Caculation

It is not a tough task to calculate the interest of credit card. Input your current credit card balance in cell A1, input the formula in cell B1 (= A1*(credit card interest rate/12)), in cell C1 input the monthly payment you make, in D1 Create formula =A1+B1-C1. NOW A2=D1, copy cells B1, C1 & D1 and paste onto cell B2, C2 &D2. Now copy entire row of A2:d2 and paste down until cell D become zero.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Need Excel formula for Credit Card Interest Caculation"
Thread Thread Starter Forum Replies Last Post
Excel formula for calculating total payments made using Amex card balajivenkateshan Software Development 1 26-09-2012 03:56 PM
I am looking for a formula to calculate compound interest in Excel Corey Dunnett MS Office Support 3 03-02-2012 05:05 PM
PayPal Credit and Credit Card Bao Technology & Internet 4 22-07-2010 10:38 AM
Is it worth to ADD Graphic card! My MB is D945GCNL. My Interest in Screensavers & watching movies only. PkM37 Monitor & Video Cards 1 22-01-2009 05:59 PM


All times are GMT +5.5. The time now is 11:22 PM.