Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Very Interesting...Math Whizzes Only..
Old 09-11-2004, 11:01 AM   #1
Recycles dryer sheets
 
Join Date: Jul 2004
Posts: 170
Very Interesting...Math Whizzes Only..

How do you take the result from an MS Excel calculation and have it automatically populate itself into the appropriate cell in a worksheet embedded on a webpage, and THEN send the results back into your worksheet?

I've completed my monthly budget and want to see how my savings rate (when plugged into http://www.4degreez.com/misc/million.mv), will impact how long it will take me to get to $1MM.

I don't know to use the compound interest or FV formulas, so if that's easier, please advise.

Regards,
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: Very Interesting...Math Whizzes Only..
Old 09-14-2004, 09:59 AM   #2
Full time employment: Posting here.
 
Join Date: Oct 2003
Posts: 961
Re: Very Interesting...Math Whizzes Only..

TD,

FV is excel is pretty easy to use this way:

RATE is the interest rate per period (like per year) your investments will earn

NPER is the number of periods (like per year) the interest will compound.

PMT is the payment you'll make per period. For accumulating, enter a negative number.

PV is the amount of money you have now. Enter a negative number.

TYPE is when you'll be making the contribution. Enter "1" for contributions at the beginning of each period, or enter "0" [zero] for contributions at the end of each period.

For example, say my assumed rate of return is 5% per year, for 30 years, I'll be contributing $2000/year (enter "-2000"), I've got no money saved already, and I'll be contributing at the end of each year. The FV is

=FV(5%,30,-2000,0,0)

or $132,877.70.

If you want to contribute monthly, just change everything to be denominated in months. So, I'll be contributing $166.666667 per month, for 360 months, at a rate of return of 0.4074% per month, and again at the end of each month, with no starting money.

To get the monthly return, just take:

(1+ annual rate of return) = (1 + monthly rate of return)^(12)

and solve for "monthly rate of return" to get:

(1+ annual rate of return)^(1/12)-1 = monthly rate of return

It's also really, really easy to place the inputs in separate cells, and then just reference the cells in the FV function, which is placed in another cell. Makes it a whole lot easier when you change inputs to see the affect on the FV.

- Alec
__________________

__________________
ats5g is offline   Reply With Quote
Re: Very Interesting...Math Whizzes Only..
Old 09-16-2004, 07:54 AM   #3
 
Posts: n/a
Re: Very Interesting...Math Whizzes Only..

ats5G said:
[blue]For example, say my assumed rate of return is 5% per year, for 30 years, I'll be contributing $2000/year (enter "-2000"), I've got no money saved already, and I'll be contributing at the end of each year. The FV is

=FV(5%,30,-2000,0,0)

or $132,877.70.[/blue]

Likewise, another example may be helpful.
For example 2, say my assumed rate of return is 6% per year, for 35 years, I'll be contributing $3,000/year (enter "-3000"), I've got $10,000 saved already, and I'll be contributing at the end of each year. The FV is

=FV(6%,35,-3000,-10000,0)

or $411,165.21
__________________
  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
The Toilet and The Seat - Let's Do The Math Danny Other topics 26 06-06-2008 04:34 PM
Working for a Mega Corp sounds interesting, am I nuts? saluki9 Young Dreamers 45 07-03-2006 11:59 AM
Interesting new "loan" site Olav23 FIRE and Money 14 02-07-2006 08:03 PM
Interesting Job Market-Interesting Blog greg Other topics 1 12-18-2005 01:42 PM
Weapons of Math Instruction BigMoneyJim Other topics 2 03-25-2004 07:03 AM

 

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