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!