PC Review


Reply
Thread Tools Rate Thread

Credit Card time to payoff and defered balance

 
 
=?Utf-8?B?TWlrZSBKb2huc3RvbmU=?=
Guest
Posts: n/a
 
      21st Oct 2007
How can I calculate the amount of money needed and the amount of time in
months to pay off a credit card, it I know the balance, the percentage rate
(compound interest) and the monthly minimum payment (2 to 3% of the unpaid
balance)?

 
Reply With Quote
 
 
 
 
=?Utf-8?B?Q3JpbmdpbmcgRHJhZ29u?=
Guest
Posts: n/a
 
      21st Oct 2007
Your question is not really about programming (the subject of this discussion
group), so this probably wasn't the best place to post.
Try working your way through this tutorial and it may help you understand
how to use Excel to do the sort of things you're asking about:
http://office.microsoft.com/training...CR061831141033

The Excel functions you'll probably want to use are:
=NPER(<interest rate>,<payment>,<balance>)
That will give you the number of payments (months).
Note that the interest rate is per period (month), so will need to be the
annual rate/12.

=PV(<interest rate>,<number of payments>,<payment>)
Will return the total amount to be payed.
Do the NPER first so that you have the number of payments to enter.
Otherwise, nest the functions:
=PV(<interest rate>,NPER(<interest rate>,<payment>,<balance>),<payment>)

"Mike Johnstone" wrote:

> How can I calculate the amount of money needed and the amount of time in
> months to pay off a credit card, it I know the balance, the percentage rate
> (compound interest) and the monthly minimum payment (2 to 3% of the unpaid
> balance)?
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
credit card payoff worksheet toombstone Microsoft Excel Worksheet Functions 2 3rd Oct 2008 10:54 PM
Re: Calculating pay-off time for Credit Card? Bernie Deitrick Microsoft Excel Worksheet Functions 0 1st Oct 2008 05:01 PM
Credit Cards, time in months to payoff and payoff amount =?Utf-8?B?TWlrZSBKb2huc3RvbmU=?= Microsoft Excel Worksheet Functions 1 21st Oct 2007 10:41 AM
Excel macro to calc payment/payoff of credit card =?Utf-8?B?ZXhzZmNwIC0gU3RldmU=?= Microsoft Excel Programming 1 21st Dec 2006 09:04 AM
Version 8 Integration for SOP does not pick up the credit card specified in the source field it uses the default credit card against the debtor. Jen Microsoft Access 1 14th Sep 2005 03:17 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:34 AM.