#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 77
Default compound

hello community

can anybody teach me how to find how much will i have at the end of 5 years???

example:

I want to save $5000 at 4% per annum for 5 years. How to derive a formula
to find out how much will i have at the end of the 5th years.

thanks community for the assistance given
--
oldLearner57
  #2   Report Post  
Posted to microsoft.public.excel.misc
RWN RWN is offline
external usenet poster
 
Posts: 104
Default compound

5,000 * 1.04^5

--
Regards;
Rob
------------------------------------------------------------------------
"tikchye_oldLearner57" wrote in message
...
hello community

can anybody teach me how to find how much will i have at the end of 5 years???

example:

I want to save $5000 at 4% per annum for 5 years. How to derive a formula
to find out how much will i have at the end of the 5th years.

thanks community for the assistance given
--
oldLearner57



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 418
Default compound


RWN wrote:
"tikchye_oldLearner57" wrote:
can anybody teach me how to find how much will i have at the end of 5 years???
example:
I want to save $5000 at 4% per annum for 5 years. How to derive a formula
to find out how much will i have at the end of the 5th years.


5,000 * 1.04^5


Equivalently:

=fv(4%, 5, 0, -5000)

However, that assumes only annual compounding. That would be
appropriate if 4% is the APY. But if it is the nominal rate and if the
OP is talking about a savings account in the US, we might expect daily
compounding at the rate of 4%/365. In that case:

=fv(4%/365, 5*365, 0, -5000)

A difference of nearly $24 ;-).

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 77
Default compound

thanks RWN for the solution, that was cool :)
--
oldLearner57


"RWN" wrote:

5,000 * 1.04^5

--
Regards;
Rob
------------------------------------------------------------------------
"tikchye_oldLearner57" wrote in message
...
hello community

can anybody teach me how to find how much will i have at the end of 5 years???

example:

I want to save $5000 at 4% per annum for 5 years. How to derive a formula
to find out how much will i have at the end of the 5th years.

thanks community for the assistance given
--
oldLearner57




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 77
Default compound

thanks joeu2004 :)
--
oldLearner57


" wrote:


RWN wrote:
"tikchye_oldLearner57" wrote:
can anybody teach me how to find how much will i have at the end of 5 years???
example:
I want to save $5000 at 4% per annum for 5 years. How to derive a formula
to find out how much will i have at the end of the 5th years.


5,000 * 1.04^5


Equivalently:

=fv(4%, 5, 0, -5000)

However, that assumes only annual compounding. That would be
appropriate if 4% is the APY. But if it is the nominal rate and if the
OP is talking about a savings account in the US, we might expect daily
compounding at the rate of 4%/365. In that case:

=fv(4%/365, 5*365, 0, -5000)

A difference of nearly $24 ;-).


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Implied Compound Interest? dazman Excel Worksheet Functions 4 January 6th 06 06:01 PM
Compound interest Robert Tracey Excel Worksheet Functions 1 November 30th 05 12:27 AM
Compound Rate of Return Steve C Excel Worksheet Functions 2 June 20th 05 09:04 PM
Why can I not open an Excel Compound file with Office Excel xp? Wetcoast40 Excel Discussion (Misc queries) 1 February 4th 05 10:42 PM
Are financial functions calculated based on compound interest? KDR Excel Worksheet Functions 1 January 3rd 05 02:58 AM


All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"