This is a fully functional, institutional quality, and dynamic real estate financial model for calculating the return of the acquisition and sale of an Office (or other types of commercial real estate). It is a robust model (with only three tabs), very user-friendly, that will provide the user with a detailed Excel spreadsheet. It's purposely simple, clean, and made to be filled out in no more than half an hour.
Summary – all investment-related inputs are entered into this sheet. These include property description, investment timing, acquisition, Capex, sale assumptions, operating expense assumptions, financing assumptions, etc.
Monthly Cash Flow Tab: All Cash Flow calculations are performed on this sheet. This template includes the estimation of Levered and Unlevered CF and the calculation of Cashflows by Equity partner following a 4-tier Waterfall model. The Assumptions entered on the Input sheet flow to the Monthly Cash Flow sheet, where a monthly forecast of all cash flows is calculated.
The Annual Cash Flows tab rolls up the monthly cash flows to annual periods so you can view high-level cash flows on one page. The report is printable.
• The user only needs to input information into the cells formatted in the dark blue font in the Investment Summary and Budgets sheets. If the contents of a cell are colored black, it means that it is a formula;
• The template is provided with information from a hypothetical property, for demonstration purposes, that must be erased;
• All inputs in the model are formatted in blue type. Any input that has a suffix or Prefix such as "/month", "Year", or "SFT", and so after/before the numeric value is custom formatted to display that text suffix/prefix. You only need to enter NUMBER VALUES in those cells. Do not re-type the text suffix -- it will corrupt the calculations or crash the model altogether.
• The model is expandable for up to 10 years.