This sheet allows you to report the history for the chart of accounts for the subject and report all the departments' revenue and expenses. This sheet is a pre-requisite for the Revenue + Expense Operating History sheet.
This guide shows you how to use the Revenue and Expense and Revenue and Operating History sheets in your Hospitality Workbook.
Pre-Requisites
- Subscription Tier:
- Enterprise: Included with the Subscription fee
-
Professional: Available as an Add-On
- Please contact the Client Success Manager if you want to upgrade your subscription to access the Valcre Hospitality Workbook and Word Report template.
- Downloaded Hospitality Template from Valcre Online.
- Set up the Hospitality Valuation Workbook & complete all previous sheets.
Table of Contents
Video
How-to Guide
Step 1: Access the Revenue and Expenses sheet by selecting H_IE_IN from the bottom or left-side menu.
This sheet is set up to allow you to input data for:
- Revenue History
- Operated Department Expenses History
- Undistributed Expenses History
- Fixed Expenses & Costs History
Revenue History
Step 1: Identify the Assigned Revenue Names you will be using.
We default to standard revenue names: Rooms, Food & Beverage, Other Operated Departments, and Rentals & Others. You can adjust them as necessary.
Step 2: Enter the borrower's information, and those items are associated with the chart of accounts.
If the borrower has multiple line items associated with the Assigned Revenue Name, select the same Assigned Revenue Name again in the appropriate blue field.
Step 3: Enter the historical data for each line item
Note: Operators Pro Forma - this is not the year one forecast you would have in the Operations sheet
| Pro-Tip: The tables on this sheet do not have a Word file for your Word Report but feed into the Revenue and Operating History sheet, which can be added to your Word Report. |
Step 4: Enter your summary of conclusions for this section (Optional)
Use the yellow box at the top of the table to enter your summary for the reader.
Operated Department Expenses History
Step 1: Identify the Assigned Expenses Names you will be using.
We default to standard revenue names: Rooms, Food & Beverage, Other Operated Departments, and Rentals & Others. You can adjust them as necessary.
Step 2: Enter the borrower's information, and those items are associated with the chart of accounts.
If the borrower has multiple line items associated with the Assigned Expenses Name, select the same Assigned Revenue Name again in the appropriate blue field.
Step 3: Enter the historical data for each line item
Note: Operators Pro Forma - this is not the year one forecast you would have in the Operations sheet
| Pro-Tip: The tables on this sheet do not have a Word file for your Word Report but feed into the Revenue and Operating History sheet, which can be added to your Word Report. |
Step 4: Enter your summary of conclusions for this section (Optional)
Use the yellow box at the top of the table to enter your summary for the reader.
Undistributed Expenses History
Step 1: Identify the Assigned Expense Names you will be using.
We default to standard revenue names: Administrative & General, Info & Telecom, Marketing, Franchise, Property Operations & Maintenance, and Utility Costs. You can adjust them as necessary.
Step 2: Enter the borrower's information, and those items are associated with the chart of accounts.
If the borrower has multiple line items associated with the Assigned Revenue Name, select the same Assigned Revenue Name again in the appropriate blue field.
Step 3: Enter the historical data for each line item
Note: Operators Pro Forma - this is not the year one forecast you would have in the Operations sheet
| Pro-Tip: The tables on this sheet do not have a Word file for your Word Report but feed into the Revenue and Operating History sheet, which can be added to your Word Report. |
Step 4: Enter your summary of conclusions for this section (Optional)
Use the yellow box at the top of the table to enter your summary for the reader.
Fixed Expenses & Costs History
Step 1: Identify the Assigned Revenue Names you will be using.
We default to standard revenue names: Management Fee, Real Estate Taxes, Property Insurance, and Reserve for Replacement. You can adjust them as necessary.
Step 2: Enter the borrower's information, and those items are associated with the chart of accounts.
If the borrower has multiple line items associated with the Assigned Expense Name, select the same Assigned Expense Name again in the appropriate blue field.
Step 3: Enter the historical data for each line item
Note: Operators Pro Forma - this is not the year one forecast you would have in the Operations sheet
| Pro-Tip: The tables on this sheet do not have a Word file for your Word Report but feed into the Revenue and Operating History sheet, which can be added to your Word Report. |
Step 4: Enter your summary of conclusions for this section (Optional)
Use the yellow box at the top of the table to enter your summary for the reader.
Revenue and Operating History Sheet
This table will include the Revenue and Expense information provided in the Revenue and Expenses sheet.
Step 1: Access the Revenue and Operating History
Select H_IE from the bottom or left-side menu.
Step 2: Review the data
Step 3: Summarize the data displayed in the chart (Optional)
Step 4: Add the table to the Word Report if not already added.
Use the Insert Link feature in the Word Report to insert the table using the table name HIA_Historical, at the bottom of each table.
Once you have completed all necessary information in the Income and Expenses sheet and reviewed the Revenue & Expense Operating History sheet, you can move on to the Revenue and Expenses sheet in the Hospitality Workbook.
For additional questions about using the Income and Expenses or Revenue & Expense Operating History sheet in the Hospitality Valuation Workbook, please get in touch with Valcre Support using the Online Chat using Valcre Online or Valcre Mobile.