How to calculate breakeven occupancy when other income isn't tied to occupancy?
I'm trying to come up with a formula without using Goal Seek in Excel. Right now, I've got (Debt Service + Total Expenses)/(Gross Revenue/Occ.%) -- grossing up revenue since the property is not fully occupied. Not sure what is the best way to handle algebraically. Any thoughts?
[{"id": "humiyij", "text": "Write it in partials until you have it right. \n\nI think you have it right but this assumes all leasable space is at the same rate, no?", "replies": [], "depth": 1}, {"id": "humk5i6", "text": "(Debt Service + Total Expenses-\"other income\")/((Gross Revenue-other income)) = breakeven occupancy %\n\nI assume you're getting some type of extra income from cell tower, billboard, parking, etc? \"Other income\"", "replies": [{"id": "humkzab", "text": "Cell tower. \n\nAnd that formula works. Awesome, thank you so much.", "replies": [{"id": "humll13", "text": "Awesome!", "replies": [], "depth": 3}, {"id": "hunbhf1", "text": "Does it work though? Is all your space at x psf?", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}]