Question: 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

 What values do I fill in for the last table? Not

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

Full problem-

sure what the PV or PMT would be for that one. Full

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!