Logo

Using Excel for Business Analysis, Revised Edition provides practical guidance for anyone looking to build financial models. Whether for business proposals, opportunity evaluation, financial reports, or any other business finance application, this book shows you how to design, create and test your model, then present your results effectively using Excel 2013. The book opens with a general guide to financial modelling, with each subsequent chapter building skill upon skill until you have a real, working model of your own. Financial tools, features and functions are covered in detail from a practical perspective and put in context with application to real-world examples.

Contents: Preface. 1. What is financial modelling? 2. Building a model. 3. Best practice principles of modelling. 4. Financial modelling techniques. 5. Using excel in financial modelling. 6. Functions for financial modelling. 7. Tools for model display. 8. Tools for financial modelling. 9. Common uses of tools in financial modelling. 10. Model review. 11. Stress-testing, scenarios and sensitivity analysis in financial modelling. 12. Presenting model output. Summary. Index.