NEWStock Market Analysis — Sector Performance Analyzer · Metals & Automobiles deep dives · Global Markets Open →
◆Financial Derivatives — In Progress Please await announcements of new courses and upcoming batches. Course Updates →
The Mountain Path Academy

Bootstrapping Basics and Linear Interpolation of Interest Rate Yields

Understand the idea, work a simple example by hand, then build the spot curve one discount factor at a time.

By Prof. V. Ravichandran · CFA / FRM / MBA · Manual examples · 17 learning sections · Two interactive laboratories

Bootstrapping & interpolation at a glance
4.4200%Interpolated 1.5Y par yield
0.8415381.5Y coupon-case discount factor
11.5016%1.5Y continuous spot rate
97.1200Repriced 2Y coupon bond

Interpolation estimates between points. Bootstrapping extracts discount factors from prices. Always label the rate convention.

SECTION 01

What is bootstrapping, and why do we need it?

Bootstrapping builds a spot-rate curve one maturity at a time from bond prices. First solve the shortest bond’s discount factor. Use factors already known to value the earlier coupons of the next bond. Subtract those values from its price, then solve for the factor on the final payment.

Why do this? A coupon bond pays on several dates. Its yield to maturity is a single rate that reproduces that bond’s price; it is not automatically the correct spot rate for every date. A spot curve gives one discount factor for each payment date.

The central idea:
Price = value of earlier payments already known + value of the final payment still unknown.

Solve the shortest maturity first, then use what you know to solve the next maturity.

Follow this guide in order: manual annual-pay example → discount factors → zero-coupon bonds → semiannual coupon bonds → spot-rate conversions → interpolation → Treasury case. The annual example and the semiannual case are separate datasets, with their own stated compounding conventions.

SECTION 02

Start by hand: a three-year annual-pay example

A simple manual example: annual-pay par bonds

Assume face value ₹100, annual coupons, settlement on a coupon date and annual effective spot rates. Each bond trades at par, so its price is ₹100. These hypothetical rates are separate from the semiannual workbook case below.

MaturityAnnual par yieldAnnual coupon cash amountPrice
1 year4.00%₹4.00₹100
2 years4.50%₹4.50₹100
3 years5.00%₹5.00₹100

Step 1 — Find the 1-year spot rate

The 1-year bond pays ₹104 at maturity: ₹4 interest plus ₹100 principal. There are no earlier coupons.

100 = 104/(1 + s₁)
1 + s₁ = 104/100 = 1.04
s₁ = 4.0000%
D₁ = 100/104 = 0.961538462

The one-year par yield equals the one-year spot rate here because this annual-pay bond has only one payment date.

Step 2 — Find the 2-year spot rate

The 2-year bond pays ₹4.50 at year 1 and ₹104.50 at year 2. Discount the first coupon at the 1-year spot rate already found.

100 = 4.50/1.04 + 104.50/(1 + s₂)2
Known coupon value = 4.50/1.04 = ₹4.326923
Remaining present value = 100 − 4.326923 = ₹95.673077

95.673077 = 104.50/(1 + s₂)2
s₂ = (104.50/95.673076923)1/2 − 1
s₂ = 4.5113% per year
D₂ = 95.673076923/104.50 = 0.915531837

The 2-year spot rate is slightly above the 4.50% par yield. The early coupon is valued at the lower 4% spot rate, so the final payment requires a slightly higher rate to keep the total price at ₹100.

Step 3 — Find the 3-year spot rate

The 3-year bond pays ₹5 at years 1 and 2, and ₹105 at year 3. The first two discount factors are now known.

100 = 5D₁ + 5D₂ + 105D₃
Year-1 coupon PV = 5 × 0.961538462 = ₹4.807692
Year-2 coupon PV = 5 × 0.915531837 = ₹4.577659
Earlier coupons PV = 4.807692 + 4.577659 = ₹9.385351
Remaining present value = 100 − 9.385351 = ₹90.614649

90.614648509 = 105/(1 + s₃)3
s₃ = (105/90.614648509)1/3 − 1
s₃ = 5.0341% per year
D₃ = 90.614648509/105 = 0.862996652

All calculations retain full precision internally; displayed values are rounded.

The same calculation with one helper column

S = sum of previous discount factors. Add the factors once in this column, then use the same short formula in every row.

DF = (Price − Coupon × S)/(Face + Coupon)
Annual effective spot rate = DF−1/n − 1
Next row’s S = current S + current DF
Years nCoupon CPrevious-factor sum SDiscount factor DFSpot rate
1₹4.000.0000000000.9615384624.0000%
2₹4.500.9615384620.9155318374.5113%
3₹5.001.8770702980.8629966525.0341%

