Answered step by step
Verified Expert Solution
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
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 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 considerStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started