(Calculate with Excel only) Consider Bob, who just turned 18 years old and is about to...

80.2K

Verified Solution

Question

Finance

(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 60^th 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?

Answer & Explanation Solved by verified expert

3.9 Ratings (417 Votes)

athe cash flows of the investment are as follows YearCash See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

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?