The model is a 100% unlocked Excel file with fully transparent formulas. The TSM real estate financial model will be precise and error free. While it is fully customizable, we are confident you won’t need to make time-consuming adjustments because we have done everything for you.

The purchase includes a 1-hour complimentary consultation with the analyst that developed the model - valued at $250.

This model includes the following features:

• Investor Summary - Printable 2-page formatted summary with return calculations

• Error check - allows for quick insight into the accuracy of the financial model

• Model Outputs - used for investor relations reports/packages and includes sources/uses, capital stack, project costs, rent roll, hypothetical investor returns, etc.

• Assumptions - general, acquisition, timing, debt and waterfall assumptions.  Also includes summary statistics, rent roll, vacancy assumptions, capex assumptions and sensitivity table

• Renovation Budget - with ability to control timing on each specific line item and select if the calculation is fixed, $/sf, or percentage (%)

• Rent Roll - The Rent Roll tab is an input tab. This tab is an Excel file reflecting the in-place leases, along with a lease-up schedule. This has the same function as the ARGUS Rent Roll without actually having ARGUS integrated into the model.

• Monthly Cashflow - with hyperlinks, circular break, and detailed analysis of unlevered and levered cashflows

• Annual Cashflow - with hyperlinks and detailed analysis of unlevered and levered cashflows

• Waterfall - with the number of tiers selected in the custom model builder

• Taxes - detailed calculations based on either a $/sf assumption or millage rate

• Sale Comps

• Lease Comps

• LIBOR - forward LIBOR curve used for floating rate debt

• Costar Exports - exports for lease comps and sale comps out of Costar and into this Excel financial model