A high school graduate has to decide between working and going to college. If he works, he will work for the next 50 years of his life. If he goes to college, he will be in college for 5 years, and then work for 45 years. In this model, the rate of discount that equates the lifetime present value of not going to college and going to college is 8.24 percent when the cost of each year of college is $15,000, each year of noncollege work pays $35,000, and each year of postcollege work pays $60,000. For each of the parts below, discuss how the rate of discount that equalizes the two options would change and who would make a different schooling decision based on the change. (Extra credit: Use Excel to show that the rate of return to schooling is 8.24 percent in the above case and solve for the rates of discount associated with each of the parts below.) a. Each year of college still costs $15,000 and each year of postcollege work still pays $60,000, but each year of noncollege work now pays $40,000. b. Each year of college still costs $15,000 and each year of noncollege work still pays $35,000, but each year of postcollege work now pays $80,000. c. Each year of noncollege work and postcollege work still pays $35,000 and $60,000 respectively, but now each year of college costs $35,000. d. Each year of college still costs $15,000. The first year of noncollege work pays $35,000 but then increases by 3 percent each year thereafter. The first year of postcollege work pays $60,000 but then increases by 5 percent each year thereafter.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter27: Time Value Of Money (compound)
Section: Chapter Questions
Problem 6E
icon
Related questions
Question

A high school graduate has to decide between working and going to college. If he works, he will work for the next 50 years of his life. If he goes to college, he will be in college for 5 years, and then work for 45 years. In this model, the rate of discount that equates the lifetime present value of not going to college and going to college is 8.24 percent when the cost of each year of college is $15,000, each year of noncollege work pays $35,000, and each year of postcollege work pays $60,000. For each of the parts below, discuss how the rate of discount that equalizes the two options would change and who would make a different schooling decision based on the change. (Extra credit: Use Excel to show that the rate of return to schooling is 8.24 percent in the above case and solve for the rates of discount associated with each of the parts below.)
a. Each year of college still costs $15,000 and each year of postcollege work still pays $60,000, but each year of noncollege work now pays $40,000.
b. Each year of college still costs $15,000 and each year of noncollege work still pays $35,000, but each year of postcollege work now pays $80,000.
c. Each year of noncollege work and postcollege work still pays $35,000 and $60,000 respectively, but now each year of college costs $35,000.
d. Each year of college still costs $15,000. The first year of noncollege work pays $35,000 but then increases by 3 percent each year thereafter. The first year of postcollege work pays $60,000 but then increases by 5 percent each year thereafter.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Knowledge Booster
Checking Accounts
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT