MS Excel Templates, VBA Code for Your Business and Home

Financial Excel Collection for 2015 

five_stars.gif (379 bytes)

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 XP/2000 or later & MS Office or Excel 2000 or later.

More Info

Costing Templates

five_stars.gif (379 bytes)

Costing Templates provides new costing templates for product costing including the abc system and overhead allocation formula.

OS : Windows 98 or later & MS Office or Excel 97 or later.

More Info

Portfolio Tracking & Monitoring

five_stars.gif (379 bytes)

$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)

More Info

Portfolio Optimization 

The 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)

More Info

Multiple Regression Forecasting

five_stars.gif (379 bytes)

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)

More Info

Investment Valuation

The 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)

More Info

Excel Scheduler

Free 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

More Info

 

MS Excel Topics

You can find below add-ins, MS Excel Spreadsheets, and Templates, Workbooks, VBA Code for your business & home.

Accounting Converting Management
Analysis E-Books Marketing
Budgeting Finance Planning
Calculators Forecasting Project Management
Cars Accounting Employment Quality Control
Charting Inventory Management Scheduling
Checks Investment Management Wage Calculation

Home