The financial workbook

http://planmagic.com 

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.
 

BACK NEXT

Web site