Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

compute interest at 1.05% compounded daily on $77,000 for 5 years

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
larionova - 19 Jul 2006 01:48 GMT
i have invested $77,000 at an interest rate of 1.05% compounded daily. i want
to create a formula showing the yield at the end of 5 years (by day).
John - 19 Jul 2006 04:06 GMT
> i have invested $77,000 at an interest rate of 1.05% compounded daily. i want
> to create a formula showing the yield at the end of 5 years (by day).

Do you mean you want to show every day's value for 1825 days? Or do you
want something that will show the value for any given day? Or do you
just want the value at the end of 5 years?

There is a simple formula that will give the value at any particular
time of compounded interest.

 FV = P(1 + r)n

Future Value = principal times interest rate raised to the power of the
duration.

Your interest rate would be .05/365 + 1

So your formula is 77000*(1.000136986)n
the n is the number of days and is an exponent.

to find your balance at, say, day 123 just plug 123 into n.

John
larionova - 19 Jul 2006 22:05 GMT
Thank you John. I input the formula in cell A1, and all I got for an answer
is the formula. Please, what am I edoing wrong?

> > i have invested $77,000 at an interest rate of 1.05% compounded daily. i want
> > to create a formula showing the yield at the end of 5 years (by day).
[quoted text clipped - 19 lines]
>
> John
MDubbelboer - 19 Jul 2006 23:10 GMT
make sure the cell that you've put the formula in is formatted a
general
then recalculate your cell (press f2 to edit, then press enter
John - 22 Jul 2006 05:17 GMT
What formula did you put in the cell?

Try this.

In a2 put =power(1.000136986,a1)*77000

Put the mumber of days in a1 and the principal will appear in a2... did
for me anyway.

John

> Thank you John. I input the formula in cell A1, and all I got for an answer
> is the formula. Please, what am I edoing wrong?
[quoted text clipped - 22 lines]
>>
>>John

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.