Calculating the rate of return for each case is straightforward in Excel using the IRR function. In particular, list Years from 0 to 49. Then, list the salary for college in the next column. Next, list the cost of college or the salary from college for each year. Finally, create a fourth column that is the difference in value (college minus no college). Assuming the difference values are in cells E4 through E53, the Excel command is =IRR (E4:E53). The rate of discount, where each year of college costs $15,000, each year of post college work pays $60,000 and each year of non-college work pays $40,000.

Question

Want to see the full answer?

Answer 1

Question

Chapter 6, Problem 14P

a)

To determine

Calculating the rate of return for each case is straightforward in Excel using the IRR function. In particular, list Years from 0 to 49. Then, list the salary for college in the next column. Next, list the cost of college or the salary from college for each year. Finally, create a fourth column that is the difference in value (college minus no college). Assuming the difference values are in cells E4 through E53, the Excel command is =IRR (E4:E53).

The rate of discount, where each year of college costs $15,000, each year of post college work pays $60,000 and each year of non-college work pays $40,000.

b)

To determine

The rate of discount, where each year of college costs $15,000, each year of post college work pays $80,000 and each year of non-college work pays $35,000.

c)

To determine

The rate of discount, where each year of college costs $35,000, each year of post college work pays $60,000 and each year of non-college work pays $35,000.

d)

To determine

The rate of discount, where each year of college costs $15,000, the first year of post college work pays $60,000 but then increases by 5 percent per year and each year of non-college work pays $35,000 but then increases by 5 percent each year thereafter.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Lauren was accepted at three different graduate schools, and she must choose one. Elite U costs $50,000 per year and did not offer Lauren any financial aid. Lauren values attending Elite U at $60,000 per year. State College costs $30,000 per year and offered Lauren an annual $10,000 scholarship. Lauren values attending State College at $40,000 per year. NoName U costs $20,000 per year and offered Lauren a full $20,000 annual scholarship. Lauren values attending NoName at $15,000 per year. What is Lauren's economic surplus from attending State College instead of her next best alternative? Multiple Choice $40,000 $20,000 $10,000 $5,000 X

Suppose Fred's wage-schooling relationship is given by Years of Schooling Earnings 9 $28,000 10 $31,150 11 $33,700 12 $35,900 13 $37,400 14 $38,500 Derive the marginal rate of return schedule. When will Fred quit school if his discount rate is 5 percent? What if the discount rate is 10 percent?

Suppose an individual can decide between two careers: (1) a surgeon and (2) a business analyst. Salaries for four periods a displayed in the table below. OCCUPATION Surgeon Period 0 -$40 Business Analyst -$10 Period 1 $100 $41 SALARY Period 2 $115 $43 Period 3 $300 $45 (Questions) (a) Assume the individual's discount factor is 0.90. Calculate the net present value of becoming a surgeon. Show all steps to your work. (b) Again, assume the individual's discount factor is 0.90. However, this time, calculate the net present value of becoming a business analyst. Show all steps to your work. (c) For which occupation did the individual have a higher net present value (NPV)? Based on this information, discuss potential intrinsic characteristics that this person might have? (d) Explain why a large internal rate of return for an occupation, such as being a surgeon, can persist over a long period of time.

Answer 2

Question

Chapter 6, Problem 14P

a)

To determine

Calculating the rate of return for each case is straightforward in Excel using the IRR function. In particular, list Years from 0 to 49. Then, list the salary for college in the next column. Next, list the cost of college or the salary from college for each year. Finally, create a fourth column that is the difference in value (college minus no college). Assuming the difference values are in cells E4 through E53, the Excel command is =IRR (E4:E53).

The rate of discount, where each year of college costs $15,000, each year of post college work pays $60,000 and each year of non-college work pays $40,000.

b)

To determine

The rate of discount, where each year of college costs $15,000, each year of post college work pays $80,000 and each year of non-college work pays $35,000.

c)

To determine

The rate of discount, where each year of college costs $35,000, each year of post college work pays $60,000 and each year of non-college work pays $35,000.

d)

To determine

The rate of discount, where each year of college costs $15,000, the first year of post college work pays $60,000 but then increases by 5 percent per year and each year of non-college work pays $35,000 but then increases by 5 percent each year thereafter.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 6, Problem 14P

a)

To determine

Calculating the rate of return for each case is straightforward in Excel using the IRR function. In particular, list Years from 0 to 49. Then, list the salary for college in the next column. Next, list the cost of college or the salary from college for each year. Finally, create a fourth column that is the difference in value (college minus no college). Assuming the difference values are in cells E4 through E53, the Excel command is =IRR (E4:E53).

The rate of discount, where each year of college costs $15,000, each year of post college work pays $60,000 and each year of non-college work pays $40,000.

b)

To determine

The rate of discount, where each year of college costs $15,000, each year of post college work pays $80,000 and each year of non-college work pays $35,000.

c)

To determine

The rate of discount, where each year of college costs $35,000, each year of post college work pays $60,000 and each year of non-college work pays $35,000.

d)

To determine

The rate of discount, where each year of college costs $15,000, the first year of post college work pays $60,000 but then increases by 5 percent per year and each year of non-college work pays $35,000 but then increases by 5 percent each year thereafter.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 6, Problem 14P

