Daily writing prompt
Tell us about your favorite pair of shoes, and where they’ve taken you.
Internal Rate of Return (IRR) is the discount rate at which the Net Present Value (NPV) of a project becomes zero.
In simple terms:
IRR is the rate of return a project is expected to generate over its life.
It considers:
Time value of money
Multiple cash inflows and outflows
Long-term project performance
IRR is widely used in:
Real estate development
Infrastructure planning
PPP projects
Urban redevelopment
Sustainable building investments
IRR is calculated using the NPV equation.
🔹 NPV Formula
NPV=−Initial Investment+∑Cash Flowt(1+r)tNPV = -Initial\ Investment + \sum \frac{Cash\ Flow_t}{(1+r)^t}NPV=−Initial Investment+∑(1+r)tCash Flowt
Where:
rrr = discount rate
ttt = time period
IRR is the value of rrr when:
NPV=0NPV = 0NPV=0
So,0=−Initial Investment+∑Cash Flowt(1+IRR)t0 = -Initial\ Investment + \sum \frac{Cash\ Flow_t}{(1+IRR)^t}0=−Initial Investment+∑(1+IRR)tCash Flowt
Since the equation cannot be solved directly, IRR is found using:
Trial and error
Interpolation method
Financial calculator
Excel IRR function
IRR helps planners and architects:
Compare multiple development proposals
Evaluate long-term infrastructure investments
Justify PPP concession models
Assess sustainable building investments
Decide between design alternatives
Determine project viability
If:
IRR > Required Rate of Return (Cost of Capital) → Project is acceptable
IRR < Required Rate of Return → Project should be rejected
✅ Example 1: Small Commercial Building Project
Initial Investment (Year 0)
₹1,00,000
Expected Cash Inflows:
Year 1 = ₹60,000Year 2 = ₹60,000
Step 1: Try 10% Discount Rate
NPV=−1,00,000+60,0001.10+60,0001.102NPV = -1,00,000 + \frac{60,000}{1.10} + \frac{60,000}{1.10^2}NPV=−1,00,000+1.1060,000+1.10260,000 =−1,00,000+54,545+49,587= -1,00,000 + 54,545 + 49,587=−1,00,000+54,545+49,587 =+4,132= +4,132=+4,132
NPV is positive → IRR is higher than 10%
Step 2: Try 15%
NPV=−1,00,000+60,0001.15+60,0001.152NPV = -1,00,000 + \frac{60,000}{1.15} + \frac{60,000}{1.15^2}NPV=−1,00,000+1.1560,000+1.15260,000 =−1,00,000+52,174+45,369= -1,00,000 + 52,174 + 45,369=−1,00,000+52,174+45,369 =−2,457= -2,457=−2,457
NPV is negative → IRR is between 10% and 15%
Step 3: Interpolation Formula
IRR=r1+NPV1NPV1−NPV2×(r2−r1)IRR = r_1 + \frac{NPV_1}{NPV_1 – NPV_2} \times (r_2 – r_1)IRR=r1+NPV1−NPV2NPV1×(r2−r1)
Where:
r1=10%r_1 = 10\%r1=10%
r2=15%r_2 = 15\%r2=15%
NPV1=4,132NPV_1 = 4,132NPV1=4,132
NPV2=−2,457NPV_2 = -2,457NPV2=−2,457
IRR=10+41324132+2457×5IRR = 10 + \frac{4132}{4132 + 2457} \times 5IRR=10+4132+24574132×5 IRR≈13.1%IRR \approx 13.1\%IRR≈13.1%
✅ Example 2: Urban Parking Project
Initial Investment = ₹2,50,00,000
Annual Net Cash Flow = ₹40,00,000Project Life = 8 years
Using financial approximation:
IRR ≈ 14–16%
If the required return is 12%, the project is financially viable.
✅ Example 3: Solar Panel Investment in Office Building
Installation Cost = ₹5,00,000
Annual Savings = ₹1,20,000Life = 5 years
Using trial method or Excel:
IRR ≈ 18–20%
This supports sustainable investment decision-making.
🔹 1. Real Estate Feasibility Studies
Apartment development
Commercial complex
Mixed-use buildings
Helps developers decide project scale and phasing.
🔹 2. Transit-Oriented Development (TOD)
IRR helps evaluate:
Increased land value
Higher rental income near transit
Mixed-use density benefits
🔹 3. Public-Private Partnership (PPP)
IRR determines:
Concession period
Revenue sharing ratio
Private investor attractiveness
🔹 4. Infrastructure Projects
Used for:
Metro stations
Bus terminals
Multi-level parking
Smart city infrastructure
🔹 5. Sustainable Building Investments
IRR justifies:
Green roof systems
Solar panels
Energy-efficient façade
Water recycling systems
✔ Considers time value of money✔ Useful for long-term projects✔ Easy comparison between alternatives✔ Widely accepted in financial markets✔ Useful for PPP and infrastructure projects
❌ Complex to calculate manually❌ May give multiple IRRs in unusual cash flow patterns❌ Does not show absolute profit amount❌ Can mislead if project sizes differ
Therefore, IRR should be used along with:
NPV
ROI
Payback Period
Cost-Benefit Analysis
When preparing a Detailed Project Report:
Estimate yearly cash flows
Apply discounting
Calculate IRR
Compare with cost of capital
Recommend project acceptance or rejection
Internal Rate of Return (IRR) is one of the most powerful financial tools in architecture and urban planning. It helps evaluate:
Real estate viability
Infrastructure feasibility
TOD development returns
Sustainable design investments
PPP financial attractiveness
For architects and planners, understanding IRR ensures that projects are not only technically sound and aesthetically strong but also financially sustainable.
