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!