I am not a true financial type. What I need is a formula that will tell a person how much money they will pay, over time, in a revolving credit account.
Mary has $600.00 on her Credit Card. She makes a minumum payment (4% of balance or $15,00, whichever is greater) each month. How long will it take her to pay in full, and what is the cumulative value of her payments.
In building a simple amortization table based on the above, I know it will take 51 payments to pay off the credit card and the sum of all payments amounts to $843.41.
But I know there has to be a way to do this without having a table that will cover all the variables that might come up with Mary's (or anyone else's) credit card. They change the interest rate, or minimum payment, etc.
In the attached zip file:
Cell D3 has the beginning balance
Cell D4 has the interest rate
Cells G3 & G5 have the paramaters for minimum payment.
Cell D6 has the time it will take to pay off.
Cell G6 has the total of all payments made until paid off.
I would like to know if there are functions that could return the values in Cells D6 & G6 without the need to have the table.
My reason is that I want to show how a Debt Snowball would work with multiple revolving accounts.
Last edited by DCSwearingen; 04-11-2008 at 09:31 AM.
I am using Windows 7 and Office 2007, all of my posts are based on this.
I have made some user defined functions for this, they are already included in the attached .zip. The results of these functions are in cells A3 (number of payments) and A4 (total payment).
Thank you very much.
I will study the UDFs to see what you did.
Originally Posted by WinteE
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1