Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compound Interest Only (Excel 2000)

    If I invest 50 for 10 years at 5% interest rate and receive a final amount on that investment of 77641.14, and stop contributing to that investment, how would I find the interest on that money left sitting there on a yearly basis? I am compounding the remaining 77641.44 only, with no more investing.
    Thanks
    Nannette <img src=/S/brainwash.gif border=0 alt=brainwash width=15 height=15>
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Compound Interest Only (Excel 2000)

    Nannette, you can still use FV to do the calculation, just set the payment to zero. For example, assuming yearly compounding, if A1 has the number of years, then <pre>=-FV(0.05,A1,0,77641.14)</pre>

    gives the future value. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compound Interest Only (Excel 2000)

    Sam,
    Thank you a real million...your answer did the trick. Gosh, I love this place... <img src=/S/joy.gif border=0 alt=joy width=23 height=23>

    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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