Real Property Negotiation Game (CW): Excel Model

Arthur I. Segel; John  Vogel; Justin Seth Ginsburgh

}
//]]>
</script>
<input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="E39AC016" />
<script type="text/javascript">RegisterSod("sp.core.js", "\u002f_layouts\u002fsp.core.js?rev=7ByNlH\u00252BvcgRJg\u00252BRCctdC0w\u00253D\u00253D");</script><script type="text/javascript">RegisterSod("sp.res.resx", "\u002f_layouts\u002fScriptResx.ashx?culture=en\u00252Dus\u0026name=SP\u00252ERes\u0026rev=b6\u00252FcRx1a6orhAQ\u00252FcF\u00252B0ytQ\u00253D\u00253D");</script><script type="text/javascript">RegisterSod("sp.ui.dialog.js", "\u002f_layouts\u002fsp.ui.dialog.js?rev=Tpcmo1\u00252FSu6R0yewHowDl5g\u00253D\u00253D");RegisterSodDep("sp.ui.dialog.js", "sp.core.js");RegisterSodDep("sp.ui.dialog.js", "sp.res.resx");</script><script type="text/javascript">RegisterSod("core.js", "\u002f_layouts\u002f1033\u002fcore.js?rev=Emb5hNX1RZMNXk9oS82yvA\u00253D\u00253D");</script>
<script type="text/javascript">
//<![CDATA[
var _spFormDigestRefreshInterval = 1440000;window.g_updateFormDigestPageLoaded = new Date(); window.g_updateFormDigestPageLoaded.setDate(window.g_updateFormDigestPageLoaded.getDate() -5);function loadMDN2() { EnsureScript('MDN.js', typeof(loadFilterFn), null); }
function loadMDN1() { ExecuteOrDelayUntilScriptLoaded(loadMDN2, 'sp.ribbon.js'); }
_spBodyOnLoadFunctionNames.push('loadMDN1');//]]>
</script>
<script type="text/javascript">RegisterSod("sp.runtime.js", "\u002f_layouts\u002fsp.runtime.js?rev=IGffcZfunndj0247nOxKVg\u00253D\u00253D");RegisterSodDep("sp.runtime.js", "sp.core.js");RegisterSodDep("sp.runtime.js", "sp.res.resx");</script><script type="text/javascript">RegisterSod("sp.js", "\u002f_layouts\u002fsp.js?rev=\u00252B4ZEyA892P3T0504qi0paw\u00253D\u00253D");RegisterSodDep("sp.js", "sp.core.js");RegisterSodDep("sp.js", "sp.runtime.js");RegisterSodDep("sp.js", "sp.ui.dialog.js");RegisterSodDep("sp.js", "sp.res.resx");</script><script type="text/javascript">RegisterSod("cui.js", "\u002f_layouts\u002fcui.js?rev=OOyJv78CADNBeet\u00252FvTvniQ\u00253D\u00253D");</script><script type="text/javascript">RegisterSod("inplview", "\u002f_layouts\u002finplview.js?rev=WB6Gy8a027aeNCq7koVCUg\u00253D\u00253D");RegisterSodDep("inplview", "core.js");RegisterSodDep("inplview", "sp.js");</script><script type="text/javascript">RegisterSod("ribbon", "\u002f_layouts\u002fsp.ribbon.js?rev=F\u00252BUEJ66rbXzSvpf7nN69wQ\u00253D\u00253D");RegisterSodDep("ribbon", "core.js");RegisterSodDep("ribbon", "sp.core.js");RegisterSodDep("ribbon", "sp.js");RegisterSodDep("ribbon", "cui.js");RegisterSodDep("ribbon", "sp.res.resx");RegisterSodDep("ribbon", "sp.runtime.js");RegisterSodDep("ribbon", "inplview");</script><script type="text/javascript">RegisterSod("sp.ui.policy.resources.resx", "\u002f_layouts\u002fScriptResx.ashx?culture=en\u00252Dus\u0026name=SP\u00252EUI\u00252EPolicy\u00252EResources\u0026rev=YhBHGmUAGyJ3lAgSdE4V\u00252Fw\u00253D\u00253D");</script><script type="text/javascript">RegisterSod("mdn.js", "\u002f_layouts\u002fmdn.js?rev=gwmFFJ2\u00252FfFacqXWAqG\u00252FqKg\u00253D\u00253D");RegisterSodDep("mdn.js", "sp.core.js");RegisterSodDep("mdn.js", "sp.runtime.js");RegisterSodDep("mdn.js", "sp.js");RegisterSodDep("mdn.js", "cui.js");RegisterSodDep("mdn.js", "ribbon");RegisterSodDep("mdn.js", "sp.ui.policy.resources.resx");</script>
<script type="text/javascript">
//<![CDATA[

function _spNavigateHierarchyEx(nodeDiv, dataSourceId, dataPath, url, listInContext, type, additionalQString) {
    SetAdditionalNavigateHierarchyQString(additionalQString);
    g_originalSPNavigateFunc(nodeDiv, dataSourceId, dataPath, url, listInContext, type);
}

