The exercise Excel notebook gives data for three mutual funds. Compute the discrete annual returns for each

Question:

The exercise Excel notebook gives data for three mutual funds. Compute the discrete annual returns for each fund and then use an array function to compute the compound annual return over the period. Recall that discretely compounded, the return in year t is (Fund value t / Fund valuet−1) − 1. If the returns were continuously compounded, then the year- t return would be ln(Fund value t / Fund valuet− 1).

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Financial Modeling

ISBN: 9780262027281

4th Edition

Authors: Simon Benninga

Question Posted: