Using Excel to make a comparison of two scenarios: Keep the mortgage and invest VS pay the mortgage early by reducing the investment account. In part 2, we create the control scenario of keeping the mortgage. Write formulas to accurately calculate investment balance and mortgage balance based on key inputs.
Demo file: www.patreon.com/posts/49501051