Real Estate Valuation & Investment Modelling
Budget: $30 – $250 USD
Required Skills:
Statistics & Data Modeling:
Understands weighted scoring, normalization, and multi-factor models
Familiar with investment scoring models (e.g., FICO, Moody’s, Morningstar-like systems)
Excel Modeling (Advanced):
Fluent in OpenPyXL and advanced Excel automation (VLOOKUP, Index/Match, dynamic named ranges, etc.)
Python Programming:
OpenPyXL for Excel integration
Pandas/Numpy/Scikit-learn (optional, if you want statistical modeling/ML to supplement scoring in future)
Real Estate or Hospitality Knowledge (Bonus):
Understanding of CapEx, PIP, ADR, RevPAR, hotel ROI, cash-on-cash returns
Awareness of what makes a hotel "good" vs. "bad" investment
Data Visualization (Optional but Valuable):
Can chart score distributions, weight impacts, or comparison dashboards using matplotlib or Excel itself
Sample Job Post
Project: Hotel Investment Scoring Model (HIGS) in Excel + Python
I’ve created a preliminary structure for a hotel investment scoring system based on weighted sub-metrics across six categories. The system ensures a normalized total score out of 100, based on how each category and sub-metric performs.
I need someone who can:
Review and refine my Excel/Python-based model
Automate score calculations with category/sub-metric weights
Ensure formulas are scalable (easy to add more metrics)
Build backend logic in Python (OpenPyXL) to export guides and scores
(Bonus) Add visualization or scoring explanations for investor decks
Your role would be to take my structured logic and help formalize it into a rock-solid analytical model that could be expanded into an app.
Deliverables:
Polished scoring engine (in Excel and/or Python)
Dynamic input system for evaluating different hotels
Support documentation / flowchart of the scoring logic
Ideal Candidate:
Excel modeling + Python automation wizard
Solid grasp of finance, real estate, or hospitality preferred
Understands normalized scoring and weighted systems
Next Step: Please share examples of scoring systems or financial models you’ve built, and let me know if you have experience with hotel or real estate modeling.
Statistics & Data Modeling:
Understands weighted scoring, normalization, and multi-factor models
Familiar with investment scoring models (e.g., FICO, Moody’s, Morningstar-like systems)
Excel Modeling (Advanced):
Fluent in OpenPyXL and advanced Excel automation (VLOOKUP, Index/Match, dynamic named ranges, etc.)
Python Programming:
OpenPyXL for Excel integration
Pandas/Numpy/Scikit-learn (optional, if you want statistical modeling/ML to supplement scoring in future)
Real Estate or Hospitality Knowledge (Bonus):
Understanding of CapEx, PIP, ADR, RevPAR, hotel ROI, cash-on-cash returns
Awareness of what makes a hotel "good" vs. "bad" investment
Data Visualization (Optional but Valuable):
Can chart score distributions, weight impacts, or comparison dashboards using matplotlib or Excel itself
Sample Job Post
Project: Hotel Investment Scoring Model (HIGS) in Excel + Python
I’ve created a preliminary structure for a hotel investment scoring system based on weighted sub-metrics across six categories. The system ensures a normalized total score out of 100, based on how each category and sub-metric performs.
I need someone who can:
Review and refine my Excel/Python-based model
Automate score calculations with category/sub-metric weights
Ensure formulas are scalable (easy to add more metrics)
Build backend logic in Python (OpenPyXL) to export guides and scores
(Bonus) Add visualization or scoring explanations for investor decks
Your role would be to take my structured logic and help formalize it into a rock-solid analytical model that could be expanded into an app.
Deliverables:
Polished scoring engine (in Excel and/or Python)
Dynamic input system for evaluating different hotels
Support documentation / flowchart of the scoring logic
Ideal Candidate:
Excel modeling + Python automation wizard
Solid grasp of finance, real estate, or hospitality preferred
Understands normalized scoring and weighted systems
Next Step: Please share examples of scoring systems or financial models you’ve built, and let me know if you have experience with hotel or real estate modeling.