Hi, can you please help me solve these parts of a problem info sheet provided: the job is as a Nutritionist job. Please help solve this. What are the answers for NPER, Rate, PV, PMT, and FV. Lastly Question 7 part how does ROI relate. Thanks, I appreciate it!

Transcribed Image Text:

Find a job posting for an entry level position in your field choice. If you are already employed in your career field, find 35 Q6 an advancement job. Then post the salary in C36. 36 What would you earn in that job if you worked 20 years? (This is the earning expectation amount with a college degree) What would you earn in you only had a HS diploma and worked that job for 20 years? (This is the earning expectation amount without a college degree) 37 38 What is the 20 yr. ROI of going to college? 39 Reminder: Show the TVM inputs and calculate in Excel. 40 41 Q7 How does ROI relate to human and financial capital? (min. 25 words) NPER RATE PV PMT FV #N/A Hint: This would be total cost Hint College Degree- Without College Degree Find a job posting for an entry level position in your field choice. If you are already employed in your career field, find 35 Q6 an advancement job. Then post the salary in C36. 36 What would you earn in that job if you worked 20 years? (This is the earning expectation amount with a college degree) What would you earn in you only had a HS diploma and worked that job for 20 years? (This is the earning expectation amount without a college degree) 37 38 What is the 20 yr. ROI of going to college? 39 Reminder: Show the TVM inputs and calculate in Excel. 40 41 Q7 How does ROI relate to human and financial capital? (min. 25 words) NPER RATE PV PMT FV #N/A Hint: This would be total cost Hint College Degree- Without College Degree