We are still in Beta - Contact us if you find any errors!
HOTEL ANALYSIS
BankOpedia gives you the tools you need to analyze your hotel's cash flow in an excel workbook.
HOTEL ANALYSIS INSTRUCTIONS
Hotel Analysis Instructions
Complete the basic information for the project in Section A. Fill in the cells with blue text font. Only gold cells include inputs.
Input the proforma Average Daily Rate (ADR) and Occupancy Rates in Section B. Also add the numbers of rooms and average size, in square fee, in Section B.
Optional: if you have existing financial information for the property, complete Section C and the far right columns in Sections D and Section E. This information should be annualized.
If you don't have existing information, add the proforma income and expense information in Section D.
Income and Vacancy Sensitivity Analysis
Change the Percentages in Section A to see the impact of increases or decreases in renal rates on your net operating income, debt coverage, property value and loan-to-value.
Change the Vacancy Rates in Section B to see the impact of different Vacancy Rates on 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
Understand the impact of increasing interest rates on your property. Section A reflects the debt coverage at various interest rates, on an interest only basis and with principal and interest.
Section B reflects the Break-Even Interest Rate on an Interest Only AND an amortizing basis.
Analyze different amortization scenarios by changing the Amortization for Scenario #2 in Section C.
The only input on this worksheet is the alternate amortization.