Excel & Real Estate Feasibility Analyst
# Excel & Real Estate Feasibility Analyst **doneandelivered** · Gunjur, Bengaluru, Karnataka · `On-site` 🕒 **Статус:** *Опубликовано: 7 дней назад* · *Источник: Indeed* --- ### About the Role About the Role We are looking for a highly skilled Excel & Real Estate Feasibility Analyst who can independently develop, maintain, and improve Excel-based feasibility models for residential and real-estate development projects. The ideal candidate should have strong hands-on experience in Advanced Excel, financial modelling, real-estate project calculations, costing, revenue projections, and feasibility analysis . The candidate will be responsible for converting project inputs such as land extent, FAR/FSI, construction area, apartment sizes, construction costs, selling prices, landowner/developer sharing, approvals, finance costs, and other project expenses into accurate and dynamic Excel models. Key Responsibilities1. Advanced Excel Modelling - Create and maintain complex Excel-based financial and feasibility models. - Build models using formulas so that changing any major input automatically updates all related calculations. - Develop interconnected worksheets for project costing, revenue, profitability, cash flow, and feasibility. - Maintain professional formatting, structure, formulas, validations, and error checks. - Improve existing Excel models without disturbing the original structure and presentation. 2. Real Estate Project Feasibility Prepare feasibility calculations for: - Residential apartment projects - Villa projects - Land development projects - Joint Development (JD) projects - Landowner–developer sharing models - Pre-launch and post-launch sales models Calculate and analyse: - Land area and conversion - Acre / Guntas / Sq.Ft. calculations - FAR / FSI - Ground coverage - Built-up area (BUA) - Saleable area - Carpet area / efficiency - Number of apartments - Apartment mix and unit sizes - Construction cost - Development and infrastructure cost - Approval and professional fees - Marketing expenses - Finance costs - Contingency - Land cost - Registration and other project costs - Selling price and revenue - Gross profit - Project margin - Cost per Sq.Ft. - Revenue per Sq.Ft. - Break-even analysis 3. Landowner / Developer Calculations - Prepare landowner and developer share calculations. - Calculate apartment/unit allocation based on agreed percentages. - Develop JD and revenue-sharing models. - Calculate pre-launch requirements and funding requirements. - Analyse different sharing and pricing scenarios. 4. Dynamic Formula-Based Models The candidate must be capable of building models where changing inputs such as: Land Area → FAR/FSI → BUA → Saleable Area → No. of Apartments → Construction Cost → Total Project Cost → Selling Price → Revenue → Profit automatically updates throughout the workbook. 5. Scenario & Sensitivity Analysis Create scenarios for: - Different land prices - Different FAR/FSI - Different construction costs - Different selling prices - Different apartment sizes - Different landowner shares - Different project timelines - Best-case / Base-case / Worst-case scenarios 6. Reporting & Management MIS Prepare clear Excel reports and dashboards for management covering: - Project cost - Project revenue - Investment requirement - Profitability - ROI / margins - Sales assumptions - Construction assumptions - Project feasibility summary Required Excel Skills The candidate should have strong practical knowledge of: - Advanced Excel - SUM / SUMIFS / COUNTIFS - IF / IFS / IFERROR - XLOOKUP / VLOOKUP - INDEX / MATCH - ROUND / ROUNDDOWN / ROUNDUP - Percentage calculations - Date and financial functions - Data Validation - Conditional Formatting - Named Ranges - Pivot Tables - Charts and dashboards - Scenario analysis - What-If Analysis - Goal Seek - Basic Power Query is an advantage - Basic VBA/Macros is an advantage Real Estate Knowledge – Preferred Candidates with knowledge of the following will be preferred: - Real estate development - Apartment construction - Land acquisition - Joint Development Agreements - Landowner/developer sharing - FAR / FSI - Built-up area - Saleable area - Construction costing - Real estate pricing - Project feasibility - Real estate financial modelling Real-estate experience is preferred, but candidates with excellent Advanced Excel and financial modelling skills can also be considered. Candidate Profile We are looking for someone who is: - Excellent in Advanced Excel - Strong in numbers and calculations - Highly detail-oriented - Good at financial analysis - Able to understand real-estate project assumptions - Comfortable working with large and interconnected Excel models - Capable of identifying formula errors - Able to build models independently - Good at presenting data in a clean and professional format - Strong in logical and analytical thinking Education Preferred: - B.Com - M.Com - MBA Finance - CA Inter / CMA - BBA Finance - Civil Engineering / Quantity Surveying - Any relevant degree with strong Excel and financial modelling experience Experience 2–5 years of relevant experience in any of the following: - Real Estate - Construction - Project Finance - Financial Modelling - MIS - Business Analysis - Costing - Real Estate Feasibility Freshers with exceptional Advanced Excel and financial modelling skills may also be considered. Practical Test – Mandatory Shortlisted candidates will be given an Excel practical test. The candidate should be able to create a dynamic feasibility model using inputs such as: - Land Area: 4 Acres - FAR / FSI - Apartment Size - Saleable Efficiency - Construction Cost / Sq.Ft. - Selling Price / Sq.Ft. - Landowner Share - Approval Costs - Marketing Costs - Finance Costs The model should automatically calculate: Total BUA → Saleable Area → Number of Apartments → Project Cost → Revenue → Developer Share → Landowner Share → Total Investment → Gross Profit → Profit Margin Candidates who can build a clean, formula-driven model without manually hardcoding calculated values will be preferred. Key Performance Indicators (KPIs) - Accuracy of Excel models - Formula reliability - Speed of model preparation - Ability to understand project assumptions - Accuracy of feasibility calculations - Quality of management reports - Ability to identify discrepancies - Ability to independently develop and improve Excel models Immediate Joining Preferred Hemanthmukkara@doneanddelivered.co.in Pay: ₹100,000.00 - ₹120,000.00 per month Benefits: - Cell phone reimbursement - Commuter assistance - Flexible schedule - Food provided - Health insurance - Internet reimbursement - Leave encashment - Life insurance - Paid sick time - Paid time off - Provident Fund - Work from home Work Location: In person
Наблюдалась 2026-10-15, впервые 2026-10-08, источник — Indeed.