Weighted-average life

Last updated

In finance, the weighted-average life (WAL) of an amortizing loan or amortizing bond, also called average life, [1] [2] [3] is the weighted average of the times of the principal repayments: it's the average time until a dollar of principal is repaid.

Finance Academic discipline studying businesses and investments

Finance is a field that is concerned with the allocation (investment) of assets and liabilities over space and time, often under conditions of risk or uncertainty. Finance can also be defined as the art of money management. Participants in the market aim to price assets based on their risk level, fundamental value, and their expected rate of return. Finance can be split into three sub-categories: public finance, corporate finance and personal finance.

In banking and finance, an amortizing loan is a loan where the principal of the loan is paid down over the life of the loan according to an amortization schedule, typically through equal payments.

Contents

In a formula, [4]

where:

If desired, can be expanded as for a monthly bond, where is the fraction of a month between settlement date and first cash flow date.

Settlement Date is a securities industry term describing the date on which a trade settles. That is, the actual day on which transfer of cash or assets is completed and is usually a few days after the trade was done. The number of days between trade date and settlement date depends on the security and the convention in the market it was traded. For example when settling a share transaction on the London Stock Exchange this is set at trade date + 2 business days.

WAL of classes of loans

In loans that allow prepayment, the WAL cannot be computed from the amortization schedule alone; one must also make assumptions about the prepayment and default behavior, and the quoted WAL will be an estimate. The WAL is usually computed from a single cash-flow sequence. Occasionally, a simulated average life may be computed from multiple cash-flow scenarios, such as those from an option-adjusted spread model. [5]

Prepayment is the early repayment of a loan by a borrower, in part or in full, often as a result of optional refinancing to take advantage of lower interest rates.

Option-adjusted spread (OAS) is the yield spread which has to be added to a benchmark yield curve to discount a security's payments to match its market price, using a dynamic pricing model that accounts for embedded options. OAS is hence model-dependent. This concept can be applied to a mortgage-backed security (MBS), or another bond with embedded options, or any other interest rate derivative or option. More loosely, the OAS of a security can be interpreted as its "expected outperformance" versus the benchmarks, if the cash flows and the yield curve behave consistently with the valuation model.

WAL should not be confused with the following distinct concepts:

Bond duration
Bond duration is the weighted-average time to receive the discounted present values of all the cash flows (including both principal and interest), while WAL is the weighted-average time to receive simply the principal payments (not including interest, and not discounting). For an amortizing loan with equal payments, the WAL will be higher than the duration, as the early payments are weighted towards interest, while the later payments are weighted towards principal, and further, taking present value (in duration) discounts the later payments.
Time until 50% of the principal has been repaid
WAL is a mean, while "50% of the principal repaid" is a median; see difference between mean and median. Since principal outstanding is a concave function (of time) for a flat payment amortizing loan, less than half the principal will have been paid off at the WAL. Intuitively, this is because most of the principal repayment happens at the end. Formally, the distribution of repayments has negative skew: the small principal repayments at the beginning drag down the WAL (mean) more than they reduce the median.
Weighted-average maturity (WAM)
WAM is an average of the maturity dates of multiple loans, not an average of principal repayments.

Applications

WAL is a measure that can be useful in credit risk analysis on fixed income securities, bearing in mind that the main credit risk of a loan is the risk of loss of principal. All else equal, a bond with principal outstanding longer (i.e., longer WAL) has greater credit risk than a bond with shorter WAL. In particular, WAL is often used as the basis for yield comparisons in I-spread calculations.

The Interpolated Spread or I-spread or ISPRD of a bond is the difference between its yield to maturity and the linearly interpolated yield for the same maturity on an appropriate reference yield curve. The reference curve may refer to government debt securities or interest rate swaps or other benchmark instruments, and should always be explicitly specified. If the bond is expected to repay some principal before its final maturity, then the interpolation may be based on the weighted-average life, rather than the maturity.

WAL should not be used to estimate a bond's price-sensitivity to interest-rate fluctuations, as WAL includes only the principal cash flows, omitting the interest payments. Instead, one should use bond duration, which incorporates all the cash flows.

Bond duration

In finance, the duration of a financial asset that consists of fixed cash flows, for example a bond, is the weighted average of the times until those fixed cash flows are received. When the price of an asset is considered as a function of yield, duration also measures the price sensitivity to yield, the rate of change of price with respect to yield or the percentage change in price for a parallel shift in yields.

Examples

The WAL of a bullet loan (non-amortizing) is exactly the tenor, as the principal is repaid precisely at maturity.

On a 30-year amortizing loan, paying equal amounts monthly, one has the following WALs, for the given annual interest rates (and corresponding monthly payments per $100,000 principal balance, calculated via an amortization calculator and the formulas below relating amortized payments, total interest, and WAL):

An amortization calculator is used to determine the periodic payment amount due on a loan, based on the amortization process.

