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