Loan Amortization Modelo Essentials
Generate an amortization schedule for any fixed-rate loan. See each payment split between principal and interest across the full loan term.
O Que Está Incluído
- Dashboard with loan summary showing monthly payment, total principal, total interest, and payoff date
- Loan setup with amount, annual interest rate, and term in months or years for any fixed-rate loan type
- Complete amortization schedule with payment number, date, principal portion, interest portion, and balance
- Monthly principal and interest split displayed for every payment from the first month to the final one
- Remaining balance tracking with color-coded input fields (yellow) and formula-driven schedule (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 loan summary showing monthly payment, total principal, total interest, and payoff date
- Loan setup with amount, annual interest rate, and term in months or years for any fixed-rate loan type
- Complete amortization schedule with payment number, date, principal portion, interest portion, and balance
- Monthly principal and interest split displayed for every payment from the first month to the final one
- Configure ate 5 emprestimos separados com nome, valor do emprestimo, taxa de juros anual, prazo em meses e data de inicio
- Painel com 6 cartoes de KPI: total de parcelas mensais, divida total, juros total de todos os emprestimos, quantidade de emprestimos, menor prazo e maior taxa
- Tabela completa de amortizacao dedicada para cada um dos 2 primeiros emprestimos com data de pagamento, principal, juros e saldo devedor por parcela
- Planilha de resumo de todos os emprestimos mostrando cada emprestimo lado a lado: parcela mensal, juros total, custo total e saldo devedor em qualquer momento
- Planilha de impacto de pagamento extra simulando como pagamentos mensais adicionais afetam a economia de juros e a data de quitacao de cada emprestimo
Pré-visualização
Veja o que tem dentro desta planilha
Como Usar Esta Planilha de Loan Amortization
Enter loan details
Input the loan amount, annual interest rate, and term in months or years on the loan setup sheet.
Review the payment
The calculator shows your fixed monthly payment amount based on the loan terms you entered.
Study the schedule
The amortization table displays each payment with its principal portion, interest portion, and remaining balance.
Track the payoff
The dashboard summarizes total principal, total interest, and the date of the final payment.
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 types of loans does this work for?
Any fixed-rate, fully amortizing loan - mortgages, personal loans, auto loans, or business loans. Enter the terms and the schedule generates automatically.
Can I enter the term in months?
Yes. The setup accepts months or years. A 5-year loan can be entered as 60 months or 5 years.
Why does the principal portion grow each month?
As the balance decreases, less of each payment goes to interest and more goes to principal. This is how standard amortization works.
Does it handle extra payments?
This template generates a standard amortization schedule without extra payments. For extra payment modeling, use the Mortgage Payoff Calculator.
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 Mortgage & Home
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.