Asset Management Model
After opening day the work is keeping the center on plan. This shows how close it is.
- Type
- Excel model
- Version
- v1.1
- Updated
- May 2026
- Stage
- Lease, hold and sell
- File
- Excel workbook (.xlsx), 40 KB
- Works in
- Microsoft Excel for Windows, desktop. Not compatible with Excel for Mac.
What it answers
- Is the property ahead of or behind budget?
- What does the rest of the hold look like on today's numbers?
- Is it time to sell?
What goes in
- Annual budget
- Monthly actual income and expenses
- Leasing updates
What comes out
- Budget compared with actual
- Re-forecast cash flow
- Hold value and returns
How we use it
We use it to report to our partners each quarter on the centers we still own.
Before you open it
- Use the desktop version of Excel. Excel for the web and other spreadsheet apps cannot run the parts of a model that use macros.
- On Windows, Excel blocks macros in any file downloaded from the internet and shows a red bar. Close the file, right-click it, choose Properties, tick Unblock and press OK, then open it again. If it came inside a zip, unblock the zip before you extract it.
- Read the Version tab first. It records the model's history and its authors. Leave it in place, unchanged, if you share the file.
Use and sharing
Free to use, adapt and share with anyone, as long as it stays free and its Version tab and credits stay in the file. Provided as is, for education. It is not investment, legal or tax advice, not an appraisal, and not an offer of any security. Any project figures in it are illustrative. Full terms, including credits, are in our Terms of Service.
Asset-Management-Actual-Forecast-DCF-v1.1.xlsx · SHA-256 3c18441d72ce91a34cd94c54febd24932d0c16daa306504b786c49a88a4d4a0a
Where it fits in our work
Often used with
Co-GP, JV & capital partners
Build With Us
We structure joint ventures with operating partners, co-GP sponsors, and capital partners who bring proven track records. Outline your firm and the partnership you have in mind.