g_originalSPNavigateFunc = _spNavigateHierarchy;
_spNavigateHierarchy = _spNavigateHierarchyEx;
var _fV4UI = true;//]]>
</script>
<script type="text/javascript">RegisterSod("msstring.js", "\u002f_layouts\u002f1033\u002fmsstring.js?rev=QtiIcPH3HV7LgVSO7vONFg\u00253D\u00253D");</script><script type="text/javascript">RegisterSod("browserScript", "\u002f_layouts\u002f1033\u002fnon_ie.js?rev=EVTj1bu32\u00252FMla6SDN\u00252FsNTA\u00253D\u00253D");</script>
<script type="text/javascript">
//<![CDATA[
var __wpmExportWarning='This Web Part Page has been personalized. As a result, one or more Web Part properties may contain confidential information. Make sure the properties contain information that is safe for others to read. After exporting this Web Part, view properties in the Web Part description file (.WebPart) by using a text editor such as Microsoft Notepad.';var __wpmCloseProviderWarning='You are about to close this Web Part.  It is currently providing data to other Web Parts, and these connections will be deleted if this Web Part is closed.  To close this Web Part, click OK.  To keep this Web Part, click Cancel.';var __wpmDeleteWarning='You are about to permanently delete this Web Part.  Are you sure you want to do this?  To delete this Web Part, click OK.  To keep this Web Part, click Cancel.';//]]>
</script>
</form>

Go to main content

Supplement | HBS Case Collection | February 2010

Real Property Negotiation Game (CW): Excel Model

by Arthur I. Segel, John Vogel and Justin Seth Ginsburgh

Abstract

This Excel model is used to analyze the deals made in The Real Property Negotiation Game, which simulates the experience negotiating the sale, purchase, or financing of a property.

Keywords: Property; Negotiation Deal; Sales; Financing and Loans; Mathematical Methods; Real Estate Industry;

Format: Multimedia

60 length of video

Purchase

Citation:

Segel, Arthur I., John Vogel, and Justin Seth Ginsburgh. "Real Property Negotiation Game (CW): Excel Model." Harvard Business School Spreadsheet Supplement 210-703, February 2010.

About the Author

Arthur I Segel

Poorvu Family Professor of Management Practice

Finance

Entrepreneurial Management

View Profile »
View Publications »

More from the Author

Case | HBS Case Collection | June 2013 (Revised July 2017)

Angus Cartwright IV

Kenneth J. Hatten, William J. Poorvu, Howard H. Stevenson, Arthur I Segel and John H. Vogel, Jr.

Judy and John DeRight, looking to diversify their investment portfolios, have retained Angus Cartwright, Jr. to identify prospective real estate acquisitions. Mr. Cartwright has four potential properties that he feels merit an in-depth financial analysis. The case provides an opportunity to examine the various components of real estate return—cash flow, tax benefits, and futures—and measure the profitability of a proposed investment through the calculation of net present value, internal rate of return, and capitalization rate.

Keywords: Acquisition; Cash Flow; Investment Return; Investment Portfolio; Taxation; Balanced Scorecard; Valuation;

Citation:
Hatten, Kenneth J., William J. Poorvu, Howard H. Stevenson, Arthur I Segel, and John H. Vogel, Jr. "Angus Cartwright IV." Harvard Business School Case 813-185, June 2013. (Revised July 2017.) View Details

Cite View Details Educators Purchase Related
Case | HBS Case Collection | May 2013 (Revised July 2017)

Pinckney Street

William J. Poorvu, Arthur I Segel, John H. Vogel, Jr., Lisa Strope and Erich Dylus

Although inexperienced in real estate, Edward Alexander hopes in June 2013 that youthful enthusiasm and $240,000 in savings and inheritance will help him enter the real estate business. His experience chronicles the process of finding, evaluating, and acquiring a four-unit brownstone in need of renovation in the Beacon Hill area of Boston. The case also identifies the various players in the process. A rewritten version of an earlier case.

Keywords: real estate; Acquisition; Investment; Housing; Real Estate Industry; Boston;

Citation:
Poorvu, William J., Arthur I Segel, John H. Vogel, Jr., Lisa Strope, and Erich Dylus. "Pinckney Street." Harvard Business School Case 813-182, May 2013. (Revised July 2017.) View Details

Cite View Details Educators Purchase Related
Technical Note | HBS Case Collection | August 2015 (Revised July 2017)

Hotel Industry

Arthur I. Segel, Daniel Woodbury and Michael Horowitz

This note teaches the critical elements to understand the fundamentals of hotel investing, ownership, and management. It outlines the basics of hotel segmentation, operations, ownership, management, and valuation. The changing impact of technology is also addressed.

Keywords: Business or Company Management; Investment; Ownership; Accommodations Industry;

Citation:
Segel, Arthur I., Daniel Woodbury, and Michael Horowitz. "Hotel Industry." Harvard Business School Technical Note 216-012, August 2015. (Revised July 2017.) View Details

Cite View Details Educators Purchase Related

Faculty & Research

Real Property Negotiation Game (CW): Excel Model

Abstract

Citation:

About the Author

More from the Author