I hope for your help, please use Excel. Thank you!

The most important annuity you may ever buy is your investment in your own education. Your upfront costs are likely to be more than compensated for by increased income and lots of other benefits to yourself, your family, community, and country. Here's an opportunity to measure just how profitable an investment this is likely to be for you. 1. Read "Is College Worth It? Clearly, New Data Say". Skim, "The top 50 U.S. colleges that pay off the most in 2020". 2. Estimate the cost of your education. Include tuition, books, and the opportunity costs, for example, lost wages over 2-4 years. Assume all these costs occur today. 3. Estimate the increase in your annual earnings as a result of your education. Assume these benefits occur every year of your career. Calculate the present value of this annuity using an 7% discount rate in Excel. 4. Calculate the NPV of your college investment by subtracting the total cost from the PV benefit. 5. Does your NPV agree with the one in the article? What do you think of this result? 6. Optional: Adjust your discount rate until the NPV = 0. This is the Internal Rate of Return of your investment in yourself. What do you conclude? 7. Optional: Work with another student and compare your analysis and results 8. Check your work carefully for accuracy, completeness, spelling, grammar, and compliance with our shared values before pressing "Submit". The most important annuity you may ever buy is your investment in your own education. Your upfront costs are likely to be more than compensated for by increased income and lots of other benefits to yourself, your family, community, and country. Here's an opportunity to measure just how profitable an investment this is likely to be for you. 1. Read "Is College Worth It? Clearly, New Data Say". Skim, "The top 50 U.S. colleges that pay off the most in 2020". 2. Estimate the cost of your education. Include tuition, books, and the opportunity costs, for example, lost wages over 2-4 years. Assume all these costs occur today. 3. Estimate the increase in your annual earnings as a result of your education. Assume these benefits occur every year of your career. Calculate the present value of this annuity using an 7% discount rate in Excel. 4. Calculate the NPV of your college investment by subtracting the total cost from the PV benefit. 5. Does your NPV agree with the one in the article? What do you think of this result? 6. Optional: Adjust your discount rate until the NPV = 0. This is the Internal Rate of Return of your investment in yourself. What do you conclude? 7. Optional: Work with another student and compare your analysis and results 8. Check your work carefully for accuracy, completeness, spelling, grammar, and compliance with our shared values before pressing "Submit