Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What values do I fill in for the last table? Not sure what the PV or PMT would be for that one. Full problem- To

image text in transcribed

What values do I fill in for the last table? Not sure what the PV or PMT would be for that one.

Full problem-

image text in transcribed

To help him determine if it really is worth it to get a college education, Josh wants to see what the return on investment (ROI) will be 20 years after he graduates. After some research, Josh discovers that for his career choice he can expect to earn $2 million with a degree and $900,000 without one. What is Josh's 20-year ROI? (Hint: Use TVM and solve for I/Y.) N Explanation: I/Y PV PMT FV Josh is not sure if he should attend college or not. Part of his decision will be based on the return on investment of college. He estimates that the per year cost to attend Texas Tech including room and board is $27,750. He also assumes the cost will rise by 5.5% per year. How much is a 4-year degree going to cost Josh? Explanation: I/Y 27,750+(27,750*1.055)+(29,276.25*1.055)+(30,886.44*1.055)= PV $120,497.88 PMT $-27,750 Find FV by multiplying the previous year's tuition by the $120,497.88 interest rate N times then finding the sum 5.5% $0 FV Josh recognizes that not only will he have the costs of attending school, but he will also be giving up a salary while he attends school. He figures the average salary for those with only a high school diploma is $30,000. He assumes he would receive a 2.4% cost of living raise each year. Determine how much money he will forgo while attending school. 4 Explanation: I/Y 2.4% 30,000+(30,000*1.024)+(30,720*1.024)+(31,457.28*1.024)= PV $124,389.53 PMT $-30,000 Find FV by multiplying the previous year's lost salary by the FV interest rate N times then finding the sum N $0 Josh adds the cost of college with the salary he will forgo by attending college, he finds it will cost: $244,887.41_in total. (Keep in mind that this does not include any interest on loans needed to pay for school.) $120,497.88+$124,389.53=$244,887.41 To help him determine if it really is worth it to get a college education, Josh wants to see what the return on investment (ROI) will be 20 years after he graduates. After some research, Josh discovers that for his career choice he can expect to earn $2 million with a degree and $900,000 without one. What is Josh's 20-year ROI? (Hint: Use TVM and solve for I/Y.) Explanation: I/Y PV PMT FV Is this a good ROI or not? List at least 3 other factors besides ROI that John should consider

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Essentials You Always Wanted To Know Self Learning Management Series

Authors: Vibrant Publishers , Kalpesh Ashar

5th Edition

1636510973, 978-1636510972

More Books

Students also viewed these Finance questions

Question

3-29. Was the message well timed?

Answered: 1 week ago

Question

3-28. Specific purpose:

Answered: 1 week ago