Suppose, you take a 30 year period to repay your house loan. The present value (loan amount) of the mortgage is $300,000. The mortgage charges an interest rate of 8% per year.
Let us calculate how much will be the periodic installment and let us break it up into respective interest and principal components.
The formula sheet for each cell can be found below.