For example, the third row uses S = 0.961538462 + 0.915531837 = 1.877070298. Therefore DF = (100 − 5 × 1.877070298)/105 = 0.862996652. We add discount factors, not interest rates.

Check: do the spot rates reproduce the original prices?

1Y: 104D₁ = ₹100
2Y: 4.5D₁ + 104.5D₂ = ₹100
3Y: 5D₁ + 5D₂ + 105D₃ = ₹100

The spot curve is 4.0000%, 4.5113%, 5.0341%. In this rising example, the later spot rates exceed the corresponding par yields. A par yield is not a simple arithmetic average of spot rates: it is the coupon rate that makes the bond’s discounted cash flows equal its face value.

General formula and conventions
For annual payments: P = C(D₁ + … + Dₙ₋₁) + (F + C)Dₙ
Dₙ = (P − C × S)/(F + C)
sₙ = Dₙ−1/n − 1

For a par bond with annual par yield pₙ entered as a decimal:
C = F × pₙ
Dₙ = (1 − pₙ × S)/(1 + pₙ)

The numerator uses market price P for a general bond. Replace P with face F only when the bond is priced at par. If F = 100 and pₙ = 0.045, its annual coupon is 100 × 0.045 = ₹4.50, not ₹0.045.

For m coupon periods per year, use C = F × p/m, solve the discount factors at each coupon date, then convert to the nominal annual spot rate j(t) = m[D(t)−1/(mt) − 1]. For a real bond, use its settlement dirty price and actual remaining cash-flow schedule. Missing dates require an explicit interpolation assumption, sometimes solved jointly with the curve.

SECTION 03

The bridge: discount factors and spot rates

A discount factor D(t) is today’s value of one unit paid at time t. A spot rate discounts a single payment. A par yield sets the coupon rate of a hypothetical bond priced at face value. Yield to maturity is one internal rate for all of a particular bond’s cash flows.

Price = Σ cash flow(t) × D(t)
D(t) = exp[−rc(t) × t] = (1 + j(t)/2)−2t = (1 + yeff(t))−t

Here rc is a continuously compounded annual spot rate, j is a nominal annual spot rate with semiannual compounding, and yeff is the annual effective rate. This is continuous compounding for rc and a nominal annual rate with semiannual compounding for j. A yield curve plots consistently quoted rates against maturity. Clean price excludes accrued interest; dirty price includes it. Keep currency, credit basis, observation date and quotation convention consistent.

A discount factor is a value, not a percentage interest rate. For example, D(1) = 0.89 means one unit due in one year is worth 0.89 today. First solve the factors from cash flows; convert them to whichever rate convention is required afterwards.

SECTION 04

Zero-coupon bonds: the simplest starting point

A zero-coupon bond pays only its face value at maturity. There are no earlier coupons to strip, so its price immediately gives the discount factor.

DF = Price/Face
Continuous annual spot rate = −ln(DF)/t
Years tPrice per 100 faceDiscount factorContinuous spot
0.594.000.94000000012.3751%
189.000.89000000011.6534%
1.584.150.84150000011.5046%
279.770.79770000011.3011%

The illustrative zero-coupon prices are 94, 89, 84.15 and 79.77. The last two are rounded input prices in the reference demo. They form a separate illustration: do not force their factors to equal the more precise factors recovered from the coupon bonds below.

1Y example: DF = 89/100 = 0.89
Continuous spot = −ln(0.89)/1 = 11.6534%
Reprice: 100 × exp(−0.1165338163 × 1) = 89
SECTION 05

Coupon bonds: one helper column makes it simple

Each cash flow has its own date

Following the introductory slides, a 1.5-year bond paying 4 every half-year has these cash flows:

Payment date0.5Y1.0Y1.5Y
Cash flow44104
Present value4 × 0.944 × 0.89104 × unknown DF

Price = 4 × 0.94 + 4 × 0.89 + 104 × DF. The first two payments can already be valued; only the final payment’s discount factor is unknown.

Start with the two zero-coupon bonds

0.5Y: DF = 94/100 = 0.94
1.0Y: DF = 89/100 = 0.89
Previous-factor sum for the next bond = 0.94 + 0.89 = 1.83

Then use the same short formula for every coupon bond

Use one helper column: Sum of previous discount factors. For each new bond, this column already contains the factors for all earlier coupon dates. Multiply it by this bond’s coupon, subtract from the price, then divide by the final payment.

