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
