MS Excel Spreadsheets, VBA Code for Your Business and Home
INVESTMENT-CALC PRO 2002
$125.00
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.
OzGrid Plus and Duplication Manager+ free Excel Download Package ($12.95) + free File Size Reducer for Excel
Savings! $59.90
$39.95
Formula Report Generator:
Allows you to very easily create a report showing
formulas within your Workbook that are either external
references, internal references or both. You can also
nominate which Worksheet(s) to use to base your report
on.
Dynamic Range Namer:
This will allow you to very quickly and easily create
any one of eight different types of dynamic ranges that
will expand down rows or across columns. You can even
nominate the column or row to use as the criteria. It
can also expand automatically each day month or
week.
Real Calendar:
This one will create a live calendar in an instant
using real dates, so you can reference it if needed.
The current day is always highlighted and updates
automatically.
Sheet Creator and Sorter:
This option will create any number of pre-named
worksheets which can be Financial Years (1901-2050),
Weekdays (Monday-Sunday), Months (January-December),
Years (1901-2050), Quarters (Quart1-Quart4), Days
(Day1-Day1460) and Weeks (Week1-Week208). It also has
an option that allows you to Sort (ascending or
descending) any Worksheets in any Workbook.
A Random Number Generator:
This can produce up to 1000 non repeating random
numbers that meet a criteria you specify.
Conditional Row Deletion:
This one will save many hours of repetitive work when
you need to quickly and easily delete rows in a
Worksheet that meet any criteria. There is an option
that allows you to easily nominate any one of Excels
six Error Types, or all of them. There is also a simple
option that allows you to nominate the criteria.
Duplication Report:
Will produce a statistical table of your data.
Including a Count of occurrences of each item, the
total number of duplicates and a total of all entries.
It will also produce a list of your data containing
only unique entries. Better than a Pivot Table in a
single click.
Excel Duplication Manager Add-in:
This very handy add-in will make your management of
lists a breeze. It is designed to assist you when you
have duplicates in 1 or more lists. You can create a
list of uniques, hide all duplicates, create a summary
report, color code all duplicates up to 3 levels and
even prevent users from adding duplicates to a list or
table! There is also the option to compare 2 lists for
matching entries and remove duplicate lines from a
table.
Do On Time:
This feature allows you to run a macro (recorded or
written) at a set time, display a personal message or
reminder at a specified time or even open a nominated
Workbook at a set time.
Sheet Index Creator:
Have a workbook with a large number of Worksheets?
Find it hard and too time consuming navigating through
all the sheets? This option allows you to easily create
an Index Sheet that has click-able links to all sheets.
It also has the option of placing a "Back to Index"
link on all the sheets.
File Size Reducer:
It's a common problem with Excel Workbooks to increase
in size unrealistically, even after you think you have
cleared out all the data. The File Size Reducer has
become extremely popular as it can reduce unrealistic
file size by 50% or more! All you need to do is install
the add-in and click the button.
Excel 97/2000/XP and Windows
Excel Time Sheet Advanced+ free Excel Download Package ($12.95) + free File Size Reducer for Excel
$29.95
This extremely easy and simple to use Excel Time
Sheet will keep track of your employees hours. It
allows you to specify and set unpaid breaks in 5 minute
intervals on a daily basis. If your employees work
hours that span into a new day, no problem, the time
calculations will accommodate this. All Start and End
times span a 24 hours period in 15 minute intervals,
all you do is select a Start time and End time from a
drop down list. This makes it impossible to enter times
that Excel wont recognize.
The Time Sheet incorporates a 1, 2, 3 or 4 week period
with any week and/or day being optional. All you do is
enter your employee names once, save as a Template and
you are set.
1 Enter your employee names in the cells below
Employee Name. The same names will automatically flow
through to Week2, Week3 and Week4.
2 Select the starting date from directly below Week 1
Includes. 7 day periods will automatically flow through
to Week2, Week3 and Week4.
3 Once you have done this, go to File>Save As and
Save as a Template into the path that Excel defaults
to.
4 If Week2, Week3 or Week4 are not needed, simply
ignore them and do not enter any times on them.
5 You can now add the Time Sheet as a Template
Workbook simply by going to File>New
The Totals sheet has a very easy to use Pivot Table
which is based off all employees and their hours. You
can simply specify to display results by Week and/or by
Name or show All Names and/or All Weeks. Double
clicking on any hours within the Total Hours field will
give you a Break Down of the displayed data.
Excel 97/2000/XP and Windows
TimeAndWageBook + free Excel Download Package ($12.95) + free File Size Reducer for Excel
$35.00
Free 30 Day Money Back Guarantee
If you need to track employee hours and calculate their pay based on the hours worked, this Workbook will make it a breeze! It is an Excel Workbook which you enter, one time only, all your employee names into. You then enter their hourly rate and then simply enter their total hours worked for each day. It also has the option to add 2 different overtime rates and the hours after which these rates apply, all calculations are done for you! You can also (optionally) add 2 different rates for both Saturday and Sunday rates. If your employees work Public holidays, there is another option for Public holiday rates. All you do is fill in the needed details once and save as a Template.
Excel 97/2000/XP and Windows
FASTPLAN PRO $125
Free 30 Day Money Back Guarantee
FASTPLAN 2001 provides an
integrated suite of spreadsheets for Excel 97 &
2000 which build monthly business plans for any period
up to 5 years and calculates 5 year balance sheets,
income statement and cash flow forecasts. Monthly build
up provides product unit sales forecasting, price
variations, and cost of sales assumptions.
Risk analysis feature recalculates financial forecasts
for any change in revenue assumptions.
FastPlan PRO Version 3.0 provides fast track compilation of 5-year financial plans for a single business to plug straight into your business plans for presentations to venture capital sources, investors, banks, or for company planning purposes. Version 4.0 combines multiple FastPlan PRO Excel workbooks into one consolidated five year balance sheets, income statements and cash flow statements for a group of companies or budgets. Incorporate federal and state income tax calculations. More Info
Spreadsheet xlNavigator 2003 TM
Spreadsheet XlNavigator is a neat Excel add-on that lets you see the relationship of formula cells in your complex workbooks. Have you ever wished for an easy, flow-chart view of a complex spreadsheet so that you could immediately identify precedent and dependent cells? Now you can with XlNavigator. Simply highlight the cells or sheets you want to view and instantly see a chart depicting which cells feed data to which other cells. A zoom feature lets you focus on the area of interest and a global view lets you move a small highlight frame to wherever you wish. Spreadsheet XlNavigator is easy to use and you'll appreciate the insight into your workbooks. Key Benefits Navigate the spreadsheet using cell precedent-dependent representation. Flow chart representation emphasizes calculation order. Direct link between xlNavigator representation and Excel spreadsheet cells. Visual representation makes troubleshooting complex spreadsheets much easier.
The Spreadsheet XlNavigator 2003 version replaces
the 2002, and 2000 versions. Many new features such as
edge navigation, ability to resize the form have been
added.
Advanced Excel Find
Awards:5 Stars
If you are not satisfied
with the Excel's built-in Find where you have to make
numerous clicks to find the information needed, the
Advanced Excel Find can serve all your needs.
It enhances Excel's built-in Find and makes search
through multiple worksheets and workbooks in Excel fast
easy and comfortable. The whole thing takes you just a
few seconds and a couple of clicks.
The Advanced Excel Find has all features of the
Excel's built-in Find and besides you have the
advantages of simultaneous search in values, formulas
and comments; search in all or selected worksheets and
workbooks at the same time; multiple selections of the
found items...
One click and you can move freely around search
results, select the items of interest and just continue
you work.
The Advanced Excel Find is an add-in designed for MS
Excel 2000 and MS Excel XP and adds no new workbooks or
VBA macros.
Advanced Excel Select
Awards:5 Stars
If you ever tried to find
cells containing conditional formats, formulas,
comments, and such, you would appreciate Advanced
Excel Select at its true value.
Just two clicks to have the job done!
It also introduces a
feature useful in fast table formatting: Select by
Format.
Save your time and nerves with Advanced Excel
Select:
• A single dropdown menu on a toolbar;
• Select rows and columns that have the same
format with the button on a toolbar;
• Simple installation and clean
uninstallation.
Excel Typos Finder
Awards:5 Stars
Aren't you sick and tired of typos in your spreadsheets?
It is a specially designed
tool to help you polish off all typos in your Excel
workbook.
The Typos Finder is an add-in for Microsoft Excel 2000
and 2002 that:
• Searches for fuzzy duplicates and quickly
finds values containing one to four typos
• Recognizes lost symbols, inserted symbols
and misprinted symbols
• Searches for typos inside the selected
range or inside the current column of the current
list
• Shows all found typos in the convenient
typos list
• Allows correcting typos by ONE CLICK
ONLY
• It can easily handle over 65,000 rows
Kill typos in your workbooks!The Backup
Assistant is designed to help you make backup
copies of your workbooks before you make changes to
them. One of its most useful features is to prompt you
to backup a file immediately after it is opened!
Eliminate the worry about messing up a file
and not having an up to date backup.
CSV File Creator for Microsoft Excel $24.95 More Info
The CSV File Creator allows you to easily create CSV files from your workbooks. You just select the worksheets that are to be converted to CSV files and let the CSV File Creator do the work.
Consolidation Assistant for Microsoft Excel $49.95 More Info
The Consolidation Assistant is designed to help you consolidate data from multiple workbooks or from multiple worksheets.
1(2) Next
MS Excel Topics
You 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.