|
Very Interesting...Math Whizzes Only..
09-11-2004, 10: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
|
|
|
|
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..
09-14-2004, 08: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
|
|
|
Re: Very Interesting...Math Whizzes Only..
09-16-2004, 06:54 AM
|
#3
|
|
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
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|