TSM Retail Acquisition Model (RETA012)

$2,700.00

TSM’s Excel-based model for Retail Acquisition. We know it works because we have used it ourselves to underwrite over $80 Million in transactions.

This model contains base +4 tiers of Waterfall Calculations, with mezzanine debt, and with ability to refinance.

Add To Cart

TSM Retail Acquisition Financial Excel Model.jpg

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 (%)
Building Info - consolidates ARGUS rent roll exports into a pre-formatted presentation rent roll with the ability to consolidate up to 15 individual properties into a portfolio view
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
ARGUS Instructions - detailed instructions on how to export reports out of ARGUS and seamlessly import into this Excel financial model
ARGUS Exports - various reports/schedules exported out of ARGUS and into this Excel financial model
Costar Exports - exports for lease comps and sale comps out of Costar and into this Excel financial model
Instruction Manual - Embedded manual to assist in using the model

TSM Retail Acquisition Model (RETA012)

TSM Retail Acquisition Model (RETA012)

TSM’s Excel-based model for Retail Acquisition. We know it works because we have used it ourselves to underwrite over $80 Million in transactions.

This model contains base +4 tiers of Waterfall Calculations, with mezzanine debt, and with ability to refinance.

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 (%)

Building Info - consolidates ARGUS rent roll exports into a pre-formatted presentation rent roll with the ability to consolidate up to 15 individual properties into a portfolio view

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

ARGUS Instructions - detailed instructions on how to export reports out of ARGUS and seamlessly import into this Excel financial model

ARGUS Exports - various reports/schedules exported out of ARGUS and into this Excel financial model

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

Instruction Manual - Embedded manual to assist in using the model