Complete Excel Templates Financial Management 2009

This Complete Excel Templates Financial Management 2009 Collection provides 180 business finance spreadsheets, Excel add–ins and Risk Analysis spreadsheets which will help you manage financial assets, analyse investments, control cash flows, set up budgets and model financial statements and forecasts quickly and effectively.

The 2009 Collection includes Cash Flow workbooks as follows:

• Investment-Calc 2008 spreadsheets analyses Present values and internal rates of return of periodic cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, present value of periodic investments, acquisition synergy net present values, cost of capital, terminal (to infinity) net present values. Includes a 30 page Guide to Investment Rate of Return Calculations with formulas including worked examples.
  

• Master Budgeting for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis. 12 months departmental budgets consolidated.

• The Fixed Asset Accounting workbook provides all you need to keep track of and forecast depreciation for a maximum 3,000 assets. Use Excel 97-2003, 2007 & 2008 to work with depreciation records, book values and disposals. It will save you many hours of work with MACRS tax depreciation and deferred tax balances. Recalculate or model asset balances at any month end date.

• Instant Balance Sheets.

• Excel Costing templates provide standard costing models. Now includes Profit Margin risk analysis by simulating probable profit outcomes when different cost variances are consolidated.

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

• FastPlan 9.16 for five year financial plans. Develop your 5 year financial forecast and transfom these into simulated balance sheets, income forecasts and cash flows...

You can download (or order the CD version) all these financial workbooks as well within this collection : Financial Plan for Bankers & Investors – Risk Forecasting – Capital Project Justification - Future Values – Merger & Acquisition Synergy Values – Company Valuation - Rate of Return Solutions – Multi Variable Investment Forecasting – Net Return on capital After Cost of Capital Calculations – Present Value of Capital Investment - …and more

FES emailer

FES emailer - POP3 emailer with anti-SPAM, mass email, re-sender, and encryption tools.

Allows to send selected emails to another e-mail box, to encrypt all saved input and output e-mails with several user defined 2048 bit keys, to load 20, 200, 1000, or all rows of an email from POP3 server, to send personified email to many recipients, to remove e-mails without downloading, to archive old e-mails, to find an email in input, output and archive folders. and more.

And free addition: safe web viewer using default web browser and saver. This program can remove all active content from a web page - images, scripts, applets, objects, styles, and more before viewing. You will receive the register key within 1 day.

CreateCallBack (CreatefunctionCallBack)

