I will build a dcf valuation model for real estate or infrastructure assets
Financial and Quant Analyst
About this Gig
Is the price justified? I build DCF valuation models for real estate and infrastructure assets that show the value, the key drivers and how sensitive it is.
What you get:
- Discount rate: WACC build-up from your cost of debt and required equity return
- 10-year unlevered free cash flow (NOI less capex)
- Terminal value from an exit cap rate, with selling costs and a Gordon-growth cross-check
- Cross-checks against direct capitalisation and any appraisal
- Sensitivity grid: value by discount rate and exit cap rate
- Equity IRR, equity multiple and unlevered IRR against your target return
- Clean, colour-coded Excel with no macros and a short valuation summary
I work as an investment analyst on unlisted real estate, so I know what a reviewer checks first: the exit cap, the capex and whether the valuation reconciles.
Send me your cash flow forecast or deal summary. If you need the forecast built too, see my property fund forecast gig.
Please message me before ordering so I can confirm scope.
Visualization Tools:
Microsoft Excel
•
Python
•
Tableau
Type of model:
Discounted cash flow
Industry:
Data analytics
•
Financial services
•
Real estate
Target country:
United Kingdom
•
United States
•
Worldwide

