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

suspense account group is defined underending inventory equationformula of contribution marginaccounts payable excelpetty cash slip templateis depreciation a fixed or variable costannuity formula proofaccounting adjusting entryaccumulated depreciation journal entriesbookkeeping general ledgerreceivables ledgerfob sellerpmt dividendoverhead journal entryadjusting entry for unearned revenueallowance for doubtful accounts debit or creditsales ledger accountinsurance paid in advance journal entrymeaning of unearned revenuecost of goods manufactured and sold statement formatexamples of sundry expensesreturn on common stockholders equity calculatorasset disposal journal entrycontribution margin format income statementaccounting ratios cheat sheetpayback period methodmeaning deferred revenue expenditure give examplescalculate future value formulaaccounts recievable turnover ratioaccounting journal entries transactionaccounts payable receivable interview questions answerssingle column cash book formatrecording capital leasegeneral ledger chart of accounts exampleswhat is amortisation in accountingmargin and markup calculationscos cost of salesusing irr in excelmirr finance rateaccounts payable meaning in accountingcash cheque receipt formatconsignment sales accounting treatmenttrade discount accounting entryreducing balance interest formulaquick acid ratio formulaprovision for stock obsolescenceretained earnings journal entrydouble entry accounting transactions are made up ofnominal interest rate formulaaccumulated depreciation journal entriesperiodic perpetualunearned rental revenue ismerchandise inventory adjusting entrystraight line depreciation half year conventiondifficult accounting entriesadjusting journal entries unearned revenuemarkup margin formulayear end closing journal entriesreceivable turnover rateannuity tables present valuecalculating amortization expensejournal entries under perpetual inventory systemfuture annuity formulacalculate lifo reservefinancial leverage ratio definitionmanufacturing overhead formula examplefixed asset turnover examplepayroll tax expense journal entrysales tax payable journal entrygross profit method of inventory valuationdisbursement journal templatetemplate for a voucherpresent value interest factor annuity tablechart of accounts for construction company templatecashbook templatefactoring account receivablelearn accounting entriesimpairment of fixed assets journal entriesjournal ledger example