Owner Financing Analysis Spreadsheet

[Snehann Kapnadak]

Happy New Year everyone!

Does anyone have an Excel spreadsheet for analyzing seller-financed deals? I'd want to be able to do a quick analysis that includes the following:

• Agreed-upon purchase price
• Finance details: amount the seller would carry back vs. the amount the sponsor brings to the table, interest rate, term length, etc.
• Monthly payment amount we would owe to the seller
• Balloon payment owed to the seller at the end of financed period
• Refinance details (ARV, long-term debt interest rate and term length, LTV ratio, etc.)
• Cash on cash return during the financed period

I'm creating one but I'm not sure if I have the formulas to make sure that I have the formulas correct, so I wanted to double check. I couldn't find anything on FilePlace either. I'd be happy to share my final spreadsheet when it's ready if anyone wants that.

Thanks in advance!

[Farrukh Amini]

I use one that I made very specific to my own needs (I buy and sell on terms). Happy to share with you. Not sure if you’ll like it because it doesn’t provide some of your criteria.