Re: calculating interest

Article View: comp.apps.spreadsheets

Article #110

Back to comp.apps.spreadsheets Previous Next

#110

From: Rick Blaiklock
Date: Wed, 19 Aug 1992 14:17

17 lines
994 bytes

In article <2A911B88.4215@orion.oac.uci.edu> Richard Myers,
rmyers@dec5200.acs.uci.edu writes:
>Posted on behalf of a friend:
>Using excel, I want to find the rate of return on an investment where
>I deposit $1000/month for 10 years and wind up with $200,000.

Using the Rate formuala in Excel provides the answer.

=Rate(10*12,-1000,0,200000,0,.1/12)

gives an answer of about .8%

Note that the amount is -, since it is cash paid out. (Otherwise the
formula won't converge.)
...Rick

Technical Details

Message-ID: <1992Aug19.141700.7809@bcrka451.bnr.ca>

Path:

arc1-ca.pugleaf.net!sparky!uunet!kithrup!stanford.edu!ames!sun-barr!cs.utexas.edu!convex!news.utdallas.edu!corpgate!bnrgate!bcrka451!nuntius

References: <2A911B88.4215@orion.oac.uci.edu>

Show Full Headers

Complete Article Headers

Newsgroups: comp.apps.spreadsheets
Path: arc1-ca.pugleaf.net!sparky!uunet!kithrup!stanford.edu!ames!sun-barr!cs.utexas.edu!convex!news.utdallas.edu!corpgate!bnrgate!bcrka451!nuntius
From: Rick Blaiklock <rmb@bnr.ca>
Subject: Re: calculating interest
Message-ID: <1992Aug19.141700.7809@bcrka451.bnr.ca>
Sender: 5E00 Corkstown News Server
Organization: Bell-Northern Research Ltd.
X-Useragent: Nuntius v1.1
References: <2A911B88.4215@orion.oac.uci.edu>
Date: Wed, 19 Aug 1992 14:17:00 GMT
Lines: 17

Reply to Parent Message