After earning an MBA, a student begins working on an $80,000 per year job on 9/1/18....

After earning an MBA, a student begins working on an $80,000 per year job on 9/1/18. She expects to receive a 5 percent raise each year until she retires on 9/1/48. If the cost of capital (i.e. interest rate she uses to discount future earnings to current dollars) is 8% per year and she is paid monthly, determine the total present value of her before tax earnings. Assume she is paid at the end of each month and each annual raise takes effect on Sept 1 each year. (answer is $1,521,144,67) In Excel functions

Solutions

Expert Solution

Answer is $1,031,834.19

ekkarill92 answered 10 months ago

Next > < Previous

Related Solutions

1) A prospective MBA student earns $50,000 per year in her current job and expects that...

1) A prospective MBA student earns $50,000 per year in her current job and expects that amount to increase by 9% per year. She is considering leaving her job to attend business school for two years at a cost of $50,000 per year. She has been told that her starting salary after business school is likely to be $105,000 and that amount will increase by 10% per year. Consider a time horizon of 10 years, use a discount rate of...

John was a high school teacher earning $ 80,000 per year. He quit his job to...

John was a high school teacher earning $ 80,000 per year. He quit his job to start his own business in pizza catering.In order to learn how to run the pizza catering business, John enrolled in a TAFE to acquire catering skills.John’s course was for 3 months. John had to pay $2,000 as tuition for the 3 months. After the training, John withdrew $110,000 from his savings account. He had been earning 5 percent interest per year for this account....

John was a high school teacher earning $ 80,000 per year. He quit his job to...

John was a high school teacher earning $ 80,000 per year. He quit his job to start his own business in pizza catering. In order to learn how to run the pizza catering business, John enrolled in a TAFE to acquire catering skills. John’s course was for 3 months. John had to pay $2,000 as tuition for the 3 months. After the training, John withdrew $110,000 from his savings account. He had been earning 5 percent interest per year for...

A prospective MBA student earns $50,000 per year in her current job and expects that amount...

A prospective MBA student earns $50,000 per year in her current job and expects that amount to increase by 12% per year. She is considering leaving her job to attend business school for two years at a cost of $45,000 per year. She has been told that her starting salary after business school is likely to be $85,000 and that amount will increase by 15% per year. Consider a time horizon of 10 years, use a discount rate of 11%,...

A prospective MBA student earns $55,000 per year in her current job and expects that amount...

A prospective MBA student earns $55,000 per year in her current job and expects that amount to increase by 7% per year. She is considering leaving her job to attend business school for two years at a cost of $40,000 per year. She has been told that her starting salary after business school is likely to be $100,000 and that amount will increase by 10% per year. Consider a time horizon of 10 years, use a discount rate of 13%,...

A prospective MBA student earns $45,000 per year in her current job and expects that amount...

A prospective MBA student earns $45,000 per year in her current job and expects that amount to increase by 6% per year. She is considering leaving her job to attend business school for two years at a cost of $30,000 per year. She has been told that her starting salary after business school is likely to be $90,000 and that amount will increase by 16% per year. Consider a time horizon of 10 years, use a discount rate of 9%,...

A prospective MBA student earns $60,000 per year in her current job and expects that amount...

A prospective MBA student earns $60,000 per year in her current job and expects that amount to increase by 11% per year. She is considering leaving her job to attend business school for two years at a cost of $45,000 per year. She has been told that her starting salary after business school is likely to be $75,000 and that amount will increase by 18% per year. Consider a time horizon of 10 years, use a discount rate of 12%,...

A prospective MBA student earns $55,000 per year in her current job and expects that amount...

A prospective MBA student earns $60,000 per year in her current job and expects that amount...

A prospective MBA student earns $60,000 per year in her current job and expects that amount to increase by 14% per year. She is considering leaving her job to attend business school for two years at a cost of $45,000 per year. She has been told that her starting salary after business school is likely to be $90,000 and that amount will increase by 10% per year. Consider a time horizon of 10 years, use a discount rate of 12%,...

1. Dane decides to give up a job earning $200,000 per year as a corporate lawyer...

1. Dane decides to give up a job earning $200,000 per year as a corporate lawyer and converts a duplex he owns into a UFO museum. The market rent for a similar duplex is $20,000 a year. He pays wages of $75,000 a year to his assistants and $10,000 a year for utilities. Fans flock to the museum to see his collection of extraterrestrial paraphernalia. Over the course of the year, the museum brings in revenues of $200,000. Use the...

Subjects