Rental Property Cash Flow Modelo Essentials
Track rental income and expenses for investment properties. Calculate net cash flow, cap rate, and return metrics for landlords.
O Que Está Incluído
- Dashboard with property performance metrics including net cash flow, cap rate, and cash-on-cash return
- Property setup with rental income, mortgage payment, property taxes, insurance, and management fee inputs
- Net cash flow calculations subtracting all expenses from gross rental income to show monthly and annual profit
- Vacancy and maintenance reserves with percentage-based inputs that automatically reduce effective income
- Return on investment metrics with color-coded input cells (yellow) and auto-calculated performance figures (blue)
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Need more from this template?
The Essentials version covers everyday tracking. Ultimate goes further with multi-entity support, scenario analysis, and ultimate-grade reporting.
- Dashboard with property performance metrics including net cash flow, cap rate, and cash-on-cash return
- Property setup with rental income, mortgage payment, property taxes, insurance, and management fee inputs
- Net cash flow calculations subtracting all expenses from gross rental income to show monthly and annual profit
- Vacancy and maintenance reserves with percentage-based inputs that automatically reduce effective income
- Acompanhe ate 5 imoveis para aluguel com preco de compra, financiamento, impostos, seguro, condominio, manutencao e detalhes de taxa de administracao
- Painel com 6 cartoes de KPI: fluxo de caixa mensal total, total de propriedades, renda bruta de aluguel, despesas totais, receita operacional liquida e cap rate medio
- Planilha de fluxo de caixa mensal acompanhando receitas e despesas por propriedade ao longo de 12 meses com totais acumulados e resumo anual
- Calculadora de ROI mostrando retorno sobre o capital investido, cap rate, rendimento bruto e retorno total por propriedade e de todo o portfolio
- Grade de analise de sensibilidade mostrando como o fluxo de caixa liquido muda conforme a taxa de vacancia e o preco do aluguel variam em 25 combinacoes
Pré-visualização
Veja o que tem dentro desta planilha
Como Usar Esta Planilha de Rental Property Cash Flow
Enter property details
Input monthly rental income, mortgage payment, property taxes, insurance, and management fees on the setup sheet.
Set vacancy and maintenance
Enter vacancy rate and maintenance reserve as percentages. These reduce effective income automatically.
Review net cash flow
The template calculates monthly and annual net cash flow after all expenses and reserves are deducted from rental income.
Check return metrics
The dashboard shows cap rate, cash-on-cash return, and net operating income for evaluating property performance.
Criadas com Claude AI. Aperfeiçoadas por nós.
Usamos Claude AI para criar cada planilha, após uma pesquisa aprofundada. Depois, nossa equipe entra em ação. Refinamos o layout, testamos exaustivamente cada fórmula, corrigimos casos extremos e polimos o design até que pareça algo que nós mesmos usaríamos. A IA nos leva 80% do caminho. Os últimos 20% são puro julgamento humano.
Perguntas Frequentes
What is cap rate?
Capitalization rate divides net operating income by the property purchase price. It measures the return independent of financing.
What vacancy rate should I use?
Common assumptions range from 5% to 10% depending on market conditions and property type. Enter the rate that matches your local market.
Does it include mortgage payments?
Yes. The cash flow calculation deducts the full mortgage payment (principal and interest) from rental income alongside all other expenses.
Can I track multiple properties?
This template covers one property. Duplicate the file for each rental property and track them individually.
Como abrir no Google Sheets?
Envie o arquivo .xlsx para o Google Drive e abra com o Google Sheets. Todas as fórmulas e formatações serão preservadas.
Mais modelos Essentials de Business Finance
Procurando planilhas premium?
Nossas planilhas pagas incluem painéis avançados com várias abas, gráficos nativos do Excel e atualizações contínuas.