FREE DOWNLOADABLE SPREADSHEET LIBRARY
We update our Library regularly, so check back often for new content.
Price Per Sq. Ft. Calculator
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
Effects of Leverage Calculator
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.
Multi-Family Rent Roll Calculator
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.
Overall Cap Rate Calculator
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.
Income and Expense UW Model
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.
Quick Interest Rate Comparison
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.
Two-Loan Amortization Comparison
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.