To calculate the implicit interest rate in a lease, you solve for the single discount rate that makes the present value of the lease payments plus the present value of the unguaranteed residual value equal the asset’s fair value plus the lessor’s initial direct costs. There is no closed-form algebra for it. You feed the four inputs into a spreadsheet’s RATE or IRR function and let it iterate to the answer.
What the Rate Actually Solves For
The implicit rate is the return baked into the lease from the lessor’s side, and the true financing cost from the lessee’s side. Both U.S. GAAP and IFRS define it the same way. IFRS 16 calls it “the rate of interest that causes the present value of (a) the lease payments and (b) the unguaranteed residual value to equal the sum of (i) the fair value of the underlying asset and (ii) any initial direct costs of the lessor.”1IFRS Foundation. IFRS 16 Leases ASC 842 uses essentially the same definition, with a minor adjustment allowing the fair value to be reduced by any investment tax credits the lessor retains.
In equation form:
Present value of lease payments + Present value of unguaranteed residual value = Fair value of the asset + Lessor’s initial direct costs
Because the rate appears in the discounting on the left side, isolating it algebraically is not possible. You test rates until both sides match, which is what a spreadsheet function does in the background.
The Four Inputs You Need
Each input comes from the lease agreement, the lessor’s records, or a valuation report. An error in any one of them flows straight into the result.
Fair Value of the Asset
Fair value is what the asset would sell for in an arm’s-length transaction at the lease commencement date. For new equipment, the invoice price usually stands in for fair value. Used assets and sale-leaseback transactions often need a formal appraisal. This figure anchors the right side of the equation.
Lease Payments and Their Timing
Pull the exact payment amount and schedule from the contract. Monthly and quarterly schedules are most common, but some commercial leases pay annually. You also need to know whether payments fall at the beginning of each period (annuity due) or the end (ordinary annuity). That single distinction shifts every cash flow by one period and changes the resulting rate.
Unguaranteed Residual Value
The residual is what the lessor expects the asset to be worth at lease end, and it usually appears in the purchase-option clause or a valuation exhibit. Only the unguaranteed portion enters the implicit rate formula. If the lessee guarantees part of the residual, that guaranteed piece is already treated as part of the payment stream.2IASB/FASB Joint Meeting February 17-18, 2010. Definition of Interest Rate Implicit in the Lease So a $20,000 expected residual with a $5,000 lessee guarantee means $15,000 goes into the formula as the unguaranteed residual, and the $5,000 is folded into the payments.
Lessor’s Initial Direct Costs
Initial direct costs are incremental expenses the lessor would not have paid if this lease had never been signed. Broker commissions tied to closing the deal are the classic example. Costs the lessor would have owed either way do not qualify: legal fees for drafting the agreement, credit-check charges, fixed employee salaries, general overhead, and the cost of soliciting potential lessees are all excluded.
These costs are often small relative to fair value and move the rate only slightly. When they are material, they raise the lessor’s net investment and push the implicit rate a little lower than it would otherwise be.
Running the Calculation in a Spreadsheet
The fastest route is the RATE function in Excel or Google Sheets. It iterates through trial percentages until the present value of the cash flows nets to zero.
RATE Function Arguments
The syntax is RATE(nper, pmt, pv, [fv], [type], [guess]).3Microsoft Support. RATE Function For an implicit rate calculation:
- nper is the total number of payment periods. A five-year lease with monthly payments is 60.
- pmt is the periodic payment. Its sign must be opposite to pv, because the two flows move in opposite directions.
- pv is the fair value of the asset plus initial direct costs, entered as a negative number to represent the lessor’s outflow at commencement.
- fv is the unguaranteed residual value the lessor expects to recover at the end of the term, entered as a positive number.
- type is 0 for payments at the end of each period and 1 for payments at the beginning. Left blank, it defaults to 0.
- guess is an optional starting estimate. Excel starts at 10% if you omit it. A closer guess helps the function converge on unusual cash flow patterns.
A Worked Example
A lessor signs a five-year lease on equipment with a fair value of $100,000. Payments are $1,900 per month, due at the end of each month. The lessor expects the equipment to be worth $10,000 at lease end, all unguaranteed, and paid $2,000 in broker commissions to close the deal.
The formula is: =RATE(60, 1900, -(100000+2000), 10000, 0)
RATE returns a monthly rate. Multiply by 12 for the nominal annual rate. For the effective annual rate, use (1 + monthly rate)^12 – 1. The gap between the two widens as the rate rises, so confirm which version your accounting team wants before reporting it.
When Payments Are Uneven: Use IRR
RATE assumes a constant payment. If your lease has step-ups, skipped periods, or any other irregular schedule, RATE will not work. Lay every cash flow out in a column instead: the lessor’s net investment as a negative number in the first cell, each payment in the following cells, and the residual added to the final payment. Run IRR on the range. IRR returns the periodic rate directly.
Common Errors and How to Fix Them
The most frequent problem is a #NUM! error where the rate should appear. That means Excel hit its iteration limit without converging.4Microsoft Support. How to Correct a NUM Error Usual causes:
- Payments and present value entered with the same sign. They must be opposite.
- Residual value omitted when it is material.
- Inputs that simply cannot produce a valid rate, such as payments too small to ever repay the asset’s value.
- Numbers entered with dollar signs or commas inside the formula. Use plain, unformatted figures.
You can also raise the ceiling under File > Options > Formulas by checking “Enable iterative calculation” and increasing the maximum iterations. Providing a guess closer to your expected rate often solves it without changing settings.
The other quiet mistake is leaving type at 0 when the lease pays at the start of each period. That single-digit change shifts every cash flow back one period and can move the annual rate meaningfully on a large lease.
If You Are the Lessee, You Probably Cannot Compute It
One boundary worth flagging. The implicit rate depends on the lessor’s fair value, residual expectations, and internal deal costs. Lessees rarely have that information. Under ASC 842 and IFRS 16, the standards recognize this and require lessees to use the implicit rate only when it is “readily determinable.” When it is not, the lessee falls back to its incremental borrowing rate, meaning the interest it would pay to borrow a similar amount over a similar term with similar collateral. Non-public companies applying ASC 842 have an additional option: a risk-free rate such as a U.S. Treasury yield matched to the lease term, applied as a consistent policy election by asset class. The risk-free rate is simpler but always lower than a borrowing rate, so it produces a larger lease liability.
If you are running the implicit rate calculation as a lessor, or as a lessee with unusually complete information about the transaction, the four-input method above is the calculation. If you are a lessee working from a signed contract and nothing else, the number you need is almost certainly your incremental borrowing rate, not the implicit rate.