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
- Equipment, office, lunch room, machinery list worksheets
- Partnership accounts worksheet
- USA benchmarks workbook
|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.