calculation pension fund investment yield (excel)?
A pension fund is making an investment of $ 100,000 today and expects to receive $ 1500 at the end of each month for the next five years. At the end of the fifth year, the capital investment of 100000 will be returned? What is the investment yield? I used excel and got 18%,but when using a investment yield calculator I get 13.% Can someone help?
Investment best answer:
Answer by Christopher C
Firts of all, $ 1500 times sixty months (5 * 12) will get you an extra $ 90,000. At the end of the fifth year only $ 90,000 will be returned, NOT the full 100,000!
You're getting a 1.5% interest increase each month, or a 18% annual increase.
Investment
EG Regional Awards East Midlands property company winner: Cedar House Investments
Image by EG Focus
Orignal From: calculation pension fund investment yield (excel)? and EG Regional Awards East Midlands property company winner: Cedar House Investments
No comments:
Post a Comment