Question: 1. A fund of $10,000 is set up to pay $250 at the end of each year indefinitely. What is the fund's IRR? (There's no Excel function that answers this question-use some logic!)
2. In the spreadsheet below we calculate the future value of 5 deposits of $100, with the first deposit made at time 0. As shown in Section 1, this calculation can also be made using the Excel function =FV(interest,periods,-amount,,1).
