Profit Analysis

The P&L model also includes key ratios and metrics, such as payback period, ROI, IRR and NPV. You can also easily configure additional custom KPIs and financial metrics. In fact the whole financial model can be custom configured as needed, simply by changing a few Excel-like formula statements in the configuration settings.

 GenSight aggregates financial information from individual projects so you can analyse the portfolio at multiple levels. This also includes the ability to do dynamic slice and dice, and filtering, so you can see the effect of alternative portfolio combinations, timing, global rollout plans etc..

 The scenario planning tools in GenSight are also integrated into this model, so if you model alternative assumptions about future market conditions, for example, then you can see the effect of these uncertainties in the differing rates of return that you will achieve. It is a tool to make strategic decisions, based on reality, and linked in real time to the current status and delivery schedule of your projects – truly top to bottom.

Functionality

• Full P&L calculations – cost and sales model combined
• NPV, IRR, ROCE, Breakeven analysis, payback period – all produced dynamically, real time data crunching when project data is changed
• Financial KPIs for dashboards
• Timeline based financial calculations, discount rate
• Risk adjusted calculations if required – e.g. on probability of success
• Scenario based weight adjusted risk calculations if required
• Data export
• Excel and Word integration with 2 way data synchronization