+ Reply to Thread
Results 1 to 3 of 3

Financial Functions

  1. #1
    Forum Contributor
    Join Date
    03-24-2005
    Location
    Wisconsin
    MS-Off Ver
    2007
    Posts
    378

    Financial Functions

    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.

    Example:
    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.
    Thanks!
    Dennis

    I am using Windows 7 and Office 2007, all of my posts are based on this.

  2. #2
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544
    Hi Dennis,

    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).

    Succes,
    Erik
    Attached Files Attached Files
    Just keep it simple !


    http://www.excelguide.eu
    In English as well as in Dutch

  3. #3
    Forum Contributor
    Join Date
    03-24-2005
    Location
    Wisconsin
    MS-Off Ver
    2007
    Posts
    378

    This Works!

    Thank you very much.

    I will study the UDFs to see what you did.

    Quote Originally Posted by WinteE
    Hi Dennis,

    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).

    Succes,
    Erik

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1