Companion files
A Practitioner's Guide to FFO, AFFO, NAV and the Public–Private Bridge in Listed Real Estate
These are the companion files of REIT Analysis and Valuation by Julian R. Sterling.The book on Amazon →
The five Excel workbooks that go with the book, corrected where they were wrong: Chapter 19’s complete analysis, the template, the two practice cases, the checklist and Appendix F’s loop. Every figure Chapter 19 publishes is a live formula — FFO of 532.0, AFFO of 381.0, net asset value of $42.97 a share, an implied cap rate of 6.21%, net debt to EBITDA of 4.76× and a payout ratio of 81.3% — and five that were printed wrong are corrected. Around them: two of the models with the inputs emptied, thirteen working documents to print, forty questions that mark themselves, and three cases the book names and never takes to a number. Nothing is locked, protected or watermarked.
Free to download. No sign-up, no email address, nothing to fill in.
Eleven workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 24 September 2026.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →
Learn to model a commercial property, from rent roll to waterfall: the Real Estate Modeling course →
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
These carry the book’s own figures, so that every number it prints can be traced to a live formula. Each now closes on a checks sheet that reads ALL OK. Download these five96 KB
Chapter 19
Nine sheets working from the filings to the recommendation: every input in one place, the FFO and AFFO bridges, net asset value and the implied cap rate, leverage and coverage, the dividend, the cost of capital and development, the sensitivity, and a checks sheet that holds every figure of the chapter. Change the cap rate in row 26 of the Assumptions sheet and watch net asset value move while the implied cap rate does not — the argument of Chapters 7 and 8. Revised: the thresholds Step 9 and Step 10 print are computed (135 basis points of exit cap rate widening, not “about 70”; $34.50 at the implied cap rate, not $35.90), the discount halving is worth 3.9% a year as the book says (the first file showed 3.6), and the lease roll of Step 7 is costed.
Download the workbook29 KBChapters 4 to 12 and 17
The same structure, empty, for a REIT of your own. Every formula is wrapped so that a blank column shows blanks rather than a screen of errors — you can open it, look at how it is built, and fill it in later. The FFO and AFFO bridges, the NAV build, the leverage tests and the dividend coverage are already wired. Revised: your column now stays blank until you type into it, and four rows are added — the accretion frontier of Appendix F, capitalized overhead, and net debt to enterprise value.
Download the workbook14 KBAppendix C
Two timed cases with the brief, a working area and a live solution: FFO and AFFO built from a net-lease income statement, and a net asset value, implied cap rate and accretion test for an open-air retail company that looks cheap and is not. Both reproduce the appendix exactly; a checks sheet now carries all 27 of its figures. Work them against a clock before opening the solution block.
Download the workbook16 KBAppendix B
All 54 items with a status dropdown, a notes column and a counter, in the appendix’s ten groups: structure, portfolio, earnings, operating trend, valuation, the balance sheet, the dividend, capital allocation, governance, and before you conclude. A "no" is the next question to ask on the call.
Download the workbook12 KBAppendix F
Chapter twelve describes a feedback loop between the share price and the business, calls both directions self-reinforcing, and prints one table at one moment in time. This file turns the loop: three years, both directions, on Meridian's own figures. It reproduces the chapter's three lines to the basis point first, then finds where the accretion frontier actually sits — not at net asset value, but at a 6.2 per cent discount on the test the table uses and an 11.6 per cent discount on the test the chapter prescribes three pages later. Forty-six controls, eight of which name a finding rather than a pass, and a last line that reads ALL OK. Revised: the archive carried a copy with French quotation marks; this is the English one, and the two conventions Appendix F uses without naming — the $50.00 start of the upward loop and the half of accretion added to growth — are inputs.
Download the workbook28 KBTwo of the workbooks with every company input emptied. The checks sheets count what is still missing and test what holds for any inputs.
Chapter 19 · Appendix F
The complete analysis with its 30 inputs emptied: fill the Assumptions sheet and every sheet computes, from FFO and AFFO to the implied cap rate, the accretion test, the development threshold and the lease roll. The loop keeps its conventions and empties the fifteen company figures. The cap rate steps and share prices of the grids stay.
The book’s inputs are listed in a text file inside the archive. Type them back in and the book’s figures come back with them: $42.97 of net asset value, 6.21% implied, a frontier at $40.32.
Download the blank set50 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 1 to 19 · Appendices A and B
The five facts and the reading order, with the share count. FFO and AFFO rebuilt on one definition, with Meridian beside your column. Same-store NOI decomposed. Occupancy, leasing and the expiry profile on one page. Net asset value line by line, with the corrected sensitivity. The implied cap rate and the six explanations of a discount. The six-column comparison.
The dividend on one line. The balance sheet page with the maturity ladder and covenant headroom. The cost of capital line, the frontier and the four ways out. Management and governance. The development pipeline and capital recycling. The note in five questions, with the four break-evens.
Download the documents37 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Seven on FFO and AFFO, seven on net asset value and the discount, seven on multiples, the dividend and the balance sheet, seven on the cost of capital and Appendix F, six on operations, structure and the bridge, and six on the three cases below. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part.
Download the questions17 KBNew material, not a restatement. Three situations the chapters name and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Chapters 11 and 17 · Case one
Chapter 17 asks for four thresholds and Chapter 19 computes none. With a maturity ladder and covenant levels ADDED: refinancing the next three years costs 7.3 cents a share and lifts the payout to 84.2%. The dividend breaks first, at a same-store fall of 14.0%; the leverage covenant at an EBITDA fall of 32.1%; refinancing only above 26.2% on the maturing debt.
Chapter 13 · Case two
The same buildings run on a 0.75% base fee on assets (ADDED). The structure costs 16.5% of NOI against 8.1%; the fee stream capitalizes to $8.26 a share; the termination fee takes NAV to $41.67. An equity-funded acquisition at $30.00 cuts AFFO per share 2.4% and raises the fee 4.8%. Internalizing costs $1.30 and removes $4.66.
Chapters 6 and 10 · Case three
Chapter 6 says an office company often cannot fund its own re-letting from retained cash, and never shows one. Costed from the expiry schedule, the roll takes 136.8 against 70 deducted: AFFO per share falls to $0.968 and the payout from 84.9% to 124.0%. A 12% headline spread is -0.4% net of free rent, and Appendix A’s formula misses 28.9% of the roll.
Download the three cases35 KB| Blue text | a hardcoded input — you may edit these |
| Black text | a formula — do not overtype these |
| Green text | a link to another sheet |
| Yellow fill | the assumptions that carry the answer |
| Checks sheet | the last sheet of every workbook with figures: each control states its own verdict, and the file ends ALL OK |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
Chapter 19 publishes a NAV sensitivity table of $45.86 and $40.36 at cap rates 25 basis points either side of the base case. The live build in the workbook returns $45.72 and $40.47. The first version of this page called that a rounding difference; it is an error in the printed table, and a quarter point moves the answer by about six percent, not seven. The base case of $42.97 reproduces to the cent. Three more printed figures are corrected in the files: the pipeline stops creating value at 135 basis points of cap rate widening, not about 70; net asset value at the implied cap rate is the share price, $34.50, not $35.90; and Appendix A’s formula for that widening is simply the spread.
Both sets of figures are shown side by side on the sensitivity sheet, with the variance displayed. A companion file that quietly adjusted its own output to match a printed table would teach the opposite of what the book teaches.
REIT Analysis and Valuation develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisAlso as an ebook on Apple Books · Google Play · DRM-free PDF edition ($19.99).
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers; the PDF prints on A4 or US Letter. They use no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 24 Sep 2026 | The five workbooks corrected and given checks sheets. Chapter 19’s sensitivity is $45.72 and $40.47, an error in the printed table rather than rounding; the development threshold is 135 basis points, not about 70; net asset value at the implied cap rate is $34.50, not $35.90; the discount-halving return is 3.9%, as printed (the file showed 3.6). The Loop Run replaced by its English version. Added: a blank set, thirteen working documents, forty questions that mark themselves, and three cases. |
More in real estate, with free companion files. The full list of titles is on the author page.
These files accompany REIT Analysis and Valuation. The book is on Amazon.
If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.
Also available as a standalone free template: REIT valuation model.
Also available as a standalone free template: Implied cap rate calculator.