The Art and Science of Financial Modeling

  • 44m
  • Anurag Singal
  • Business Expert Press
  • 2018

To use a cliché, we live in a volatile uncertain complex and ambiguous (VUCA) world. Organizations simply cannot afford to try out new strategies in reality and correct mistakes, once they’ve occurred. The stakes are too high. Thus emerges the utility of this technique across functions like financial planning and risk management. Financial models help a business manager simulate the future and see the impact of their change, without risking costly setbacks of real world trials and errors. Mastering the art of financial modeling is imperative for those who want to enter the ultra-competitive world of corporate finance, investment banking, private equity, or equity research. Only those who excel (pun intended) in modeling early on are often the most successful long- term. The book will help readers dive deep into the vocabulary and the syntax, the art and science of financial modeling and valuation. Readers will be able to prepare/use existing models more competently, interpret the results and have greater comfort over the integrity and accuracy of the model's calculations.

About the Author

Anurag Singal is a Chartered Accountant and an MBA from IIM Ahmedabad. He secured All India Rank 22 and 25 in CA Final and CA PE-II respectively. He received the "CA Professional Achiever-Manufacturing Sector" at the 6th ICAI Awards in February 2013 for his professional contribution across his stints across leading corporate houses in India His e-learning lectures on Auditing, Strategic Finance etc. are hosted on the Knowledge Portal of ICAI. He is a CA-GMCS Faculty at Kolkata and has mentored hundreds of young Chartered Accountants. His articles on various contemporary topics have been published in various journals. He has been the Chief Mentor of cajobportal.com India's first job portal exclusively for Chartered Accountants. He has authored books like "Accounting for People Who Think They Hate Accounting," and MS Excel - Lets advance to the next level, published by Business Expert Press, USA and "Auditing Mantras for CA IPCC" published by Book Corporation Kolkata

In this Book

  • Introduction
  • Approach to Financial Modeling
  • Deep Dive into the Construction Phase
  • Guidelines for Creating an Effective Financial Model
  • Scenario Analysis and Sensitivity
  • Financial Modeling—Real Life Illustrations
  • Case Studies
  • Cash-Flow-at-Risk (CFaR) Model—A Useful Tool for Risk Management in Corporates