Compute the value of investment.

a ) I have an investment of $1000 (Ex.) which accumulates 20% per year but on a DAILY basis. That means that every day the capital is growing by an additional $2.7777 (1000 / 360 = 2.7777). What I need is to have Excel 2007 calculating every time i open the spreadsheet how much did my investment grow. On the third day it will tell me $8.3331 and the next day will automatically update to $11.1108.

b )This is the data I have:

1. Date of purchase of the capital ($1000).
2. Date that the capital starts to accumulate interest.
3. Value of the investment.
4. Rate of interest.
5. This is what i need: Interest growth as today.