XT2 Team Features

Team-based workflow!

• Up to 5 users work together on a budget/forecast simultaneously.
• Team Leader maintains data integrity by approving team changes.

Getting Started

• Import trial balance, months P&L, months balance sheet
• Key in a financial statement and in minutes 90% complete.
• Key in data or import from QuickBooks, Peachtree, GreatPlains, Excel or any accounting software

Sales

• Calculate annual sales by month plus collections
• 3 methods of calculating sales collections:
  • Percentage of sales
  • Developed pattern (so much collected in following month etc.)
  • Collections computed based on days sales in accounts receivable.
• Sales by product, customer any unit of production desired. Collections can be different assumptions for each unit.
• Revenue using percentage of completion method of accounting.

Management Reports

• Credit availability analysis
• Payroll spreadsheet
• Comparative P&L (actual vs forecast)
• Comparative cash flow (actual vs forecast)
• Comparative Balance Sheets and financial ratios
• Monthly ratios with exceptions
• Integrated actual with your budget/forecas
• Sales by product Analysis
• Break-even analysis
• Ratio analysis
• Job cost analysis
• Sales by product vs. actual products sold
• Plus 14 additional reports:
  • P&L: monthly, quarterly, year to date
  • Cash flow: monthly, quarterly, year to date, indirect and direct methods
  • Term loans report
  • Notes receivable report
  • Notes and assumptions automatic
  • Graphics

Additional Cost of Goods Sold

• By product, customer, employee etc.
• Develop cost using 33 cost items

Expenses

• Up to 250 expenses
• 9 expense departments
• 11 methods to calculate an expense:
  • Percent of sales
  • Fixed expense
  • Percent of another expense
  • As you wish
  • When you know the expected amount
  • Adjust prior years expenses +/-
  • Drill it down into unlimited items
  • Linear regression
  • Product by units x cost per unit
  • 52 weekly amounts
  • Relate and compute expense based on product, customers revenue

Other Items

• Amortization of prepaid expenses
  • Edit the payment assumption to be applied to an expense
• Multiple year forecasting up to 5 years or more
• Have up to 99 forecasts online
• Sales tax payment and collection
• Interest on cash balances
• Dividends: charge equity or show as an expense
• Loans to/from affiliates and much more!
• Forecast payroll by employee
• Consolidate multiple entities
• Roll the forecast forward for 1,2 or 3 months
• 1 to 13 week cash flow forecast
• Customer deposits on A/R
• Convert reports to non-profit status
• Service contracts, amortization with related deferred income
• Expense computed on net income
• Drill Down and roll up an expense
• Payroll by employee if desired

Business Valuation Methods

• 12 business tools including business valuation
• Currency Converter
• Discounted cash flow
• Capitalization of excess earnings

Driver Calculator

• Our answer to the spreadsheet - very powerful!

And much more!