|
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 10.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 and depreciable assets summary (5 years)
- Depreciation schedule straight line method
(5 years)
- Funding - common stock and preferred stock issuance, or proprietary capital
input for sole proprietor/partnerships (5 years)
- Loans & amortization schedule - short term, long term, deferred loans,
flexible loans (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
- Sales tax account
- Inventory account
Business analysis
- Historic ratios (3 years)
- Projected ratios including SGR and IRR/NPV for
business valuation (5 years)
- Loan capacity ratios (5 years)
- Annual summary matrix - beginning
balance, income statement, cash flow, ending balance (5 years)
- Annual dynamic sensitivity
analysis (best/worst case scenarios) (5 years)
- Comparison analysis -
personnel, sales, advertising, income, cash flow, balance sheet (5 years)
Bonus tools
- Retail store equipment list worksheet
- Personal financial statement worksheet
- Partnership accounts worksheet
- USA benchmarks workbook
PlanMagic Retail AE 10.0 (Advanced
Edition) further includes:
- Additional assumptions
- 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
- Annual dynamic what-if analysis (5
years)
- Financial summary with CAGR (5 years)
- Revenue analysis per product line (5 years)
- Dashboard
- Timeline with a new task wizard
- Exchange rate wizard
|
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 %. |
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 40 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. |
|