The EiP Brief

Commercial property modelling, explained simply

Practical lessons on Excel, financial modelling and your commercial property career. No jargon, just what you need to know.

Excel Shortcuts for Financial Modelling: 25 to Learn
0 5 min

25 Excel shortcuts for financial modelling that property analysts use every day, plus the formulas to learn next.

Lucy @ Team EiP
Lucy @ Team EiP
Real Estate Financial Modelling Test: How to Pass It
2 5 min

What to expect in a real estate financial modelling test and how to pass it: timing, structure, checks, the summary and the interview.

Lucy @ Team EiP
Lucy @ Team EiP
Sensitivity Analysis in Excel for Property Deals
0 5 min

How to run a sensitivity analysis in Excel for a property deal: data tables, scenarios, break-even and how to present the results.

Lucy @ Team EiP
Lucy @ Team EiP
How to Model a Property Loan in Excel: LTV, ICR and DSCR
1 5 min

How to model a commercial property loan in Excel: interest, repayments and covenant tests (LTV, ICR, DSCR) with a worked example.

Lucy @ Team EiP
Lucy @ Team EiP
Real Estate Waterfall: Promote and IRR Hurdles Explained
10 6 min

What is a real estate waterfall? See how preferred return, IRR hurdles and promote work in a joint venture, with a worked example.

Lucy @ Team EiP
Lucy @ Team EiP
How to Model a Commercial Lease in Excel (Step by Step)
18 6 min

How to model a commercial lease in Excel: tenancy schedule, rent reviews, breaks, rent-free periods and WAULT, step by step.

Lucy @ Team EiP
Lucy @ Team EiP

Do you want to know how to do this properly?

Build real commercial property models with Lucy, step by step, in the EiP Academy.

get on the list

For commercial property professionals who want to take on more responsibility.

Practical financial modelling tips, career advice and news of new training, straight to your inbox.

Excel in Property Limited

167-169 Great Portland Street, 5th Floor, London, W1W 5PF

© Excel in Property Limited 2026