A B C D G H Focus on YOU! Let's walkthrough your ROI of attending college! Research tuition costs for one year, along with what is the average salary with a high school diploma. Also, research what your earnings would be for over 20 years with a degree and 19 without a college degree. Make sure to site your work below. 20 Q2 Number of Years 4 21 Cost of Attendance will Rise Per-Year 2.80% 22 Cost of Living will Raise Per-Year 3.20% 23 Number of Years 20 24 Average Salary with a High School Diploma 42,590 25 Texas Tech Tuition Cost Per-Year 11,852 26 27 Q3 How much is a 4-year degree going to cost you? NPER RATE PV PMT FV 28 Reminder. Show the TVM inputs and calculate in Excel. 2.80%% D $11,852 $49,436.56) Hint: Cost of Hint: This will Attendance per be the yearly =FV(D28, C28,F28,E28) 29 year rise tuition for TTU 30 Q4 How much money you will have forgone while attending school? NPER RATE PV MT FV 31 Reminder. Show the TVM inputs and calculate in Excel. 14 3.20% 0 $42,590 ($178,713.12) Hint: The increase per Hint: Average =FV(D31, C31,F31,E31) 32 year Salary 33 Q5 What is the total cost? (cost of college + forgone salary) 5228,149.69)ar rse uitienTar 1y How much money you will have forgone while attending school? NPER - RATE PV PMT FV Reminder: Show the TVM inputs and calculate in Excel 3.20% 0 542 590 (178,713.12) Hint: The increase per Hint: Average =FV(D31,C31,F31,E31) year Salary What is the total cost? (cost of college + forgone salary) (228,149.69) Find a job posting for an entry level position in your field choice. If you are already employed in your career field, find $50,000 per year an advancement job. Then post the salary in C36. What would you earn in that job if you worked 20 years? (This is the earning expectation amount with a college