Prototype. Every figure on this page is illustrative. The register holds 8 sample assets from the MoPED data-model workbook and 112 generated to match its schema — no real asset, valuation or coordinate.
Shop Unit No. 2 — New Alamein
MTR-RTL-0027 · Matrouh
Shop Unit No. 2 — New Alamein
16 Port Said Street, New Alamein, El Alamein, Matrouh
Retail unit · Standalone · Ministry of Awqaf (Endowments)
Seasonality means the occupancy assumption should be split summer/winter.
Market value
EGP 9.1m
book value EGP 3.2m
Value after renovation
EGP 13.2m
scope: Full gut renovation
CapEx
EGP 8.1m
over 23 months
Net operating income
EGP 1.3m
on EGP 1.8m gross revenue
Gross yield
13.9%
clears the 12% hurdle
Revenue gap
EGP 1.3m
against EGP 0 earned today
Recommendation
Highest & best use
Commercial / retail
Monetization route
Securitize / REIT contribution
Payback
6.4yrs
Vacant
1yrs
Monthly rent equiv.
EGP 151,171
Assumed occupancy
71%
Blockers
None material recorded.
Location
- Coordinates
- 30.8465, 28.9539
- Main road / transport
- 0.9 / 4.4 km
Estimated valueSimulated
Back-cast from today's valuation at the Assumptions sheet's inflation rate plus governorate drift.
Condition scoreSimulated
Decay rate follows the recorded utilization status; the final point is today's rating.
A. Identification & Ownership
14- Asset IDasset_id
- MTR-RTL-0027
- Asset Name (EN)asset_name_en
- Shop Unit No. 2 — New Alamein
- Asset Name (AR)asset_name_ar
- محل رقم ٢ — العلمين الجديدة
- Custodian Entitycustodian_entity
- Ministry of Awqaf (Endowments)
- Custodian Sub-Unit / Directoratecustodian_sub
- Property Office
- Ownership Typeownership_type
- State freehold (ملكية خاصة للدولة)
- Title / Registration Statustitle_status
- Registered (مسجل)
- Real-Estate Registry No.registry_no
- 2002/4354
- Asset Classasset_class
- Retail unit (وحدة تجارية)
- Asset Sub-Typeasset_subtype
- Standalone
- Current Usecurrent_use
- Production halted
- Utilization Statusutilization_status
- Under construction (تحت الإنشاء)
- Years Vacant / Underusedvacancy_years
- 1
- Occupied By / Encumbrancesoccupied_by
- One government directorate, part of the floor area
B. Location & Geospatial
14- Governorategovernorate
- Matrouh
- City / Markazcity
- El Alamein
- District / Neighbourhooddistrict
- New Alamein
- Full Address (EN)address_en
- 16 Port Said Street, New Alamein, El Alamein, Matrouh
- Full Address (AR)address_ar
- ١٦ شارع بورسعيد، العلمين الجديدة، العلمين، مطروح
- Latitudelatitude
- 30.846456
- Longitudelongitude
- 28.953884
- Plot / Block No.plot_no
- Plot 430
- Zoning Classificationzoning
- Mixed-use
- Distance to Main Road (km)dist_main_road
- 0.91
- Distance to Transport Node (km)dist_transport
- 4.40
- Catchment Population (000s)catchment_pop
- EGP 159
C. Physical Characteristics
11- Built-Up Area / BUA (m2)bua
- 570 m²
- Gross Leasable Area (m2)gla
- 520 m²
- Number of Floorsfloors_count
- 1
- Number of Unitsunits_count
- 8
- Year Builtyear_built
- 2,018
- Building Age (yrs)building_ageƒ
- 8
- Structure Typestructure_type
- Reinforced concrete
- Finishing Levelfinishing_level
- Fully finished - standard
- Utilities Connectedutilities
- Water only
- Heritage-Listed?heritage_listed
- No
D. Internal Division & Layout
9- Internally Divided?has_internal_division
- No
- Number of Roomsrooms_count
- 0
- Number of Bathroomsbathrooms_count
- 0
- Reception / Hallsreception_count
- 1
- Kitchenskitchens_count
- 1
- Open-Plan Area (m2)open_plan_area
- 540 m²
- Partition Flexibilitypartition_flexibility
- High - open plan, easily partitioned
- Parking Spacesparking_spaces
- 6
- Layout Noteslayout_notes
- Clear-span shed with loading docks and a small office annex.
E. Condition & Renovation
9- Physical Conditioncondition_rating
- Derelict
- Condition Notes (EN)condition_notes_en
- Abandoned for over a decade; interior stripped, structure requires full assessment.
- Condition Notes (AR)condition_notes_ar
- مهجور لأكثر من عقد؛ تم تجريد الداخل ويحتاج الهيكل لتقييم شامل.
- Renovation Required?renovation_required
- Yes
- Renovation Scoperenovation_scope
- Full gut renovation
- Renovation Cost (EGP/m2)reno_cost_sqm
- 14,200 m²
- Est. Renovation Cost (EGP)reno_cost_totalƒ
- EGP 8,094,000
- Renovation Duration (months)reno_duration_months
- 23
- Licensing / Compliance Statuscompliance_status
- Fully licensed
F. Valuation
8- Valuation Methodvaluation_method
- Comparable sales (المقارنة)
- Building Value (EGP/m2)building_value_sqm
- EGP 16,000
- Est. Market Value (EGP)market_valueƒ
- EGP 9,120,000
- Value After Renovation (EGP)value_post_renoƒ
- EGP 13,224,000
- Government Book Value (EGP)book_value
- EGP 3,200,000
- Valuation Datevaluation_date
- 1 Sept 2026
- Valuation Sourcevaluation_source
- Local office lease comparables
G. Income & Rental Potential
11- ADR - Residential (EGP/day)adr_residential
- EGP 0
- ADR - Commercial / Retail (EGP/day)adr_commercial
- EGP 7,000
- ADR - Office (EGP/day)adr_office
- EGP 0
- ADR Applied (EGP/day)adr_applicableƒ
- EGP 7,000
- Assumed Occupancy Rateoccupancy_rate
- 71.0%
- Gross Annual Revenue (EGP)gross_annual_revenueƒ
- EGP 1,814,050
- Monthly Rent Equivalent (EGP)monthly_rent_equivƒ
- EGP 151,171
- Annual Operating Cost (EGP)annual_opex
- EGP 544,215
- Net Operating Income (EGP)noiƒ
- EGP 1,269,835
- Gross Yield (%)gross_yieldƒ
- 13.9%
- Renovation Payback (yrs)reno_payback_yearsƒ
- 6.37
H. Utilization Gap & Monetization
7- Current Actual Income (EGP/yr)current_annual_income
- EGP 0
- Annual Revenue Gap (EGP)revenue_gapƒ
- EGP 1,269,835
- Highest & Best Usehighest_best_use
- Commercial / retail
- Recommended Monetization Routemonetization_option
- Securitize / REIT contribution
- CapEx to Activate (EGP)capex_to_activateƒ
- EGP 8,094,000
- Priority Tierpriority_tier
- 2 - Medium term
- Key Blockersblockers
- None material
I. Media & Documentation
6- Photos Folder (URL)photos_link
- https://drive.example.org/assets/MTR-RTL-0027/photos
- Number of Photosphotos_count
- 59
- Floor Plan / Survey (URL)floorplan_link
- https://drive.example.org/assets/MTR-RTL-0027/plan.pdf
J. Data Governance
7- Primary Data Sourcedata_source
- Field survey
- Data Confidenceconfidence_level
- High
- Site Visit Datesite_visit_date
- 23 Apr 2024
- Surveyor / Analystsurveyor
- R. El Morally
- Last Updatedlast_updated
- 5 Apr 2025
- Record Statusrecord_status
- Published
- General Notesnotes
- Seasonality means the occupancy assumption should be split summer/winter.
59 photographs on file
The survey's geotagged photographs live in the custodian's drive folder. This prototype records the link and the count rather than shipping the images.
https://drive.example.org/assets/MTR-RTL-0027/photosSource: Field survey. Surveyed by R. El Morally on 23 Apr 2024. Record last updated 5 Apr 2025.