The Ultimate in Modern Business Financial Planning & Analysis

• Assumptions (General, form, financial, inventory, loans, tax, royalties on revenues, franchise, product mix, tax, dividend, and more)
• Development planning (AE only), 5 years prior and 5 years of planning with automated development timeline
• Startup expenses - can be entered as Expendable or as Depreciable
• Investment budget (unlimited number of new/existing assets, depreciation schedule using SLN, DB, DDB or SYD)
• Funding (shareholders' capital, unlimited number of new/existing loans, deferred loans, flexible loans, amortization - 5 years)
• Beginning balance sheet (with/without historic data)
• Personnel - persons, groups or departments (max. 10), monthly and quarterly (3 years), annual (5 years)
• Personnel assumptions - payroll burden with variation for tax on wage base limit, 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) - up to 10 product lines (or market areas) and unlimited products per product line.
• Sales projections monthly & quarterly (3 years) - 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 unlimited expense rows, 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 account - automated for sales tax, income tax
• Inventory account automated (5 years)

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 task wizard (3 years) - entries are as easy as 1-2-3, with project cost, start date and end date
• Line of Credit (Overdraft) scenario

DEPENDING ON PROJECT CAN ALSO INCLUDE:

• Development planning (up to 4 phases, 5 years prior and 5 years of planning with development timeline)
• Other investments (short term, bonds and securities)
• Advertising & promotion plan detailed (3 years), annual (5 years)
• Annual ROA / ROE / SGR dynamic analysis tree (5 years)
• Annual WACC / EVA dynamic analysis trees (5 years)
• Projected ratios (5 years) - including 26 ratios, IRR/NPV, SGR, OCF, FCF, Z-score for business valuation
• Detailed break-even analysis per product line with break-even charts per product line
• Annual summary matrix (balanced scorecard) - beginning balance, income statement, cash flow, ending balance (5 years)
• Annual summarized projections (income statement, cash flow, balance sheet, ratios) up to 10 years
• Revenue analysis per product line (5 years)
• Executive dashboard

ALSO AVAILABLE

• Equipment, office, lunch room, machinery list, etc.. worksheets
• Personal financial statement
• Partnership accounts