Question: Screw-‘Em-Good Corp. has just announced a revolutionary security: If you pay SEG $1,000 now, you will get back $150 at the end of each of the next 15 years. What is the IRR of this investment?
Suggestion: Do this problem two ways-once using Excel's IRR function and once using Excel's RATE function (illustrated below).