Equipment Leasing & Finance: Lessor Yield, Residual Value & Lease-vs-Loan
Price equipment leases like a lessor: payments with residuals in advance, implicit yield with fees, residual risk, after-tax lease vs loan vs cash, credit loss and margin, portfolio concentration, payoff quotes and end-of-term options, on live auto-graded spreadsheets.
The first lesson is free — no account needed.
About this course
An equipment leasing and finance course that prices the deals of one fictional lessor, Kestrel Ridge, for leasing analysts, credit staff, equipment sales teams and business owners deciding how to pay for machinery. You quote the monthly payment of a 60-month excavator lease from cost, residual value and rate with payments in advance, work out the lessor's implicit yield with RATE after fees and direct costs, test how the yield moves with the resale price, compare buying a tractor with cash, with a loan and with a lease on an after-tax NPV basis, estimate the expected credit loss and margin per deal, summarise a 14-lease portfolio by industry with SUMIFS, calculate an early payoff quote and choose between returning, renewing and buying out at fair market value. Illustrative numbers, not investment, tax or accounting advice. The first lab is free.
Lessons
- Price a Lease: Payment from Cost, Residual & RateFree
- The Lessor's Implicit Yield with RATE, Fees & Direct Costs Pro
- Residual Value Risk & Yield Sensitivity Pro
- Customer View: Lease vs Loan vs Cash Purchase (After-Tax NPV) Pro
- Credit Loss & the Pricing Margin per Deal Pro
- Portfolio Yield & Industry Concentration with SUMIFS Pro
- Early Termination: the Payoff Quote Pro
- End-of-Term Options: Return, Renew or Buy Out at FMV Pro