MS Excel Templates, VBA Code for Your Business and Home
Free 30 Day Money Back Guarantee
All Programs supplies:
Investment-Calc PRO for NPV & IRR calculations.
Cash Flow templates
10 Year financial plan templates (balance sheets, income, cash flows and ratios_ Financial
ratios for 2 and 5 periods.
Loans Amortization Manager
CheckMy Loans 2000
Budget Templates
Costing templates
Valuation templates
Buy To Rent NPV & IRR templates
Asset Register PRO templates
OS : Windows 95, 98, ME, 2000/2003 or XP & MS Office or Excel 97 or later.
Costing Templates
Costing Templates for Excel provides new costing templates for product costing including the abc system and overhead allocation formula.
OS : Windows 95, 98, ME, or XP & MS Office or Excel 97 or 2000
Operations Manager $12+
Free 30 Day Money Back Guarantee
Operations Manager contains 35 templates for manufacturing and operations decision support. All templates have a simple, consistent interface and include an actual application. Runs with Excel, Lotus & Quattro Pro. Benefits include: adjust for seasonality and predict trends, optimize economic order quantity, determine best inventory (includes reorder points & safety stocks) and workforce levels, improve production throughput and enhance customer service. Includes programs:
- Forecasting Free 30 Day Money Back Guarantee
- Inventory Management Free 30 Day Money Back Guarantee
- Material Requirements Planning Free 30 Day Money Back Guarantee
- Production Planning Free 30 Day Money Back Guarantee
- Facility Location Free 30 Day Money Back Guarantee
- Scheduling Free 30 Day Money Back Guarantee
- Quality Control Free 30 Day Money Back Guarantee
- Analysis of Waiting Lines Free 30 Day Money Back Guarantee
The programs above may be also ordered separately.
CheckMy Bank 2008 for Excel provides a quick way to check and verify compound interest calculations for overdraft bank accounts over 12 consecutive monthly periods.
Resource Manager for Excel $2400
30 Day Money Back Guarantee
Resource Manager will help you plan and schedule your key resources (workcenters, material, labor) quickly, easily, and affordably. Use just a piece to fill in the gaps of your current system, or use all of it -- Resource Manager for Excel delivers the benefits of manufacturing software without the pain. Guaranteed.
Resource Manager for Excel/BOR $600
ree 30 Day Money Back Guarantee
Resource Manager for Excel/BOR is a subset of Resource Manager for Excel/FULL and includes all sheets except Forecast, Plan, and Orders.
Key features include:
Build and Maintain multi-level, costed Bills of Material
Build and Maintain Routings
Single Job Scheduling (Forward and\or Reverse)
Rough Cut Capacity
Full Reporting
Gross MRP Reporting
Resource Manager for Excel/FORE $1200
Free 30 Day Money Back Guarantee
Resource Manager for Excel/FORE is a subset of Resource Manager for Excel/FULL and includes all sheets except Plan, and Orders.
Key features include:
Build and Maintain multi-level, costed Bills of Material
Build and Maintain Routings
Multi-Job Scheduling (Forward, Reverse, and more)
Batch Rescheduling
Order Entry
Rough Cut Capacity
Full Reporting
Gross MRP Reporting
Resource Manager for Excel/PLAN $1800
Free 30 Day Money Back Guarantee
Resource Manager for Excel/PLAN is a subset of Resource Manager for Excel/FULL and includes all sheets except Orders.
Key features include:
Build and Maintain multi-level, costed Bills of Material
Build and Maintain Routings
Multi-Job Scheduling (Forward, Reverse, and more)
Batch Rescheduling
Order Entry
Rough Cut Capacity
Full Reporting
Gross MRP Reporting
Inventory and Adjustments
Inventory Reporting
Adjusted MRP Schedules
Tracking Actuals
Rescheduling with Actuals
Spreadsheet QC $129.00
Free 30 Day Money Back Guarantee
Spreadsheet QC is a collection of templates for use with Excel, Lotus & Quattro Pro. It is ideally suited for small operations which are just beginning to implement quality improvement programs, as well as for large operations, to complement existing Total Quality Management systems, for flexible, ad-hoc reporting and individual training. By automating the main techniques in a familiar spreadsheet format, Spreadsheet QC makes statistical process and quality control more accessible.
Spreadsheet Scheduler $129.00
Free 30 Day Money Back Guarantee
Low cost and easy-to-use spreadsheet templates for Project Management, Scheduling Customer Jobs and Employees, Generating Calendars and Gantt Charts.
The Spreadsheet Scheduler is a toolkit containing 14 ready-to-use, practical models for a variety of common scheduling problems. The models are spreadsheet templates that work with all popular spreadsheets. The 14 spreadsheet-based programs provide an easy-to-use set of tools to help any organization manage projects more efficiently, improve customer deliveries, and minimize work-in-process times.
INVESTMENT-CALC PRO 2002
Free 30 Day Money Back Guarantee
Investment-Calc 2002 PRO Version 6.0 for Excel.
Top of the popularity list of single software purchases for ten months in succession,
Investment-Calc PRO provides managers and investors with quick and simple tools to
calculate NPV, DCF, IRR, EVA and ROI for any capital investment using ready made
spreadsheets which automate calculations for projects financed with leases and loans, and
supply annual interest, depreciation and tax values. Includes new sensitivity analysis
tables, which allow users to keep their original forecasts while varying their assumptions
for instant recalculations of NPV and IRR forecasts under any combination of key
variables.
New version 6.0 includes new additional workbooks for calculating the internal rate of
return of any irregular cash outflows/inflows forecast over 60 months or 50 years. Version
6.0 also incorporates a new simple list way of creating cash flow forecasts, which speeds
up calculations and reduces work time.
You can create and manipulate cash flow worksheets with ready to use forms for capital
purchases, loan and lease financing options and incremental working capital forecasts to
calculate NPV/ROI, EBIT, free cash flow and accounting rate of returns. Annual asset
depreciation calculations and loan repayment values are extracted from pre-programmed
tables. From the program library you can quickly check the capital efficiency of an asset
financed by a lease or loan, produce NPV calculations based on monthly income and expense
forecasts for up to 30 years x 12 monthly periods, set up quick 30 year models of income
(or recaptured costs) projected from new capital investment incorporating working capital,
taxes, depreciation plus additional capital investments if required during the project
term, to calculate discounted cash flows, NPV and IRR. Includes ready made compounding
templates for calculating investment deposit interest compounded on a daily
basis for any time period, any interest rate, incorporating variable deposits and
withdrawals on irregular dates, plus yearly compounding tables calculating the amount of
investment required today to replace asset prices in the future, and use the program to
calculate the NPV of a company's forecast cash flows over any period up to 20 years to
calculate business per share valuations.
This is currently our most popular program used by owners, investors, managers, law firms,
and accountants. Create and manipulate cash flow worksheets to analyse company
acquisitions, capital investments, lease purchases, using combinations of term
loan/capital lease financing, plus calculate daily compound deposit interest and optimise
capital budgeting to maximise returns. Plenty of help notes and directions are included
together with Excel Solver equations to solve capital allocation optimisation problems.
Portfolio Tracking & Monitoring
$22.00 The Portfolio Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of investments. The model allows the entering of investment transactions during a reporting period to calculate performance. Furthermore, incremental investment transactions undertaken during a period are fully accounted for in the periods performance calculations. Roll over of the model and archiving of transactions make this model ideal for monitoring your portfolio on an ongoing basis. The key features of the Portfolio Monitoring template include: Ease and flexibility of product and transaction input, with embedded help prompts. Accurate handling of distributions, investments, and divestments to calculate returns. 'Rollover' option to reset the model for a new reporting period. Storage of historical transactions. (Requires Microsoft Excel 97 or above) Portfolio OptimizationThe Portfolio Optimization model calculates the optimal capital weightings for a basket of investments that gives the highest return for the least risk. The unique design of the model enables it to be applied to either financial instrument or business portfolios. The ability to apply optimization analysis to a portfolio of businesses represents an excellent framework for driving capital allocation, investment, and divestment decisions. The key features of the Portfolio Optimisation template include: Ease and flexibility of input, with embedded help prompts. Ability to specify the number of units held in each product or business. Specify minimum and maximum constraints for the optimised portfolio. Unique 'Maintain Current Return Level' option to ensure that return is not deteriorated at the expense of risk. Intuitive graphical result display with Monte Carlo simulation, including probability analysis on specified 'Target' return level. $18.00 (Requires Microsoft Excel 97 or above) Multiple Regression Forecasting
The Multiple Regression Forecasting model provides a solid basis for identifying value drivers and forecasting data. While it utilises a range of commonly employed statistical measures to test the validity of the analysis, results are summarized in text for ease of use. Once relationships have been identified, forecasting can be accomplished based on a range of available methodologies. The intuitive step-by-step usage flow enables you to develop strong forecasts for your projects in a timely manner. The key features of the Multiple Regression Forecasting template include: Ease and flexibility of input, with embedded help prompts. User-friendly results display for the 'Non-statistician'. Multiple and Individual Regression of independent variables. Tests for statistical significance, auto-correlation, and multi-colinearity. Quick forecasting process with options to employ 3rd polynomial, 2nd polynomial, exponential or linear trend lines on independent variables. $14.00 (Requires Microsoft Excel 97 or above) Investment ValuationThe Investment Valuation model is ideal for evaluating a wide range of investment and business case scenarios. While it is based on the traditional discounted cash flow method of valuation, its also provides ability to evaluate economic value added valuation, accounting impact, and a range of other evaluation parameters. Furthermore, the step-by-step input flow makes usage straightforward, gaining quick results to drive decision-making. The key features of the Investment Valuation template include: Ease and flexibility of input, with embedded help prompts. Cost of capital calculation. Economic value added valuation with flexibility on identifying economic costs with specific amortization periods. Accurate handling of asset purchase, disposal and depreciation with capital and gearing impacts. Evaluation of new investments or changes to existing investments. Unique 'finite' terminal value calculation alternative to mimic investment life cycles. Unique Comparative Investment Score can be set to evaluate and prioritise different investments, depending on the prevailing business environment. $26.00 (Requires Microsoft Excel 97 or above) Excel SchedulerFree 30 Day Money Back Guarantee Project Management, Gantt Charting, and Employee Scheduling. For all versions of Microsoft Excel. To run Excel Scheduler, simply run Excel and read in template(s) of choice. Project Management: CPMDAILY.XLS CPMHOUR.XLS CPMWEEK.XLS Gantt Charting GANTDAY.XLS GANTHOUR.XLS GANTWEEK.XLS Employee Scheduling DAYSOFF.XLS
MS Excel TopicsYou can find below MS Excel add-ins, MS Excel Spreadsheets, and MS Excel Templates, MS Excel Workbooks, VBA Code for Excel for your business & home. |