株式会社極東書店トップ > 商品一覧 > The Essentials of Financial Modeling in Excel : A Concise Guide to Concepts and Methods.
商品詳細
The Essentials of Financial Modeling in Excel : A Concise Guide to Concepts and Methods.
・ISBN 978-1-394-15778-5 paper US$ 55.00
¥12,886.- (税込) ※(※)価格はご注文時の参考価格となります。
納品価格につきましては書籍の入荷時点で確定となります。
版元の原価改定、外国為替の変動等により異なる場合がございますので、予めご了承下さい。
電子版あり 大学・学術機関向け電子ブック(eBook)ISBN 978-1-394-32077-6
| 著者・編者 | Rees, Michael, |
|---|---|
| 出版社 | (Wiley, US) |
| 出版年月 | 2023.02 |
| ページ数 | 336 pp. |
| 言語 | ENG |
| ニュース番号 | <690-255> |
解説
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.