Start the loan amortization table
You want to know how much you will need to pay yearly on a $200,000 house loan to plan for your monthly expenses. You can use the pmt()
function to calculate the yearly payment for this loan at 4% interest and a 15 year loan. Remember to expand the cells if you cannot see the table headers.
Creating these tables will help you understand how loans are repaid and allow you to check different interest rates and loan amounts for the best fit to your budget.
Este ejercicio forma parte del curso
Financial Modeling in Google Sheets
Instrucciones del ejercicio
- In
B7
, use thepmt()
function with the interest, number of years, and negative initial loan balance to calculate the yearly payment. - In
B10
, enter a reference to the initial balance by using=B4
. - In
C10
, enter an absolute reference to the yearly payment calculated inB7
.
Ejercicio interactivo práctico
Pon en práctica la teoría con uno de nuestros ejercicios interactivos
