MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### how to calculate compound interest ?

• Follow

```Version: 2004
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I would like to put in a spread sheet a compounded rate of return calculator that the user would only have to put in present value, time period, interest rate <br><br>Example: \$25,000 present value <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1% interest rate <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;22 number of days <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\$??,??? Future value <br><br>can you help me? Please . .
```
 0

```Have you looked at the FV() & FVSCHEDULE() functions? If so you'll need to
explain why neither of them will do the job. Details on both are in Excel
Help. Nobody can offer a possible alternative if they don't know why the
conventional methods don't work.

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 2/3/10 4:21 PM, in article 59bb2322.-1@webcrossing.JaKIaxP2ac0,
"bebrents@officeformac.com" <bebrents@officeformac.com> wrote:

> Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> I would like to put in a spread sheet a compounded rate of return calculator
> that the user would only have to put in present value, time period, interest
> rate
>
> Example: \$25,000 present value
>               1% interest rate
>               22 number of days
>          \$??,??? Future value
>
> can you help me? Please . .

```
 0

```This is a multi-part message in MIME format.

------=_NextPart_000_002E_01CAA525.C891C5D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Look in HELP for the FV() function

--=20
Kind regards,

Niek Otten
Microsoft MVP - Excel

<bebrents@officeformac.com> wrote in message =
news:59bb2322.-1@webcrossing.JaKIaxP2ac0...
Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) =
Processor: Intel I would like to put in a spread sheet a compounded rate =
of return calculator that the user would only have to put in present =
value, time period, interest rate=20

Example: \$25,000 present value=20
1% interest rate=20
22 number of days=20
\$??,??? Future value=20

can you help me? Please . .
------=_NextPart_000_002E_01CAA525.C891C5D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18882">
<STYLE></STYLE>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2 face=3DArial>Look in HELP for the FV()=20
function</FONT></DIV><FONT size=3D2 face=3DArial>
<DIV><BR>-- <BR>Kind regards,</DIV>
<DIV>&nbsp;</DIV>
<DIV>Niek Otten<BR>Microsoft MVP - Excel<BR></FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; =
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV>&lt;<A=20
=
href=3D"mailto:bebrents@officeformac.com">bebrents@officeformac.com</A>&g=
t;=20
wrote in message <A=20
=
href=3D"news:59bb2322.-1@webcrossing.JaKIaxP2ac0">news:59bb2322.-1@webcro=
ssing.JaKIaxP2ac0</A>...</DIV>Version:=20
2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I =
would=20
like to put in a spread sheet a compounded rate of return calculator =
that the=20
user would only have to put in present value, time period, interest =
rate=20
<BR><BR>Example: \$25,000 present value=20
=
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;1%=20
interest rate=20
=
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;22=20
number of days=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\$??,??? =
Future value=20
<BR><BR>can you help me? Please . .</BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_002E_01CAA525.C891C5D0--

```
 0

2 Replies
692 Views

Similiar Articles:

7/30/2012 4:51:34 AM