bnb business plan financials    bnb start-up business plan

PlanMagic BnB Financial Application

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, and more)
  • Development planning (up to 4 phases, 5 years prior and 5 years of planning with automated development timeline) [Hotel 12 & Resort 12 only]
  • Investment budget (unlimited number of new/existing assets, depreciation schedule using SLN, DB, DDB, or SYD)
  • Other investments (3/5 years) [Hotel 12 & Resort 12 only]
  • 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, 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) - [Hotel 12 & Resort 12 only]
    -- bookings (low, mid and high season, weekday, weekend, weekly, monthly, holiday)
    -- summary - 3 years monthly and 5 years annual
    -- cost breakdown with half/no pension calculations, variable cost per person, per serving, per room type
  • Food & beverages calculations
  • Restaurant and Bar calculations - [Hotel 12 & Resort 12 only]
  • Room service average calculations - [Hotel 12 & Resort 12 only]
  • Amenities - [Hotel 12 & Resort 12 only]
  • Profit centers - [Hotel 12 & Resort 12 only]
  • Concessions - [Hotel 12 & Resort 12 only]
  • Cost of Goods overview
  • 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 - [Hotel 12 & Resort 12 only]
  • Notes to the financial statements
  • Advertising & promotion budget detailed (3 years), annual (5 years) [Resort 12 only]

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)
  • Financial summary with CAGR (5 years)
  • Annual summary matrix (Balanced Scorecard) - beginning balance, income statement, cash flow, ending balance (5 years)
  • Annual ROA/ROE/SGR dynamic analysis tree (5 years) - [Hotel 12 & Resort 12 only]
  • Annual WACC/EVA dynamic analysis trees (5 years) [Resort 12 only]
  • 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)
  • Revenue analysis per product line (5 years) - [Hotel 12 & Resort 12 only]
  • 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 - [Hotel 12 & Resort 12 only]

Bonus tools  BONUS TOOLS

  • Equipment, office, lunch room, machinery list worksheets
  • Partnership accounts worksheet
  • Personal financial statement 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.
Personnel plan wizard. Entry as simple as 1-2-3, persons with monthly or hourly wages, bonuses, overtime, payroll burden.
New improved accommodation planning. We made it more complete yet much easier.
More than 40 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.