Could ypu demonstrate how to find the answer in excel?

A common personal finance talking point is that paying off a mortgage early can be a mistake. Let's see why: Suppose that you are currently 6 years into your mortgage. Your mortgage is a traditional 30 year fixed: you make monthly paymeits, and the loan was originally $500,000 at a 5.5% interest rate. Suppose that you unexpectedly received $100,000. Your wealth manager suggests that you could invest in a mutual fund that earns 8% per year, but your significant other feels that you should pay down the mortgage. Which should you do? Support your answer by calculating the future value of your "portfolio" in two scenarios: 1. You pay down $100,000 of principal on your mortgage 2. You invest the $100,000 in the mutual fund