Mia-Associate Degree
Career Path: Dental Hygienist
College: Trade School
⚫Tuition: $3,412 per year paid for by Federal
Student Loans at a 5% interest rate over 10
years.
Starting Salary: $78,000
Annual Raise: 3%
Liam: Bachelors degree
。 Career Path: Social Work
。 College: Private University
。 Tuition: $37,000 per year paid for
with Federal Student Loans at 5%
interest over 20 years
。
Starting Salary: $55,000
o
Annual Raise: 3%
1. Enter the information for Mia into the spreadsheet.
a. What are their lifetime earnings after 5 years?
Answer
b. What are their lifetime earnings after 20 years?
Answer
c. What are their lifetime earnings at retirement (47 years)
Answer
2. Enter the information for Liam into the spreadsheet.
a. What are their lifetime earnings after 5 years?
b. What are their lifetime earnings after 20 years?
Answer
c. What are their lifetime earnings at retirement (47 years)
Answer
3. Compare
a. How much less did Liam make when compared to Mia?
Answer
b. Why might someone choose a career path like Liam's, despite the financial disadvantages
compared to a path like Mia's?
Answer
ㄖㄖ
