Transcribed Image Text
(Calculate with Excel only) Consider Bob, who justturned 18 years old and is about to embark on a four-year degreeprogram. The tuition for the course is $20,000 per year. Bobcurrently works at Vons making $18,000 per year and will have tosurrender his job to pursue the degree. Based on the BLSOccupational Handbook Bob anticipates his earnings will be $25,000more each year following graduation (starting when he turns 22)until he retires on his 60th birthday. He anticipateshis incremental earnings will increase by 4% each year of hiscareer. For your calculations, you can assume all payments andincome are incurred-received at the end of each year and that hecan borrow/save at an interest rate of 6%.Calculate the net present value of thisinvestment.Calculate the internal rate of return from theinvestment ineducation (round answer to a whole percent).Based on the NPV and IRR, should he undertake theprogram? Why?