Real Estate Financial Modelling

Property models you can defend line by line: monthly development cash flows, acquisition pro formas, debt schedules, IRR and equity multiple, JV waterfalls, and the checks, versions and reviews that keep them right.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Real Estate Financial Modelling, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help you organise your own affairs. It is not legal advice, and following it does not make anyone your lawyer. Rules differ between countries and change often, so check decisions that matter, and anything you sign, with a qualified lawyer or the official authority in the country concerned.

What it installs.

1

Pillar

1

Area

50

Projects

200

Starter tasks

🏢 Real Estate Investing & Development

Real Estate Financial Modelling

Building property models: monthly development cash flows, acquisition pro formas, debt schedules, IRR and equity multiple, and JV waterfalls.

  1. House layout for every property model
  2. Colour and formatting conventions for models
  3. Calculation settings and circularity switch
  4. Monthly timeline and period flags engine
  5. Return metrics refresher for IRR, XIRR, NPV and multiple
  6. Error check sheet that flags a broken model
  7. Personal template library and file naming
  8. Choosing modelling software and add-ins
  9. First acquisition model from a blank sheet
  10. Monthly development cash flow from land to exit
  11. S-curve phasing of construction costs
  12. Sales receipts and deposit phasing
  13. Development loan with rolled-up interest and fees
  14. Equity-first funding order and cash sweep
  15. Annual income property pro forma
  16. Lease-by-lease commercial rent roll engine
  17. Multifamily unit mix revenue build
  18. Operating costs, recoveries and capex reserve lines
  19. Investment loan amortisation schedule
  20. DSCR, LTV and debt yield covenant tests
  21. Exit value and disposal costs block
  22. Levered and unlevered returns summary
  23. JV waterfall with preferred return and promote
  24. Pre-send model check routine
  25. Model version log and change register
  26. Live deal model register
  27. Monthly actuals into the live development model
  28. Quarterly reforecast of hold asset models
  29. Floating rate and hedge inputs refresh
  30. Weekly timed modelling drill
  31. Monthly peer model swap
  32. Yearly template library rebuild
  33. Scenario selector for base, downside and upside cases
  34. Two-way sensitivity grids for returns
  35. Break-even and covenant breach stress tests
  36. One-page model dashboard for decision makers
  37. Auditing an inherited model from a broker or partner
  38. Removing hard codes and circular references from a legacy model
  39. Monthly or quarterly periodicity decision
  40. Model build against a bid deadline
  41. Lender model submission and model audit
  42. Real estate modelling test for an interview
  43. Model handover pack for a JV partner
  44. Founder's first deal model without an analyst
  45. Career switch into real estate modelling
  46. Briefing and checking a freelance modeller
  47. Freelance modelling service for small developers
  48. Catch-up and multi-tier IRR waterfall
  49. Phased master plan model with plot-level cash flows
  50. Fund-level roll-up of several deal models

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

House layout for every property model

Models built a different way for every deal take twice as long to review and hide errors in a new place each time. A fixed layout of cover, inputs, timeline, calculations, debt, returns and checks, in that order, means anyone who has seen one of your models can find any number in the next one within a minute. Set it before the next deal lands, because nobody standardises during a bid.

First tasks

  • Open your last two models and list the tabs each one used
  • Create the blank workbook with the eight standard tabs in order
  • Write the flow and one-row-one-formula rules on the cover tab
  • Rebuild one past deal in the new layout and compare the returns

Colour and formatting conventions for models

A reviewer who cannot tell an input from a formula has to click every cell to understand a model. Agreeing one set of conventions, such as blue for hard-coded inputs, black for formulas, green for links to other tabs and a shaded fill for anything a user may change, makes a model readable in print and stops colleagues typing over calculations.

First tasks

  • Write down the colours and number formats you already use most often
  • Create named cell styles for input, formula, link and check cells
  • Set one format each for multiples, percentages and currency
  • Apply the styles to the template and one live model

Calculation settings and circularity switch

Interest on a development loan depends on the loan balance, which depends on the interest, so most development models carry a circular reference somewhere. Deciding once how you handle it, either a copy-paste macro, a closed-form calculation or iterative calculation behind an on and off switch, prevents the frozen workbooks and error cascades that wreck a model the night before a deadline.

First tasks

  • Find where the circular reference sits in your current development model
  • Choose between a paste macro, a closed-form calculation or iterative calculation
  • Add the circularity switch to the inputs tab and wire it to interest
  • Force an error in the loop and confirm the switch clears it

Make it yours.

Install Real Estate Financial Modelling, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.