Cool How To Calculate Home Loan Interest Formula In Excel Ideas. Loans consist of 4 basic parts. In the formula, b2 is.
The excel formula used to calculate the monthly payment of the loan is: The interest rate and number of periods need to be expressed in annual terms, since the length is presumed to be in years. Amortization is calculated using below formula: