Built a Deal Analysis Spreadsheet with Scoring System – Looking for Input

[Matt Preddice]

Hey everyone,

I’ve been working on a deal analysis spreadsheet and wanted to share it here to get some feedback from others actively analyzing or buying deals.

The main feature I built into it is a 1–100 scoring system designed to standardize how deals are evaluated across different property types. It takes core metrics, cash-on-cash return, cash flow, DSCR, cap rate, and rent-to-expense margin, and converts them into a weighted score so everything can be compared on the same scale.

The idea is to create a consistent framework where a small single-family property and a larger multifamily deal can be evaluated side-by-side without relying on any one metric in isolation. Instead of focusing on just cash flow or just cap rate, the score attempts to reflect overall deal quality by balancing return, risk, and margin.

Each component is weighted (with CoCR and cash flow carrying the most influence), then combined into a final score capped at 100. It’s meant to function as a filtering and ranking tool to quickly identify stronger opportunities before diving deeper.

Would appreciate any general constructive criticism, whether that’s around the metrics chosen, weighting, assumptions, or anything you’d approach differently based on your experience. If anyone has built something similar or uses a different framework, I’d be interested in how you structure your analysis as well.