Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 10000 | 0.75% | ||||
2 | day1 | $0.21 | $10,000.21 | |||
3 | day2 | $0.21 | $10,000.41 | |||
4 | day3 | $0.21 | $10,000.62 | |||
5 | day4 | $0.21 | $10,000.82 | |||
Sheet1 |
Check these links:
http://support.microsoft.com/kb/213907
http://www.mrexcel.com/archive2/34400/39458.htm
Hope it helps !
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 10000 | 0.75% | ||||
2 | day1 | $75.00 | $10,075.00 | |||
3 | day2 | $75.56 | $10,150.56 | |||
4 | day3 | $76.13 | $10,226.69 | |||
5 | day4 | $76.70 | $10,303.39 | |||
6 | day5 | $77.28 | $10,380.67 | |||
7 | day6 | $77.86 | $10,458.52 | |||
8 | day7 | $78.44 | $10,536.96 | |||
Sheet1 |
Hi
=StartingBalance * (1 + Rate)^NumberOfDays
ie:
=10000*(1+0.0075)^182