Finally starting to get somewhere with my property/ real estate valuation model
Hey guys I have literally been pulling my hair out with this automation I’ve been working on. But finally just now feels like we are getting a breakthrough. It might not be complicated to some of the wizards on here but it’s my first automations and been a strong learning curve. But and the big bit is we now have multiple tools connected to an api call that then draws all The relevant data on a particular property here in the uk and I have finally managed to send this data in to an agent to provide an investment summary on that property.It’s now time to deep dive into what outputs I want and how I get the inputs into the system for analysis. Right now though I’m having a beer and relax for the rest of the day. That was harder than i thought it was gonna be…🍺🍻 1. Executive Summary - **Estimated Value:** £875,000 - **Last Sold Price/Date:** £615,000 on 9 Nov 2023 - **Rent Estimate:** £727/week - **Gross Yield:** 4.1% - **EPC Rating:** D (64) - **Property Type:** Detached House, 4 Bed, 2 Bath - **Verdict:** ⚠️ Review - **Reasoning:** The estimated value is promising, but the gross yield is slightly below average. Further review recommended. 2. Property Overview - **Address:** 88, THE ELMS, HERTFORD, HERTFORDSHIRE, SG13 7UX - **UPRN:** 100080740583 - **Classification:** Detached - **Construction Date:** Data unavailable - **Internal Area:** 1066 sqft - **Habitable Rooms:** 7 - **Outdoor Space:** Garden - **Parking:** Data unavailable - **Tax Band/Amount:** F / £3,379 - **Tenure:** Freehold - **Use Class:** Class C3 3. Capital Value Analysis - **Estimated Value:** £875,000 ± £55,000 - **Last Sold Price:** £615,000 - **Price Per Sqft:** £516 - **Average Sold Price:** £823,140 - **70th Percentile Sold Range:** £710,000 - £915,000 4. Rental Analysis - **Single Let:** - **Estimated Rent:** £727/week - **Market Average:** £584/week - **Range:** £508 - £762/week - **Gross Yield:** 4.1% - **HMO (if present):** - **HMO Rent/Month:** Data unavailable - **HMO Sale Value:** Data unavailable - **HMO Gross Yield:** Data unavailable