Calculate the internal rate of return of his migration

(Calculate with Excel only) Consider Carl, a 26-year-old San Diegan who has just graduated from SDSU with a B.A. in Economics. He has received two job offers, one in San Diego that pays him $40,000/year and another in Miami, Florida that will pay him $44,000/year. He is planning on working in the position, regardless of the location, until he finishes his 20th year of work. His added monetary costs in Miami will be $2,500 each year and he expects psychic costs totaling $5,000 each year for the first 5 years only. He can borrow/save at a rate of 6%. Using the information provided and assuming all costs and benefits are incurred/accrued at the end of each year determine the following:

a. Calculate the net present value of his migration.

 

b. Calculate the internal rate of return of his migration (round answer to a whole percent).

c. Based on the NPV and IRR, should he migrate? Why?