Amortising Loan Cash Flows to the Investor: PMT and the Schedule
This lesson is part of the course
In this lesson
You calculate the monthly payment on your note with PMT, split each payment into interest and principal for the first year and total the interest you receive.
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
- Loan Grades & Interest Rates: Build the Rate Card, Price Your Loans Locked
- Amortising Loan Cash Flows to the Investor: PMT and the Schedule Locked
- Expected Loss & Default-Adjusted Return by Grade Locked
- Net Yield after Platform Fees, Late Fees and Charge-Offs Locked
- Diversification: the Chance of a Loss with N Loans (BINOM.DIST) Locked
- Your Real Return: IRR and XIRR of a 50-Loan Portfolio Locked
- Recoveries & Collections: Why Timing Changes the Loss Locked
- Equity Crowdfunding: Outcome Distribution and Where the Value Comes From (Chart) Locked