Q8 How much is going back to school going to cost? Reminder: Show the TVM inputs...

 

Transcribed Image Text:

Q8 How much is going back to school going to cost? Reminder: Show the TVM inputs and calculate in Excel Q9 How much money will be forgone will attending school? Reminder: Show the TVM inputs and calculate in Excel Q10 What is the total cost? (cost of college + forgone salary) Q11 What is the 15 yr. ROI of attending graduate school? Reminder: Show the TVM inputs and calculate in Excel Q12 Is this is a good ROI or not? List at least 3 other factors besides ROI that Jessica should consider. NPER RATE PV 3 3.00% PMT $31,000 FV #N/A NPER RATE PV PMT FV 31 4.00% 0 $58,500 #N/A NPER RATE 3 1% PV 278,431.50 Hint: The total PMT ($94,672.87) FV $322,500.00 cost Hint: With- Without #N/A Masters Degree 5 Unit 3: Building - Using Your Current Income Tomorrow 6 LG7-Understand the concepts of saving and investing and how it relates to human and financial capital accumulation 7 8 Q8 9 Texas Tech Graduate Program Cost of Attendance Per-Year 10 Number of Years 11 Cost of Attendance will Rise Per-Year 12 13 Q9 14 Average Salary with Bachelor's Degree (Entry Level Accountant) 15 Number of Years 16 Cost of Living Raise Per-Year 17 18 Q11 19 Number of Years 20 Earnings with a Master's Degree (Sr. Accountant) 21 Earnings without a Master's Degree 22 $31,000 3 3.00% $58,500 3 4.00% 15 $1,200,000 $877,500 Q8 How much is going back to school going to cost? Reminder: Show the TVM inputs and calculate in Excel Q9 How much money will be forgone will attending school? Reminder: Show the TVM inputs and calculate in Excel Q10 What is the total cost? (cost of college + forgone salary) Q11 What is the 15 yr. ROI of attending graduate school? Reminder: Show the TVM inputs and calculate in Excel Q12 Is this is a good ROI or not? List at least 3 other factors besides ROI that Jessica should consider. NPER RATE PV 3 3.00% PMT $31,000 FV #N/A NPER RATE PV PMT FV 31 4.00% 0 $58,500 #N/A NPER RATE 3 1% PV 278,431.50 Hint: The total PMT ($94,672.87) FV $322,500.00 cost Hint: With- Without #N/A Masters Degree 5 Unit 3: Building - Using Your Current Income Tomorrow 6 LG7-Understand the concepts of saving and investing and how it relates to human and financial capital accumulation 7 8 Q8 9 Texas Tech Graduate Program Cost of Attendance Per-Year 10 Number of Years 11 Cost of Attendance will Rise Per-Year 12 13 Q9 14 Average Salary with Bachelor's Degree (Entry Level Accountant) 15 Number of Years 16 Cost of Living Raise Per-Year 17 18 Q11 19 Number of Years 20 Earnings with a Master's Degree (Sr. Accountant) 21 Earnings without a Master's Degree 22 $31,000 3 3.00% $58,500 3 4.00% 15 $1,200,000 $877,500