Category Archives: Applications

08Mar/16
xdata-ltd-five-keys-to-business-success-excel-add-ins-logo.JPG

Five Keys To Business Success (Excel Add-Ins)

Five Keys To Business Success (Excel Add-Ins)

Five Excel Add-Ins For Business.

Excel add-ins provide ready made solution for forecasting, investment economics, portfolio optimization, business resource optimization and material planning.

Forecasting.xla. Calculates moving averages, exponential smoothing moving averaging, linear regression and seasonal trend analysis.

Investment Economics.xla. Calculates net present values and internal rate of return after tax for any capital investment projects. Selects projects that in aggregate meet users objectives.

Portfolio Optimization.xla. Optimises any investment portfolio to meet users objectives. Both business investments and securities investments are catered for.

Process.xla. Creates computer models to mirror business flows. Calculates the optimized scheduling of materials and resources which maximise profits. Use Process Flow to work with your line managers on each business step for scheduling the the highest optimization of scarce resources.

MRP.xla. Creates dynamic materials requirement planning (MRP) spreadsheets which optimizes the least cost solution for users’ manufacturing requirements. Including material purchasing, defines minimum inventory levels, least cost production scheduling.

Free Giveaway. Business Statistics for Excel. Instant calculation of Averages, Moving Averages, Mean, Median, Mode, Range, Frequency, Seasonality Trends, Correlation, Variance, Regression formula, Significance (T-Test), Sigma and Six Sigma values, Least Squares, Best Fit Forecasting.
Supression of unwanted zeros in data range, set upper and lower boundaries for calculations.

Download the entire Collection plus instructional templates in one zip file.

Get Five Keys To Business Success (Excel Add-Ins) now:


Purchase the full version for unlimited use

08Mar/16
xdata-ltd-excel-costing-expense-controls-logo.JPG

Excel Costing & Expense Controls

Excel Costing & Expense Controls

Our standard costing workbooks include:

Standard costs, activity based costs, overhead cost recovery ratios, cost drivers, absorption costs and cost allocation ratios in Excel.

Plus 24 Self Teaching Costing Forms ? Start a Hospitality Business – Start up cost estimator ? financial costs estimator ? food costs estimator ? market research cost estimator ? financial plan ? skill assessment estimator ? to get you started with a new hospitality business.

Complete range of product costing formula with eight ready to use costing templates iin the first workbook with Excel costing formula provide unit costs for pricing and profit recovery calculations.

Excel database supplies accurate costs into costing formula.

Benchmark costing ratios.

A ? Z spreadsheets for Marginal costing – Standard costing ? Activity based costing ? Cost drivers ? Absorption Costing values and Most economic quantity.

Formula and equations each step of the way.

Incorporate risk analysis of reaching your gross profit margin goals when customer spending patterns change and these changes impact your unit costs. Runs Monte Carlo simulations of the most probable outcomes and returns the probability of achieving whatever target is set. ITEM COSTING & EXPENSE CONTROL 1500

Item by Item Costing 1500. Every purchase is captured and logged into Excel. Assign each purchase to a category, a product type, a location and a budget (all four codes each item). Excel analyzes costs against preset budgets for your 1,500 key items and reports overspending in any category, location and budget. Calculates current unit costs, average costs, cost histories total expenditures and percentage costs to total costs and sales for each category, location, budget and supplier spend to date. Use a simple bar code reader and import item codes directly into Excel or make up your own codes. Instant over spending alerts for up to 1,500 purchase items in real time.



Get Excel Costing & Expense Controls now:


Purchase the full version for unlimited use

08Mar/16
xdata-ltd-financial-excel-collection-for-2015-logo.jpg

Financial Excel Collection for 2015

Financial Excel Collection for 2015

Our Complete Financial Excel Collection provides 150 finance spreadsheets which will help improve your business finances, analyze stock valuations, explains & demonstrates dividend maxing share portfolios, manage cash flows, create Excel budgets, identify key business ratios and model financial statements and forecasts quickly and effectively.

Activity Cost Analysis. Cost categories linked to cost database in Excel linked to work time provide complete analysis of project costs by activity and by employee work time. Suitable for R&D tax credits cost analysis, project costing, staff costing records.

Stock Dividends Maxing for Excel?increase dividend income with designer share portfolio Excel plan. Live examples from NYSE, TSX and LSE high yield portfolio.

Share valuations for Excel.

Cash management – A/P & A/R control Excel workbooks.

Financial ratio templates for Excel. Balance sheet, income statement and cash flow analysis calculates 50 key ratios, including efficiency ratios, earnings ratios, operating ratios, shareholder returns, working capital ratios, debt, sales days, inventory turnover, and liquidity.

Balanced Financial Scorecard for Excel.

Excel budgeting workbook saves you time preparing monthly budgets for multiple profit departments.

