Calculate Early Mortgage Payoff Excel November 27, - Calculating mortgage payments might seem like a daunting task at first glance, but with a tool like Excel, it becomes much more manageable. Whether you're buying your first home or just curious about how it all works, figuring out these numbers can give you a clearer picture of what to expect.