Imagine that you want to make calculation of how expensive flat/house you can afford to buy. You know how much you can spend on housing per month (100). You also know that there are three factors that affect the cost of housing:

- Price = size of the loan
- Interest rate. The interest is not fixed and you want to experiment with different levels "what happens if the interest increases from 2% to 4,5%?"
- The cost of running the house. Varies between objects.

The whole situations is a little "swings and roundabouts". If one flat/house has high running costs, especially 1 needs to be lower. If you expect the interest to increase, again 1 (and 3) must be lower, etc.

I want to setup a table in Excel where I can find answer to questions like

"If 3 is 20, my loan is 1000, what is the maximum interest rate if I want the whole cost to be lower than 100?" (8% in this case)

"If I borrow 1500 and expect the interest to increase to 6%, what is the max running cost I can afford?" (10)

"If the interest rate is 5%, how does the relationship between mortgage and running cost look?" (If the running cost is 100, you can't afford any mortgage, if the running cost is 60, you can borrow 800, if there is no running cost, you can borrow 2000).

As you understand, I am looking for a way to use at least three dimensions in one table to see which combinations of the three factors described above that are possible when you have a certain budget constraint.

It is easy to make a table over, e.g., price/interest rate or running cost/interest payments

but none of these tables cover all three dimensions. And that is my question:

Is it possible to illustrate a budget constraint depending on more than two factors in a regular spreadsheet? How?