display on excel please

Suppose you were going to borrow $1 million dollars six months ago at approximately 2.9%

Now the interest rate is 4.7% if you keep your mortgage payment the same (same cash flow per month) because your boss has not given you a raise, then how much does the mortgage loan have to change?

In this case, you can finance the home with no money down, no taxes and no other transaction costs