Commercial Real Estate Financial Model - Acquisition

Real Estate Analysis Tool for Commercial Real Estate Acquisition: In this video, I walk you through a detailed real estate investment analysis process, covering inputs, operating metrics, financial modeling, and partnership returns. I explain how to set up the model, input data, analyze cash flows, and evaluate project returns. Pay attention to key metrics like debt yield, levered and unlevered returns, and partnership distributions. For more information, please visit alkaline-advisors.com 00:00 Intro 01:01 Inputs Tab, General Inputs 03:23 Inputs Tab, Operating Inputs 05:31 Inputs Tab, Tax Section (Goal Seek) 07:55 Inputs Tab, Operating Reserves 10:11 Rent Roll Tab 13:03 Inputs Tab, Financing Overview, Acquisition Loan & SOFR 15:07 Inputs Tab, Pref Equity (Mezz Debt) 16:19 Inputs Tab, Perm Loan 18:28 Inputs Tab, Sensitivity Analysis 21:08 CF Tab 23:45 Partnership Returns Tab 25:43 Annual CF Tab & Loan Amortization Tab 26:08 Investor Summary Tab & Lender Summary Tab 29:29 Outro