Weekly loan repayment
This example shows how to calculate weekly loan repayments, using an Excel PMT function
Example: Weekly loan repayment
|
=-PMT(C5/C7,C6*C7,C4)
|
This formula uses the Excel PMT function to calculate weekly loan repayments for a $100,000 loan at 5.00% interest rate with a period of 10 years. Given we are calculating the weekly loan repayments, cell C7 captures the number of weeks per annum.
|
EXPLANATION
This example shows how to calculate weekly loan repayments. The formula uses the an Excel PMT function.
This example shows how to calculate weekly loan repayments. The formula uses the an Excel PMT function.
FORMULA
=-PMT(interest_rate/weeks_per_year,years*weeks_per_year,loan_amount)
=-PMT(interest_rate/weeks_per_year,years*weeks_per_year,loan_amount)
ARGUMENTS
interest_rate: Interest rate.
weeks_per_year: The number of weeks per annum.
years: The number of years of the loan.
loan_amount: The loan amount.
interest_rate: Interest rate.
weeks_per_year: The number of weeks per annum.
years: The number of years of the loan.
loan_amount: The loan amount.
APPLICATION
The weekly 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 weekly loan repayments.
The weekly 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 weekly loan repayments.