Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
 Compound Interest Formula!  : (
Old 09-08-2004, 03:21 PM   #1
Recycles dryer sheets
 
Join Date: Jul 2004
Posts: 170
 Compound Interest Formula!  : (

Anyone have this so I can input into my spreadsheet?

TD
__________________

__________________
Tommy_Dolitte is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Re: **Compound Interest Formula! *: (
Old 09-08-2004, 04:03 PM   #2
Full time employment: Posting here.
 
Join Date: Aug 2004
Posts: 909
Send a message via ICQ to Marshac Send a message via AIM to Marshac Send a message via Yahoo to Marshac
Re: **Compound Interest Formula! *: (

use the future value (FV) function.

The formula itself is P(1 + rate)^years
__________________

__________________
Marshac is offline   Reply With Quote
Re: **Compound Interest Formula! *: (
Old 09-08-2004, 04:12 PM   #3
 
Posts: n/a
Re: **Compound Interest Formula! *: (

Quote:
use the future value (FV) function.

The formula itself is P(1 + rate)^years
OK, I used to be OK with math as I am a Software Engineer, but I'm Getting to be an old fart now.

What is "^"
__________________
  Reply With Quote
Re: **Compound Interest Formula! *: (
Old 09-08-2004, 04:15 PM   #4
Full time employment: Posting here.
 
Join Date: Aug 2004
Posts: 909
Send a message via ICQ to Marshac Send a message via AIM to Marshac Send a message via Yahoo to Marshac
Re: **Compound Interest Formula! *: (

it's a carrot... yum!

It's just a way of denoting an exponent without the use of supercase.
__________________
Marshac is offline   Reply With Quote
Re:  *Compound Interest Formula! *: (
Old 09-08-2004, 04:57 PM   #5
Recycles dryer sheets
 
Join Date: Jul 2004
Posts: 170
Re:  *Compound Interest Formula! *: (

Thanks. I used a link I have to a site that provides the results for a weekly contribution @ "x" %---did so for varying inputs, $100, $500, $750, $1000...then I added the exponential trend curve. I'm getting results:

Value = K*e^(0.4967)x

Where K is:

3,297 for $100 weekly contribution
16,487 for $500
24,731 for $750
32,974 for $1,000


Any math whizzes out there?

TD
8)
__________________
Tommy_Dolitte is offline   Reply With Quote
Re:  *Compound Interest Formula! *: (
Old 09-13-2004, 02:18 PM   #6
Recycles dryer sheets
 
Join Date: Aug 2003
Posts: 474
Re:  *Compound Interest Formula! *: (

I don't understand what you are trying to do. If you are using a constant time frame then the value changes proportionally to the amount that you put in each month. Note that your answer for $1k is exactly twice your answer for $500.

In Excel the function FV() does all this for you, and will work for any interest rate and number of periods. If you know the future value and want to find the payment amound then PMT() is the one you want.

If you are looking for the formula, it's called the annuity formula and you can find it on google.

__________________

__________________
bongo2 is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
ISM Feb interest payment FIRE'd@51 FIRE and Money 17 02-16-2007 06:16 PM
long interest rate Bart523 FIRECalc support 0 08-25-2006 05:07 PM
Do I-Bonds pay compounded interest? zakenjanei FIRE and Money 4 03-23-2005 06:04 PM
Nice baby formula deals cute fuzzy bunny Other topics 0 03-20-2005 10:30 AM
HELOC Interest Deductibility Question grumpy Other topics 2 10-25-2004 06:13 PM

 

 
All times are GMT -6. The time now is 12:26 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.