Free Shipping on All Orders 1-866-764-1801

Vist our Online Store
+ Reply to Thread
Results 1 to 5 of 5
  1. #1

    Member Sales Rating: (16)

    Join Date
    Nov 2007
    Posts
    4,012

    Default Any MS Excel Gurus in the house? Need a financial formula or function

    Is there an Excel Doctor in the house??

    I need a formula in Excel that can calculate the remaining balance on a savings account.

    The inputs would be:
    * The current balance
    * Monthly withdrawal amounts (same date every month)
    * Number of months to make the withdrawals
    * Earnings on the account during the withdrawal period (as an annual return)

    The output would be what is left in the savings account after the withdrawals, but accounts for earnings on the balance during the drawdown period.

    There are lots of links on the internet for 'drawdown calculators' that do exactly this - but I'd like to automate this in Excel.

    Any thoughts?

    Thanks!

    H9: If you don't trust what you are hearing, then maybe you need to be less invested in a hobby which all the pleasure comes from listening to music.

  2. #2

    Member Sales Rating: (0)

    Join Date
    Jan 2009
    Location
    Brownsburg, Indiana
    Posts
    9,656

    Default

    Quote Originally Posted by Erik Tracy View Post
    Is there an Excel Doctor in the house??

    I need a formula in Excel that can calculate the remaining balance on a savings account.
    Only formula you need is this: Savings Account + Club Polk = No Savings Account....


    Sorry, I couldnt help it .

    Hopefully someone will be around to really help you in a bit...
    Advice is free, the Flea Market is earned - F1Nut

    Lessons cost money, good ones cost LOTS - Tony Beets

    HT: APC H15 | Pio 51FD | Uverse | Xbox 360 | Squeezebox Classic | Integra DTR 5.9 | Carver AV-705x & M1.0t MKII Opt002 | LSi 15 | LSiC | LSi F/x | Kimber Hero IC & 8VS SC

    Office: Win 7 -> DacMagic w/ Pangea PSU | Sunfire TGP-II | Parasound HCA-750ii | Polk RTA 11TL | Cables TBA

    Bedroom: Uverse | Roku 2 | Samsung LCD | SurroundBar 2000

    Sales Rating
    Gear

  3. #3

    Member Sales Rating: (4)

    Join Date
    Jul 2001
    Location
    Omaha, NE
    Posts
    344

    Default

    Use the FV function. For example,

    =FV(2%/12, 24, 500, -10000)

    That is 2% annual rate (divided by 12 months because of your monthly withdraws), 24 withdraws at $500 each, and the initial balance of $10,000.

    (the above example also assumes that the monthly withdraws are at the end of the month)

  4. #4

    Member Sales Rating: (16)

    Join Date
    Nov 2007
    Posts
    4,012

    Default

    Thanks - I'll give that a try!

    H9: If you don't trust what you are hearing, then maybe you need to be less invested in a hobby which all the pleasure comes from listening to music.

  5. #5

    Member Sales Rating: (16)

    Join Date
    Nov 2007
    Posts
    4,012

    Default

    Works great!

    Thanks!

    H9: If you don't trust what you are hearing, then maybe you need to be less invested in a hobby which all the pleasure comes from listening to music.

Thread Information

Users Browsing this Thread

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

     

Similar Threads

  1. BIC Formula F12 sub - opinions?
    By HTguru1982 in forum Speakers
    Replies: 10
    Last Post: 08-15-2011, 10:14 AM
  2. Formula 1 2010
    By quadzilla in forum Video Games
    Replies: 4
    Last Post: 01-04-2011, 10:53 PM
  3. excel gurus question
    By jflail2 in forum The Clubhouse
    Replies: 10
    Last Post: 02-03-2010, 11:28 AM
  4. CD Cleaning Solution Formula?
    By kevhed72 in forum 2 Channel Audio
    Replies: 1
    Last Post: 07-28-2009, 11:41 AM
  5. Formula Drift. I want one in my backyard!!!
    By treitz3 in forum The Clubhouse
    Replies: 4
    Last Post: 02-13-2008, 10:52 PM

Posting Permissions

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