Discount factor = (Price − Coupon × Previous-factor sum) ÷ (Face + Coupon)
In short: DF = (P − C × S)/(F + C)
SymbolPlain meaning
PBond price, including accrued interest if applicable
CCash coupon paid each half-year, not the annual percentage
SSum of discount factors for dates BEFORE this bond’s maturity
FFace value repaid at maturity
Three steps for every row:
1. Read S from the helper column.
2. Calculate DF = (P − C × S)/(F + C).
3. Add this new DF to S to prepare the next row.

Start with S = 0. No earlier payments exist for the first bond. The next row’s helper value is simply previous S + previous DF. Add discount factors, never spot rates. This shortcut assumes regular shared coupon dates and a constant coupon amount for each bond; irregular cash flows need their individual present values.

SECTION 06

Set out the semiannual bond cash flows

Source: Coupon Bootstrap!A5:D9. All amounts are per 100 face. The coupons below are cash amounts paid every half-year, so 4 and 5 correspond to annual coupon rates of 8% and 10%.

MaturityFaceCoupon each half-yearPriceFuture cash flows
0.5Y100094.00100 at 0.5Y
1.0Y100089.00100 at 1Y
1.5Y100494.844, 4, 104
2.0Y100597.125, 5, 5, 105

Teaching assumptions: valuation on a coupon date, no accrued interest, regular six-month dates, and comparable credit and liquidity characteristics. These are workbook examples, not current market quotes.

SECTION 07

Solve each discount factor, then reprice

MaturityPrice PCoupon CPrevious-factor sum SDF = (P − C×S)/(100+C)
0.5Y94.0000.0000000000.940000000
1.0Y89.0000.9400000000.890000000
1.5Y94.8441.8300000000.841538462
2.0Y97.1252.6715384620.797736264

Read the table one row at a time

First row: S = 0, so DF = 94/100 = 0.94.
Next row: S = 0 + 0.94 = 0.94. The coupon is zero, so DF = 89/100 = 0.89.
1.5-year row: S = 0.94 + 0.89 = 1.83.
2-year row: S = 1.83 + 0.841538462 = 2.671538462.

1.5Y: DF = (94.84 − 4 × 1.83)/(100 + 4)
= (94.84 − 7.32)/104 = 0.841538462

2Y: DF = (97.12 − 5 × 2.671538462)/(100 + 5)
= (97.12 − 13.357692308)/105 = 0.797736264

The helper column does the adding once. The discount-factor formula stays identical in every row.

Check the answer with the same helper column

Repriced bond = C × S + (F + C) × DF
2Y bond = 5 × 2.671538462 + 105 × 0.797736264
= 13.357692308 + 83.762307692 = 97.120000

Reprice every bond using unrounded values; the difference from its market price should be zero apart from numerical rounding.

SECTION 08

Convert the factors into spot rates

Continuous: rc = −ln D(t)/t
Semiannual periodic: i = D(t)−1/(2t) − 1
Nominal annual, semiannual: j = 2i
Annual effective: yeff = D(t)−1/t − 1
MaturityD(t)Continuous annualNominal annual (SA)Annual effective
0.5Y0.94000000012.3751%12.7660%13.1734%
1Y0.89000000011.6534%11.9996%12.3596%
1.5Y0.84153846211.5016%11.8387%12.1891%
2Y0.79773626411.2989%11.6241%11.9619%

For the 1-year zero-coupon bond priced at 89, the same discount factor 0.89 gives 11.6534% continuous, 11.9996% nominal annual with semiannual compounding, or 12.3596% annual effective. Different quotations describe the same cash flow value.

These rates come from the coupon-bond case. The 1.5Y and 2Y zero-coupon prices in section 4 are rounded inputs in a separate example, so their rates differ slightly.

SECTION 09

Fill missing maturities with linear interpolation

w = (t − t₁)/(t₂ − t₁)
r(t) = r₁ + w × (r₂ − r₁) = (1 − w)r₁ + wr₂
SymbolMeaning
t₁, r₁Lower maturity and its rate
t₂, r₂Upper maturity and its rate; t₂ > t₁
tTarget maturity, with t₁ ≤ t ≤ t₂
wPosition within the interval; 0 ≤ w ≤ 1

The interpolation weight measures the fraction of the maturity interval travelled. A midpoint gets half the difference between the endpoint rates. Interpolate rates of the same type: par with par, or spot with spot.

