May 13 (edited) • General discussion
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
5. Local Market Context
- **Average Asking Price:** £737,490
- **70th Percentile Range:** £535,000 - £1,000,000
- **Asking Price Per Sqft:** £507
- **Comparables:**
1. [£650,000 - Semi-detached, 4 Bed](URL) 2. [£825,000 - Semi-detached, 4 Bed](URL) 3. [£1,250,000 - Detached, 4 Bed](URL)
6. Energy Performance
- **EPC Rating:** D
- **Numeric Score:** 64
- **Upcoming Compliance Risks:** Data unavailable
7. Investment Appraisal
- **Acquisition Costs (Stamp Duty):** £20,000
- **Financials:**
| Metric | Value | | ------------ | ------------- | | Monthly Rent | £727 | | Annual Rent | £37,804 | | Gross Yield | 4.1% | | Net Yield | Data unavailable | | ROI (Yr 1) | Data unavailable |
8. Comparable Sales
- **Recent Sales:**
1. Address:1, The Elms, SG13 7UY- £575,000 (March 2024) 2. Address:17, Honeysuckle Close, SG13 7TQ- £730,000 (Sep 2023) 3. Address:14, Tamworth Road, SG13 7DD- £875,000 (Aug 2023)
9. Development & Uplift Potential
- **Value Uplift Options:** None identified
10. Risk Factors
- **Bullet Risks:** Data unavailable
11. Final Recommendation
- **Verdict:** ⚠️ Review
- **Summary:** The property presents a fair investment opportunity with potential for improvement in rental yield. Further evaluation on rental performance recommended.
1
1 comment
Finally starting to get somewhere with my property/ real estate valuation model
Suggested communities
Powered by