Scribd
Upload
39 views1 page

Hotel Budget and Earnings Overview

This document is a budget summary for a hotel showing earnings and expenses for each month of the year as well as totals. However, all figures are blank, showing zeros or the error "#DIV/0!" indicating a division by zero. This suggests the hotel has not yet opened or begun operations for the year and therefore has no financial data to report.

Uploaded by

GT
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
39 views1 page

Hotel Budget and Earnings Overview

This document is a budget summary for a hotel showing earnings and expenses for each month of the year as well as totals. However, all figures are blank, showing zeros or the error "#DIV/0!" indicating a division by zero. This suggests the hotel has not yet opened or begun operations for the year and therefore has no financial data to report.

Uploaded by

GT
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Company Budget

Summary Earnings Statement


Name of Hotel
Date

JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL % SALES PR YEAR % SALES VARIANCE
STATISTICS
Available Rooms -
Occupied Rooms -
Occupancy % 0.00%
Average Daily Rate $ -
RevPar $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

REVENUE
Rooms $ - #DIV/0! #DIV/0! -
Food $ - #DIV/0! #DIV/0! -
Beverage $ - #DIV/0! #DIV/0! -
Telephone $ - #DIV/0! #DIV/0! -
Other $ - #DIV/0! #DIV/0! -
Misc. - - - - - - - - - - - - - #DIV/0! - #DIV/0! -
TOTAL REVENUE - - - - - - - - - - - - - #DIV/0! - #DIV/0! -

DEPARTMENTAL PROFITS
Rooms $ - #DIV/0! #DIV/0! -
Food $ - #DIV/0! #DIV/0! -
Beverage $ - #DIV/0! #DIV/0! -
Telephone $ - #DIV/0! #DIV/0! -
Other $ - #DIV/0! #DIV/0! -
Misc. - - - - - - - - - - - - - #DIV/0! - #DIV/0! -
TOTAL DEPARTMENTAL PROFITS - - - - - - - - - - - - - #DIV/0! - #DIV/0! -

DEDUCTIONS FROM INCOME


Administrative & General Dept. $ - #DIV/0! #DIV/0! -
Credit Card Commission $ - #DIV/0! #DIV/0! -
Management Fee $ - #DIV/0! #DIV/0! -
Franchise Dept. $ - #DIV/0! #DIV/0! -
Marketing Dept. $ - #DIV/0! #DIV/0! -
Honored Guest Program $ - #DIV/0! #DIV/0! -
Repairs & Maintenance Dept. $ - #DIV/0! #DIV/0! -
Energy Dept. $ - #DIV/0! #DIV/0! -
TOTAL DEDUCTIONS - - - - - - - - - - - - $ - #DIV/0! - #DIV/0! -

GROSS OPERATING PROFIT - - - - - - - - - - - - - #DIV/0! - #DIV/0! -


% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

FIXED CHARGES
Incentive Fee - #DIV/0! - #DIV/0! -
Interest Expense - #DIV/0! #DIV/0! -
Property Insurance - #DIV/0! #DIV/0! -
Property Taxes - #DIV/0! #DIV/0! -
Capital Leases - #DIV/0! #DIV/0! -
FF&E Reserve - #DIV/0! #DIV/0! -
Base Rent - #DIV/0! #DIV/0! -
Percentage Rent - #DIV/0! - #DIV/0! -
Other - - - - - - - - - - - - - #DIV/0! - #DIV/0! -
Owner's Expenses - - - - - - - - - - - - - #DIV/0! - #DIV/0! -
TOTAL FIXED CHARGES - - - - - - - - - - - - - #DIV/0! - #DIV/0! -

NET OPERATING INCOME $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - #DIV/0! $ - #DIV/0! $ -


% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

You might also like