Velocity Reviews > Formula for compound interest or capital drawdown

Formula for compound interest or capital drawdown

SS
Guest
Posts: n/a

 02-04-2006
Is there a formula available for calculating compound interest where you can
put in the interest rate, capital sum, number of years and come out at the
end with a total sum. Also would be useful to specify whether interest is

ALSO a formula to calculate remaining sum when a capital sum is invested at
an interest rate and a regular amount is taken out every month (i.e. how
long would £20,000 last if invested at 4% but £500 is taken out every
month)?

Ta

richard1969@usa.com
Guest
Posts: n/a

 02-04-2006
Amortization.
That's more or less the technical name.
Surf the web and you'll find all kinds of software for doing what you
want.
Have fun.

old jon
Guest
Posts: n/a

 02-04-2006

"SS" <(E-Mail Removed)> wrote in message
news:362Ff.7349\$(E-Mail Removed)...
> Is there a formula available for calculating compound interest where you
> can
> put in the interest rate, capital sum, number of years and come out at the
> end with a total sum. Also would be useful to specify whether interest is
>
> ALSO a formula to calculate remaining sum when a capital sum is invested
> at
> an interest rate and a regular amount is taken out every month (i.e. how
> long would £20,000 last if invested at 4% but £500 is taken out every
> month)?
>
> Ta
>
>

http://www.webmath.com/compinterest.html

http://www.finance.cch.com/text/c10s10d030.asp

http://www.moneychimp.com/articles/f...s/fmfutval.htm

www.mortgage-investments.com/
Mortgage_and_real_estate_Calculators/compound_interest_calculator.htm

here`s some to get you started <g>.

--
bw..OJ

GHalleck
Guest
Posts: n/a

 02-04-2006

SS wrote:

> Is there a formula available for calculating compound interest where you can
> put in the interest rate, capital sum, number of years and come out at the
> end with a total sum. Also would be useful to specify whether interest is
>
> ALSO a formula to calculate remaining sum when a capital sum is invested at
> an interest rate and a regular amount is taken out every month (i.e. how
> long would £20,000 last if invested at 4% but £500 is taken out every
> month)?
>
> Ta
>
>

The formula is in Microsoft Excel...if you want to use it.
Just plug in the values.

FML
Guest
Posts: n/a

 02-04-2006
SS wrote:
> Is there a formula available for calculating compound interest where you can
> put in the interest rate, capital sum, number of years and come out at the
> end with a total sum. Also would be useful to specify whether interest is
>
> ALSO a formula to calculate remaining sum when a capital sum is invested at
> an interest rate and a regular amount is taken out every month (i.e. how
> long would £20,000 last if invested at 4% but £500 is taken out every
> month)?
>
> Ta
>
>

http://www.tcalc.com/calculators.htm

or if you must have the formulas themselves:

http://www.kbapps.com/finance.html

Plato
Guest
Posts: n/a

 02-04-2006
SS wrote:
>
> Is there a formula available for calculating compound interest where you can
> put in the interest rate, capital sum, number of years and come out at the
> end with a total sum. Also would be useful to specify whether interest is

Perhaps ten thousand free such type calculators on the Internet. Just
check any mortgage site.

--
http://www.kissmyip.com/

SS
Guest
Posts: n/a

 02-11-2006
Wanted the formula for a spreadsheet so online calculators no good

"Plato" <|@|.|> wrote in message
news:43e52ac5\$0\$4816\$(E-Mail Removed)...
> SS wrote:
> >
> > Is there a formula available for calculating compound interest where you

can
> > put in the interest rate, capital sum, number of years and come out at

the
> > end with a total sum. Also would be useful to specify whether interest

is
> > added yearly or monthly.

>
> Perhaps ten thousand free such type calculators on the Internet. Just
> check any mortgage site.
>
>
> --
> http://www.kissmyip.com/
>
>

Yddap
Guest
Posts: n/a

 02-11-2006
In news:bmiHf.23427\$(E-Mail Removed),
SS <(E-Mail Removed)> opined very noisily:
> Wanted the formula for a spreadsheet so online calculators no good
>
> "Plato" <|@|.|> wrote in message
> news:43e52ac5\$0\$4816\$(E-Mail Removed)...
>> SS wrote:
>>>
>>> Is there a formula available for calculating compound interest
>>> where you can put in the interest rate, capital sum, number of
>>> years and come out at the end with a total sum. Also would be
>>> useful to specify whether interest is added yearly or monthly.

>>
>> Perhaps ten thousand free such type calculators on the Internet. Just
>> check any mortgage site.
>>
>>
>> --
>> http://www.kissmyip.com/

see http://www.math2.org/math/general/interest.htm
all will be revealed

--

Yddap

=?UTF-8?B?UGFsaW5kcuKYu21l?=
Guest
Posts: n/a

 02-11-2006
Yddap wrote:
> In news:bmiHf.23427\$(E-Mail Removed),
> SS <(E-Mail Removed)> opined very noisily:
>
>>Wanted the formula for a spreadsheet so online calculators no good
>>
>>"Plato" <|@|.|> wrote in message
>>news:43e52ac5\$0\$4816\$(E-Mail Removed)...
>>
>>>SS wrote:
>>>
>>>>Is there a formula available for calculating compound interest
>>>>where you can put in the interest rate, capital sum, number of
>>>>years and come out at the end with a total sum. Also would be
>>>>useful to specify whether interest is added yearly or monthly.
>>>
>>>Perhaps ten thousand free such type calculators on the Internet. Just
>>>check any mortgage site.
>>>
>>>
>>>--
>>>http://www.kissmyip.com/

>
>
> see http://www.math2.org/math/general/interest.htm
> all will be revealed
>

Many thanks - I haven't seen that loan balance equation before.

--
Sue

SS
Guest
Posts: n/a

 02-11-2006
Cracking - thanks!

"Yddap" <(E-Mail Removed)> wrote in message
news:JxiHf.18394\$(E-Mail Removed). uk...
> In news:bmiHf.23427\$(E-Mail Removed),
> SS <(E-Mail Removed)> opined very noisily:
> > Wanted the formula for a spreadsheet so online calculators no good
> >
> > "Plato" <|@|.|> wrote in message
> > news:43e52ac5\$0\$4816\$(E-Mail Removed)...
> >> SS wrote:
> >>>
> >>> Is there a formula available for calculating compound interest
> >>> where you can put in the interest rate, capital sum, number of
> >>> years and come out at the end with a total sum. Also would be
> >>> useful to specify whether interest is added yearly or monthly.
> >>
> >> Perhaps ten thousand free such type calculators on the Internet. Just
> >> check any mortgage site.
> >>
> >>
> >> --
> >> http://www.kissmyip.com/

>
> see http://www.math2.org/math/general/interest.htm
> all will be revealed
>
> --
>
> Yddap
>
>