HauteCRE's template is a consolidated Personal Financial Statement (PFS) and Corporate Financial Statement (CFS) template, which almost all lenders will require when requesting CRE capital.

HauteCRE's Price Per Sq. Ft. Per AC Calculator model easily converts price(s) per square foot to price(s) per acre, based on a 'base' price per square foot, with increments above that base. HAUTE Price per SF - per AC Calculator

HauteCRE's Commercial Rent Roll model tracks leasing, base rental, and operating expense recoveries for a multi-tenant commercial rental property. 

HauteCRE's Effects of Leverage Excel model contains three scenarios that address the impact of leverage: 1) an All-Cash Purchase; 2) an example of Positive Leverage, and; 3) and example of Negative Leverage. Each scenario can be viewed independently of the other, with regard to cash flow inputs and financing.

HauteCRE's Residential Mortgage Qualifier estimates the monthly costs associated with a home purchase at a given price and financing terms, and the monthly and annual income required to qualify for the anticipated financing.

HauteCRE's Leasing Calculator estimates the gross leasing commision that can be expected, based on certain assumptions such as the lease type, lease escalations, tenant improvements, and other variables.

HauteCRE's Lease Rollover Excel model calculates the occupancy costs of a given property, or multiple properties, based on net rentable area, market rent, retention ratios, commissions, tenant improvements, and other related expenses.

HauteCRE's Multi-Family Rent Roll Calculator allows a user to list and track all rental income activity at a given multi-family property, along with tracking real-time current market rental rates for comparison to the subject units. Rental and occupancy statistics on each unit – both vacant and occupied – are also calculated. 

HauteCRE's Model calculates the "As Is" and "As Stabilized" value of a given property, after considering appropriate renovation costs (soft and hard), downtime, free rent, and other concessions.

HauteCRE's Overall Cap Rate Calculator contains two matrices; one will calculate an overall capitalization rate, assuming a given loan-to-value ratio and a loan interest rate. The second matrix an overall capitalization rate, assuming a required Equity IRR and growth over the specified holding period.

HauteCRE's Step Lease Model values a commercial real estate lease (or any other long-term lease or contract) having multiple layers of income in increments, or 'steps,' over the life of the lease or contract.

HauteCRE's 10-year DCF Model is a 'back-of-the-envelope' ten-year DCF analysis. It can be used for both commercial, multi-family, or mixed-use projects, based on how much data is entered into the “Property Information” fields.

HauteCRE's 5-Year DCF model is a 'back-of-the-envelope' non-complicated five-year DCF analysis. It can be used for both commercial, multi-family, or mixed-use projects, with expense input measured in $/SF of Net Rentable Area ("NRA").

HauteCRE's Capital Quote Sheet & Tracker model is used to track quotes and deal structures from competing senior debt lenders but can also be modified to include mezz and equity layers of the overall capital stack.

HauteCRE's Chart of Real Estate Accounts illustrates ways to classify certain income and expense accounts associated with commercial real estate.

HauteCRE's model is an example of a Discounted Rent Loss Model, whereby a non-stabilized investment property incurres certain revenues and expenses in reaching stabilized status.

Haute CRE's Effective Rent Model calculates the net present value of the effective rent paid over the life of a commercial lease.

HauteCRE's Gannt Chart allows for partial task completions, and a variety of different activities with both planned and actual start and finish event durations, as well as a 'percentage completed' tracker.

HauteCRE's Income and Expense UW model combines a number of columns allowing for historical income and expense analysis, as well as reconciling Broker Pricing Opinions ("BPOs"), property budgets, and third-party appraisals in order to project a stabilized operating expense.

HauteCRE's Land Residual Analysis model is used to determine the amount that should be paid for a parcel of land, given its Highest and Best Use, and what can be built upon it to bring the highest value possible.

HauteCRE's Lease Commission Model will calculate the 'gross' and 'net' commissions on a lease transaction, and then waterfall the fees based on whehter a co-broker is involved.

HauteCRE's Multi-Tiered Commission Waterfall model calculates brokerage/consulting fees that are tiered to change, based on the amount of overall production.

HauteCRE's Quick Interest Rate Comparison Model compares one loan having a term (balloon payment) and amortization period against two different interest rates, and calculates the interest differential, as well as the present value of that interest differential at a given discount (yield) rate.

HauteCRE's Quick Multi-Family Development Sizer model does a quick 'back-of-the-envelope' analysis of the feasibility for developing a multi-family rental apartment project.

HauteCRE's Sample JV Equity Waterfall model analyzes the equity component of the capital stack in a commercial real estate investment involving the syndication of equity.

model HauteCRE's Single Loan Amortization Model illustrates a typical loan amortization schedule that also allows for additional principal reduction payments, as well as an 'interest-only' fucntion, allowing for customized periods of 'interest-only' payments.

HauteCRE's Sources and Uses model calculates the 'sources' (capital) and 'uses (costs and cash outflows) for a given commercial real estate investment, for which all capital and correspoding expenses are accounted.

HauteCRE's Two-Loan Amortization Model compares metrics associated with two different types of commercial debt instruments to determine total interests costs paid over the life of each loan; the outstanding loan balance at the expiration of the term, and the monthly and annual amounts of debt service.

HauteCRE's Yield Maintenance Pre-Payment Model contains three examples calculating three different Yield Maintenance premiums at different interest rates.