a)

To determine

Calculating the rate of return for each case is straightforward in Excel using the IRR function. In particular, list Years from 0 to 49. Then, list the salary for college in the next column. Next, list the cost of college or the salary from college for each year. Finally, create a fourth column that is the difference in value (college minus no college). Assuming the difference values are in cells E4 through E53, the Excel command is =IRR (E4:E53).

The rate of discount, where each year of college costs $15,000, each year of post college work pays $60,000 and each year of non-college work pays $40,000.

b)

To determine

The rate of discount, where each year of college costs $15,000, each year of post college work pays $80,000 and each year of non-college work pays $35,000.

c)

To determine

The rate of discount, where each year of college costs $35,000, each year of post college work pays $60,000 and each year of non-college work pays $35,000.

d)

To determine

The rate of discount, where each year of college costs $15,000, the first year of post college work pays $60,000 but then increases by 5 percent per year and each year of non-college work pays $35,000 but then increases by 5 percent each year thereafter.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 6, Problem 14P

a)

To determine

Calculating the rate of return for each case is straightforward in Excel using the IRR function. In particular, list Years from 0 to 49. Then, list the salary for college in the next column. Next, list the cost of college or the salary from college for each year. Finally, create a fourth column that is the difference in value (college minus no college). Assuming the difference values are in cells E4 through E53, the Excel command is =IRR (E4:E53).

The rate of discount, where each year of college costs $15,000, each year of post college work pays $60,000 and each year of non-college work pays $40,000.

b)

To determine

The rate of discount, where each year of college costs $15,000, each year of post college work pays $80,000 and each year of non-college work pays $35,000.

c)

To determine

The rate of discount, where each year of college costs $35,000, each year of post college work pays $60,000 and each year of non-college work pays $35,000.

d)

To determine

The rate of discount, where each year of college costs $15,000, the first year of post college work pays $60,000 but then increases by 5 percent per year and each year of non-college work pays $35,000 but then increases by 5 percent each year thereafter.

Answer 6

Chapter 6, Problem 14P

a)

To determine

Calculating the rate of return for each case is straightforward in Excel using the IRR function. In particular, list Years from 0 to 49. Then, list the salary for college in the next column. Next, list the cost of college or the salary from college for each year. Finally, create a fourth column that is the difference in value (college minus no college). Assuming the difference values are in cells E4 through E53, the Excel command is =IRR (E4:E53).

The rate of discount, where each year of college costs $15,000, each year of post college work pays $60,000 and each year of non-college work pays $40,000.

Answer 7

Chapter 6, Problem 14P

a)

To determine

Calculating the rate of return for each case is straightforward in Excel using the IRR function. In particular, list Years from 0 to 49. Then, list the salary for college in the next column. Next, list the cost of college or the salary from college for each year. Finally, create a fourth column that is the difference in value (college minus no college). Assuming the difference values are in cells E4 through E53, the Excel command is =IRR (E4:E53).

The rate of discount, where each year of college costs $15,000, each year of post college work pays $60,000 and each year of non-college work pays $40,000.

Answer 8

b)

To determine

The rate of discount, where each year of college costs $15,000, each year of post college work pays $80,000 and each year of non-college work pays $35,000.

Answer 9

b)

To determine

The rate of discount, where each year of college costs $15,000, each year of post college work pays $80,000 and each year of non-college work pays $35,000.

Answer 10

c)

To determine

The rate of discount, where each year of college costs $35,000, each year of post college work pays $60,000 and each year of non-college work pays $35,000.

Answer 11

c)

To determine

The rate of discount, where each year of college costs $35,000, each year of post college work pays $60,000 and each year of non-college work pays $35,000.

Answer 12

d)

To determine

The rate of discount, where each year of college costs $15,000, the first year of post college work pays $60,000 but then increases by 5 percent per year and each year of non-college work pays $35,000 but then increases by 5 percent each year thereafter.

Answer 13

d)

To determine

The rate of discount, where each year of college costs $15,000, the first year of post college work pays $60,000 but then increases by 5 percent per year and each year of non-college work pays $35,000 but then increases by 5 percent each year thereafter.

Answer 14

Expert Solution & Answer

Answer 15

Expert Solution & Answer

Answer 16

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 17

Ch. 6 - Discuss how the present value of a future income...Ch. 6 - Prob. 2RQ Ch. 6 - Prob. 3RQ Ch. 6 - Prob. 4RQ Ch. 6 - Prob. 5RQ Ch. 6 - Prob. 6RQ Ch. 6 - Prob. 7RQ Ch. 6 - Prob. 8RQ Ch. 6 - Prob. 9RQ Ch. 6 - Prob. 1P

The rate of discount, where each year of college costs $15,000, each year of post college work pays $80,000 and each year of non-college work pays $35,000.

The rate of discount, where each year of college costs $35,000, each year of post college work pays $60,000 and each year of non-college work pays $35,000.

The rate of discount, where each year of college costs $15,000, the first year of post college work pays $60,000 but then increases by 5 percent per year and each year of non-college work pays $35,000 but then increases by 5 percent each year thereafter.

Want to see the full answer?

Chapter 6 Solutions