Get contract and Dollars.Assume the life of a billboard is X.Cash flow the revenue stream.Get a cost estimate to build the type of billboard you're thinking.Run your Revenue and cost for the above and see what the return is. 

My estimate is that maybe 1 out of 10 “normal” properties are not redeemed.  

Here are some basic facts:Initial cash invested: $120kYear 1 Cash Flow: $12.3kYear 2 Cash Flow: $8.6kYear 3 Cash Flow (YTD, 3 months left in year): -$4.5kCurrent equity estimate (net of expected selling costs): $102KMortgage rates at or below 3.75%CapEx uncertainty: HVACs will likely require replacement within the next 5 years and one of the  roofs is nearing 20 years old.Market is the Huntsville, AL area.Underwriting hurdle when acquiring these properties was 10% CoC return annually.With a 10% CoC return after Year 1, I felt good about this investment.

Should there be a recession I'm estimating that I'll drop from 75-80% occupancy down to around 40-50%.

(any feedback on that estimate is appreciated BTW).

If your market has a significant number of FHA or VA loans with zero to low down payments where a buyer can't afford to pay their agent out of pocket, your sellers may end up cutting off a significant portion of the home buying market, or once they do come around to considering negotiating on BAC, they may feel deceived, and now you may lose the potential for the recurring client that will ultimately otherwise drive your seller lead acquisition cost down.For planning: In a great business, a good rule of thumb is to estimate:100% Gross Income35% Cost of Sale30% Expenses35% Profit <-- very few businesses achieve this, but we're looking at an ideal solutionAssuming a national price average of $300k and 0.6% GCI, you'd be looking at:$1,800 Gross Income$630 Cost of Sale <-- agents/ transaction coordinators$540 Expenses <-- photos/ signs/ lockboxes/ Errors & Omissions insurance/ MLS fees/ liability insurance/ tech fees/ VA admin support/ marketing to get clients for the business (this piece should be roughly 10% of revenue, which would be $54 in this case)$630k ProfitIf your business sold 1,000 of these homes a year, you would have:$1,800,000 Gross Income$630k Cost of Sale <-- agents/ transaction coordinators (you could have 5 agents handling 200 sales each at $100k incomes and TC support at scale)$540k Expenses <-- photos/ signs/ lockboxes/ Errors & Omissions insurance/ MLS fees/ liability insurance/ tech fees/ VA admin support/ marketing to get clients for the business (you're going to est $125k in runner fees alone for signs; $25k+ in signs, $54k in ads to attract clients, $200k in photos, $10-20k minimum in E&O, $2k in liability, and what tech/ VA support)$630k Profit Scale costs will include hiring a managing broker for compliance to help oversee all of these transactions and implement legal changes and training.

Pittsburgh's current population is 302,000 (US census estimates 2024) whereas in 1950 it was 676,000. 

The engineer can help with this estimate, but local contractors are the top source for getting this info. 

This means, you will either over purchase the system (too many panels, batteries, etc) or under estimate, both making the outcome not optimal. 

If that's the case and you aren't viewing more properties in person than you are making spreadsheets on, you are destined for analysis paralysis.Spreadsheets can only tell you estimations based on numbers given to you online or by a real estate agent whose job is to sell the property.