Monthly loan repayment
This example shows how to calculate monthly loan repayments, using an Excel PMT function
Example: Monthly loan repayment
|
=-PMT(C5/C7,C6*C7,C4)
|
This formula uses the Excel PMT function to calculate monthly loan repayments for a $100,000 loan at 5.00% interest rate with a period of 10 years. Given we are calculating the monthly loan repayments, cell C7 captures the number of months per annum.
|
EXPLANATION
This example shows how to calculate monthly loan repayments. The formula uses the an Excel PMT function.
This example shows how to calculate monthly loan repayments. The formula uses the an Excel PMT function.
FORMULA
=-PMT(interest_rate/months_per_year,years*months_per_year,loan_amount)
=-PMT(interest_rate/months_per_year,years*months_per_year,loan_amount)
ARGUMENTS
interest_rate: Interest rate.
months_per_year: The number of months per annum.
years: The number of years of the loan.
loan_amount: The loan amount.
interest_rate: Interest rate.
months_per_year: The number of months per annum.
years: The number of years of the loan.
loan_amount: The loan amount.
APPLICATION
The monthly loan repayment calculation that is shown in this example can be applied to a financial environment. Financial institutions and debt holders such as Banks and individuals with the debt can apply this example if they want to calculate the monthly loan repayments.
The monthly loan repayment calculation that is shown in this example can be applied to a financial environment. Financial institutions and debt holders such as Banks and individuals with the debt can apply this example if they want to calculate the monthly loan repayments.