You must create your callback windows functions for C (c++, c#) manually. Why? CreateCallBack will generate it automatically with adding all identifiers of this dialog using your resource.rc file!

• You will need just add your code for your events.
• Allows to save your time and to work with the comfort.
• Create the dialog windows fast and easy! All you need is MS Word.
• Run MS Word and open resource.rc file.
• Then open callback.doc file and copy the text of your resource file to this document.
• Then click on the "CreateCallBack" button.
• Alternatively you can run "CreateCallBack" macro.
• Then enter the dialog name in dialog window and the work is done! Just paste your callback function to your Visual C project.

FinExcelSoft Securities Excel Templates

FinExcelSoft Securities Excel templates - Contains 26 securities Excel templates:

• templates for coupons (6 templates),
• templates for price calculation (6 templates),
• templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duration for a security.

Free bonus:

10 Annuities Excel templates ann.xls contains Excel templates for: price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule.

FinExcelSoft Safe Office

FinExcelSoft Safe Office - A set of financial, statistic Excel templates and software.

Contains:

1. 
   
   5, 10 and 15 Year Project Investment NPV and EVA Excel templates
   
   Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.
   
   
   
2. Financial Excel templates - business valuation, forecast, securities, amortization, loans, annuities, investment.
3. Statistic Excel templates - regression and correlation analysis, partial correlation.
4. FES emailer - safe POP3 email client with many features including: SPAM blocker, resender from one email account to another one, safe saving of emails - with 2048 bit encoding, multiple passwords, and much more. Allows to remove emails without downloading them.
5. FES Notes - text editor with 2048 bit encoding, multiple passwords. Allows to safely save financial documents, passwords and so on.
6. FES alarm - allows to set a month, day, year, hours, and minutes and track the time.
7. Safe Web Browser - allows to download web pages, remove any dangerous
   content (scripts and more) from them, save them and pass them to default web browser.
8. Alarm-Clock.
9. Allows to encode the files with 2048 bit key.
10. Accounting Excel add-in - accounting with hierarhic data. You may define several levels of hierarchy in your Excel list.

For example: assemblies, units, packs, details, subdetails, and so on. This add-in contains about 250 VBA macros.

Allows to set hierarchic and other dependencies between columns of your list(s).

And when you enter your data, this add-in will track these dependencies and offer you to correct your data.

Use this add-in for your data entry and save your accounting time!

Also, allows easy pivot table and subtotals creation, has a timer and more. This add-in is supplied by your inquiry within 1 day.

Special requirements: MS Excel 2000 or later. Platform: Windows 98 or later.

FinExcelSoft NPV & IRR Excel Templates

FinExcelSoft NPV & IRR Excel templates -

Ready to use 5 Excel templates for NPV/EVA and IRR/MIRR calculation and more.

1. 5, 10 and 15 Year Project NPV and EVA Calculation.

NPV and EVA Excel templates for 2 to 15 period projects.

Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.

2. NPV & IRR Excel template for periodic cash flows

3. NPV & IRR Excel Template for a schedule that is not necessarily periodic.

4. MIRR Excel template.

5. Additional Financial Excel Templates. Requires Excel 97 or later.

Additional templates allow:

• effective annual interest rate,
• annual nominal interest rate,
• price per $100 face value of security that pays periodic interest,
• yield on a security that pays periodic interest,
• number of periods for an investment based on an interest rate and a constant payment schedule,
• future value of an investment based on an interest rate and a constant payment schedule,
• present value of an investment based on an interest rate and a constant payment schedule,
• payment amount for a loan based on an interest rate and a constant payment schedule.
  

FinExcelSoft FinStat Excel Templates

FinExcelSoft FinStat Excel Templates -

5, 10 and 15 Year Project NPV and EVA Calculation.

NPV and EVA Excel templates for 2 to 15 period projects.

Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.

Plus 137 Excel templates for almost any financial & statistic calculations:
NPV, IRR, MIRR, amortization templates, securities templates, effective annual interest rate, annual nominal interest rate, price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule, and more. Also contains all statistic functions.

finExcelSoft.xls workbook contains also the spreadsheet for easy function navigation in all workbooks.

Use of some complex financial functions are simplified by VBA procedures.

Benefit:

with these Excel templates you can now do financial & statistic calculations more easily. For example, you enter your source data and the work is done! Now you can see, for example, NPV and IRR results. To receive a correlation matrix you just click one button. Moreover,
you will receive the partial correlation matrix too.

Please note also that some complex Excel functions are simplified by VBA code.

Please note also that Excel contains hundreds functions and you may have problems with a search of the function you need for your given task.

The finexcelsoft.xls workbook contains the links to all financial and statistic functions. And these links to financial functions are grouped in 6 groups (investment interest, annuities, securities, rates, amortization, date functions), the statistic functions are grouped in 14 groups.

Now you can review only functions in one group rather all list! Moreover, finexcelsoft.xls contains additional grouping of financial functions: interest rate, income, payment, price, number of periods.

To open the template you simply double click its name, and the work in done!

Therefore, Excel templates may be very useful as for professionals, as for students!

This unique collection of Excel templates (supplied in conjunction with examples and full instructions) allows you easily learn all financial and statistic Excel functions and easily use them for your needs.

FinExcelSoft Correlation and Regression Templates

FinExcelSoft Correlation & Regression Excel Templates -

Allows to calculate correlation matrix and partial correlation matrix, linear, exponential, polynomial regression analysis.

Additionally, contains 26 securities Excel templates:

• templates for coupons (6 templates),
• templates for price calculation (6 templates),
• templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duration for a security.
• Full instructions.

NPV & IRR Excel Template for Periodic Cash Flows

NPV & IRR Excel Template for Periodic Cash Flows - Ready to use Excel Template for NPV & IRR & EVA calculations for periodic cash flows in Excel 97 or later.

Allows you to evaluate your business. The net present value of an investment is the current value of a future series of payments and receipts. The internal rate of return is the interest rate received for an investment consisting of payments and receipts that occur at regular intervals.

Here is the short description of NVP/IRR calculation.

You define a cash flow in Excel list, enter a rate of interest for NPV calculation, initial rate of interest for IRR calculation, and click on a button. NPV & IRR are calculated automatically and stored in special cells of this template.

Also contains the bonus:
- evacalc.xls - 5, 10 and 15 Year Project NPV and EVA Calculation. NPV and EVA Excel templates for 2 to 15 period projects. Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.
- MIRR.xls - MIRR (Modified Rate of Return) calculation
- Npvirrdate.xls - NPV & IRR calculations for non-periodic cash flows.
- finExcelSoft.xls - contains Excel templates for the following more usefull financial functions:

NPV, IRR, MIRR, future value of initial principal, effective annual interest rate, annual nominal interest rate, price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule.

FinExcelSoft Annuities Excel Templates

FinExcelSoft Annuities Excel Templates -

Contains 10 annuities Excel templates: price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule.

Bonus:

1. investment evaluation 5 Excel templates.
2. effective annual interest rate, annual nominal interest rate.
3. 2 secutities Excel templates: Price and Yield. Easy function navigation in 4 workbooks.
4. Use of some complex financial functions are simplified by VBA procedures.
5. Full instructions.

FinExcelSoft Amortization Excel Templates

FinExcelSoft Amortization Excel Templates:

Calculates straigh-light depreciation of an asset for a single period, sum-of-years' digits depreciation of an asset for a specified period, depreciation of an asset for a specified period using the fixed-declining balance method, depreciation of an asset for a specified period using the double-declining balance method or some other method you specify, depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify.

Free bonus: sec.xls - contains 26 annuities Excel templates:

• templates for coupons (6 templates),
• templates for price calculation (6 templates),
• templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duration for a security.
• Full instructions.

Universal Pricing Calculations for Excel

Universal Pricing Calculations for Excel

The Universal Pricing Excel Spreadsheets calculate price - demand relationships and uses standard accounting formula to give you the exact price which will produce the maximum profit for any product.

The user supplies two datasets, demand1@price1 and demand2@price2.

• The program calculates elasticity of demand (change in demand for $1 change in price) and the price which yields the maximum profit

• The second part of the program calculates discount price required to create additonal demand that will sell unused spare capacity or stock at maximum profit.

• The third part of the program supplies a costing calculator for Excel. Input these unit cost values in the pricing calculators.

Excel finds the exact Price which maximizes this standard profit formula:

Profit for period = Demand*Price (Revenues) - Demand*Unit Costs = Maximum value.

An easy way to understand the relationship of price - demand - profit for any product is to use the program to drive the Price - Demand - Profit schedule and charts provided. You will see that as prices start to rise in the chart, profits increase, reaching a maximum plateau, then decline as demand falls away. The program calculates the maximum price point of any product curve that produces the maximum profit

The Excel costing calculator works out unit product costs for the optimum pricing - profit calculations.

Financial Excel All Programs Edition

Millennium Software sells its own Excel templates for Financial Analysis, Business Valuation, Financial Accounting, Business Planning, Cash Flow, Real Estate & Loan, Budgeting Templates.

Excel templates supply business software solutions and templates that will help you plan your business finances, monitor cash flows, prepare budgets, analyze business statistics, track fixed assets and investment projects and calculate return on investments with net present values and internal rate of return.

Financial Excel All Programs Edition provides these business finance Excel workbooks.

The Finanial Excel All Programs Edition provides 150 business finance spreadsheets which will help you manage financial assets, analyse investments, control cash flows, set up budgets and model financial statements and forecasts quickly and effectively.

Investment-Calc 2008 spreadsheets for analysing Present values and internal rate of return of periodic cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, present value of periodic investments, acquisition synergy net present values, cost of capital, terminal (to infinity) net present values.

Includes a 30 page Guide to Investment Calculations with formulas and rate of return spreadsheets.

Plus Project investment analysis spreadsheets analysing cash flows, EBITDA, operating and after tax profits, average annual income and ROIC, net present values & IRR.

Master Budgeting for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis. 12 months departmental budgets consolidated.

The Fixed Asset Accounting workbook provides all you need to keep track of and forecast depreciation for a maximum 3,000 assets. Use Excel 97-2003, 2007 & 2008 to work with depreciation records, book values and disposals. It will save you many hours of work with tax depreciation and deferred tax balances.

Lease Accounting aggregates repayment and interest balances for up to 3,000 capital leases. Models variations in lease repayment terms anytime during a lease payment.

Excel Costing templates provides standard costing models. Now includes Profit Margin risk analysis by simulating probable profit outcomes when different cost variances are consolidated.

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

FastPlan 9.16 for five year financial plans. Develop your 5 year financial forecast and transfom these into simulated balance sheets, income forecasts and cash flows.

Cash Flow & Liquidity Forecasting 2008.xls creates a cash flow forecast to 150 days horizon from Excel list of accounts payable and receivable with forecast banking dates.

If you need to calculate your cash burn each day for 150 days ahead use the extra CASH BURN forecasting spreadsheet provided within this zip file.

BONUS EXCEL SKILLS PACK included.

Savings & Investment Planner

Savings & Investment Planner provides the perfect financial assistance if you want to seriously improve your personal finances.

• Savings template. Personal expenses spreadsheet to enter all your expenses as they occur. Use + values for really essential expense items and – values for non essential expenses. Excel works out the exact amounts of essential/non essential expenses, monthly savings if you eliminate all non essential costs and the percentage spent on non essentials.

• Check Savings, Credit card and Bank accounts. Excel is an absolutely perfect tool for being able to check account balances and for retracing calculations carried out by your bank or lender. Templates make this process really easy for you as well as verifying the interest credits or charges on your savings and card accounts.

• Credit card account templates. Track your credit card interest and protection insurance charges using this spreadsheet which calculates the real annual interest rate charged . Any previous late payment or overdue balance can shift your interest rate into the stratosphere. Keep a close watch on your credit card rates with these spreadsheets.

• Savings account template. Track your savings interest rate using this spreadsheet which calculates the real annual interest rate credited to your account. Find a higher savings rate and keep checking. Similarly keep a close watch on your savings account interest rate because they can be changed without notice.

• Bank account template. Track your bank charges and interest using this spreadsheet which correct your daily balances when over zealous bank charges deplete your account balances.

• Accelerate your mortgage repayments. Use this spreadsheet to calculate how much your net worth increases by applying your monthly savings to faster repayment of your mortgage loan and reducing the financing charges.

• The Guidance edition leads by example. By reallocating income into accelerated repayment of a 25 year fixed rate (5.95% p.a.) $255,000 mortgage will yield savings of $100,259.

You can test whether investing in a Mutual fund increases your net worth more than paying down your mortgage.

The Managed Investment Funds spreadsheets calculate returns from alternative investment opportunities covering a ten year investment period for up to four different investment plans.

Sales Leads 2008 for Excel 2007

Sales Leads 2008 for Excel 2007

Sales Leads 2008 CD for Excel 2007 supplies over 10 million sales contacts and addresses sorted in to 51 States. Excel 2007 has expanded capacities from 65,000 maximum rows in Excel 2003 to one million, and this enables Excel 2007 to provide this huge store of of sales leads.

You can sort sales leads using any combination of values: SIC code* (six digit codes), annual sales values (sort “greater than” values) , City (Text filter), State, Zip code (numbers filter), and/or Numbers of employees. * A quick SIC look up Excel form enables you to pinpoint the exact SIC business sector they want to filter contact names, addresses, telephone numbers etc. Excel makes it really easy to sort records using SIC numbers as the basis.

Address fields include first and last contact names, job titles, company names, street address, city, county, state, zip code. Telphone numbers are included.

You can attach sorted contact names, addresses and zip codes in Excel 2007 to a Word 2007 Mail Merge file. The Sort dialog in Word Mail Merge can be used to filter and select address lists at one or more levels to provide just the right sales targets.

If your firm operates outside the USA you can filter the 10 million business address information to supply addresses of importers, distributors and sales agents in any one of the 51 States.

Quick Five Year Financial Plans Plus Ratios

Quick Five Year Financial Plans Plus Ratios

FastPlan provides a complete five year financial plan using Microsoft Excel to create balance sheets, income statements and cash flow forecasts. Also included in the CD edition are our Company Valuation spreadsheets using multiple ratios to obtain valuations, plus a complete Agreement to Buy or Sell a Business (legal Agreement template Word file).

With FastPlan you can forecast your investment finances, fixed asset purchases, revenues, expenses, balance sheets and cash flows month by month for five years.

Incorporating accounts receivable and payables and inventory and FastPlan produces a complete five year schedule of balance sheets. Monthly depreciation and loan interest and repayment schedules can easily be incorporated into the five year plan.

Outputs include a Management summary covering the five year period containing all the ratios and multiples.

No previous accounting experience is necessary. A tutorial editon in the zip file shows you what goes where.

You can input five year forecasts outputs into the Company Valuation spreadsheet to value a business using Sales multiples, EBIT multiples and price earnings multiples.

Multiple ratio valuation benchmarks for 2007 are provided so that you can obtain a current value for a business purchase or sale.

Quick 3 Year Plan

This Quick 3 Year Plan collection of financial plan workbooks provides 50 business finance spreadsheets plus 9 Excel Add-ins and full Excel Training Course to help you create your forecasts quickly and easily. The following is a partial summary:

Three year cash flow plan helps you combine monthly forecasts quickly easily and convert into cash flows.

Forecasting calculations are so easy with Excel. Excel links spreadsheets together so that you can filter and sort records just anyway you want.

If you need to calculate your cash burn each day for 150 days ahead use the cash forecasting spreadsheet.

If you need to look further ahead use the Cash Flow accounting spreadsheets which make it really quick and simple to prepare a detailed monthly budget plan and forecast how your balance sheets and cash flows will look for 5 years x 12 monthly periods ahead.

You can value your company based on your budget forecasts using the valuation spreadsheet.

Seeking help to raise finance? The CD edition provides the following extra document files:

• Share Offering Memorandum pro-forma wording and layout to make it quick and easy for you to raise $1,000,000 new equity or loan capital.
  
• Save $10,000 - $25,000 on legal fees. Just add the figures and your business plan into the document provided following the guidance notes.
  
• Share subscription agreements are supplied.
  
• Help provided for non US companies how to structure an offering to secure finance.
  
• Popular with start ups, franchises, entrepreneurs and small businesses.
  
• List of capital sources supplied.

QuickValue PRO 2008

Use QuickValue to calculate the worth of any company with Excel.

QuickValue PRO 5.0 provides company valuation spreadsheets plus eight free bonus Excel Add-in files to make your Excel 100 times more productive. Quick Value helps you create valuations quickly and easily. The following is a partial summary:

The current fast pace of business acquisitions is driven by buyers who are able to see more value within a business than conventional analysts and professional valuation experts can see using old fashioned rules and standard calculations. There is usually More Value to be obtained from a business than can be determines from using conventional rules. QuickValue shows you how to prepare a conventional valuation using ready made templates and then incorporate Terminal Values.

To create a quick value in QuickValue 5.0, start by preparing a conventional twelve month profit and loss forecast using the P-L Template. QuickValue 5.0 automatically generates a 10 year forecast from this current year scenario applying growth rate extrapolation percentages you supply.

Use the extrapolation spreadsheet to prepare the base earnings scenario for a 10 year business plan valuation. Hide unwanted rows.

Valuation calculations use a selected choice of multiples.

In the second “Company Valuation” workbook you can prepare a quick value of your company based on five year results or forecasts and apply sales multiples, EBIT or Price Earnings values. You can then incorporate the Terminal Value beyond the forecast horizon period to create the additional net worth.

In addition to P/L valuation basis, you can adjust a business valuation using balance sheet figures. You can select which basis of valuation you want to apply and the table automatically adjusts the Total Value.

QuickValue 5.0 can incorporate Industry Benchmarks into your Value calculations. You just pull down a selector, choose your industry and the benchmark ratios are included into your valuation calculations if you wish. Your valuation can be very quick and accurate and relevant to your current time frame using data from the US acquisitions and mergers market updated monthly.

Monte Carlo Financial Modeling 2008

Easy & Quick Monte Carlo Risk Analysis and Modeling Spreadsheets will help you model financial outcomes quickly and effectively.

The Sales & Profit Forecasting modeler will accurately predict your company sales and profits by combining up to 15 different product or profit center estimates of incoming sales leads, costs per lead, leads conversion rates, price yields, gross profit margins, G&A recovery rates and their upper and lower limits. Forecasts probabilities achieving any sales or profit targets using Monte Carlo simulations.

The Monthly Sales Model provides confidence level of reaching any 12 month sales goal using Monte Carlo sales forecasting simulations.

The Capital Project Model analyses the probability that investment capital will be justified by returning the target ROIC value set by the user when up to 15 variables are combined. Investment simulations apply Monte Carlo calculations. This Sim simply works out whether a target ROIC value will be reached or not. InvestmentSIm listed below analyses an entire 10 year investment period and calculates the most probable levels of IRR, ROIC and NPV.

Investment-Calc will model any investment project, combining all years 1-10 variables to predict the most probable values for IRR, ROIC and Net Present Values.

The Gross Profit Margin Model (2 workbooks collection) combines up to 15 variables and product mixes applying Monte Carlo analysis.

All six workbooks will run in Excel 2003 – 2007.

Loan & Bank Refund Claim Software 2008

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

When you purchase the 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 CheckMyBank 2008 (Excel workbook) and Loan Amortization Manager (web software).

• With CheckMy Bank you can quickly verfiy all the calculations which lead to your monthly interest charges. Compare the real ending balance totals with your actual balances and challenge your account deductions if this is justified.

• Loan Amortization Manager will store up to 100 current loan account repayment statements for you. You can change any rate or payment within any loan account during its repayment period and check that the current loan balance is correct.

Lease/Loan Organizer

Lease/Loan Organizer

This asset and lease accounting Excel workbook provides all you need to manage and keep track of up to 3,000 asset and capital lease accounting records. You can select straight line depreciation or declining/double declining deprecation methods for the Asset Register. You can export asset records from your current accounting package into Excel and copy the asset descriptions, purchase costs and dates of purchase straight into the Asset Register.

Each asset is defined by location (100 possible), asset class (100 possible), depreciation months and salvage percentage.

Individual assets can have their own unique depreciation life independently of the class assigned.

Everything is so easy with Excel. Excel links location, asset class, depreciation lives together and you can filter and sort records just anyway you want.

Depreciation totals are reported for any month end. Users can wind the month end date backwards or forwards to recalculate asset purchases, depreciation and book values by department and asset class for any selected date.

The Lease Register reports the repayment status, interest expense and remaining balances for up to 3,000 capital leases at any selected month end. Lease terms can include pre-payments and final balloon payments. Users can create up to 100 individual Master Lease ID categories with 3,000 sub-components or classify leases by Class or locations. Lease interest, outstanding balances and current month principal repayment are totalled for each single Master Lease ID.

You can simulate the results which will arise from changing any combination of repayment amount, interest rate or final balloon payment terms for any lease. Calculate the new final repayment month and the difference in interest expenses between the current repayment terms and adjusted terms for cost saving projections.

INVESTMENT-CALC PRO 2008 IRR & NPV Solutions

INVESTMENT-CALC PRO 2008 IRR & NPV Solutions

This complete collection of Investment Return workbooks now comes with free document and spreadsheet connectivity as well. Spreadsheet connectivity will help you share spreadsheets more effectively.

Includes a 30 page Guide fully explaining all the calculations and equations required for time based value of investing. Includes Quick IRR –NPV spreadsheets and Future Values.

Investment Appraisal simulations. This spreadsheet will run 3,000 forecasts combining up to 80 variables of any investment project to predict the most probable 10 year pre-tax profits, cash flows, NPV, IRR and ROIC.

The library of investment analysis spreadsheets incorporate present value beyond the cash flow forecasting horizon. With our quick and easy to use spreadsheets terminal values are automatically added to project net worth and included in the real return on capital values.

Quick calculation of your firms cost of capital using beta risk look up values from the database included within the workbook. Your firms or your project cost of capital is the real discount rate to apply to all net present value spreadsheets.

Synergy Value schedule calculates the economic and net present value of the financial benefits of an acquisition or merger.

Insurance buy out schedules value any bond to its terminal value.

This workbook includes lots of Present values calculators, and internal rate of returns of investment project cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, and present value of periodic investments.

Quick NPV and IRR spreadsheets provide present values and IRR of any project for up to 40 years

Plus rate of return of investment portfolios with any buy/sell patterns.

New Excel Finance Spreadsheets for Investment Cash Flow Forecasting – NPV & IRR

Investment-Calc 2009 - NPV - IRR

Investment-Calc 2009 - NPV - IRR

This complete collection of Investment Return workbooks now comes with free document and spreadsheet connectivity as well. Spreadsheet connectivity will help you share spreadsheets more effectively.

Includes a 30 page Guide fully explaining all the calculations and equations required for time based value of investing. Includes Quick IRR –NPV spreadsheets and Future Values.

Investment Appraisal simulations. This spreadsheet will run 3,000 forecasts combining up to 80 variables of any investment project to predict the most probable 10 year pre-tax profits, cash flows, NPV, IRR and ROIC.

The library of investment analysis spreadsheets incorporate present value beyond the cash flow forecasting horizon. With our quick and easy to use spreadsheets terminal values are automatically added to project net worth and included in the real return on capital values.

Quick calculation of your firms cost of capital using beta risk look up values from the database included within the workbook. Your firms or your project cost of capital is the real discount rate to apply to all net present value spreadsheets.

Synergy Value schedule calculates the economic and net present value of the financial benefits of an acquisition or merger.

Insurance buy out schedules value any bond to its terminal value.

This workbook includes lots of Present values calculators, and internal rate of returns of investment project cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, and present value of periodic investments.

Quick NPV and IRR spreadsheets provide present values and IRR of any project for up to 40 years

Plus rate of return of investment portfolios with any buy/sell patterns.

New Excel Finance Spreadsheets for Investment Cash Flow Forecasting – NPV & IRR

Inventory Manager PRO For Excel

Inventory Manager provides manufacturing and operations decision support for inventory management and scheduling with Excel. Maximum 10,000 inventory items capacity.

Determine the best inventory re-order schedules (includes safety stocks), optimize the lowest cost re-order quantities, establish ordering frequencies and lot sizes, receive alerts when you need to re-order, includes seasonality, trends and forecasting, quality control inventory analysis. Improve efficiencies and enhance customer service with INVENTORY MANAGER PRO.

• You can establish which inventory items should be re-ordered on a daily basis with INVENTORY MANAGER.

• You can establish least cost ordering quantities with INVENTORY MANAGER taking account of storage costs, administration of purchasing costs and the cost of finance.

• You can create Excel lists of inventories in categories and storage locations.

• You can export inventory lists from QuickBooks (and Quattro Pro and barcode readers which interface with Microsoft Excel) to create your own inventory management control system which will include supplier delivery lead time, re-order quantities, safety levels.

• When you want to evaluate buying inventory in larger quantities to gain volume discounts, use INVENTORY MANAGER to determine the inventory level s for each product item that will deliver profit gains after storage costs are taken into account.

• Analyze quality control data of incoming stock with INVENTORY MANAGER Statistic spreadsheets.

• Generate re-order schedules for all stock items.

Worked examples and full guidelines provided in a separate demo tutorial version download.

Seeking help to raise business finance? The CD edition provides the following extra document files:

• Share Offering Memorandum pro-forma wording and layout to make it quick and easy for you to raise $1,000,000 new equity or loan capital.
  
• Save $10,000 - $25,000 on legal fees. Just add the figures and your business plan into the document provided following the guidance notes.
  
• Share subscription agreements are supplied.
  
• Help provided for non US companies how to structure an offering to secure finance.
  
• Popular with start ups, franchises, entrepreneurs and small businesses.
  
• List of capital sources supplied.

Cash Flow & Liquidity Forecasting 2008 - Cash Forecasting, Credit Controls, Scheduling

Cash Flow & Liquidity Forecasting – 150 days ahead, 12 Month Cash Operating Plan, Customer Credit Control, Daily Cash Consolidations, Scheduling Payments - Five new Excel workbooks for better cash management during 2009.

• Cash Flow Forecasting 150 days.xls - Forecast 150 days ahead. List current receivable and payable accounts by date, set target payable and receivable days, generate overdue and late account lists, generate daily, weekly and monthly cash flow forecasts, set targets, analysis variances. Individual (linked) spreadsheet by tabs > Guide, Targets, Accounts Register, Daily balance forecasts, Monthly forecasts, Create Lists. The workbook provides daily closing cash balances for the entire 150 day period, summarizes late payers, week end and month end forecast balances.

• Cash Operating Plan.xls - 12 month sales and expenses plan spreadsheet links to the working capital spreadsheet where the user enters monthly targets for days sales outstanding, percentage payable to sales, days inventories outstanding to monthly cash forecast spreadsheet presented as Operating and working capital monthly changes -capital requirements – loan balances requirements – ending as changes in monthly cash.Individual (linked) spreadsheet by tabs > Start & Summary, Monthly P_L Budget, Working Capital, Monthly Cash Changes Forecast.
  

• Customer Credit Control.xls – This workbook alerts managers up front if customers will exceed their credit limits if an order is processed using Excel. Incorporates current credit limit values per customer, accepted order values pending, and net credit positions. Posts STOP each order before output costs are incurred. Individual (linked) spreadsheet by tabs > Guide, Product List, Customer Credit Status, Order Control, Sales Running Rates.
  

• Daily Cash Consolidation.xls – When you have different operating divisions reporting different daily income, expenses and capital expenditures on a cash accounting basis, this workbook will consolidate all daily cash in and out reports into combined totals and compare actuals to the overall budget on a monthly basis. Individual (linked) spreadsheet by tabs > Set up Income-Expense Categories – Monthly P_L Budget – Divisions 1-12 Daily Reports – Month to Date & Variances – Daily Consoldations.
  

• Scheduling Payments.xls – Everyone has to schedule who to pay and when. This workbook makes that task easier. Enter all your receivables (or forecast receivables) into the Receivable register in simple Excel list format with the amounts, invoice dates and target (or average) days collection. This page will display alerts when each receivable account is overdue. List payable accounts in the Schedule Payments spreadsheet with amounts and due dates. Adjust payment dates so that you do not exceed daily credit limits which are calculated 150 days ahead in the Rescheduled Balances & Credit Available (summary) spreadsheet. Make cash scheduling more effective and manages daily credit forecasting. Individual (linked) spreadsheet by tabs > Set Bank Holiday Dates – Receivable Register – Schedule Payables – Rescheduled Balances & Credit.

Business Solvency & Financial Ratios 2008

You can run quick and easy checks on the solvency of companies you rely on to deliver services to you and to buy from you using this Business Solvency & Financial Ratios 2008 workbook.

Business Solvency:

The Business Solvency & Financial Ratios 2008 workbook employs all the multivariate analysis equations published by Edward Altman. Altman is the Max L. Heine Professor of Finance at the Stern School of Business, New York University.

In the workbook supplied you can simply enter two comparative sets of financial data for any company (including your own). The Altman Z scores are readily computed using the multivariate formulas provided by Professor Altman.

Bonus Addition:

Financial Ratios with Excel

Windex 2008 calculates all major financial ratios in Excel.

Calculates these financial ratios from balance sheet, income statement and cash flow templates provided:

• 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

Instant Balance Sheets Excel Templates

12 MONTHS INSTANT BALANCE SHEETS WITH EXCEL

Instant Balance Sheets provides 12 month revenue and expense forecasts spreadsheet, linked to working capital forecasts, fixed asset purchases with monthly depreciation. Creates monthly balance sheets and cash flow forecasts from your plans.

Ideal for when you want to turn your monthly profit and loss forecasts or last 12 months data into monthly and year end balance sheets and cash flows.

Start by entering monthly inputs of Unit Volumes/Prices/Cost of Sales and Company Expenses (100 rows). There are quick and easy working capital and fixed capital forecast spreadsheets provided.

All monthly balance sheets “balance” by transferring changes occurring between successive monthly periods into the monthly cash flow spreadsheet. The cash flow schedule tracks changes for all twelve monthly balance sheets and calculates the balancing cash position at the end of each month.

If you want to transform 12 month financials (historical or forecast) into neat income schedules and balance sheets to display to management, investors, lenders, banks, use Instant Balance Sheets for really quick results.

Provides a forward looking planning suite which accepts monthly unit volume forecasts, different product prices and cost of sales for the 12 month period and a monthly company expenses forecast. You can predict sales days outstanding, inventory levels and percentage of sales supporting receivables.

Provides a demo version which shows you how everything fits together.

Budgeting Spreadsheets for Excel

A collection of Budgeting Spreadsheets for Excel (workbooks) provides 50 business finance spreadsheets plus 9 Excel Add-ins and full Excel Training Course to help you create, control and value your budgets quickly and easily. The following is a partial summary:

Master Budgets 4.6 helps you combine up to 10 department budgets quickly easily

Everything is so easy with Excel. Excel links combine separate budgets into the Master Budget. You can track your budgets with actual performance. Master Budgets reports monthly variances and year to date totals.

If you need to calculate your cash burn each day for 150 days ahead use the cash forecasting spreadsheet.

If you need to look further ahead use the Cash Flow accounting spreadsheets which make it really quick and simple to prepare a detailed monthly budget plan and forecast how your balance sheets and cash flows will look for 5 years x 12 monthly periods ahead.

You can value your company based on your budget forecasts using the valuation spreadsheet.

The CD edition provides the following extra document files:

Share Offering Memorandum pro-forma wording and layout to make it quick and easy for you to raise $1,000,000 new equity or loan capital. Save $10,000 - $25,000 on legal fees. Just add the figures and your business plan into the document provided following the guidance notes. Share subscription agreements are supplied. Help provided for non US companies how to structure an offering to secure finance. Popular with start ups, franchises, entrepreneurs and small businesses. List of capital sources supplied.

Google Spreadsheets Excel Templates Collection

Google Spreadsheets Excel Templates Collection: 25 Excel files in total - 23 upload and run in Google Docs Spreadsheets, plus 2 Cash Flow Forecasting with file sizes that are greater then the Google Docs limit which enables larger data volumes.

• GoogleDocsCalendar
• GoogleDocsEnquiriesTracking
• GoogleDocsDailyDollarResults
• GoogleDocsOrdersForecasts
• GoogleDocsForecasting
• GoogleDocsReceivableCash Forecast (Part 1)
• GoogleDocsPayableCashForecast (Part 2)
• GoogleDocsCashFlowForecast
• GoogleDocsEBITValuation
• GoogleDocsCommRealEstate
• GoogleDocs12MonthsCostCenterBudgets
• GoogleDocs12MonthsPLBudget
• GoogleDocsCostingSpreadsheets
• GoogleDocsQuickCalcNPV-IRRCashFlows
• GoogleDocsNewProjectAnalysis
• GoogleDocsPortfolioCalc
• GoogleDocsROR
• GoogleDocsRatios
• GoogleDocsCostSavingProjects
• GoogleDocsAcqustionsIRR
• GoogleDocsMAForecasting
• GoogleDocsPromoPricingTables
• GoogleDocsSolvencyTest

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, unauthorised loan insurance charges, or incorrect penalty charges this dual software package is for you.

With the 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 CheckMyBank 2008 (Excel workbook) and Loan Amortization Manager (web software).

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

Loan Amortization Manager will store up to 100 current loan account repayment statements for you. You can change any rate or payment within any loan account during its repayment period and check that the current loan balance is correct.

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.

Asset & Lease Accounting With Excel

Fixed Asset Accounting workbook provides all you need to keep track of a maximum 3,000 asset depreciation records, book values and disposals with Excel 97-2003. It will save you hours of work calculating MACRS depreciation for tax purposes and deferred tax balance values for any month end date. It also includes capital lease accounting.

You can select straight line depreciation or the declining/double declining deprecation methods.

You can wind the month end back and forwards to calculate accounting depreciation, MACRS depreciation and deferred tax balances at any month end. The default calculation period is the current month end.

The MACRS depreciation rates are variable. They are set for US tax depreciation rules but you can enter any MACRS rates into the database which will apply to your calculations.

In the first workbook each asset is defined by location, accounting depreciation life, MACRS class and salvage percentage.

Individual assets can have their own unique depreciation life.

Everything is so easy with Excel. Excel links location, asset class, depreciation lives together and you can filter and sort records just anyway you want.

Disposal accounting included.

The Lease accounting section reports repayment status, interest and remaining balances for all capital leases at any month end. Lease terms can include pre-payments and final balloon payments.

The Zip download is a 6.67 MB file. After downloading unzip the three Excel Asset Accounting workbooks including the tutorial edition. The MACRS accounting is provided in a separate workbook (No: 2). CD shipping is also an option.

Financial Statement Forecasting PRO

When you need a quick snap way to create your financial statement forecasts for your senior managers, bank manager or investors, use Financial Statement Forecasting PRO.

Financial Statement Forecasting PRO enables you to set up a 12 month forecast of your financial statements starting at any month of your choice. As well as calculating monthly balance sheets, income statements and cash flows (source and application of funds) the workbook outputs all key operating, financial and shareholder ratios and financing covenant ratios.

Plus the FinExcelSoft 10 year financial statement forecasting workbook.

Quick and simple to use. No accounting knowledge is required.

Financial Ratios with Excel

Financial Ratios with Excel

Windex 2008 calculates all major financial ratios in Excel from balance sheet, income statement and cash flow templates provided:

• 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.

Excel Add-ins & Training Bible Complete Collection

Combined Excel Add-ins and Excel Training Bible package

Nine Excel add-ins plus the Complete Excel Training Bible modules 101-701.

Plus Free Workbook Bonus - Learn how to develop your own Excel Currency Converter with this extra free workbook.

Convert any of your financial records or lists into any one of 81 cross currency exchange rates updated via the Excel import function – In today’s environment of volatile exchange rates, instant recalculation into your home currency from different currencies is an essential tool.

Free workbook with the Combined Collection.

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. 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.

• 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.

• Sales and Profits Risk Forecasting using Monte Carlo formulas.

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

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

FastPlan 2008 Five Year Company Forecasting

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 plus all core ratios and five years financial summary overview.

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.

Excel Skills Pack - COMPLETE MICROSOFT EXCEL CORE KNOWLEDGE PACK

COMPLETE MICROSOFT EXCEL CORE KNOWLEDGE PACK

Core fundamentals 1. Keyboard functions, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas - The least you should know, Useful functions and Paste Function, Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear, Essential Printing, Data Sorting, Hiding, AutoFormats, Protection, Basic Charts, Basic Formatting, If Function.

Core fundamentals 2. Improved working with Formulas, Worksheet Formulas, Extracting Data for Decision Making, Data Validation, Importing external data. Core fundamentals of Advanced Filters, AutoFilters, Names Charts, Under Utilized Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining.

Core fundamentals 3. Learn Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files, Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the Web, Macros 1, Macros 2.

Plus Core Knowledge chapters 4, 5, 6 and 7 VBA and Macro developments.

Special Bonus: Excel Add-Ins improve your spreadsheets presentations and reduce your spreadsheet working hours.

• Duplication Manager
• Formula Manager
• Number Manager
• Text Manager
• Excel Plus
• Named Range Manager
• Formula Reference Changer
• Sheet Index Creator
• File Size Reducer Download or CD shipping.

Excel Costing 2009

Excel Costing 2009 provides new and free document and connectivity software for Excel spreadsheets from February 1, 2009: Spreadsheet connectivity will help you share financial more effectively.

The standard costing workbooks include:

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

• 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.

Excel Budgeting & Financial Forecasting

Budgeting & Financial Forecasting collection includes the following Excel workbooks:

Master Budgets 4.6 helps you combine up to 10 department budgets quickly and easily and tracks actuals and variances. Create seperate 12 monthly budgets and Excel consolidates to a Year to Date summary tracking actuals vs budgets.

Cash Flow Forecasting 2008.xls will convert any list of AR-AP accounts into a daily and calendar month cash flow forecast up to 150 days ahead from users starting date. Import accounts payable and receivable into this Excel workbook from any accounting package and generate an instant 150 day cash flow forecast. Manage slow payers and accounts payable more effectively with closer identification of cash flow forecasts.

Everything is so easy with Excel. Excel links all your receivable and payable accounts together to provide a day by day and month by month cash flow summary.

If you need to calculate your cash burn each day for 150 days ahead use the extra CASH BURN budgeting & forecasting spreadsheet provided within this zip file.

New! Quick Budget Forecasting PRO. Excel is brilliant at consolidating actual transactions into separate fixed and variable cash flow categories, enabling quick monthly budget forecasts to be developed based on real actual results and trends. This extra workbook helps you assign transactions to fixed and variable categories. Excel consolidates actual transaction data into monthly cash flow reports presented in fixed and variable categories. The year to date report continually updates the 12 months Budget Forecast spreadsheet so that your forecasts are always current, based on latest results.

Excel Add-Ins File Collection

With this powerful Excel Add-Ins File Collection for Microsoft Excel you enhance your Excel with extra capabilities that are well beyond standard Microsoft Excel features:

• Add page indexes to link all spreadsheets together.

• Add Reminder notes. Like those little yellow pads, bring reminders messages into your Excel at preset times and dates.

• Add formulas list with links to each formula cell.

• Manage cell ranges with more options than provided by Microsoft.

• Convert imported numbers to true Excel formats.

• Hide zeros, Hide text, hide numbers, hide negatives, hide positives with one click.

• Create one year Excel 365 days calendars.

• Manage List duplicates, number formats and equations much more efficiently and make Excel work faster for you.

• Convert vertical number sequences into horizontal rows with one click.

• Copy data to a different part of your spreadsheets keeping the orginal cell references. the same

• File size reduction to save disk space.

Excel Scheduler

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

Operations Manager

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.

Resource Manager for Excel/FULL

Resource Manager for Excel/FULL contains the functionality of high-end systems, without the complexity and expense. An add-on for existing systems, or stand-alone, Resource Manager adapts to your specific needs.

Key features include:

• Easily integrates with all systems

• General purpose resource management tool for projects that contain any combination of people, materials, and equipment

• Dynamic finite capacity analysis

• A great stand alone scheduler

• Priority Scheduling

• Costing & estimating

• True Windows GUI

• Inventory Management & MRP

• Excel Integration

• Planning

• Rough-cut capacity planning

• Bills-Of-Material/Resources containing material, workcenters, & labor requirements.

Spreadsheet QC

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 by User Solutions, Inc.

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.

Excel ActiveX

Excel ActiveX acts as an ActiveX document container for hosting Excel document in a custom form or Web page. Support Excel automation client and offer abundant sample codes.

Excel ActiveX can be easily integrated into applications written in languages that support ActiveX control such as Visual C++, Visual Basic, Delphi, C++ Builder and .Net languages.

ZRandom for Excel

ZRandom implements high quality random number generation for Microsoft Excel using the Merssenne Twister algorithm :

• Use higher quality pseudo-random numbers than the Excel RAND() and VBA Rnd() functions.
  
• Generate random numbers from 16 discrete and continuous distributions.

ZRandom implements the following discrete distributions: Uniform, Bernoulli, Geometric, Hypergeometric, Negative Binomial and Poisson.

ZRandom implements the following continuous distributions: Beta, Burr, Exponential, Gamma, Lognormal, Normal, Pareto, Triangular, Uniform and Weibull.

• Create large batches of random numbers using the interactive user interface.
  
• Excel functions for use in spreadsheet formulas.
  
• Random Sort and Random Sample
  
• Interactive distribution wizard
• A VBA interface to generate random numbers in your code.

Excel Workbook Splitter

Excel Workbook Splitter is a powerful, friendly and easy-to-use Excel tool to split multi-sheet excel files into single sheet excel files with high speed. This excel tool changes the complicated, duplicate and boring excel works into easy ones. Especially it's used for financial affairs, legal affairs and so on. Excel Workbook Splitter supports Microsoft Excel only and Windows 2000/XP operating system.

With Excel itself, the operation requires opening each workbook, selecting entire sheet, creating a new workbook, pasting the sheet, saving... But with Excel Workbook Splitter, you just load any number of workbooks (or even some folders) into the program and see the list of all worksheets from all workbooks at once.

AutoWin Homepage
Excel Workbook Splitter
Excel Workbook Splitter Free Trial

Budget Forecaster & Expense Tracker Combo Package

Budget Forecaster for Excel® is a household budgeting and finance management software was designed for Microsoft Excel® lovers who prefer using Excel-based household budgeting software to a stand-alone application to manage their family finances.

These users tend to enjoy the convenience of managing their household finances with the help of this VBA Excel tool without having to learn a new household finance management software application

• Track where your money goes See where your money goes by tracking your daily expenses by type.
  

• Get a clear picture of where your money is going by week or by month.
  

• Track your income, investments and expenses for the selected time period, and analyze your income allocation and expenses distribution with efficient Budget Forecaster software tools - all in one place.
  

• View colorful detailed charts & graphs.

• View colorful, detailed charts and graphs and see visually by category where your money goes. If you prefer to see where your expenses go in a colorful easy to read pie chart, you will enjoy this feature.