1. For, HS graduate, the NPV(net present value) of earnings is as follows:
age 18-30 = 30,000[ 1/(1.02) + 1/(1.02)2 + 1/(1.02)3 + 1/(1.02)4 + 1/(1.02)5 + 1/(1.02)6+ 1/(1.02)7 + 1/(1.02)8 + 1/(1.02)9 + 1/(1.02)10+ 1/(1.02)11 + 1/(1.02)12]
age 30-40 = 45,000 [ 1/(1.02)13 + 1/(1.02)14 + 1/(1.02)15 + 1/(1.02)16 + 1/(1.02)17 + 1/(1.02)18 + 1/(1.02)19 + 1/(1.02)20 + 1/(1.02)21 + 1/(1.02)22 ]
NPV of total yearly earnings of HS graduate = 6,35,982
For college graduate, the NPV of yearly earnings is as follows:
age 18-22 = -90,000 [ 1/(1.02) + 1/(1.02)2 + 1/(1.02)3 +1/(1.02)4 ]
age 23-30 = 50,000 [ 1/(1.02)5 + 1/(1.02)6 +1/(1.02)7 + 1/(1.02)8 + 1/(1.02)9 + 1/(1.02)10 + 1/(1.02)11 + 1/(1.02)12 ]
age 31-40 = 95,000 [ 1/(1.02)13 + 1/(1.02)14 + 1/(1.02)15 + 1/(1.02)16 + 1/(1.02)17 + 1/(1.02)18 + 1/(1.02)19 + 1/(1.02)20 + 1/(1.02)21 + 1/(1.02)22 ]
NPV of total yearly earnings of College graduate = 6,68,542

Above is the age -earning profiles graph.
(b). The person will choose to go to college as his higher educational qualification leads to higher earnings.
2. If the discount rate changes to 3%, then,
For, HS graduate, the NPV(net present value) of earnings is as follows:
age 18-30 = 30,000[ 1/(1.03) + 1/(1.03)2 + 1/(1.03)3 + 1/(1.03)4 + 1/(1.03)5 + 1/(1.03)6+ 1/(1.03)7 + 1/(1.03)8 + 1/(1.03)9 + 1/(1.03)10+ 1/(1.03)11 + 1/(1.03)12]
age 30-40 = 45,000 [ 1/(1.03)13 + 1/(1.03)14 + 1/(1.03)15 + 1/(1.03)16 + 1/(1.03)17 + 1/(1.03)18 + 1/(1.03)19 + 1/(1.03)20 + 1/(1.03)21 + 1/(1.03)22 ]
NPV of total yearly earnings of HS graduate = 5,67,851
For college graduate, the NPV of yearly earnings is as follows:
age 18-22 = -90,000 [ 1/(1.03) + 1/(1.03)2 + 1/(1.03)3 +1/(1.03)4 ]
age 23-30 = 50,000 [ 1/(1.03)5 + 1/(1.03)6 +1/(1.03)7 + 1/(1.03)8 + 1/(1.03)9 + 1/(1.03)10 + 1/(1.03)11 + 1/(1.03)12 ]
age 31-40 = 95,000 [ 1/(1.03)13 + 1/(1.03)14 + 1/(1.03)15 + 1/(1.03)16 + 1/(1.03)17 + 1/(1.03)18 + 1/(1.03)19 + 1/(1.03)20 + 1/(1.03)21 + 1/(1.03)22 ]
NPV of total yearly earnings of College graduate = 5,45,683
(b) the person here will choose not to go to college as his NPV of toatal earnings declines with higher eduv=cation because here inflation rate has risen from 2% to 3%.
1 Optimal Education Choice 1. [You can use excel if you want. Show your work| Assume...
You wish to begin a college education savings program for the benefit of your child, Rebecca, who is 4 years old. Rebecca will begin college at age 18. Currently, the college costs are $10,000 per academic year. You assume that college cost will increase at the rate of 7% annually from now until Rebecca enters college and that you can achieve a before-tax rate of return of 8% annually on funds earmarked for this purpose. They also assume that Rebecca...
22. Does education improve your chances of being employed? attainment and employment status of the sonulation, 25 years of age 2012. The data is in thousands of people. (Source: Bureau of Labor Star moved? The following table provides data on the educational 9 years of age and older, in the labor force as of October Less than a High School Diploma High School Graduates No College Some College r Associate Bachelor's Degree and Higher Total Degree Employed 125,613 9,886 33,702...
You want to start saving for your daughter's college education now. She will enter college at age 18 and will pay fees of $4,000 at the end of each of the four years. You will start your savings by making a deposit in one year and at the end of every year until she begins college. If annual deposits of $2,458.79 will allow you to reach your goal, how old is your daughter now? Assume you can earn 6% annual...
To quantify the values of two potential career paths (work or go to college), you assume the followings. 1. Your parents will give you $55,000 from a college fund today whichever career path you choose. 2. Your salary directly goes to your saving account and sits there. 3. Your total living cost and taxes are always zero. 4. You will retire in 45 years from now. 5. The interest rate of your saving account is 2% per year, compounded annually....
Tara, an 18-year-old, just graduated from high school. She now has three choices: 1)Go to work in retail sales and earn $25,000/year until she retires at age 65. 2)Go to cosmetology school for one year during which time she earns nothing and has to pay $11,000 for school. After she finishes cosmetology school she can get a job in the beauty industry and earn $40,000/yearuntil she retires at age 65. 3)Go to college for four years during which time she...
Can you please solve these on Excel and show me how you solved
it. Thank you so much.
6) You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment immediately. You have not saved any money for your retirement as of yet. Assume interest rate is 7%, how much money must you set aside per year until and including your 65th birthday?...
Please don't use excel to solve the problems and show your
work.
16.1. (a) Calculate the amount realized at the end of 7 years through annual deposits of $1000 at 10 percent compound interest. (b) What would the amount be if interest were compounded semiannually? 16.2. A young woman purchases a used car. After down payment and allowances, the amount to be paid is $8000. If money is available at 10 percent, what is the monthly payment to pay off...
Assume you are now 21 years old and will start working as soon as you graduate from college. You plan to start saving for your retirement on your 25thbirthday and retire on your 65thbirthday. After retirement, you expect to live at least until you are 85. You wish to be able to withdraw $40,000 (in today’s dollars) every year from the time of your retirement until you are 85 years old (i.e., for 20 years). The average inflation rate is...
QUESTION 19 Assume that you are 30 years old today, and that you are planning on retirement at age 65. Your current salary is $35,000 and you expect your salary to increase at a rate of 4% per year as long as you work. To save for retirement, you plan on making annual contributions to a retirement account. Your first contribution will be made on your 31st birthday and will be 8% of this year's salary. Likewise, you expect to...
Let’s assume that you’re preparing for your (future) child (or grandchild)’s college education. 20 years later from now, your (future) child will go to college. Currently, you’re considering two colleges for your (future) child (or grandchild) University 1 Harvard University University 2 Vanderbilt University 1. Please visit the website of each university and find tuition and related information. Use out-of-state tuition information. Make sure that you include accurate information and citation source (20 points). 2. Using the tuition and related...