Portfolio Yield & Industry Concentration with SUMIFS
This lesson is part of the course
In this lesson
You summarise Kestrel Ridge's 14 leases by industry and measure the portfolio's yield and concentration.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Price a Lease: Payment from Cost, Residual & Rate Locked
- The Lessor's Implicit Yield with RATE, Fees & Direct Costs Locked
- Residual Value Risk & Yield Sensitivity Locked
- Customer View: Lease vs Loan vs Cash Purchase (After-Tax NPV) Locked
- Credit Loss & the Pricing Margin per Deal Locked
- Portfolio Yield & Industry Concentration with SUMIFS Locked
- Early Termination: the Payoff Quote Locked
- End-of-Term Options: Return, Renew or Buy Out at FMV Locked