PlanMagic Retail 11.0

The financial workbook

Trend setting retailer financial plan workbook in XLS (MS Excel) format that knows no competition. You will not find a better solution as detailed and as automated for any type of retailer. Enter the required main assumptions, add product lines and products as is needed, and start entering your financial data into the clearly marked cells. Use it for a business plan and for ongoing monitoring of your retail business. If you have purchased the Advanced Edition you can view more detailed financial analysis reports of your retail business anytime.

PlanMagic Retail 11.0 Financial Plan Workbook

- A products wizard to add up to 10 product lines and unlimited products per product line
- Assumptions (general, formation, financial, sales, inventory, expenses, tax, dividend, franchise)
- Investment budget - incl. start-up costs for start-ups, unlimited number of new/existing assets, and depreciable assets summary (5 years)
- Depreciation schedule using SLN, DB, DDB, or SYD (5 years)
- Funding - common stock and preferred stock issuance, or proprietary capital input for sole proprietor/partnerships (5 years)
- Loans & amortization schedule - unlimited number of new/existing loans, deferred loans, flexible loans, amortization (5 years)
- Beginning balance sheet with automated financing check
- Balance sheet historic (3 years)
- Income statement historic (3 years)
- A personnel wizard to add up to 10 departments and an unlimited number of persons and groups per department
- Personnel assumptions - payroll burden, hourly/overtime rates, bonuses payment schedule
- Personnel plan monthly & quarterly (3 years) - with headcount, payroll, overtime, bonuses and payroll burden summary
- Personnel plan annual (5 years)
- Product details & cost of goods with minimum stock level entry (3 years) - Add/Edit/Remove product lines and products
- Sales projections monthly & quarterly (3 years) - enter sales by units or amounts, or in bulk per product line, rebates & allowances
- Sales projections annual (5 years)
- Income statement (Profit & Loss) monthly & quarterly (3 years) - with automated discounts & returns, bad debts and losses & thefts.
- Income statement (Profit & Loss) annual (5 years) - with EBITDA and earnings per share details for companies
- Cash flow projection monthly & quarterly (3 years) - direct method used
- Cash flow projection annual (5 years)
- Balance sheet projection monthly (3 years)
- Balance sheet projection annual (5 years) - with no. of shares issued and net asset value per share details
- Notes to the financial statements - with automated data from the projections
- Tax accounts - sales and income tax
- Inventory account

Business analysis

- Historic ratios (3 years)
- Projected ratios - incl. SGR and IRR/NPV, (AE only: Z-score) for business valuation (5 years)
- Industry standards comparison (5 years)
- Loan capacity ratios (5 years)
- Annual summary matrix - beginning balance, income statement, cash flow, ending balance (5 years)
- Annual dynamic what-if analysis (5 years)
- Annual dynamic sensitivity analysis (best/worst case scenarios) (5 years)
- Comparison analysis - personnel, sales, advertising, income, cash flow, balance sheet (5 years)
- Overdraft scenario

Bonus tools

- Retail store equipment list worksheet
- Personal financial statement worksheet
- Partnership accounts worksheet
- USA benchmarks workbook

PlanMagic Retail AE 11.0 (Advanced Edition) further includes:

- Additional assumptions
- Development planning (up to 4 phases, 5 years prior and 5 years of planning with automated development timeline)
- Advertising & promotion plan detailed (3 years)
- Advertising & promotion plan annual (5 years)
- Annual ROA / ROE / SGR dynamic analysis tree (5 years)
- Detailed break-even analysis per product line with break-even charts per product line
- Financial summary with CAGR (5 years)
- Revenue analysis per product line (5 years)
- Dashboard
- Timeline with a new task wizard
- Exchange rate wizard - to easily convert values into another currency

NEW FEATURES

Feature	Benefit
Automated from A to Z.	Completely automated from start to finish.
After the first year numbers are automated based on averages or increase % using our Smart Entry System (SES)™.	Provides fast results by eliminating unnecessary manual input.
New improved categorized income statement.	Categorized expenses and extra rows can be added.
New improved 1-2-3 personnel plan wizard.	Entry as simple as 1-2-3, departments, groups, persons with monthly or hourly wages, bonuses, overtime, payroll burden.
New improved 1-2-3 products wizard.	Add product lines or market areas and products quickly and easily.
New improved sales projections.	Enter monthly sales by units or amounts per product, or in bulk per product line.
More than 60 automated charts.	Gives you a quick overview when 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.