Back to search:
Freelance Excel / Hong Kong
Freelance Job: Excel Real Estate Deal Analyzer - VBA
Hong Kong
Published on www.peopleperhour.com
05 Apr 2025
I'm seeking an experienced Excel developer to create a professional real estate investment analyzer tool. The tool should enable quick analysis of investment properties in a clean, well-designed single-sheet interface that supports multiple investment strategies.
Key Requirements
Functionality
Create a comprehensive real estate investment calculator in a single-sheet design
Include analysis for multiple investment strategies:
BRRRR (Buy, Rehab, Rent, Refinance, Repeat) strategy
DSCR (Debt Service Coverage Ratio) loan analysis
Cash purchase with refinance option
Implement dynamic elements that change based on selected investment strategy
Create professional financial calculations for ROI, cash flow, debt coverage ratios, etc.
Include conditional formatting for visual assessment of deal quality
Develop a recommendation engine that evaluates deals based on key metrics
Technical Specifications
Microsoft Excel (compatible with latest version)
VBA for button functionality
Cell protection to prevent formula corruption
Data validation for proper inputs
Professional design with consistent color scheme and typography
Design Requirements
Clean, professional aesthetic with consistent color palette
Intuitive layout that doesn't require switching between tabs
Clear visual hierarchy with section headers
Conditional formatting to indicate good/bad values
Input fields clearly distinguished from calculated fields
Deliverables
Complete Excel workbook with all functionality implemented
Basic documentation explaining how to use the analyzer
All calculations visible and explainable
All VBA code properly commented
Skills Required
Advanced Excel (formulas, conditional formatting, data validation)
VBA programming
Financial calculations knowledge
UI/UX design sensibility
Understanding of real estate investment calculations
I have a detailed specification document prepared that outlines the exact layout, formulas, and design requirements for this project, which I will share with the chosen freelancer
View all