Worked example: the 1.5-year par yield

Suppose we observe 1-year and 2-year par yields of 4.33% and 4.51%.

StepSubstitutionResult
Weight(1.5 − 1)/(2 − 1)0.5
Rate difference4.51% − 4.33%0.18 percentage points = 18 bp
Weighted increase0.5 × 0.18 percentage points0.09 percentage points = 9 bp
Estimated par yield4.33% + 0.09%4.4200%
Excel, exactly as in the guide:
=C16+(C19-C15)/(C17-C15)*(C18-C16)
Result: 4.4200%

The answer is a par-yield estimate, not a spot rate. The endpoints must have the same rate type, compounding convention and observation date. Estimating outside them is extrapolation.

Additional interpolation practice

Endpoint maturitiesEndpoint par yieldsTargetWeightEstimated par yield
0.5Y → 1Y4.23% → 4.33%0.75Y0.504.2800%
2Y → 3Y4.51% → 4.59%2.5Y0.504.5500%
3Y → 5Y4.59% → 4.64%4Y0.504.6150%
3Y → 5Y4.59% → 4.64%4.5Y0.754.6275%
1Y1.5Y2Y4.33%4.42%4.51%
The midpoint in maturity receives half of the 18 bp yield difference.
SECTION 10

Try it: interpolation laboratory

Rates are percentage inputs: enter 4.33 to mean 4.33%. Use the same rate type and compounding convention at both endpoints. The calculator rejects targets outside the two endpoints.

SECTION 11

Apply both methods to the Treasury par curve

Use the following five par-yield anchors. These five anchors match the official U.S. Treasury daily par-yield table for 6 November 2026. They are a dated teaching dataset, not live rates. The intermediate six-month par yields below are classroom interpolations, not additional Treasury observations.

MaturitySupplied anchor par yield
0.5Y4.23%
1Y4.33%
2Y4.51%
3Y4.59%
5Y4.64%

Construct hypothetical par bonds at every six-month maturity. Fill missing par yields by linear interpolation, then bootstrap the full schedule. This reconstruction is a classroom model, not a replication of the Treasury’s official curve-construction process.

At each maturity: C = 100 × par yield/2
D(0.5) = 100/(100 + 2.115) = 0.979288058
D(1) = [100 − 2.165 × 0.979288058]/102.165 = 0.958056491
1Y nominal spot (SA) = 2[D(1)−1/2 − 1] = 4.3311%

The 1Y spot rate is slightly above its 4.33% par yield because earlier coupons are discounted using the lower short-end rate in this example.

The complete ten-point classroom curve

YearsPar yieldPrevious-factor sum SDiscount factorNominal spot (SA)
0.54.2300%0.0000000000.9792880584.2300%
1.04.3300%0.9792880580.9580564914.3311%
1.54.4200%1.9373445480.9364882944.4227%
2.04.5100%2.8738328420.9145714824.5152%
2.54.5500%3.7884043250.8934869734.5561%
3.04.5900%4.6818912980.8725261204.5975%
3.54.6025%5.5544174180.8525594454.6098%
4.04.6150%6.4069768630.8329389434.6225%
4.54.6275%7.2399158060.8136603814.6354%
5.04.6400%8.0535761870.7947195394.6485%
Use the same helper column: DF = (100 − Coupon × S)/(100 + Coupon)
Next row’s S = this row’s S + this row’s DF
Nominal annual spot (semiannual) = 2 × (Dₙ−1/n − 1)

Each row uses its own par-bond coupon Cₙ = 100 × yₙ/2. S is zero for the first row. Rows at 0.5Y, 1Y, 2Y, 3Y and 5Y use the published anchors; all other par yields are interpolated. All ten hypothetical bonds reprice to 100 using unrounded discount factors.

Official Treasury observations: 6 November 2026. Treasury constructs its official curve from market inputs with monotone-convex forward interpolation; the table here is a simpler classroom reconstruction.

SECTION 12

Optional: interpolate a spot rate between curve nodes

Use this extension after you understand the par-yield bootstrap. It starts from an already constructed zero curve.

From your Q&A Interpolation tab, continuous spot rates are 11.65338163% at 1Y and 11.50157070% at 1.5Y. Estimate the 1.25Y spot rate:

r(1.25) = 11.65338163% + 0.5 × (11.50157070% − 11.65338163%)
= 11.57747616% continuous
D(1.25) = exp(−0.1157747616 × 1.25) = 0.865265873
PV of 100 due at 1.25Y = 86.526587

