The Essentials of Financial Modeling in Excel
eBook - ePub

The Essentials of Financial Modeling in Excel

A Concise Guide to Concepts and Methods

Michael Rees

Share book
  1. English
  2. ePUB (mobile friendly)
  3. Available on iOS & Android
eBook - ePub

The Essentials of Financial Modeling in Excel

A Concise Guide to Concepts and Methods

Michael Rees

Book details
Table of contents

About This Book

A concise and practical guide to financial modeling in Excel

In The Essentials of Financial Modeling in Excel: A Concise Guide to Concepts and Methods, veteran quantitative modeling and business analysis expert Dr. Michael Rees delivers a practical and hands-on introduction to financial modeling in Excel. The author offers readers a well-structured and strategic toolkit to learn modeling from scratch, focusing on the core economic concepts and the structures commonly required within Excel models.

Divided into six parts, the book discusses the use of models and the factors to consider when designing and building models so that they can be as powerful as possible, yet simple.. Readers will also find:

  • The foundational structures and calculations most frequently used in modeling, including growth- and ratio-based methods, corkscrews, and waterfall analysis
  • Walkthroughs of economic modeling, measurement, and evaluation, and the linking of these to the decision criteria. These include breakeven and payback analysis, compounding, discounting, calculation of returns, loan calculations, and others
  • Structured approaches for modeling in corporate finance, including financial statement modeling, cash flow valuation, cost of capital, and ratio analysis
  • Techniques to implement sensitivity and scenario analysis
  • Core aspects of statistical analysis, including data preparation, manipulation, and integration
  • The use of approximately 100 Excel functions within example modeling contexts
  • Further Topics Sections, which introduce advanced aspects of many areas, in order to provide further benefit to more advance readers, whilst presenting the truly essential topics separately. Examples of these include introductions to PowerQuery and PowerPivot, as well as advanced waterfall structures

An invaluable, all-in-one blueprint for learning financial modeling in Excel, this book is ideal for beginning and intermediate financial professionals and students seeking to build and reinforce essential topics in financial modeling.

Frequently asked questions

How do I cancel my subscription?
Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is The Essentials of Financial Modeling in Excel an online PDF/ePUB?
Yes, you can access The Essentials of Financial Modeling in Excel by Michael Rees in PDF and/or ePUB format, as well as other popular books in Commerce & Finance. We have over one million books available in our catalogue for you to explore.



Table of contents