Financial Forecasting, Analysis, and Modelling

"Financial Forecasting, Analysis and Modelling: A Framework for Long-Term Forecasting "covers financial models in the area of financial statement simulation. It provides clear and concise explanations in each case for the implementation of the models using Excel. It is relevant to a variety of situations. It assists professionals to: Project a company's financial performance; Forecast future cash flows and perform a DCF valuation; Present the Good, Basic and Bad scenarios of the evolution of the company's debt covenants.At a more advanced level it ensures that the financial analyst or decision maker is informed of and comfortable when called to decide: What the double impact on the liquidity of the organization of a simultaneous increase of 5% in turnover and decrease of 10 days in the credit period provided to clients will be. What the range of the company's expected income at 95% confidence level based on selected assumptions will be.This book is a step by step guide through the entire process of developing long term projection plans using Excel. Making use of various tools (Excel Scenario Manager, Sensitivity Analysis & Monte Carlo Simulation), this book provides practical examples of how to apply risk and uncertainty to these projection plans. Although no projection is a guarantee, they can help organizations be better informed, thus assisting to negate potential risks.