The risk/reward here sounds pretty far skewed.

Even better, I would like to make it into a heat map with blue pins being lower numbers and red pins being higher numbers.My questions to you all: Does anything like this exist?

Currently, agents aren’t significantly rewarded for showing rental properties to potential tenants.

You can either buy an existing property or flip a building and then rent it out.

I can help run their existing numbers to get more of an idea of the Business's Financials and work with you on how a loan payment would affect cash flows. 

My knowledge in that area is virtually non-existent.

Ask me privately.Financial Highlights- Gross Potential Rent: $98,061 per month ($1,176,732 annually)- Total Income (5/1/2023-4/30/2024): $1,357,459.80- Net Operating Income: $896,896.09- Existing assumable loan: $6.7M at 5.38% fixed rate until 2029Value-Add Opportunity- Partially renovated property with potential for further upgrades- Current loss-to-lease suggests room for rent growth- Opportunity to implement operational efficienciesMarket Dynamics- Huntsville's population grew 9.4% between 2020 and 2023- Strong job growth, particularly in aerospace and defense sectors- Significant multifamily supply growth (15.9% inventory expansion in past year)Investment Strategy- Assume existing favorable financing- Implement value-add renovations to drive rent growth- Capitalize on Huntsville's robust economic expansion- Target hold period: 3-5 years to align with loan maturityRisks and Considerations- High market-wide vacancy rate (17%) due to recent supply growth- Potential for market softening due to rapid inventory expansion- Property age may require significant capital expendituresThis opportunity offers a blend of stable cash flow from the existing operations and upside potential through strategic improvements, all underpinned by Huntsville’s strong economic fundamentals.ⓘ This is not an offer, solicitation of an offer, to buy or sell securities.

Any deductions should be the same for existing resales vs new construction. 

Yes. build to rent in urban core adjacent neighborhoods. traditionally in our market in Columbus Ohio existing inventory was good 2014-2020. as prices rose, the cost to build started to match existing inventory prices because of supply shortage, especially for 2-4 multiunit dwellings. around that time we started to look at new construction and land. we found that land is a 12 month or more supply in our market which makes it a buyers market and you can design any structure you want in new construction. if you like a layout or floorplan all you have to do is design it. after that we looked at the right unit mix and Floorplans and layouts. we started looking at high rent per square foot layouts that were better than single family.

The ratio above works anywhere.Step2 "Existing":Ineach town count the number of units by size.