Interpolation directly on discount factors instead gives (0.89 + 0.841538462)/2 = 0.865769231. The results differ because discounting is nonlinear. Log-linear discount factors produce piecewise constant continuous forward rates; linear spot-rate interpolation is another assumption. State which variable you interpolate.

Why the interpolation variable matters

Method at 1.25YDiscount factorPV of 100
Linear continuous spot rate0.86526587386.526587
Linear discount factor0.86576923186.576923
Log-linear interpolation of discount factors0.86543008486.543008

For log-linear interpolation, D(t) = D(t₁)1−wD(t₂)w. The two endpoints are matched by every method; intermediate values and forward rates differ. Interpolation is a modelling assumption, not a new market observation.

SECTION 13

Excel implementation: the same helper-column method

Download the companion workbook

Every example in this guide, with live formulas: 1 Concept (one discount factor, three rate conventions), 2 Annual Coupon and 3 Semiannual Coupon (sequential formula, LINEST and MMULT/MINVERSE), 4 ZCB Bootstrap, 5 Coupon + LINEST and 6 Tsy Case (the U.S. Treasury par curve). Each sheet reprices its bonds with a ✔ check.

The manual method is the calculation. Excel simply repeats it accurately. The reference demo places maturity in B, the previous-factor sum in C and the new discount factor in D.

StepCell / formula in the reference layoutMeaning
Start the helper columnC21 = 0No earlier cash flows in the first row
First discount factorD21 =(E6-D6*C21)/(C6+D6)Price minus earlier coupon PV, divided by final cash flow
Next helper valueC22 =SUM($D$21:D21)Add the discount factors already solved
Next discount factorD22 =(E7-D7*C22)/(C7+D7)The same calculation with the next bond
1.5Y factorD23 =(E8-D8*C23)/(C8+D8)C23 = 1.83; answer = 0.841538462
Continuous spot rateE23 =-LN(D23)/B23Use maturity t = 1.5 years
Nominal annual spot (SA)F23 =2*(D23^(-1/(2*B23))-1)Two compounding periods per year
Reprice the 1.5Y bondH23 =D8*C23+(C8+D8)*D23Should equal its input price 94.84

In the input block B6:E9, B is maturity, C is face, D is coupon cash per half-year and E is price. Keep these input labels separate from the calculation-table headings above. For the helper column, C22=C21+D21 is equivalent to the expanding SUM formula; copy that recurrence down if it is easier to follow.

Optional check: solve all four factors with LINEST

Construct the four-bond cash-flow matrix with columns ordered 0.5Y, 1Y, 1.5Y, 2Y. The reference layout uses prices E6:E9 and cash flows C14:F17.

=LINEST(E6:E9,C14:F17,FALSE,FALSE)

The zero intercept means prices are explained entirely by discounted cash flows. Excel returns the factors in reverse column order: 2Y, 1.5Y, 1Y, 0.5Y, followed by a zero intercept. The four factors should match the sequential calculation. With an overdetermined or rank-deficient system, an exact unique fit is not assured.

SECTION 14

Try it: coupon-bond bootstrap laboratory

Want the full engine? The Bond Bootstrapping & Spot Rate Engine → builds the whole curve four ways: zero-coupon bonds, par bonds, a mixed set of bonds with interpolated coupon dates, and a LINEST least-squares fit. It shows annual, semiannual or continuous spot rates, forward and par curves, reprices every bond, and exports to Excel, Google Sheets or CSV.

Edit the two coupon-bond prices and coupon cash amounts; the first two zero-coupon prices remain 94 and 89. Repricing residuals are algebraic checks, not proof that the chosen quotes form a realistic market curve.

SECTION 15

Check your understanding and avoid common errors

1. Find the 4Y par yield between 3Y at 4.59% and 5Y at 4.64%.

Weight = (4−3)/(5−3) = 0.5. Yield = 4.59% + 0.5 × 0.05% = 4.6150%.

2. Is the 6Y yield estimated from those endpoints an interpolation?

No. Weight = 1.5 and straight-line yield = 4.6650%. It is extrapolation. FORECAST.LINEAR can extrapolate without a warning.

3. What is the continuous forward rate from year 1 to year 2?

Using workbook Treasury D(1) = 0.958056491 and D(2) = 0.914571482: ln[D(1)/D(2)]/(2−1) = 4.6451%. This is an implied forward rate, not a guaranteed future realised rate.

4. Must discount factors always decrease?

