How to use this template
Download the Excel workbook and replace the clearly marked amber example inputs with your figures. Formulas calculate the results automatically. Every workbook includes a Formula guide tab showing each calculation, its cell reference and a plain-English explanation. Save your completed workbook privately; this page does not upload your information.
- Provide twelve consecutive completed months and an as-of date.
- Separate recurring operations from capital work and financing costs.
- Explain one-time items, owner allocations and related-party charges.
- A lender may adjust reported NOI; show both the source numbers and your adjustments.
What it helps establish
A clear package lets a capital provider ask specific questions about the asset, sponsor and proposed structure. Reconcile the summary with the underlying records and label estimates. The template supports an initial review; the diligence requirements for the actual transaction may be different.