Investment-Calc provides rate of return investment analysis, forecasting and risk control spreadsheets. Present values and internal rates of return, ROIC and discounted cash flows.

Asset Accounting. Our Asset Register provides all aspects of fixed asset and property management in an easy-to-use solution.

Leasing Schedules will keep track of your lease accounts and consolidates current outstanding balances, monthly interest and repayment and forecasts annual cumulative totals and balances until repayment. Includes balloons.

Inventory Control & Scheduling keeps track of 3,000 inventory items, calculates and remembers month end inventories.

Instant Balance Sheets gives you quick calculations of source and application of funds (bank balance forecasting).

Costing & expense control including activity based costing, cost drivers, economic batch quantities, allocate overhead costs by department, allocates depreciation costs.

FastPlan helps you prepares and analyses 5 year financial plans quickly and easily. Develops Excel balance sheets, income forecasts and cash flows. Includes monthly sales forecasting & itemized monthly expenses.

Get Financial Excel Collection for 2015 now:


Purchase the full version for unlimited use

08Mar/16
xdata-ltd-fastplan-version-9-6-logo.gif

FASTPLAN Version 9.6

FASTPLAN Version 9.6

FastPlan version 9.6 provides a complete five year financial plan incorporating monthly fixed asset schedules with depreciation spreadsheets, 60 x monthly sales forecasts for multi products, forecast expenses, share capital inputs, three loan notes providing monthly interest charges and declining loan balances, plus working capital forecasts to generate five annual and monthly balance sheets, income statements and cash flow forecasts with supporting financial ratios and five years financial summary overview.

Enter this promo code into the Coupon code field located beneath the product title in the Order Form for a 25% price discount. Then click Update. Valid until November 7, 2009.

MILL-XRI5-MILL

With FastPlan you can quickly and easily change any variable input and drive the financial statements and cash flows to your target goals.

No accounting knowledge is required.

Plus three separate and additional workbooks.

1. Twelve months income statements, balance sheets and cash flows forecasting spreadsheet to develop high – low forecast scenarios to analyse your sales, profits, accounts receivable, accounts payable and total cash flows for each year for all possible outcomes.

2. Sales and Profits Risk Forecasting using Monte Carlo formulas.

3. Forecasting Risk analysis (probability of reaching goals) using Monte Carlo formulas.

FastPlan and the three additional bonus workbooks all run in Excel 2003-2007.

Download the zip file now or choose CD shipping.

Become a member of our 4,000 members club buying & selling foreign exchange at mid market prices. No bid-offer pricing. Save on all fx deals. No charges.

Get FASTPLAN Version 9.6 now:


Purchase the full version for unlimited use

08Mar/16
xdata-ltd-consolidated-budgeting-logo.JPG

Consolidated Budgeting

Consolidated Budgeting

Developed by the team retained as consultants by companies in the UK, USA and Canada to negotiate investment financing from banks, investors & corporate partnerships – 100% success ? this Excel workbook provides you with the right way to prepare a quick budget plan to present to investors.

Plus 24 Self Teaching Documents ? Start a Hospitality Business – Start up cost estimator ? financial costs estimator ? food costs estimator ? market research cost estimator ? financial plan ? skill assessment estimator ? to get you started with a new hospitality business.

Budgeting Workbook.

This quick plan yields financials that will give your potential investors the positive belief that you are pinpointing key factors that will have a major influence on actual results, identifying SKU volumes, tonnages, prices, semi variable cost ratios and fixed costs burden with drill down costing in detail and working capital throughout the plan. Produces cash flow schedules.



Get Consolidated Budgeting now:


Purchase the full version for unlimited use

08Mar/16
xdata-ltd-investment-calc-pro-irr-npv-solutions-logo.gif

INVESTMENT-CALC PRO IRR/ NPV Solutions

INVESTMENT-CALC PRO IRR/ NPV Solutions

Capital improvement investment analysis – quick and easy way to evaluate improvement projects – cash flows – rate of returns- net present values.

Present value compensation for loss of employment income including bonuses for up to 40 years (can be extended). Get the right figures. Ensure compliance.

Net present value and internal rate of cost reductions from reorganization of departments requiring severances and below the line expenses.

Net present value of loan notes.

Rate of return of real estate income project including buy and sell.

Advanced real estate project analysis.

Cash Flow Projections for 150 days

Cash Flow Analyzer for Rate of Return Values

All the equations are fully readable. Just click Cntrl and select the keyboard ‘ character to display all the formulas.

The download link for the zip file containing all eight separate workbooks will be delivered in your payment confirmation window. In addition an email will arrive with the link.

Get INVESTMENT-CALC PRO IRR/ NPV Solutions now:


Purchase the full version for unlimited use

08Mar/16
xdata-ltd-excel-add-ins-file-collection-logo.JPG

Excel Add-Ins File Collection

