• please show your excel solution

Unit 3: Building - Using Your Current Income Tomorrow
LG7-Understand the concepts of saving and investing and how it relates to human and financial capital accumulation
Q8
Texas Tech Graduate Program Cost of Attendance Per-Year	$31,000
Number of Years	3
Cost of Attendance will Rise Per-Year	3.00%
Q9
Average Salary with Bachelor's Degree (Entry Level Accountant)	$58,500
Number of Years	3
Cost of Living Raise Per-Year	4.00%
Q11
Number of Years	15
Earnings with a Master's Degree (Sr. Accountant)	$1,200,000
Earnings without a Master's Degree	$877,500

Q1	Focus on YOU! Identify at least three different job postings that you would be interested in using websites such as monster.com, indeed.com, careerbuilder.com, payscale.com, indeed.com, salary.com, and others. Research and report on the starting salary, at least three of the responsibilities, and identify at least three qualifications for the job (degrees, certifications, etc.).
	Job Title
	Starting Salary Range
	3 Responsibilities
	3 Qualifications
	Career Website Source(s) Used
	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 without a college degree. Make sure to site your work below.
Q2	Number of Years	4
	Cost of Attendance will Rise Per-Year	2.80%
	Cost of Living will Raise Per-Year	3.20%
	Number of Years	20
	Average Salary with a High School Diploma
	Texas Tech Tuition Cost Per-Year
Q3	How much is a 4-year degree going to cost you?	NPER	RATE	PV	PMT	FV
	Reminder: Show the TVM inputs and calculate in Excel.
Q4	How much money you will have forgone while attending school?	NPER	RATE	PV	PMT	FV
	Reminder: Show the TVM inputs and calculate in Excel.
Q5	What is the total cost?
Q6	First career related job title (right after graduation)
	Next 20 years, earning expectation amount with a college degree
	Next 20 years, earning expectation amount without a college degree
	What is the 20 yr. ROI of going to college?	NPER	RATE	PV	PMT	FV
	Reminder: Show the TVM inputs and calculate in Excel.
Q7	How does ROI relate to human and financial capital?
	Website Source(s) Used
	Application Time! Jessica is thinking about going back to school full time and receive a Master's in Accounting. Part of her decision will be based on the return on investment of Graduate School. Help Jessica find the ROI of going back to school. (1) you will need to pull the data from the "Info Sheet" and (2) solve for the missing information.
Q8	How much is going back to school going to cost?	NPER	RATE	PV	PMT	FV
	Reminder: Show the TVM inputs and calculate in Excel.
Q9	How much money will be forgone will attending school?	NPER	RATE	PV	PMT	FV
	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?	NPER	RATE	PV	PMT	FV
	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.