Real Estate Debt Financing and Scenario AnalysisCornell Course

While all commercial real estate transactions first require understanding the merits of a particular location and property, investors also pay close attention to the capital stack and the equity at risk. In fact, few deals are done with equity capital only. Using external financing to close on certain transactions is often motivated by risk-adjusted target performances. When done carefully, investors can take advantage of the cheaper cost of capital to potentially magnify their returns positively.

In this course, you will expand on the basic underwriting model for property acquisition to incorporate financial leverage and scenario analysis. The first step is to take a precise look at how the most common types of mortgages work, noting that financing and capital structure decisions are far more complex than just building amortization tables. They include crucial details that can lead to a deal's success or failure and have important ramifications down the road. To apply your learnings on the optimal balance in your deal structure, you will model a variety of scenarios across many loan types while keeping the element of uncertainty in the forefront. You will acquire a what-if mindset through this process, helping you identify the optimal capital structure given the deal you are contemplating. With this tool combining your forecasting intelligence with a strategic choice, you will be set up to expand your knowledge in new ways and grow in your role and beyond.

In this course, the professor uses Microsoft Excel for Windows for all videos and exercises which is different from Microsoft Excel for iOS. If you are a Mac user, we strongly encourage you to download Parallels or an equivalent virtual machine that is compatible with Microsoft Excel in the Windows environment.

You are required to have completed the following courses or have equivalent experience before taking this course:

• Discounted Cash Flows in Real Estate
• Unlevered Real Estate Acquisitions