Calculate the investment price


[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.

Request for Solution File

Ask an Expert for Answer!!
Finance Basics: Calculate the investment price
Reference No:- TGS020800

Expected delivery within 24 Hours