I have that template, and it works well for calculating P&I. I need one to work backwards…I give it the payment,interest rate, and length of loan and it gives me Loan Amount.
I’ve verified the MS template on several mortgage sites also…so I know that part works.
In essence what you want is a pre-qualification work sheet with the exception that you have defined what it is you can afford…So download the prequal template and then change the acceptable debt ratios