Risk Analysis & Forecasting Simulators (Sims) to manage financial risks

Monte Carlo Forecasting Sims

Easy & Quick Monte Carlo Risk Analysis and Forecasting Spreadsheets provide new Risk Analysis & Forecasting Simulators (Sims) which will help you manage financial risks and set goals quickly and effectively.

The Sales & Profit Forecasting Simulator 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 Sim provides confidence level of reaching any 12 month sales goal using Monte Carlo sales forecasting simulations.

The Capital Project Sim provides 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.

The InvestmentSim provides a 10 year Monte Carlo analysis of 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 Risk Sims (2 workbooks collection) provides the probabilities that gross profit margin targets will be achieved when up to 15 variables and product mixes are combined applying Monte Carlo cost simulations and when the revenue stream and resulting unit costs varies between upper and lower limits.

All six workbooks will run in Excel 2003 - 2007.

Download a zip file or purchase the CD edition.