I am confused on how to start this assignment.

i also attatched the previous assignment that it mentions.

Submit Assignment Present Value of College Education Due Friday by 11:59pm Points 40 Submitting a file upload The assignment for this week is to create a professional analysis of the present value of college education. The assignment must include 1-2 pages of typed explanation of results in addition to 1 page spreadsheet that is well formatted and professional looking. This is taking the previous assignment and taking all values and converting them to present value. To make life easy use a constant expected interest rate of 2% for the future. The two most important elements of this assignment is that you show that you correctly calculated present value and that you have a professional presentation. Think of this as a proposal that you are submitting to a boss. It must look professional! You may turn in the assignment in class on Thursday. Otherwise, you need to submit the assignment by Friday night online. Previous Present Value of College Education Submit Assignment Due Friday by 11:59pm Points 40 Submitting a file upload The assignment for this week is to create a professional analysis of the present value of college education. The assignment must include 1-2 pages of typed explanation of results in addition to 1 page spreadsheet that is well formatted and professional looking. This is taking the previous assignment and taking all values and converting them to present value. To make life easy use a constant expected interest rate of 2% for the future. The two most important elements of this assignment is that you show that you correctly calculated present value and that you have a professional presentation. Think of this as a proposal that you are submitting to a boss. It must look professional! You may turn in the assignment in class on Thursday. Otherwise, you need to submit the assignment by Friday night online. dings Student Debt 1.pdf (page 1 01.4) Year Age 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 Option 12: Go to college at UMS work 20 hours week teaching Option #1: Work full a dance studio time at HINRG making $12/hour Gymnastics ($15/hour Cost of college Differences starting: $18/hour $12,000/year for Option #1 after 5 years) (5) years. (5) Option #2 (5) 18 30,750 15.00 34,550 19 30,750 153.00 69,100 20 30,750 153200 103,650 21 30, 750 151.800) 138200 22 30,750 53,800) 172,750 23 36,900 70,000 139,650 24 36,900 70,000 $106,550 25 36,900 70,000 73450 26 36,900 70,000 40350 27 36,900 70,000 7250 28 36,900 77.000 -32,850 29 43,050 77,000 -66,800 30 43,050 77,000 -100, 750 31 43,050 77,000 -134,700 32 43,050 77,000 -168,650 33 43,050 84,700 -210, 300 34 49,200 84,700 -245,800 35 49,200 84,700 -281,300 36 49,200 84,700 -316,800 37 49,200 84,700 352,300 38 49,200 93,170 -396,270 39 53,300 93,170 -436,140 40 53,300 93. 170 -476,010 41 53,300 93,170 515,880 42 53,300 93.170 -555,750 43 53,300 102, 487 604,937 61,500 102,487 645,924 45 61,500 102,487 -686,911 46 61,500 102,487 -727,898 47 61,500 102,487 768.885 48 61,500 112,736 820,121 49 67,650 112.736 50 865,207 67,650 112,736 51 910,293 67,650 112,736 -955,379 Student Debt 1.pdf (page 2 of 4) 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 52 53 54 55 56 57 58 59 60 61 62 63 64 65 67,650 67,650 73,800 73,800 73,800 73,800 73,800 79,950 79,950 79,950 79,950 79,950 79,950 79,950 112,736 124,010 124,010 124,010 124,010 124,010 136,411 136,411 136,411 136,411 136,411 150,052 150,052 150,052 -1,000,465 -1,056,825 -1, 107,035 -1,157,245 -1,207,455 -1,257,665 -1,320,276 -1,376,737 -1,433,198 -1,489,659 -1,546, 120 -1,616,222 -1,686, 324 -1,756,426 Student Debt 1.pdf (page 3 of 4) I have been working at HINRG Gymnastics as a head gymnastics and cheerleading coach- The other coaches working full time make $15/hour while the ones that have been there a while making $18/hour. So I am putting option 1 as 2050 hours at $15/hour for 5 years, then increasing to $18/ hour afterwards. For option 2 I am working at a dance studio for 20 hours a week at $12/hour and the cost to me since I do not have scholarships (my parents make too much money) is $12,000/year. I do know what I am doing so I will finish in 4 years. As an actuarial science major - I found a large variety in starting salaries with them ranging from $70,000 $90,000. I picked a lower end figure of 70,000. 1 included increases every 5 years of 10% of my salary Conclusion: In total going to college would net me more than $1.5 million compared to not going to college. Submit Assignment Present Value of College Education Due Friday by 11:59pm Points 40 Submitting a file upload The assignment for this week is to create a professional analysis of the present value of college education. The assignment must include 1-2 pages of typed explanation of results in addition to 1 page spreadsheet that is well formatted and professional looking. This is taking the previous assignment and taking all values and converting them to present value. To make life easy use a constant expected interest rate of 2% for the future. The two most important elements of this assignment is that you show that you correctly calculated present value and that you have a professional presentation. Think of this as a proposal that you are submitting to a boss. It must look professional! You may turn in the assignment in class on Thursday. Otherwise, you need to submit the assignment by Friday night online. Previous Present Value of College Education Submit Assignment Due Friday by 11:59pm Points 40 Submitting a file upload The assignment for this week is to create a professional analysis of the present value of college education. The assignment must include 1-2 pages of typed explanation of results in addition to 1 page spreadsheet that is well formatted and professional looking. This is taking the previous assignment and taking all values and converting them to present value. To make life easy use a constant expected interest rate of 2% for the future. The two most important elements of this assignment is that you show that you correctly calculated present value and that you have a professional presentation. Think of this as a proposal that you are submitting to a boss. It must look professional! You may turn in the assignment in class on Thursday. Otherwise, you need to submit the assignment by Friday night online. dings Student Debt 1.pdf (page 1 01.4) Year Age 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 Option 12: Go to college at UMS work 20 hours week teaching Option #1: Work full a dance studio time at HINRG making $12/hour Gymnastics ($15/hour Cost of college Differences starting: $18/hour $12,000/year for Option #1 after 5 years) (5) years. (5) Option #2 (5) 18 30,750 15.00 34,550 19 30,750 153.00 69,100 20 30,750 153200 103,650 21 30, 750 151.800) 138200 22 30,750 53,800) 172,750 23 36,900 70,000 139,650 24 36,900 70,000 $106,550 25 36,900 70,000 73450 26 36,900 70,000 40350 27 36,900 70,000 7250 28 36,900 77.000 -32,850 29 43,050 77,000 -66,800 30 43,050 77,000 -100, 750 31 43,050 77,000 -134,700 32 43,050 77,000 -168,650 33 43,050 84,700 -210, 300 34 49,200 84,700 -245,800 35 49,200 84,700 -281,300 36 49,200 84,700 -316,800 37 49,200 84,700 352,300 38 49,200 93,170 -396,270 39 53,300 93,170 -436,140 40 53,300 93. 170 -476,010 41 53,300 93,170 515,880 42 53,300 93.170 -555,750 43 53,300 102, 487 604,937 61,500 102,487 645,924 45 61,500 102,487 -686,911 46 61,500 102,487 -727,898 47 61,500 102,487 768.885 48 61,500 112,736 820,121 49 67,650 112.736 50 865,207 67,650 112,736 51 910,293 67,650 112,736 -955,379 Student Debt 1.pdf (page 2 of 4) 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 52 53 54 55 56 57 58 59 60 61 62 63 64 65 67,650 67,650 73,800 73,800 73,800 73,800 73,800 79,950 79,950 79,950 79,950 79,950 79,950 79,950 112,736 124,010 124,010 124,010 124,010 124,010 136,411 136,411 136,411 136,411 136,411 150,052 150,052 150,052 -1,000,465 -1,056,825 -1, 107,035 -1,157,245 -1,207,455 -1,257,665 -1,320,276 -1,376,737 -1,433,198 -1,489,659 -1,546, 120 -1,616,222 -1,686, 324 -1,756,426 Student Debt 1.pdf (page 3 of 4) I have been working at HINRG Gymnastics as a head gymnastics and cheerleading coach- The other coaches working full time make $15/hour while the ones that have been there a while making $18/hour. So I am putting option 1 as 2050 hours at $15/hour for 5 years, then increasing to $18/ hour afterwards. For option 2 I am working at a dance studio for 20 hours a week at $12/hour and the cost to me since I do not have scholarships (my parents make too much money) is $12,000/year. I do know what I am doing so I will finish in 4 years. As an actuarial science major - I found a large variety in starting salaries with them ranging from $70,000 $90,000. I picked a lower end figure of 70,000. 1 included increases every 5 years of 10% of my salary Conclusion: In total going to college would net me more than $1.5 million compared to not going to college