BnB Financial Model

The Ultimate in Modern BnB Business Financial Planning & Analysis

For any Bed and Breakfast 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 - 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 Occupancy Rate, ADR, RevPAR, CostPAR, and Available Rooms

  • 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)
BED & BREAKFAST 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)
  • 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)
  • Detailed break-even analysis with charts per product line
  • Comparison analysis - personnel, sales, advertising, income, cash flow, balance sheet (5 years)
  • Line of credit (overdraft) scenario