I created a financial model to help determine if a real estate property is worth purchasing with the intent to rent it out. Everything in green is a field that requires an input. After entering in the property purchase and monthly expenses info, the model shows the forecasted cash flow, tax benefits, and equity accumulation.
Link to a sample rental real estate model. Feel free to make a copy.