Excel Add-Ins File Collection

Powerful Add in files for Microsoft Excel provide extra capabilities that go well beyond standard Microsoft Excel features:

? Create pages link menu of all your spreadsheet pages for faster working.
? Bring reminders messages into Excel.
? Display formulas list with links to each formula. Makes editing and locating formula errors much quicker.
? More cell range options than provided by Microsoft.
? Convert imported numbers to true Excel formats.
? Hide zeros, text, numbers, negatives, positives with one click.
? Create 365 days calendars.
? Manage duplicates. Find and delete duplicates in your lists.
? Convert vertical data into horizontal rows with one click.
? Copy data ranges to a different part of your spreadsheets keeping the original cell references.
? Reduce files to save disk space.

Offer to swap anything with business professionals after purchase, business cards, information or private. Join our 4,000 strong swap club. The swap form is provided in the supplementary information following purchase. Change what you don’t need or want into something you do.

Get Excel Add-Ins File Collection now:


Purchase the full version for unlimited use

08Mar/16
xdata-ltd-financial-ratios-with-excel-logo.JPG

Financial Ratios with Excel

Financial Ratios with Excel

Windex 2010 calculates all major financial ratios in Excel from your balance sheet and income statements.

BREAKING NEWS – JUST PUBLISHED – OUR KINDLE EBOOK WHICH INCLUDES FINANCIAL RATIOS – COPY THIS URL INTO YOUR BROWSER TO VIEW:

Rate of Return on Assets (ROA)
Rate of Return on Common Equity (ROE)
Return on Capital (ROIC)
Common Earnings Leverage
Cash Flow from Operations/Total Cash Flow Ratio
Cash Flow from Investments/Total Cash Flow Ratio
Cash Flow from Financing/Total Cash Flow Ratio
Operating Cash Flow/Current Liabilities Ratio
Operating Cash Flow/Total Liabilities
Operating Cash Flow/Capital Expenditures
Working Capital/Current Liabilities Ratio
Working Capital/Long Term Liabilities Ratio
Working Capital/Total Debt Ratio
Working Capital/Current Assets Ratio
Working Capital/Total Assets Ratio
Income Tax Expense/Revenues Ratio
Total Assets Turnover Ratio
Fixed Assets Turnover
Current Ratio
Acid Test (See note for Quick Ratio)
Accounts Payables Turnover
Days Accounts Payables outstanding
Accounts Receivable Turnover Ratio
Days Receivables Outstanding Ratio
Inventory Turnover
Days Inventory Outstanding
Total Debt to Equity Ratio
Total Debt Coverage ratio
Long Term Debt Ratio
Long Term Debt to Total Assets
Long Term Debt to Shareholder Equity
Total Liabilities/Total Assets
Interest Coverage Ratio
Altman’s Z (Solvency) Ratio.

Zip file download or select CD edition shipping.



Get Financial Ratios with Excel now:


Purchase the full version for unlimited use

08Mar/16
xdata-ltd-quick-budget-plan-logo.gif

Quick Budget Plan

Quick Budget Plan

Our Budget Plan Excel workbook will also help you negotiate and secure investment financing from banks, investors & corporate partnerships – we scored 100% success for our clients using this approach.

Plus Self Teaching Documents ? Start a Hospitality Business – Start up cost estimator ? financial costs estimator ? food costs estimator ? market research cost estimator ? financial plan ? skill assessment estimator ? 24 forms in total to help you start a new hospitality business.

The budgeting workbook provides you with the right way to prepare a quick monthly budget plan for investors.

Ready to use templates help you forecast SKU volumes, tonnages, prices, semi variable cost ratios and fixed costs burdens.

Prepare drill down costing in detai.

Easy plan to forecast working capital requirements.

Easy plan monthly cash flow requirements.



Get Quick Budget Plan now:


Purchase the full version for unlimited use

08Mar/16
xdata-ltd-bank-loan-refund-software-logo.jpg

Bank & Loan Refund Software

Bank & Loan Refund Software

If you think you have been overcharged for a loan, mortgage, bank account through incorrect repayment amounts or wrong interest rate, unauthorized loan insurance charges, or incorrect penalty charges this dual software package is for you.

When you purchase our Bank & Loan Account Refund package you are acquiring 2 programs that will help you challenge lenders calculations, debits from your accounts and possible asset seizures.

The two programs are Bank Savings & Investment Manager with credit card, bank account and investment account checking excel spreadsheets and Loan Amortization Manager.

With Bank Savings & Investment Manager you can quickly verify all the calculations, which lead to your monthly interest charges. Compare real ending balance totals with your actual balances and challenge your account deductions if this is justified.



Get Bank & Loan Refund Software now:


Purchase the full version for unlimited use

Concepts: Interest, Mortgage loan, Investment, Personal finance, Bond, Debt, Loan, Payday loan