I found out the answer to Step one but am struggling with step two

can you post and show an example of how you would do it using Excel and show formulas.

Today Discount rate 1-Jul-20 2.00% Tuition/earnings ($) Time from today (days) Time/date Time from today (years) Present Value ($) 1-Sep-13 15-Jan-14 15-May-14 1-Sep-14 15-Jan-15 15-May-15 1-Sep-15 15-Jan-16 1-Sep-16 15-Jan-17 1-Sep-17 15-Jan-18 1-Sep-18 15-Jan-19 15-May-19 1-Sep-19 15-Jan-20 15-May-20 1-Sep-20 15-Jan-21 15-May-21 1800 1750 1300 1800 2100 1000 1750 1250 1200 1800 1250 1650 2200 1950 1800 1200 1850 1900 1200 1850 1900 2495 2359 2239 2130 1994 1874 1765 1629 1399 1263 1034 898 669 533 413 304 168 47 62 198 318 6.8356 6.4630 6.1342 5.8356 5.4630 5.1342 4.8356 4.4630 3.8329 3.4603 2.8329 2.4603 1.8329 1.4603 1.1315 0.8329 0.4603 0.1288 0.1699 0.5425 0.8712 Total PV 2,060.91 1,988.94 1,467.91 2,020.50 2,339.93 1,107.02 1,925.86 1,365.50 1,294.63 1,927.66 1,322.13 1,732.38 2,281.32 2,007.21 1,840.79 1,219.96 1,866.94 1,904.85 1,195.97 1,830.23 1,867.50 36,568.14 The present value of my undergraduate program is $36,568.14 Step 1: Calculate the cost of the program First fill up the following table to list down the term wise tuitions. Some terms are in the past and some will be in the future (until graduation). Only consider the current stint at MSUB; ignore if you were registered at MSUB in past or other school but did not complete the degree. Use the start of each term as the time/date (column 1 of the table): 15th January for the spring, 15th May for the first summer, 15th June for the second summer, and 1st September for the fall. Consider all the expenses related to school such as books, fees, etc. as part of Tuition (column 2). Assuming today is 1st July 2020, find the time difference (column 3) between today and the date for each term. Time from today (years) = Time from today (in days)/365 Now find the present value of the tuition (column 5). Use the formulas provided below to find the present value. Use discount rate = 2%. For past terms: Present Value = Tuition * (1 + discount rate) time from today in years For future terms: Present Value = Tuition / (1 + discount rate) time from today in years Time/Date Tuition ($) Time from today (days) Time from today (years) Present Value ($) Finally, add up the last column to find out the PV of the cost of the undergraduate program. Step 2: Estimate the opportunity cost Since you are a full time or part time student, you must be foregoing some earnings that you could have earned had you not been enrolled in the program. You may be working for fewer hours, or not working at all, or working in a place with lower wage. Find the difference between what you could have earned and what you have actually earned. Estimate similar difference for the future months as well, as you continue until graduation. In the last column find the present value of the difference. This is a monthly exercise (unlike step 1 which was a term-wise exercise). Rest of the directions and assumptions are similar to those in Step 1. Earnings ($) Could have earned ($) Difference ($) Time from today (days) Time from today (years) Present Value ($) Time/Date Finally, add up the last column and multiply the sum by 0.88 (assuming 12% tax rate) to find your opportunity cost