Hotel Business Plan Template

Financial Plan

Key Revenue & Costs

The revenue drivers for Pegasus Hotel are the revenues it will collect when guests book a reservation at the hotel. The hotel will also collect revenues from its restaurant and bar, spa, and events it will host.

The cost drivers will be the payroll and overhead costs to staff the hotel. Other costs will involve the land lease, utilities, marketing costs, and technology fees. There will also be costs associated with the maintenance of the hotel, food and beverage inventory, spa inventory, and hotel guest room supplies.

Funding Requirements and Use of Funds

Pegasus Hotel is seeking $10,000,000 in debt financing to begin constructing the hotel and commence operations of the business. The funding will be dedicated towards securing the land lease and the hotel build-out and design. Funding will also be dedicated towards three months of overhead costs to include payroll of the staff, furniture, fixtures, and equipment, initial inventory, and working capital. The breakout of the funding is below:

  • Secure the land lot, architecture, build-out, and design: $6,000,000
  • Hotel furniture, fixtures, and equipment: $2,000,000
  • Initial inventory: $750,000
  • Three months of overhead expenses (payroll, rent, utilities):  $1,000,000
  • Marketing & advertising: $150,000
  • Working capital: $100,000

Key Assumptions

The following outlines the key assumptions required in order to achieve the revenue and cost numbers in the financials and in order to pay off the startup business loan.

  • Initial Number of Room Nights Sold per Month: 8,000
  • Number of Events per Month: 30
  • Land Lease per Year: $1,500,000

Financial Projections

Income Statement

  FY 1FY 2FY 3FY 4FY 5
Revenues
Total Revenues$360,000$793,728$875,006$964,606$1,063,382
Expenses & Costs
Cost of goods sold$64,800$142,871$157,501$173,629$191,409
Lease$50,000$51,250$52,531$53,845$55,191
Marketing$10,000$8,000$8,000$8,000$8,000
Salaries$157,015$214,030$235,968$247,766$260,155
Initial expenditure$10,000$0$0$0$0
Total Expenses & Costs$291,815$416,151$454,000$483,240$514,754
EBITDA$68,185 $377,577 $421,005 $481,366 $548,628
Depreciation$27,160$27,160 $27,160 $27,160 $27,160
EBIT$41,025 $350,417 $393,845$454,206$521,468
Interest$23,462$20,529 $17,596 $14,664 $11,731
PRETAX INCOME$17,563 $329,888 $376,249 $439,543 $509,737
Net Operating Loss$0$0$0$0$0
Use of Net Operating Loss$0$0$0$0$0
Taxable Income$17,563$329,888$376,249$439,543$509,737
Income Tax Expense$6,147$115,461$131,687$153,840$178,408
NET INCOME$11,416 $214,427 $244,562 $285,703 $331,329

 

Balance Sheet

  FY 1FY 2FY 3FY 4FY 5
ASSETS
Cash$154,257$348,760$573,195$838,550$1,149,286
Accounts receivable$0$0$0$0$0
Inventory$30,000$33,072$36,459$40,192$44,308
Total Current Assets$184,257$381,832$609,654$878,742$1,193,594
Fixed assets$180,950$180,950$180,950$180,950$180,950
Depreciation$27,160$54,320$81,480$108,640 $135,800
Net fixed assets$153,790 $126,630 $99,470 $72,310 $45,150
TOTAL ASSETS$338,047$508,462$709,124$951,052$1,238,744
LIABILITIES & EQUITY
Debt$315,831$270,713$225,594$180,475 $135,356
Accounts payable$10,800$11,906$13,125$14,469 $15,951
Total Liability$326,631 $282,618 $238,719 $194,944 $151,307
Share Capital$0$0$0$0$0
Retained earnings$11,416 $225,843 $470,405 $756,108$1,087,437
Total Equity$11,416$225,843$470,405$756,108$1,087,437
TOTAL LIABILITIES & EQUITY$338,047$508,462$709,124$951,052$1,238,744

 

Cash Flow Statement

  FY 1FY 2FY 3FY 4FY 5
CASH FLOW FROM OPERATIONS
Net Income (Loss)$11,416 $214,427 $244,562 $285,703$331,329
Change in working capital($19,200)($1,966)($2,167)($2,389)($2,634)
Depreciation$27,160 $27,160 $27,160 $27,160 $27,160
Net Cash Flow from Operations$19,376 $239,621 $269,554 $310,473 $355,855
CASH FLOW FROM INVESTMENTS
Investment($180,950)$0$0$0$0
Net Cash Flow from Investments($180,950)$0$0$0$0
CASH FLOW FROM FINANCING
Cash from equity$0$0$0$0$0
Cash from debt$315,831 ($45,119)($45,119)($45,119)($45,119)
Net Cash Flow from Financing$315,831 ($45,119)($45,119)($45,119)($45,119)
Net Cash Flow$154,257$194,502 $224,436 $265,355$310,736
Cash at Beginning of Period$0$154,257$348,760$573,195$838,550
Cash at End of Period$154,257$348,760$573,195$838,550$1,149,286