P2P Lending & Crowdfunding Returns: Defaults, Diversification & Net Yield
Build a loan-grade rate card, model the cash flows of an amortising note with PMT, price expected loss by grade, get from gross interest to net yield, measure diversification with BINOM.DIST, compute a 50-loan IRR and XIRR, value recovery timing and chart an equity crowdfunding outcome distribution, every cell checked live. Fictional platform, educational only, not investment advice.
The first lesson is free — no account needed.
About this course
A P2P lending and crowdfunding returns course for retail investors and finance students who want to see past the headline rate, built on one fictional platform in a spreadsheet. You build a loan-grade rate card and your amount-weighted rate, split the monthly PMT payment of an amortising note into interest and principal, turn the headline rate of each grade into a default-adjusted return and find the break-even default rate, go from gross interest to net yield after servicing fees, late fees, charge-offs and recoveries, measure with BINOM.DIST how many loans you need before a loss becomes unlikely, compute the real return of a 50-loan portfolio with IRR and XIRR, compare recovery routes by present value and chart where an equity crowdfunding portfolio's expected multiple comes from. Simplified models, educational only, not investment advice. The first lab is free.
Lessons
- Loan Grades & Interest Rates: Build the Rate Card, Price Your LoansFree
- Amortising Loan Cash Flows to the Investor: PMT and the Schedule Pro
- Expected Loss & Default-Adjusted Return by Grade Pro
- Net Yield after Platform Fees, Late Fees and Charge-Offs Pro
- Diversification: the Chance of a Loss with N Loans (BINOM.DIST) Pro
- Your Real Return: IRR and XIRR of a 50-Loan Portfolio Pro
- Recoveries & Collections: Why Timing Changes the Loss Pro
- Equity Crowdfunding: Outcome Distribution and Where the Value Comes From (Chart) Pro