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 agile 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

[email protected]

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

📌 Excel & Real Estate Feasibility Analyst (Gunjur Village)
🏢 doneandelivered
📍 Gunjur Village