Common in Spanish mortgages. Allow a user input for "Meses de Carencia" (e.g., first 12 months).
A dynamic Excel workbook designed to calculate mortgage payments, amortization schedules, and total interest costs for property buyers in Spain (or Spanish-speaking markets). Target Audience: Homebuyers, real estate agents, and financial advisors. Core Value: transforming complex financial variables (interest rates, terms, principal) into clear, actionable data visualization and payment schedules. calculador hipotecas excel
| Column | Header | Description / Formula Logic | | :--- | :--- | :--- | | | Mes (Month) | 1 to 360 (based on term). | | B | Cuota (Payment) | The fixed monthly payment calculated above. | | C | Capital (Principal) | The portion of the payment going toward the debt. Formula: Payment - Interest | | D | Interés (Interest) | The cost of the money for that month. Formula: Previous Balance * (Annual Rate / 12) | | E | Capital Pendiente (Balance) | The remaining debt. Formula: Previous Balance - Current Principal | Common in Spanish mortgages