calculation help

pinkmali · 08-01-2006, 02:28 PM

I've searched high and low for a calculator to give me the an idea of how much I need to save for early retirement. I'm kind of working backwards from the typical calculators. Specifically I would like to know how much to save monthly/ yearly for 1 million in 13 years w/ 8% return, starting out with $150k. Does anyone know where to find a calculator or how to setup an excel sheet to play around with? What would this calculation be called - present value of ....? I can try it myself w/ excel if I knew what it is called.
Thanks
Robin

astromeria · 08-01-2006, 02:37 PM

I think this does what you need:

http://www.ipers.org/sub/calcs/Savings.html

pinkmali · 08-01-2006, 02:44 PM

perfect. thank you

retire@40 · 08-01-2006, 04:27 PM

Quote:

Originally Posted by astromeria

I think this does what you need:

http://www.ipers.org/sub/calcs/Savings.html

Just curious, your avatar looks familiar.* Is it a picture of the inside dome of the Pantheon in Rome?* I loved visiting that building a few years ago.* I still remember the amazing accoustics from the choir that was singing in there.

astromeria · 08-01-2006, 10:47 PM

Quote:

Originally Posted by retire@40

Just curious, your avatar looks familiar. Is it a picture of the inside dome of the Pantheon in Rome? I loved visiting that building a few years ago. I still remember the amazing accoustics from the choir that was singing in there.

as a certain rodent might say, ding! ding! ding! we have a winner! I've been hoping someone would recognize it or ask

Yep, it's the sunlight pouring down the hole in the Pantheon roof. It was astonishing despite the crowd present at the time.

bongo2 · 08-02-2006, 01:58 PM

The family of functions in excel that does what you want is pv, pmt, fv, ipmt, nper.

haha · 08-02-2006, 03:37 PM

Quote:

Originally Posted by astromeria

as a certain rodent might say,

Lagomorph.*

http://en.wikipedia.org/wiki/Lagomorpha

My name is Ha, and I'll be your pedant...

astromeria · 08-02-2006, 04:35 PM

beg pardon, guvnah.

from answers.com:

The noun Lagomorpha has one meaning:

Meaning #1: rabbits; hares; pikas; formerly considered the suborder Duplicidentata of the order Rodentia
Synonym: order Lagomorpha

08-01-2006, 02:37 PM	#2
astromeria Moderator Emeritus Join Date: Aug 2005 Posts: 1,375	Re: calculation help I think this does what you need: http://www.ipers.org/sub/calcs/Savings.html __________________ You can't always get what you want, but if you try sometimes, you might find you get what you need.

08-01-2006, 02:44 PM	#3
pinkmali Dryer sheet wannabe Join Date: Jan 2006 Posts: 16	Re: calculation help perfect. thank you

08-02-2006, 01:58 PM	#6
bongo2 Recycles dryer sheets Join Date: Aug 2003 Posts: 448	Re: calculation help The family of functions in excel that does what you want is pv, pmt, fv, ipmt, nper.

08-02-2006, 04:35 PM	#8
astromeria Moderator Emeritus Join Date: Aug 2005 Posts: 1,375	Re: calculation help beg pardon, guvnah. from answers.com: The noun Lagomorpha has one meaning: Meaning #1: rabbits; hares; pikas; formerly considered the suborder Duplicidentata of the order Rodentia Synonym: order Lagomorpha __________________ You can't always get what you want, but if you try sometimes, you might find you get what you need.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

08-01-2006, 02:28 PM	#1
pinkmali Dryer sheet wannabe Join Date: Jan 2006 Posts: 16	calculation help I've searched high and low for a calculator to give me the an idea of how much I need to save for early retirement. I'm kind of working backwards from the typical calculators. Specifically I would like to know how much to save monthly/ yearly for 1 million in 13 years w/ 8% return, starting out with $150k. Does anyone know where to find a calculator or how to setup an excel sheet to play around with? What would this calculation be called - present value of ....? I can try it myself w/ excel if I knew what it is called. Thanks Robin

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Firecalc Social Security Calculation	Bikerdude	FIRECalc support	2	12-10-2006 01:05 PM
What to include in SWR calculation	streamjp	FIRE and Money	1	03-31-2006 09:25 AM
Change in CPI Calculation	Michael	Other topics	37	07-12-2005 01:40 AM
SS Calculation	jodz	FIRE and Money	14	08-31-2004 09:07 PM