[A] I have an investment of $1000 which accumulates 20 percent per year but on a DAILY basis. That means that every day the capital is rising by an additional $2.7777 [1000/360 = 2.7777]. What I need is to have M.S. Excel 2007 computing every time I open the spreadsheet how much did my investment grow. On the 3rd day it will tell me $8.3331 & the next day will automatically update to dollar 11.1108.
[B] This is the data I have:
(a) Date of purchase of the capital ($1000).
(b) Date that the capital starts to accumulate interest.
(c) Rate of the investment.
(d) Rate of interest.
(e) This is what I need: Interest growth as today.