After earning an MBA, a student begins working on an $80,000 per year job on 9/1/18. She expects to receive a 5 percent raise each year until she retires on 9/1/48. If the cost of capital is 8% per year and she is paid monthly, determine the total present value of her before tax earnings. Assume she is paid at the end of each month and each annual raise takes effect on Sept 1 each year. (answer is $1,521,144,67)(Hint: create the cash flow with monthly pay periods)

I was given the answer from the professor I just need to know how to complete it in Excel.