Hello. I am wondering if you can generate a series of financial
analysis for me? I am a business owner looking to star a hotel
business. I need to present this information in a business plan. I
won?t hold you to your numbers but I will use the information you
provide to create what I need the next time. I am providing rough
data to you and all my numbers are not correct and will be revised
later. As long as I get a detailed response including ?how to? I will
calculate the rest. You can also send me a response using excel which
I could use to work with the same formulas as you when I change the
numbers.
Here is the situation. I am looking at a 70 fully furnished room
hotel with a restaurant and bar, conference services, and a RV rental
park.
Nearby competitors are as follows: (hotel 1 (unnamed for privacy)
charges $122 summer and $104 winter, hotel 2 (unnamed for privacy)
charges $117 (no seasonal price differences), hotel 3 (unnamed for
privacy) charges $92 (no seasonal price differences). You can use
these numbers to provide approximate revenue figures and break them
down per season.
I am looking for sales estimates broken down per season and per month,
net earnings calculations, cost per room (70 room hotel), investment
break even in terms of time, cash flow statements (projected), income
statements (projected), and a balance sheet (I understand it will be
incomplete but I can fix it later).
Additional information needed for calculations: land and total hotel
construction cost = $5,000,000; I as owner am putting in 25% of this
figure; commercial loan is available for 60%; and, 15% is coming from
another loan.
Please use the following occupancy rates when projecting revenue per
month and per season. You may average the numbers from the data I
provide.
Occupancy rates for 2003: Jan@35%, Feb@38, Mar@41, Apr@40, May@21,
Jun@22, Jul@34, Aug@66, Sep@64, Oct@53, Nov@38, and Dec@27.
Occupancy rates for 2002: Jan@31%, Feb@38, Mar@39, Apr@35, May@18,
Jun@20, Jul@33, Aug@48, Sep@65, Oct@62, Nov@44 and Dec@32
Occupancy rates for 2001: Jan@27%, Feb@20, Mar@42, Apr@39, May@20,
Jun@22, Jul@33, Aug@38, Sep@66, Oct@51, Nov@39 and Dec@28.
Occupancy rates for 2000: Jan@32%, Feb@42, Mar@42, Apr@40, May@48,
Jun@51, Jul@75, Aug@74, Sep@74, Oct@59, Nov@47 and Dec@27.
You can get an average occupancy rate per month for the years
presented and then use this to forecast revenue per month and per
season (March, April and May for Spring; June, July and August for
Summer; September, October and November for Autumn, and December,
January and February for winter).
Thank you. I look forward to your completed work. |
Clarification of Question by
vgold-ga
on
07 Nov 2004 11:46 PST
I forgot to add the cost side of things...
Type of Expense 70 room weighted average
front desk $120,057.20
wages housekeeping $116,756.20
wages inspection $19,421.60
wages laundry $12,518.80
central resources $34,326.18
guest supplies $7,946.90
laundry and cleaning supplies $2,635.26
front desk supplies $2,091.05
office supplies $360.75
contract cleaning expense $487.50
replacement linens $9,257.95
uniforms $235.63
cable $6,225.86
high-speed internet $6,662.50
telephone $16,573.40
sales agent's commissions $2,600.00
website hosting expenses $325.00
van expense $6,126.25
training expense $1,836.25
fitness equipment replacement expense $151.13
recruitment expense $243.75
dues and subscriptions $162.50
postage and delivery $731.25
licenses and permits $975.00
bank transaction expenses $243.75
security services $975.00
marketing expense $31,727.70
print and media expense $3,900.00
promotions expense $6,825.00
electricity $0.00
gas and oil $0.00
water and sewage $0.00
electricity, gas, oil, water and sewage $50,829.40
building maintenance expense $0.00
electrical and plumbing maintenance $0.00
carpentry maintenance $0.00
painting maintenance $0.00
light bulbs $0.00
extermination expense $0.00
supplies and small maintenance tools $0.00
maintenance contracts $0.00
grounds and landscaping work $0.00
chemicals $0.00
trash removal $0.00
locks and keys $0.00
laundry equipment maintenance $0.00
van maintenance $0.00
Total maintenace expense $33,010.30
ongoing management expense $87,030.90
insurance, fire, casualty and liability expense $9,723.50
property taxes $34,104.10
$627,077.55
These should be included when calculating the break even point and
demonstrating a cashflow statement, balance sheet, etc.
The amounts presented as expense are
|