Positive discount factors are essential. Decreasing factors imply nonnegative forward rates; increasing factors can be consistent with negative rates. Do not treat monotonic decline as a universal no-arbitrage condition.

  • Do not discount every coupon using a final-maturity spot rate.
  • Do not confuse a half-year coupon amount with an annual coupon percentage.
  • Do not mix par yields, yield to maturity and spot rates as if they were the same.
  • Use dirty price at settlement, actual coupon schedules, day counts and accrued interest for real bonds.
  • Linear interpolation creates slope changes at nodes and can cause discontinuities in implied forwards. More sophisticated methods need checks too.
  • Bootstrapped curves depend on instrument selection, liquidity, credit basis and the interpolation rule. Collateral discounting and reference-rate projection may require separate curves.
SECTION 16

Recap: a repeatable five-step method

  1. Write every cash flow at its payment date.
  2. Start with the shortest maturity and solve its discount factor.
  3. For the next bond, multiply its coupon by the sum of earlier discount factors.
  4. Subtract that known coupon value from the price; divide by face plus final coupon.
  5. Convert the factor into a spot rate and reprice the bond to check the result.
Keep the three jobs separate:
Interpolation fills a missing curve point under an assumption.
Bootstrapping extracts discount factors from instrument prices.
Rate conversion expresses each factor in a chosen compounding convention.

Teaching basis: the supplied introductory slides and demonstration workbook, used as reference material. Numerical illustrations are shown directly in this article.

U.S. Treasury: dated par-yield observations · Treasury curve methodology · Microsoft: LINEST

Explore the Term Structure of Interest Rates →

SECTION 17

Vocabulary

Key words in this article link directly to these definitions. Use the back link after a definition to return to the term you clicked.

Bootstrapping
Recovering discount factors sequentially from instrument prices and cash flows. ↑ In the article
Linear Interpolation
Estimating a value inside two observed points using a straight line. ↑ In the article
Extrapolation
Estimating beyond the range of the observed maturity endpoints. ↑ In the article
Discount Factor
The present value of one currency unit paid at a specified future date. ↑ In the article
Spot Rate
The rate from today to one future payment date; its quotation must specify compounding. ↑ In the article
Par Yield
The annual coupon rate that makes a hypothetical bond worth its face value. ↑ In the article
Yield To Maturity
The single internal discount rate that equates a bond’s cash flows to its price. ↑ In the article
Cash Flow
A coupon, principal repayment or other payment at a specified date. ↑ In the article
Coupon
The interest cash payment promised by a bond; distinguish payment amount from annual rate. ↑ In the article
Face Value
The principal amount repayable at maturity, also called par value. ↑ In the article
Maturity
The time or date at which an instrument’s final principal payment is due. ↑ In the article
Basis Point
One hundredth of a percentage point: 1 bp = 0.01% = 0.0001 in decimal rate units. ↑ In the article
Continuous Compounding
A quotation convention with accumulation exp(rt) and discounting exp(−rt). ↑ In the article
Semiannual Compounding
Two compounding periods per year; a nominal annual rate j has periodic rate j/2. ↑ In the article
Annual Effective Rate
The rate expressing the equivalent growth over one year, including compounding. ↑ In the article
Nominal Annual Rate
An annualised quotation paired with a frequency; it is not itself the annual effective return. ↑ In the article
Forward Rate
A rate implied today for a future interval by the ratio of discount factors. ↑ In the article
Repricing
Recomputing input instrument values using the constructed curve to compare them with input prices. ↑ In the article
LINEST
Excel’s linear least-squares function; here used with zero intercept to solve a full-rank cash-flow system. ↑ In the article
Cash-Flow Matrix
A table with instruments as rows, payment dates as columns and payments as entries. ↑ In the article
Dirty Price
The settlement price including accrued interest. ↑ In the article
Accrued Interest
Coupon interest earned since the previous coupon date under the applicable day count. ↑ In the article
Day Count
The convention converting calendar dates into accrual year fractions. ↑ In the article
Log-Linear Interpolation
Linear interpolation of log discount factors; between nodes this implies a constant continuous forward rate. ↑ In the article
Zero-Coupon Bond
A bond paying no interim coupons; its price directly identifies its maturity discount factor. ↑ In the article
Interpolation Weight
The fraction (t−t₁)/(t₂−t₁) travelled between two maturity endpoints. ↑ In the article
Clean Price
A quoted bond price excluding accrued interest; clean price plus accrued interest equals dirty price. ↑ In the article
Yield Curve
A relationship between maturities and consistently defined yields on an observation date. ↑ In the article