Looking for an Excel Template to Simulate Note Loan Investments?

[Sebastian Geiman]

Hey everyone,

I'm currently exploring note loan investments and looking to take a deeper dive into simulating different scenarios with variables like origination fees, interest rates, and exit fees. What I'm hoping for is an Excel or spreadsheet template that allows me to play around with these variables and, most importantly, calculates the IRR and TIR for each scenario.

Does anyone have a board or Excel sheet they use for this kind of investment simulation? I'd love to share and compare ideas, and possibly improve on my calculations.

Looking forward to your feedback!

[Alex Booth]

I agree with Chris and Don. Last year, I built a note investing calculator and kept tweaking it as I learned more. I'm no Excel expert, but it helps guide my capital allocation decisions. Don makes a good point: focusing too much on numbers can make you overlook risks and pitfalls—not just in notes, but in any investment.

I've got a spreadsheet I'd be happy to share. Personally, I learn best by diving in, so I'd suggest starting small—maybe buy a land note or a partial—to get hands-on experience with minimal risk.

For reading, I'd recommend "Invest in Debt" by Jimmy Napier. Also, the JKP Holdings podcast is great for on-the-go learning.