| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 9128 | 2001-05-08 11:18:00 | Excel Investment Formula | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 12343 | 2001-05-08 11:18:00 | Can someone help me with an excel formula or point me to a site where I can obtain one to help me plot the returns pa on investments ie the net growth of a fund (not including additional deposits) Any help will be appreciated |
Guest (0) | ||
| 12344 | 2001-05-08 13:20:00 | ...the following is a 'time bound' formula you can use in MS Excel: www.multi-matrix.de |
Guest (0) | ||
| 12345 | 2001-05-11 05:46:00 | A simple method for calculating return is: r = [(end value - start value)/start value] / t where t = time period in years e.g. invest $10 and get $11 after 1 year r = 10% You will probably need something more advanced if you wish to account for deposits made during the year (try financial functions). |
Guest (0) | ||
| 1 | |||||