How to Calculate a Debt Constant

The debt constant sometimes referred to as the loan constant or mortgage constant is the ratio of the constant periodic payment on a loan to the original loan amount.

The debt constant is only relevant to loans that have a fixed interest rate over the period of the loan, and is used to make quick calculations of the amount needed to repay a loan over its term, and the balance outstanding at any point in time.

Debt Constant Formula

The periodic payment on a loan is based on the present value of an annuity formula given as follows:

Pmt = PV x i / (1 - 1 / (1 + i)n)

The debt constant for a period is then given by the ratio of the payment (Pmt) to the loan amount (PV)):

Debt constant = Pmt/PV = i / (1 - 1 / (1 + i)n)

Mortgage Constant Example

Suppose a mortgage is for a term of 30 years at a rate of 5% with monthly repayments at the end of each month.

The mortgage constant is calculated as follows:

Mortgage loan constant = i / (1 - 1 / (1 + i)n)
i = 5%/12 per month
n = 30 x 12 = 360 months 
Mortgage loan constant = (5%/12) / (1 - 1 / (1 + (5%/12))360)
Mortgage loan constant = 0.537% per month

This calculation shows that monthly payments amounting to 0.537% of the mortgage would clear the mortgage after 30 years providing the rate is constant at 5%.

The debt constant is independent of the amount of the mortgage. In the above example, if the mortgage was for 100,000, then monthly repayments of 0.537% x 100,000 = 537 would need to be made to clear the mortgage after 30 years at an interest rate of 5%.

In order that comparisons can be made, mortgage constants are often quoted for a year. Again using the numbers in the example above, a monthly mortgage constant of 0.537%, gives an annual mortgage constant of 0.537% X 12 = 6.442%.

For our mortgage, the monthly payments in a year would total to 6.442% of the mortgage = 6.442% x 100,000 = 6,442 per year (537 x 12 allowing for rounding).

Link Between the Debt Constant and the Annuity Factor

The annuity factor given by the annuity tables and the debt constant are derived from the same present value of an annuity formula.

Pmt = PV x i / (1 - 1 / (1 + i)n)

The debt constant is equal to Pmt/PV whereas the annuity factor is given by PV/Pmt. The relationship between the debt constant and the annuity factor is therefore given by the formula.

Debt constant = 1 / Annuity factor

Consider another example of a loan for 25 years at a rate of 6% with annual payments at the end of each year.

The debt constant or loan constant is calculated using the formula as follows:

Debt constant = i / (1 - 1 / (1 + i)n)
i = 6%
n = 25
Debt constant = 6% / (1 - 1 / (1 + 6%)25)
Debt constant = 7.8227% per year

The alternative to using the debt constant formula is to use the present value of an annuity tables.

From the annuity tables, the annuity factor for 25 years and 6% is given as 12.7834, and from this the debt constant is calculated as.

Debt constant = 1 / Annuity factor
Debt constant = 1 / 12.7834
Debt constant = 7.8227% (as above)

Outstanding Loan Balance and Debt Constant

The debt constant can be used to calculate the outstanding or unpaid balance on a loan.

The outstanding balance on a loan is the present value of the outstanding annuity payments at that point in time, this is given by the present value of an annuity formula.

PV = Pmt x (1 - 1 / (1 + i)m) / i
Variables used in the formula
PV = Present Value at the date the outstanding balance is required for.
Pmt = Periodic payment
i = Discount rate
m = Number of periods out standing on the loan

But we know from earlier, that the payment (Pmt) is the debt constant for the loan multiplied by the loan amount, and the remaining function is the annuity factor for the outstanding period of the loan.

Outstanding loan = Pmt x (1 - 1 / (1 + i)m) / i
Outstanding loan = Loan x Debt constant (n) x Annuity factor(m)
But the Debt constant = 1 / Annuity factor
Outstanding loan / Loan = Debt constant (n) / Debt constant (m)
or expressed as a percentage of the loan amount
Outstanding loan % = Debt constant (n) / Debt constant (m)

Outstanding Loan Balance Example

If a loan for 250,000 has a 30 year term and a rate of 7%, what is the outstanding balance after 21 years?

The debt service constant for the loan is given as follows:

Debt constant (30)= i / (1 - 1 / (1 + i)n)
Debt constant (30) = 7% / (1 - 1 / (1 + 7%)30)
Debt constant (30) = 8.0586%

After 21 years there is 9 years left to pay. The debt constant for the remaining term is given by:

Annuity factor of remaining payments = (1 - 1 / (1 + i)m) / i
Debt constant (9) = 1 / Annuity factor
Debt constant (9) = 7% / (1 - 1 / (1 + 7%)9)
Debt constant (9) = 15.349%

The outstanding loan balance is then calculated using the debt constants

Outstanding loan % = Debt constant (n) / Debt constant (m)
Outstanding loan % = Debt constant (30) / Debt constant (9)
Outstanding loan % = 8.0586% / 15.349%
Outstanding loan % = 52.504%

At the end of 21 years 52.504% of the loan balance would be outstanding, on the 250,000 loan, this amounts to 250,000 x 52.504% = 131,260.

How to Calculate a Debt Constant November 6th, 2016Team

You May Also Like

Related pages

allowance for doubtful accounts balance sheet exampleeffective interest rate calculator for bondstvm equationdepreciation residual value calculationretained profits meaningreconciling control accountsfob value meaningicr ratioaccruals and prepayments double entryexcel formula for gross marginreceived cash from customers on account journal entryopposite of prepaid expensebank reconciliation template xlsaccumulated depreciation trial balancecash book entriesamortisation vs depreciationaccounting balance sheet templatesuspense account examplesperiodic and perpetual inventory systemsaccrual spreadsheet templatetable of future value annuity factorsbookkeeping testsstockholder equity equationjournal entry for security depositannuities due calculatorwhen is bad debt expense recordednet present value excel spreadsheetvacation accrual formulacalculating accounting rate of returnfv growing annuityreceive cash on account journal entryfixed asset turnover ratio analysisdays sales in inventory formulaoutstanding cheques in bank reconciliationcogs formulaexcel effective interest rateexcel formula for gross margincash book proformadupont return on equitywhat is present value annuityformula of accumulated depreciationcash receipt sample wordoperating expenses equationthe calculation of depreciation using the declining balance methodsample payment voucher formathow to calculate mark up percentageunearned revenue on balance sheetfob freight collect definitionrules of bookkeepingfundamental accounting conceptformula for calculating debt equity ratiowhat does accrued income meanwhat is allowance for doubtful accountsoperative leverageweighted average periodic inventory methodtrade debtors balance sheetlease accounting entriesamortization bond premiumdouble entry bookkeeping excelcost of merchandise sold definitionjournal entry for sales discountlcm reservepv annuitynet profit to sales ratiopay back period calculatorcalculate annuity duepresent value of a future annuity calculatoraccounting formula cheat sheetwhen is a trial balance preparedwages payable on balance sheetmarketable securities in accountingweighted average contribution margin formulaequation for depreciation