I'm helping my mother plan senior housing. She has a fixed amount of money in the bank that she can use to pay for housing. Generally housing has an annual increase of, say, 4%.
Using Google sheets, can someone help me to calculate how many years her savings can be used to pay for rent, assuming annual increases, for a range of different rents (e.g. $500-$1000, in $50 increments)?