Analysis using Waterfall Charts in Microsoft Excel
When analysing two or more scenarios in a financial model, it is often important to distinguish which variables have caused the most significant changes to financial outputs. However, complex financial models can often conceal the finer movements within the model.
Using 'Waterfall Charts' an analyst can determine exactly how a variable's movement has impacted upon financial outputs regardless of the model's complexity and the quantity of variables that have changed between scenarios.
The 'Waterfall Chart' can be altered for use in complex financial models where multiple revenue & cost streams require separation and graphical illustration to demonstrate their relative impact on the overall financials.
Using 'Waterfall Charts' an analyst can determine exactly how a variable's movement has impacted upon financial outputs regardless of the model's complexity and the quantity of variables that have changed between scenarios.
The 'Waterfall Chart' can be altered for use in complex financial models where multiple revenue & cost streams require separation and graphical illustration to demonstrate their relative impact on the overall financials.
No comments:
Post a Comment