|
|
how to calculate compound interest ?
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>
1% interest rate <br>
22 number of days <br>
$??,??? Future value <br><br>can you help me? Please . .
|
|
0
|
|
|
|
Reply
|
 bebrents
|
2/3/2010 9:21:54 PM |
|
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
|
|
|
|
Reply
|
CyberTaz
|
2/3/2010 10:07:33 PM
|
|
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">
<HTML><HEAD>
<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>
</HEAD>
<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> </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><<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> &nb=
sp; 1%=20
interest rate=20
=
<BR> &nb=
sp; 22=20
number of days=20
<BR> $??,??? =
Future value=20
<BR><BR>can you help me? Please . .</BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_002E_01CAA525.C891C5D0--
|
|
|
0
|
|
|
|
Reply
|
Niek
|
2/3/2010 10:08:23 PM
|
|
|
2 Replies
692 Views
(page loaded in 0.029 seconds)
Similiar Articles: how to calculate compound interest ? - microsoft.public.mac.office ...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 c... Formula to calculate compound interest on increasing principal ...Hi folks, Would appreciate some help in locating a formula to calculate compound interest on an increasing principal. Many thanks ... how to calculate interest on payments - microsoft.public.excel ...Formula to calculate compound interest on increasing principal ... how to calculate interest on payments - microsoft.public.excel ... Formula to calculate compound ... Compound Interest Rate or Growth Rate - microsoft.public.excel ...Is there a function in Excell that can be used to calculate an investment"s compound growth rate? If so what is it and how do you use it? For in... Need formula to calculate bi-monthly pay dates - microsoft.public ...Need formula to calculate bi-monthly pay dates - microsoft.public ... how to calculate compound interest ? - microsoft.public.mac.office ... Need formula to calculate bi ... Calculate How Long Funds Will Last - microsoft.public.excel ...how to calculate compound interest ? - microsoft.public.mac.office ... Calculate How Long Funds Will Last - microsoft.public.excel ... Is there a function that will return ... Calculate a daily rate - microsoft.public.access.queries ...Compound Interest Rate or Growth Rate - microsoft.public.excel ... Calculate Daily Interest, Paid out Weekly - microsoft.public.excel ... Not sure if the subject makes ... Formula to calculate interest only on a short term loan ...How to Calculate Interest on a Short Term Loan | eHow.com How to Calculate Interest on a Short Term Loan. When taking ... Calculate compound interest using this formula: P ... annuity calculation for monthly payments but quarterly compoundin ...Formula to calculate compound interest on increasing principal ... annuity calculation for monthly payments but quarterly compoundin ... The exact formula for deposits and ... how to Calculate opening balance? - microsoft.public.access ...Calculate a daily rate - microsoft.public.access.queries ... Daily Periodic Rate Calculator - CreditCard.BizCalcs.com Calculate the daily interest rate and amount on your ... How to Calculate Compound Interest | eHow.comThere are two kinds of interest computed on monetary amounts: simple and compound. The difference between the two is with simple interest, you only earn interest on ... Compound Interest - Math tutorials, resources, help, resources and ...Compound Interest formula ... Today, calculators will do the computational work for you, however, here's a breakdown of how to calculate compound interest: Compound Interest CalculatorThis calculator also has links explaining the compound interest formulas with interactive graphs. How to Calculate Compound Interest - Investors Calculate Compound ...Compound interest is interest on principal plus interest on the accumulated interest. Real estate investing requires a knowledge of how to calculate compound interest. How to Calculate Compounding Interest | eHow.comYou may have made a major purchase or investment and either paid or received compound interest. Most people, however, don't know how the bank figures how much to ... 7/30/2012 4:51:34 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
14 followers. 