Company Budget
Summary Earnings Statement
Name of Hotel
Date
JAN
STATISTICS
Available Rooms
Occupied Rooms
Occupancy %
Average Daily Rate
RevPar
REVENUE
Rooms
Food
Beverage
Telephone
Other
Misc.
TOTAL REVENUE
DEPARTMENTAL PROFITS
Rooms
Food
Beverage
Telephone
Other
Misc.
TOTAL DEPARTMENTAL PROFITS
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
TOTAL
GROSS OPERATING PROFIT
%
#DIV/0!
FIXED CHARGES
Incentive Fee
Interest Expense
Property Insurance
Property Taxes
Capital Leases
FF&E Reserve
Base Rent
Percentage Rent
Other
Owner's Expenses
TOTAL FIXED CHARGES
$
#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!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
% SALES
$
$
$
$
$
DEDUCTIONS FROM INCOME
Administrative & General Dept.
Credit Card Commission
Management Fee
Franchise Dept.
Marketing Dept.
Honored Guest Program
Repairs & Maintenance Dept.
Energy Dept.
TOTAL DEDUCTIONS
NET OPERATING INCOME
%
FEB
$
$
$
$
$
$
$
$
$
#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!
PR YEAR
% SALES
VARIANCE
$
$
0.00%
-
#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!
#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!
#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!
#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! $