resort business plan financials    resort start-up business plan

PlanMagic Resort Financial Application

The Ultimate in Modern Resort Business Financial Planning & Analysis
for any resort (hotel) business

  • Assumptions (General, form, financial, inventory, loans, tax, franchise, product mix, seasons, time, packages, and more)
  • Development planning (up to 4 phases, 5 years prior and 5 years of planning with automated development timeline)
  • Investment budget (unlimited number of new/existing assets, depreciation schedule using SLN, DB, DDB, or SYD)
  • Other investments (3/5 years)
  • Funding (shareholders' capital, unlimited number of new/existing loans, deferred loans, flexible loans, amortization - 5 years)
  • Beginning balance sheet (with/without historic data)
  • Personnel plan wizard - add persons, groups or departments, monthly and quarterly (3 years), annual (5 years)

  • Accommodation plan - 3/5 years:
    -- rooms and rates (low, mid and high season, weekday, weekend, weekly, monthly, holiday)
    -- packages (type, season, rates)
    -- bookings (low, mid and high season, weekday, weekend, weekly, monthly, holiday)
    -- cost breakdown with half/full/no pension calculations, variable cost per person, per serving, per room type

  • Annual Accommodation Summary (5 years) with adjustable Occupancy Rate, ADR, and Number of Rooms. Adjustments are carried forward to the financial projections

  • Restaurant(s) and Bar(s) calculations - up to 5 each
  • Room service average calculations
  • Amenities - up to 7 amenities calculations - tel/fax, minibar, laundry, pool, activities, child care, other - 3/5 years
  • Profit centers - up to 10 profit center calculations - conference rooms, casino, gift shop, disco, health club, water park, ski center, etc..- 3/5 years
  • Concessions - 5 years per concession

  • Cost of Goods Summary
  • Sales & cost of goods projections per product line - monthly and quarterly (3 years), annual (5 years)
  • Income statement (Profit & Loss) projection - monthly and quarterly (3 years), annual (5 years)
  • Tax account - sales tax, hotel room occupancy tax, property tax, income tax
  • Inventory account (5 years)
  • Cash flow projection monthly and quarterly (3 years), annual (5 years)
  • Balance sheet projection monthly (3 years), annual (5 years)
  • Annual summarized projections (income statement, cash flow, balance sheet, ratios) up to 15 years
  • Notes to the financial statements
  • Advertising & promotion budget detailed (3 years), annual (5 years)

RESORT (HOTEL) BUSINESS ANALYSIS

  • Historic ratios (3 years)
  • Projected ratios including OCF/FCF, IRR/NPV, Z-score for business valuation (3/5 years)
  • Loan capacity ratios (3/5 years)
  • Annual summary matrix (Balanced Scorecard) - beginning balance, income statement, cash flow, ending balance (5 years)
  • Best/Worst case scenarios (Sensitivity analysis) (5 years)
  • Annual ROA/ROE/SGR dynamic analysis tree (5 years)
  • Annual WACC/EVA dynamic analysis trees (5 years)
  • Detailed break-even analysis with charts per product line
  • Annual dynamic What-If analysis (5 years)
  • Annual dynamic Sensitivity Analysis (Best/Worst Case scenarios ) (5 years)
  • Financial summary with CAGR (5 years)
  • Revenue analysis per product line (5 years)
  • Comparison analysis - personnel, sales, advertising, income, cash flow, balance sheet (5 years)
  • Line of credit (overdraft) scenario
  • Executive dashboard
  • Timeline with a task wizard (3 years)
  • Exchange rate multiplier to easily convert values into another currency

Bonus tools  BONUS TOOLS

  • Equipment, office, lunch room, machinery list worksheets
  • Partnership accounts worksheet
  • USA benchmarks workbook

Feature

Benefit
Automated from A to Z. Incomparably automated from start to finish. No manual calculations needed.
After the first year numbers are automated based on averages or increase %. Provides fast results by eliminating unnecessary manual input.
Categorized income statement. Categorized expenses and extra rows can be added.
Persons, groups, departments personnel plan wizard. Entry as simple as 1-2-3, departments, groups, persons with monthly or hourly wages, bonuses, overtime, payroll burden.
New improved accommodation planning. We made it more complete yet much easier.
More than 50 automated charts. Gives you a quick overview when and where needed.
Print wizard: quickly print any selection of predefined print areas. Saves you time collecting data to be printed. Click and Go.
Export wizard: easily export multiple values-only worksheets. Handy for conferencing or external consultants.
Exchange rate wizard: easily recalculate into another currency. Indispensable for a global presentation.