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

1.(Calculate with Excel only) Consider Bob, who just turned 18 years old and is about to embark on a four-year degree program. The tuition for the course is $20,000 per year. Bob currently works at Vons making $18,000 per year and will have to surrender his job to pursue the degree. Based on the BLS Occupational Handbook Bob anticipates his earnings will be $25,000 more each year following graduation (starting when he turns 22) until he retires on his 60th birthday. He anticipates his incremental earnings will increase by 4% each year of his career. For your calculations, you can assume all payments and income are incurred-received at the end of each year and that he can borrow/save at an interest rate of 6%.

a.Calculate the net present value of this investment.

b.Calculate the internal rate of return from the investment in education (round answer to a whole percent).

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

*please explain excel inputs to solve if possible*

Expert Solution

b]

IRR is determined utilizing the IRR work in Excel, with info being the variety of cells containing the money streams from year 1 to year 42

IRR = 17%

c]

in light of NPV and IRR, he ought to embrace the program as NPV is certain, and IRR is higher than the obtaining/sparing expense of 6%

Rahul Sunny answered 1 year ago

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

(Calculate with Excel only) Consider Bob, who just turned 18 years old and is about to embark on a four-year degree program. The tuition for the course is $20,000 per year. Bob currently works at Vons making $18,000 per year and will have to surrender his job to pursue the degree. Based on the BLS Occupational Handbook Bob anticipates his earnings will be $25,000 more each year following graduation (starting when he turns 22) until he retires on his 60th...

(Calculate with Excel only) Consider Carl, a 26-year-old San Diegan who has just graduated from SDSU...

(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...

Sandra and Michael Wilson are the parents of Rory who just turned 5 years old (coincidentally...

Sandra and Michael Wilson are the parents of Rory who just turned 5 years old (coincidentally on the same date that primary, secondary and university academic years commence). They own a four-bedroom home in Edinburgh. Sandra is a partner in a local dental practice and Michael is a stay at home dad. Sandra earns £100,000 a year (after tax). Now that Rory is starting primary school, thoughts have turned to saving for his education. Rory is enrolled to attend a...

1.Mr. Homer, who turned 36 years old today, is getting serious about retirement planning. He has...

1.Mr. Homer, who turned 36 years old today, is getting serious about retirement planning. He has $85,000 already set aside in his retirement account and plans to add an equal amount in real terms at the end of each of the next 33 years so that he can retire at age 69. His goal is to build a retirement account that will enable him to make 25 annual withdraws with a purchasing power of $75,000 (at today’s prices) on his...

Sasha just turned 55 years old today and plans on retiring in 20 years on her...

Sasha just turned 55 years old today and plans on retiring in 20 years on her 75th birthday. She would like to withdraw money from her retirement account on her birthday each year until she dies. She would like to withdraw $80,000 on her 75th birthday, and increase her withdrawals 6% each year through her 89th birthday. She expects to die on her 90th birthday, at which time she would like to leave $300,000 to her granddaughter. Sasha currently has...

Suppose that you just turned 25 years old and that you wish toreceive an annual...

Suppose that you just turned 25 years old and that you wish to receive an annual annuity of $76,697 for 30 years (end of each year age 65-95). How much would you have to contribute annually at the end of each year ages 25-60 , if you then let the funds vest until age 65 with no further contributions? Your EAR is 5.2%.

Suppose that you just turned 25 years old and decide to put $5,109 into investments at...

Suppose that you just turned 25 years old and decide to put $5,109 into investments at the end of each year until age 60 (35 years from now). You have no savings. Your EAR is 6.2%. How much will you have by age 60?

Suppose that you just turned 25 years old and decide to put $5,750 into investments at...

Suppose that you just turned 25 years old and decide to put $5,750 into investments at the end of each year until age 60 (35 years from now). You have no savings. Your EAR is 4.7%. How much will you have by age 60?

Suppose that you just turned 25 years old and that you wish to receive a monthly...

Suppose that you just turned 25 years old and that you wish to receive a monthly ordinary annuity of $9,302 for 30 years (ages 65-95, end of month payments). How much would your monthly contributions also be at the end of each month until age 60, if you let the funds vest until age 65 with no further contributions? Your EAR is 6.0%?

Suppose that you just turned 25 years old and that you wish to receive an annual...

Suppose that you just turned 25 years old and that you wish to receive an annual annuity of $63,282 for 30 years (end of each year age 65-95). How much would you have to contribute annually at the end of each year ages 25-60 , if you then let the funds vest until age 65 with no further contributions? Your EAR is 8.7%.

Question