Financial Plan

Trend setting 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 business. 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 business. If you have purchased the Advanced Edition you can view more detailed financial analysis reports of your business anytime.

Financial 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 (5 years) including 20 ratios, break-even
• Industry standards comparison (5 years)
• Loan capacity ratios (5 years)
• Financial summary with CAGR (5 years)
• Annual dynamic what-if analysis (5 years)
• Best/Worst case scenarios (Sensitivity analysis) (5 years)
• Comparison analysis - personnel, sales, advertising, income, cash flow, balance sheet (5 years)
• Timeline with a new task wizard
• Line of Credit (Overdraft) scenario

Bonus tools

• Equipment, office, lunch room, machinery list worksheets
• Services estimation worksheets
• Personal financial statement worksheet
• Partnership accounts worksheet

PlanMagic Business AE (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)
• Other investments (short term, bonds and securities)
• Projected ratios (5 years) including 26 ratios, IRR/NPV, SGR, OCF, FCF, Z-score for business valuation
• Annual summary matrix - beginning balance, income statement, cash flow, ending balance (5 years)
• Annual ROA / ROE / SGR dynamic analysis tree (5 years)
• Annual WACC / EVA dynamic analysis trees (5 years)
• Annual summarized projections (income statement, cash flow, balance sheet, ratios) up to 10 years
• Detailed break-even analysis per product line with break-even charts per product line
• Revenue analysis per product line (5 years)
• Executive dashboard
• Exchange rate wizard to easily convert values into another currency