We are still in Beta - Contact us if you find any errors!
OFFICE PROPERTY ANALYSIS
BankOpedia gives you the tools you need to analyze your office project's cash flow in an excel workbook.
OFFICE PROPERTY ANALYSIS GUIDE:
Office Analysis Instructions
After you complete the rent roll (see below for rent roll instructions), fill in the cells with blue text font. Only gold cells have blue text.
Complete the basic information for the project in Section A.
Optional: if you have existing financial information for the property, complete Section B and the far right columns in Sections C, Section D, and Section E. This information should be annualized.
If you don't have existing information, add any proforma "other income" to section Section C.
Add the proforma expenses for Section D. The management fee is entered as a Percent of Effective Gross Income in Section F.
NOTE: THE SECTIONS LETTERS (A-F) ARE NOT INCLUDED ON THE EXCEL SPREADSHEETS AND ARE FOR INSTRUCTIONAL PURPOSES ONLY.
Income and Vacancy Sensitivity Analysis
Change the Vacancy Rates in Section A to see the impact of different Vacancy Rates on net operating income, debt coverage, property value, and loan-to-value.
Change the Percentages in Section B to see the impact of increases or decreases in renal rates on your net operating income, debt coverage, property value and loan-to-value.
The Percent Changes in Sections A and B are the only inputs on this worksheet.
Interest Rate Sensitivity Analysis
Analyze different amortization scenarios by changing the Amortization for Scenario #2 in Section A.
The top section analyzes the cash flow coverage and break-even interest rate on an interest only and a fully amortizing basis.
The Bottom section analyzes maximum loan amounts at various interest rates.
The only input on this worksheet is the alternate amortization.