Home
   
 
 
  

Complete Excel Templates Collection 2009.

 

Our 2009 Collection of Finance Templates helps you model, forecast, simulate, predict, budget and optimise cash flows, capital investments, costing, inventories, rates of return, net present values, internal rates of return, ROIC, EBITDA for optimal management decision making.

Stanford University Professor Tom Byers says all companies need to pay extra attention on how they spend their cash because if they run out of cash - game over for them. Use these spreadsheets to forecast and simulate the consequences of  all your possible "What Ifs" ahead.

Plus 7 complementary Excel Add-Ins that help reduce work time developing your own financial spreadsheets.

Plus 2 complementary Guides – Learn Rate of Return Formulas (30 pages) and all about handling Data Analysis with Excel, arrays, tables, databases and lists (81 pages) – Requires Microsoft Word.

Download Complete Excel Financial Templates Collection >     Download/CD $339.00.

2009 Additional Spreadsheets:

 

EBITDA - ROIC - NET PRESENT VALUES - Cash flows constructed from annual operational forecasts.

Real Estate income generating project forecasting - ROIC and IRR.

Capital project simulations with 15 variable inputs.

Our new 2009 edition includes profit simulations using the Excel RAND() function to work out the probability of achieving your profit and cash flow goals based on current forecasts. Includes up to 30 individual product ranges (or services, or any revenue generating activity) and up to 15 unit cost forecasts within the analysis. The simulation consolidates 30 x 15 variables within the boundaries of your best case, median and worst case forecasts.

Make or Buy Costing Forecasts. Costing 6 of 8.

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

Activity Based Costing Schedules - Costing 4 of 8.

Inventory Manager PRO will calculate least cost re-ordering date schedules to maintain minimum safety levels. Calculates next re-order dates. (Column O above).

 

Time (cost) saving complementary Formula Reference Changer Excel Add-In (top left) can be applied to change ranges of cell formulas to fixed references (freezes copy referencing). Wonderful time saver! Excel does not provide this essential global tool.

Lowest Cost Re-Ordering Quantities and Re-Order Frequency Schedules within the Inventory Manager PRO workbook.

Source and Application of Cash Flows from Annual Budget Forecasts.

 

Importance of Cash Flow.
Stanford University Professor Tom Byers says all companies need to pay extra attention on how they spend their cash because if they run out of cash - game over for them.

Reduce cost scenarios - model possible cost reduction projects with this workbooks and calculate the internal rate of return.

Annualized ROIC Scenarios - Construction Project Cash Flow Forecasts.

Copyright. Biz Solutions Inc. 2008

MICROSOFT TRADEMARKS AND COPYRIGHT – Microsoft®, Microsoft Word® and Microsoft Excel® are registered trademarks of Microsoft Corporation. This web site is not associated with Microsoft in any way.

 

 

.