Financial Modeling & Analysis
Allow Keystone Real Estate to bring clarity to your real estate decision making.
Many investors and developers prefer to focus on executing their investment strategies and maximizing opportunities rather than building excel and ARGUS models. Clients in these and other situations turn to Keystone Real Estate to build reliable, easy to use financial models- from simple deal screens to detailed models with hundreds of assumption inputs- designed to evaluate new investment opportunities as well as conduct hold/sell and other portfolio analysis.
Well-reasoned and researched assumptions are key to good investment decisions of course, but a well-designed financial model is crucial to solid deal analysis and presentation of your project to investors and lenders. Keystone Real Estate models reduce many complex data points and assumptions into clear and easy to understand dashboards and key return metrics that clients can confidently present to investors, lenders, and stakeholders.
Ryan has years of experience modeling and underwriting commercial real estate transactions, both acquisition and development, across all property types.
Financial modeling consulting services include:
- Creation of customized commercial real estate pro-formas and financial models to support development, acquisition, or hold/sell and refinance/disposition activities.
- Creation of ARGUS DCF models to support client acquisition activities
- Auditing and enhancement of client-built Excel or ARGUS financial models
- Partnership structuring and profit sharing analysis (preferred return, promote and waterfall, and JV structures)
Financial Modeling
Ryan has well over ten thousand hours experience utilizing MS-Excel and Argus to model real estate investments, incorporating: varied unique and complex promotes and waterfall structures; multiple and variable hold periods; sensitivity and 'downside' analysis; and complicated capital stacks. He has experience modeling myriad capital sources, including construction, permanent, and mezzanine debt, EB5 financing and HUD market rate multifamily loan programs
A former CRE lender himself, Ryan is well versed in current capital markets terms and structures for construction, bridge, permanent (LifeCo, Fannie/Freddie, CMBS), and HUD financing. In the past 5 years, Ryan has sourced and closed $350 MM of CRE debt, and consulted on an additional $600+ MM of loans.
Ryan has extensive experience in commercial real estate market research, from both developer/investor and bank perspectives.
This experience includes: Demand Analysis, Economic, Demographic, and Psychographic Studies, Supply/Pipeline Analysis, Differentiation Strategies, and Competitive Set Analysis.
Ryan has well over ten thousand hours experience utilizing MS-Excel and Argus to model CRE investments, incorporating: varied unique and complex promotes and waterfall structures; multiple and variable hold periods; sensitivity and 'downside' analysis; and complicated capital stacks. He has experience modeling myriad capital sources, including construction, permanent, and mezzanine debt, EB5 financing and HUD market rate multifamily loan programs.
Ryan has underwritten hundreds of potential real estate transactions, facilitating the ground up construction of 9 multifamily projects (2800 units), the sale of a dozen stabilized assets, and the construction of office/industrial build-to suits totaling 700,000 SF.
"In anything at all, perfection is finally attained not when there is no longer anything to add, but when there is no longer anything to take away"
― Antoine de Saint-Exupéry