Rate Payment Total Interest WAL Calculation WAL
4% $477.42 $71,871.20 $71,871.20/($100,000*4%) 17.97
8% $733.76 $164,153.60 $164,153.60/($100,000*8%) 20.52
12% $1,028.61 $270,299.60 $270,229.60/($100,000*12%) 22.52

Note that as the interest rate increases, WAL increases, since the principal payments become increasingly back-loaded. WAL is independent of the principal balance, though payments and total interest are proportional to principal.

For a coupon of 0%, where the principal amortizes linearly, the WAL is exactly half the tenor plus half a payment period, because principal is repaid in arrears (at the end of the period). So for a 30-year 0% loan, paying monthly, the WAL is years.

Total Interest

WAL allows one to easily compute the total interest payments, given by:

where r is the annual interest rate and P is the initial principal.

This can be understood intuitively as: "The average dollar of principal is outstanding for the WAL, hence the interest on the average dollar is , and now one multiplies by the principal to get total interest payments."

Proof

More rigorously, one can derive the result as follows. To ease exposition, assume that payments are monthly, so periodic interest rate is annual interest rate divided by 12, and time (time in years is period number in months, over 12).

Then:

Total interest is

where is the principal outstanding at the beginning of period i (it's the principal on which the i interest payment is based). The statement reduces to showing that . Both of these quantities are the time-weighted total principal of the bond (in periods), and they are simply different ways of slicing it: the sum counts how long each dollar of principal is outstanding (it slices horizontally), while the counts how much principal is outstanding at each point in time (it slices vertically).

Working backwards, , and so forth: the principal outstanding when k periods remain is exactly the sum of the next k principal payments. The principal paid off by the last (nth) principal payment is outstanding for all n periods, while the principal paid off by the second to last ((n  1)th) principal payment is outstanding for n  1 periods, and so forth. Using this, the sums can be re-arranged to be equal.

For instance, if the principal amortized as $100, $80, $50 (with paydowns of $20, $30, $50), then the sum would on the one hand be , and on the other hand would be . This is demonstrated in the following table, which shows the amortization schedule, broken up into principal repayments, where each column is a , and each row is :

230 100 80 50
1 × 2020
2 × 3030 30
3 × 5050 50 50

Computing WAL from amortized payment

The above can be reversed: given the terms (principal, tenor, rate) and amortized payment A, one can compute the WAL without knowing the amortization schedule. The total payments are and the total interest payments are , so the WAL is:

Similarly, the total interest as percentage of principal is given by :

Notes and references

See also

Related Research Articles

In economics and finance, present value (PV), also known as present discounted value, is the value of an expected income stream determined as of the date of valuation. The present value is always less than or equal to the future value because money has interest-earning potential, a characteristic referred to as the time value of money, except during times of negative interest rates, when the present value will be more than the future value. Time value can be described with the simplified phrase, "A dollar today is worth more than a dollar tomorrow". Here, 'worth more' means that its value is greater. A dollar today is worth more than a dollar tomorrow because the dollar can be invested and earn a day's worth of interest, making the total accumulate to a value more than a dollar by tomorrow. Interest can be compared to rent. Just as rent is paid to a landlord by a tenant without the ownership of the asset being transferred, interest is paid to a lender by a borrower who gains access to the money for a time before paying it back. By letting the borrower have access to the money, the lender has sacrificed the exchange value of this money, and is compensated for it in the form of interest. The initial amount of the borrowed funds is less than the total amount of money paid to the lender.

Interest fee paid by the debtor to the creditor for temporarily borrowed capital

Interest is the possession of a share in or a right to something. An alternate meaning has "interest" as payment from a borrower or deposit-taking financial institution to a lender-usurer of an amount above repayment of the principal sum, at a particular rate. It is distinct from a fee which the borrower may pay the lender or some third party. It is also distinct from dividend which is paid by a company to its shareholders (owners) from its profit or reserve, but not at a particular rate decided beforehand, rather on a pro rata basis as a share in the reward gained by risk taking entrepreneurs when the revenue earned exceeds the total costs.

The weighted average cost of capital (WACC) is the rate that a company is expected to pay on average to all its security holders to finance its assets. The WACC is commonly referred to as the firm's cost of capital. Importantly, it is dictated by the external market and not by management. The WACC represents the minimum return that a company must earn on an existing asset base to satisfy its creditors, owners, and other providers of capital, or they will invest elsewhere.

Compound interest when interest is added to the principal of a deposit or loan, so that, from that moment on, the interest that has been added also earns interest

Compound interest is the addition of interest to the principal sum of a loan or deposit, or in other words, interest on interest. It is the result of reinvesting interest, rather than paying it out, so that interest in the next period is then earned on the principal sum plus previously accumulated interest. Compound interest is standard in finance and economics.

A fixed-rate mortgage (FRM), often referred to as a "vanilla wafer" mortgage loan, is a fully amortizing mortgage loan where the interest rate on the note remains the same through the term of the loan, as opposed to loans where the interest rate may adjust or "float". As a result, payment amounts and the duration of the loan are fixed and the person who is responsible for paying back the loan benefits from a consistent, single payment and the ability to plan a budget based on this fixed cost.

Bond valuation

Bond valuation is the determination of the fair price of a bond. As with any security or capital investment, the theoretical fair value of a bond is the present value of the stream of cash flows it is expected to generate. Hence, the value of a bond is obtained by discounting the bond's expected cash flows to the present using an appropriate discount rate. In practice, this discount rate is often determined by reference to similar instruments, provided that such instruments exist. Various related yield-measures are then calculated for the given price.

In finance, bond convexity is a measure of the non-linear relationship of bond prices to changes in interest rates, the second derivative of the price of the bond with respect to interest rates. In general, the higher the duration, the more sensitive the bond price is to the change in interest rates. Bond convexity is one of the most basic and widely used forms of convexity in finance.

Moving average

In statistics, a moving average is a calculation to analyze data points by creating a series of averages of different subsets of the full data set. It is also called a moving mean (MM) or rolling mean and is a type of finite impulse response filter. Variations include: simple, and cumulative, or weighted forms.

Mortgage-backed security security

A mortgage-backed security (MBS) is a type of asset-backed security which is secured by a mortgage or collection of mortgages. The mortgages are sold to a group of individuals that securitizes, or packages, the loans together into a security that investors can buy. The mortgages of a MBS may be residential or commercial, depending on whether it is an Agency MBS or a Non-Agency MBS; in the United States they may be issued by structures set up by government-sponsored enterprises like Fannie Mae or Freddie Mac, or they can be "private-label", issued by structures set up by investment banks. The structure of the MBS may be known as "pass-through", where the interest and principal payments from the borrower or homebuyer pass through it to the MBS holder, or it may be more complex, made up of a pool of other MBSs. Other types of MBS include collateralized mortgage obligations and collateralized debt obligations (CDOs).

Amortization (business) spreading payments over multiple periods; the term is used for two separate processes: amortization of loans and amortization of assets. In the latter case it refers to allocating the cost of an intangible asset over a period of time

In business, amortization refers to spreading payments over multiple periods. The term is used for two separate processes: amortization of loans and amortization of assets. In the latter case it refers to allocating the cost of an intangible asset over a period of time.

A balloon payment mortgage is a mortgage which does not fully amortize over the term of the note, thus leaving a balance due at maturity. The final payment is called a balloon payment because of its large size. Balloon payment mortgages are more common in commercial real estate than in residential real estate. A balloon payment mortgage may have a fixed or a floating interest rate. The most common way of describing a balloon loan uses the terminology X due in Y, where X is the number of years over which the loan is amortized, and Y is the year in which the principal balance is due.

The Z-spread, ZSPRD, zero-volatility spread or yield curve spread of a mortgage-backed security (MBS) is the parallel shift or spread over the zero-coupon Treasury yield curve required for discounting a pre-determined cash flow schedule to arrive at its present market price. The Z-spread is also widely used in the credit default swap (CDS) market as a measure of credit spread that is relatively insensitive to the particulars of specific corporate or government bonds.

Mortgage calculators are automated tools that enable users to determine the financial implications of changes in one or more variables in a mortgage financing arrangement. Mortgage calculators are used by consumers to determine monthly repayments, and by mortgage providers to determine the financial suitability of a home loan applicant.

Mortgage loan loan secured using real estate

A mortgage loan or, simply, mortgage is used either by purchasers of real property to raise funds to buy real estate, or alternatively by existing property owners to raise funds for any purpose, while putting a lien on the property being mortgaged. The loan is "secured" on the borrower's property through a process known as mortgage origination. This means that a legal mechanism is put into place which allows the lender to take possession and sell the secured property to pay off the loan in the event the borrower defaults on the loan or otherwise fails to abide by its terms. The word mortgage is derived from a Law French term used in Britain in the Middle Ages meaning "death pledge" and refers to the pledge ending (dying) when either the obligation is fulfilled or the property is taken through foreclosure. A mortgage can also be described as "a borrower giving consideration in the form of a collateral for a benefit (loan)".

Flat rate (finance)

Flat interest rate mortgages and loans calculate interest based on the amount of money a borrower receives at the beginning of a loan. However, if repayment is scheduled to occur at regular intervals throughout the term, the average amount to which the borrower has access is lower and so the effective or true rate of interest is higher. Only if the principal is available in full throughout the loan term does the flat rate equate to the true rate. This is the case in the example to the right, where the loan contract is for 400,000 Cambodian riels over 4 months. Interest is set at 16,000 riels (4%) a month while principal is due in a single payment at the end.

Continuous-repayment mortgage

Analogous to continuous compounding, a continuous annuity is an ordinary annuity in which the payment interval is narrowed indefinitely. A (theoretical) continuous repayment mortgage is a mortgage loan paid by means of a continuous annuity.

An annuity is a series of payments made at equal intervals. Examples of annuities are regular deposits to a savings account, monthly home mortgage payments, monthly insurance payments and pension payments. Annuities can be classified by the frequency of payment dates. The payments (deposits) may be made weekly, monthly, quarterly, yearly, or at any other regular interval of time.