 |
| Simulation, Prediction, Projections, Forecast or What-If Analysis are essential for a C-Level Executive. However, just using Excel is not sufficient since one cannot easily build a multiple scenarios and simultaneously manipulate key drivers. Our simulation models are a variation of Executive Dashboards and provide you these capabilities. We can design specialized simulations or any What-If scenario. |
| |
| Net Profit Projections |
|
Sales Projections |
| This model using prior year number to forecast or project next year next year profit. In this case, next year Net Profit is the dependant variables, whiles other expense and income items are independent variables. Know More |
In this model, aggregate Sales are projected based on changing the growth rate of individual products from prior year. Here the Aggregate Sales is the dependant variable with individual products and their growth rates being the independent variables. Know More |
| |
|
| Balance Sheet Projections |
Income Statement Projections |
This Balance Sheet model helps CFO plan to Year-End balances based on Year -Beginning Balances. Starting with the assumption of ending balance being 100% of beginning balance, the use can manipulate any of the key parameters to get a more realistic estimate of ending balance. Care has to be taken that the sum of Assets equals the sum of Liabilities & Equity. Know More |
This Income Statement model helps CFO plan the changes to the remaining plan period based on comparison with Actual numbers. The user can select either Monthly or Quarters as basis of analysis. Similarly, plan data can be view be viewed from Year-End Projection or Year-To-Date values. An assumption is made that the user is in final quarter so values only for that quarter can be changed. Know More |
| |
