Tools

Real Estate Hedging Calculator

This calculator will estimate the returns of a project hedged using S&P/Case-Shiller Home Price Index futures.

Enter the information below in the white boxes to see how your project does. DO NOT HIT the ENTER key. The calculator runs on JavaScipt - if you hit ENTER it will clear all fields. Use the TAB key or click another field with the mouse. Also, there is no need to use currency signs, commas, or % signs. Just enter the numbers and the calculator takes care of the rest.

Please enjoy our Real Estate Hedging Calculator.

Given: Real Estate Real Estate Futures S&P / Case-Shiller
Project cost Current Index Get index
Equity Future price (Bid) Get futures
Mortgage Months till expiration
Est. Sale price Est. Index change (%) per month
Performance Bond Get initial rates
Hedge Positions:
Hedging Against: # Contracts Contract Value Contract Cost
No Hedge
Equity
Mortgage
Est. Sales
Projections
Monthly Total Months Prop. Value Future Settle
Returns
Value Change
Contracts

Notes: