I will build a real estate financial model and development pro forma in excel
AI and Data Automation Engineer, Python, Excel, Google Sheets
About this Gig
A development deal lives or dies on its numbers. I build clear Excel pro formas that show cash flow, financing and returns month by month, with reconciliation checks built in.
A new model (Standard and Premium) includes:
- One Inputs sheet that drives everything: land, hard and soft costs, schedule, sales or lease-up
- Monthly cash flow with a construction loan and interest capitalized month by month
- Sources and uses, profit, margin, levered and unlevered IRR, equity multiple
- Reconciliation checks: sources equal uses, loan repaid, cash flow ties to profit
- Premium: scenarios, sensitivity tables, a simple equity waterfall and a one-page summary
- Open formulas with no hidden macros, so every number can be traced
Basic is a check of your existing model with a clear list of issues and fixes.
I built a land development pro forma for a US land developer, who came back for a second round of changes. The sample in my gallery is a 44-lot subdivision model on synthetic data.
Send me your deal summary, budget or existing model and I will confirm the right package. This is modeling work, not investment advice.
Visualization Tools:
Microsoft Excel
Industry:
Construction
•
Financial services
•
Real estate
Target country:
United Kingdom
•
United States
•
Worldwide
My Portfolio
FAQ
Can you work from my existing model?
Yes. I can check, rebuild or extend your current Excel model, and I mark every change so you can follow it.
Which project types do you model?
Land subdivisions with lot takedowns, for-sale homes or townhomes, and small multifamily or commercial developments with lease-up.
Do I get the formulas?
Yes. Everything is in open Excel formulas with no hidden macros, plus a short guide to the inputs.
Is this investment advice?
No. I build the model from your assumptions; investment, legal, tax and lending decisions stay yours.

