Excel Modeling in Corporate Finance

"With ready-to-build spreadsheets available online!"--Cover.

Author: Craig W. Holden

Publisher: Prentice Hall

ISBN: 9780205987252

Category: Business & Economics

Page: 240

View: 938

For courses in corporate finance or financial management at the undergraduate and graduate level. Excel Modeling in Corporate Finance approaches building and estimating models with Microsoft® Excel®. Students are shown the steps involved in building models, rather than already-completed spreadsheets.

Spreadsheet Modeling in Corporate Finance

This book and CD provide step-by-step instructions so that learners can build models themselves (active learning), rather than handing learners canned “templates” (passive learning).

Author: Craig W. Holden

Publisher:

ISBN: 9780130675231

Category: Business & Economics

Page: 161

View: 412

Providing instructions for building financial models, not templates, this book and its associated website supply a programme of active learning. Instead of finding completely ready-made material, students are encouraged to use the resources to build models themselves. No Excel knowledge assumed. Emphasis on Beta and CAPM.

Mastering Financial Modelling in Microsoft Excel 3rd edn

The book is divided into two parts: the first part outlines model designs and gives templates, key features and techniques. The second part of the book shows how to build corporate financial models in Excel.

Author: Alastair Day

Publisher: Pearson UK

ISBN: 0273772341

Category: Business & Economics

Page: 520

View: 273

Comprehensive tools and methods to help you build, develop and apply financial models using Microsoft Excel, enabling you to get better, more accurate results, faster. The new edition of this bestselling title begins by explaining basic modelling techniques before moving through to more complex models. The book is divided into two parts: the first part outlines model designs and gives templates, key features and techniques. The second part of the book shows how to build corporate financial models in Excel. This new edition includes a reworking of the book in Excel 2010 (but with older material still included), inclusion of Apple Mac, addition of specific 2010 features and end of chapter exercises. If you are buying the ebook, companion files can be downloaded from the digital downloads section of http://www.financial-models.com/.

Excel Modeling in Corporate Finance Global Edition

For courses in corporate finance or financial management at the undergraduate and graduate level.

Author: Craig W. Holden

Publisher: Pearson Higher Ed

ISBN: 1292071494

Category: Business & Economics

Page: 232

View: 446

For courses in corporate finance or financial management at the undergraduate and graduate level. Excel Modeling in Corporate Finance approaches building and estimating models with Microsoft® Excel®. Students are shown the steps involved in building models, rather than already-completed spreadsheets.

Instructor s Review Copy for Excel Modeling in Corporate Finance

Author: Craig W. Holden

Publisher:

ISBN: 9780133487459

Category:

Page: 240

View: 330


Student Cd for Excel Modeling in Corporate Finance

Author: Craig W. Holden

Publisher: Prentice Hall

ISBN: 9780133487473

Category: Business & Economics

Page:

View: 116


Excel Modeling in Corporate Finance

reason to throw this information away , when it is just as easy to incorporate it into
an Excel model . ... You will : gain a practical understanding of the core concepts
of Corporate Finance , develop hands - on , Excel modeling skills , and build an ...

Author: Craig W. Holden

Publisher:

ISBN:

Category: Corporations

Page: 186

View: 339

This book teaches readers how to build financial models with step-by-step instructions in Excel. Progressing from simple examples to practical, real-world applications, this book covers the time value of money, valuation, capital budgeting, financial planning, and options and corporate finance. For financial planners and analysts.

Excel Modeling in the Fundamentals of Corporate Finance

Designed to help readers hone their modeling skills, this book and CD provide a hands-on, practical mode of learning that includes step-by-step instructions and real world applications.

Author: Craig W. Holden

Publisher: Prentice Hall

ISBN: 9780131424111

Category: Corporations

Page: 176

View: 763

The Second Edition takes an active approach in showing readers how to build financial models in Excel. Designed to help readers hone their modeling skills, this book and CD provide a hands-on, practical mode of learning that includes step-by-step instructions and real world applications. Rarely covered content items are explored, such as corporate financial planning at full-scale using real data, realistic life-cycle financial planning, and U.S. yield curve dynamics. For professionals with a career in corporate finance, investments, and/or banking.

Excel Modeling and Estimation in Corporate Finance

This book focuses on active learning by teaching students how to build and estimate financial models using Excel so they understand the steps involved, rather than being handed completed spreadsheets.

Author: Craig W. Holden

Publisher:

ISBN: 9780136089063

Category: Corporations

Page: 198

View: 309

KEY BENEFIT This book teaches readers how to build financial models with step-by-step instructions in Excel. KEY TOPICS Progressing from simple examples to practical, real-world applications, this book covers the time value of money, valuation, capital budgeting, financial planning, and options and corporate finance. MARKET For financial planners and analysts.

Excel Modeling in the Fundamentals of Corporate Finance and UG Corporate Finance Software Package

For undergraduate courses in corporate finance.

Author: Craig W. Holden

Publisher: Prentice Hall

ISBN: 9780131513433

Category: Business & Economics

Page: 158

View: 589

For undergraduate courses in corporate finance. Excel Modeling in the Fundamentals of Corporate Finance is a supplemental book and CD. It teaches students how to build financial models with step-by-step instructions in Excel. It can accompany any undergraduate corporate finance textbook, including textbooks by Brealey, Brigham, Gitman, Keown, Ross, and Van Horne.

Excel Modeling and Estimation in the Fundamentals of Corporate Finance

KEY BENEFIT: This book teaches readers how to build financial models with step-by-step instructions in Excel.

Author: Craig W. Holden

Publisher: Prentice Hall

ISBN: 9780132079891

Category: Business & Economics

Page: 177

View: 658

KEY BENEFIT: This book teaches readers how to build financial models with step-by-step instructions in Excel. KEY TOPICS: Progressing from simple examples to practical, real-world applications, this book covers the time value of money, valuation, capital budgeting, financial planning, and options and corporate finance. MARKET: For financial planners and analysts.

Corporate and Project Finance Modeling

This book allows readers to gain a true mastery of the principles underlying financial modeling and valuation by helping them to: Develop flexible and accurate valuation analysis incorporating cash flow waterfalls, depreciation and ...

Author: Edward Bodmer

Publisher: John Wiley & Sons

ISBN: 1118854365

Category: Business & Economics

Page: 624

View: 910

A clear and comprehensive guide to financial modeling and valuation with extensive case studies and practice exercises Corporate and Project Finance Modeling takes a clear, coherent approach to a complex and technical topic. Written by a globally-recognized financial and economic consultant, this book provides a thorough explanation of financial modeling and analysis while describing the practical application of newly-developed techniques. Theoretical discussion, case studies and step-by-step guides allow readers to master many difficult modeling problems and also explain how to build highly structured models from the ground up. The companion website includes downloadable examples, templates, and hundreds of exercises that allow readers to immediately apply the complex ideas discussed. Financial valuation is an in-depth process, involving both objective and subjective parameters. Precise modeling is critical, and thorough, accurate analysis is what bridges the gap from model to value. This book allows readers to gain a true mastery of the principles underlying financial modeling and valuation by helping them to: Develop flexible and accurate valuation analysis incorporating cash flow waterfalls, depreciation and retirements, updates for new historic periods, and dynamic presentation of scenario and sensitivity analysis; Build customized spreadsheet functions that solve circular logic arising in project and corporate valuation without cumbersome copy and paste macros; Derive accurate measures of normalized cash flow and implied valuation multiples that account for asset life, changing growth, taxes, varying returns and cost of capital; Incorporate stochastic analysis with alternative time series equations and Monte Carlo simulation without add-ins; Understand valuation effects of debt sizing, sculpting, project funding, re-financing, holding periods and credit enhancements. Corporate and Project Finance Modeling provides comprehensive guidance and extensive explanation, making it essential reading for anyone in the field.

Financial Modeling

All applied examples contained in the book can be reproduced step by step with the help of the Excel files. The content of this book serves as the foundation for the training course Certified Financial Modeler.

Author: Joachim Häcker

Publisher: Springer

ISBN: 1137426586

Category: Business & Economics

Page: 956

View: 929

This book provides a comprehensive introduction to modern financial modeling using Excel, VBA, standards of financial modeling and model review. It offers guidance on essential modeling concepts around the four core financial activities in the modern financial industry today: financial management; corporate finance; portfolio management and financial derivatives. Written in a highly practical, market focused manner, it gives step-by-step guidance on modeling practical problems in a structured manner. Quick and interactive learning is assured due to the structure as a training course which includes applied examples that are easy to follow. All applied examples contained in the book can be reproduced step by step with the help of the Excel files. The content of this book serves as the foundation for the training course Certified Financial Modeler. In an industry that is becoming increasingly complex, financial modeling is a key skill for practitioners across all key sectors of finance and banking, where complicated problems often need to be solved quickly and clearly. This book will equip readers with the basic modeling skills required across the industry today.

Spreadsheet Modeling in the Fundamentals of Corporate Finance

If you build it, you will learn.

Author: Craig W. Holden

Publisher:

ISBN: 9780130499080

Category: Business & Economics

Page: 135

View: 517

"If you build it, you will learn." Comes as a book and CD-ROM that teaches students how to build financial models in Excel Provides instructions for building financial models, not templates Progresses from simple examples to complex real-world applications Is available in alternative versions that match the notation of most Prentice Hall Fundamentals of Corporate Finance textbooks and other popular textbooks Includes end-of-chapter problems Has been extensively classroom-tested

Spreadsheet Modeling in Corporate Finance

Text specific with notations to correspond with this text.No templates! This series provides detailed instructions on how to build actual financial models in Excel.All models progress from simple examples to complex real-world applications.

Author: Holden

Publisher:

ISBN: 9780130879462

Category: Corporations

Page: 161

View: 959

Text specific with notations to correspond with this text.No templates! This series provides detailed instructions on how to build actual financial models in Excel.All models progress from simple examples to complex real-world applications.

The Oxford Guide to Financial Modeling

The essential premise of this book is that theory and practice are equally important in describing financial modeling.

Author: Thomas S. Y. Ho

Publisher: Oxford University Press

ISBN: 9780199727704

Category: Business & Economics

Page: 768

View: 659

The essential premise of this book is that theory and practice are equally important in describing financial modeling. In it the authors try to strike a balance in their discussions between theories that provide foundations for financial models and the institutional details that provide the context for applications of the models. The book presents the financial models of stock and bond options, exotic options, investment grade and high-yield bonds, convertible bonds, mortgage-backed securities, liabilities of financial institutions--the business model and the corporate model. It also describes the applications of the models to corporate finance. Furthermore, it relates the models to financial statements, risk management for an enterprise, and asset/liability management with illiquid instruments. The financial models are progressively presented from option pricing in the securities markets to firm valuation in corporate finance, following a format to emphasize the three aspects of a model: the set of assumptions, the model specification, and the model applications. Generally, financial modeling books segment the world of finance as "investments," "financial institutions," "corporate finance," and "securities analysis," and in so doing they rarely emphasize the relationships between the subjects. This unique book successfully ties the thought processes and applications of the financial models together and describes them as one process that provides business solutions. Created as a companion website to the book readers can visit www.thomasho.com to gain deeper understanding of the book's financial models. Interested readers can build and test the models described in the book using Excel, and they can submit their models to the site. Readers can also use the site's forum to discuss the models and can browse server based models to gain insights into the applications of the models. For those using the book in meetings or class settings the site provides Power Point descriptions of the chapters. Students can use available question banks on the chapters for studying.

Financial Analysis and Modeling Using Excel and VBA

PRAISE FOR THE FIRST EDITION OF FINANCIAL ANALYSIS AND MODELING USING EXCEL AND VBA "Excel and VBA have vast capabilities, yet until this book, users were on their own to figure out just how to use these tools for both single and complex ...

Author: Chandan Sengupta

Publisher: John Wiley & Sons

ISBN: 047027560X

Category: Business & Economics

Page: 793

View: 966

Provides a comprehensive guide for anyone who has to undertake financial analysis, or understand and implement financial models. Discusses a wide range of real-world financial problems and models using Excel 2007 and Visual Basic for Applications (VBA). Provides reference to earlier versions of Excel and VBA, and includes a CD-Rom with modelling tools and working versions of models discussed.

Financial Modeling

Financial Modeling is now the standard text for explaining the implementation of financial models in Excel.

Author: Simon Benninga

Publisher: MIT Press

ISBN: 0262027283

Category: Business & Economics

Page: 1111

View: 358

Financial Modeling is now the standard text for explaining the implementation of financial models in Excel. This long-awaited fourth edition maintains the "cookbook" features and Excel dependence that have made the previous editions so popular. As in previous editions, basic and advanced models in the areas of corporate finance, portfolio management, options, and bonds are explained with detailed Excel spreadsheets. Sections on technical aspects of Excel and on the use of Visual Basic for Applications (VBA) round out the book to make Financial Modeling a complete guide for the financial modeler. The new edition of Financial Modeling includes a number of innovations. A new section explains the principles of Monte Carlo methods and their application to portfolio management and exotic option valuation. A new chapter discusses term structure modeling, with special emphasis on the Nelson-Siegel model. The discussion of corporate valuation using pro forma models has been rounded out with the introduction of a new, simple model for corporate valuation based on accounting data and a minimal number of valuation parameters. Praise for earlier editions "Financial Modeling belongs on the desk of every finance professional. Its no-nonsense, hands-on approach makes it an indispensable tool." -- Hal R. Varian, Dean, School of Information Management and Systems, University of California, Berkeley " Financial Modeling is highly recommended to readers who are interested in an introduction to basic, traditional approaches to financial modeling and analysis, as well as to those who want to learn more about applying spreadsheet software to financial analysis." -- Edward Weiss, Journal of Computational Intelligence in Finance "Benninga has a clear writing style and uses numerous illustrations, which make this book one of the best texts on using Excel for finance that I've seen." -- Ed McCarthy,Ticker Magazine

Building Financial Models

This second edition of Building Financial Models continues the tradition of its predecessor by providing a hands-on approach to creating a core model that is supported by broad coverage of cornerstone accounting and finance principles.

Author: John Tjia

Publisher: McGraw Hill Professional

ISBN: 9780071608909

Category: Business & Economics

Page: 464

View: 335

The ability to effectively create and interpret financial models is one of the most valued skills in corporate finance--from Wall Street to Main Street. Now, the acclaimed guide to designing, building, and implementing valuation projection models is fully revised and expanded to keep finance and accounting professionals competitive in today's marketplace. This second edition of Building Financial Models continues the tradition of its predecessor by providing a hands-on approach to creating a core model that is supported by broad coverage of cornerstone accounting and finance principles. Additionally, this updated volume features: Entirely new coverage of discounted cash flow (DCF) modeling Excel formulas for making powerful calculations within the spreadsheet In-depth explanations of both the principles and mechanics of projection models Building Financial Models helps readers practice good thinking and apply sound knowledge of their tools--two key attributes to producing robust and easy-to-use models. This practical guide takes you step by step through the entire process of developing a projection model, with a full chapter dedicated to each phase. By the end, you will have a working, dynamic spreadsheet financial model for making projections for industrial and manufacturing companies. Furthermore, this Second Edition provides the vocabulary and syntax of model building so you can tailor core models to fit any size company and allow for quick input changes to test sensitivity. The companion website www.buildingfinancialmodel.com offering example spreadsheets will give you a head start on developing your own models. A flexible and successful financial projection model does more than just add numbers--it explains the complex relationships between those numbers and illuminates ways to use those associations to add value to an enterprise. Building Financial Models is the only book you need to create and implement a fluid financial projection model that is both state of the art and user friendly.

The Handbook of Financial Modeling

A nuts-to-bolts guide to solving common financial problems with spreadsheets, The Handbook of Financial Modeling is a one-stop resource for anyone who needs to build or analyze financial models.

Author: Jack Avon

Publisher: Apress

ISBN: 1430262060

Category: Business & Economics

Page: 504

View: 922

The ability to create and understand financial models that assess the valuation of a company, the projects it undertakes, and its future earnings/profit projections is one of the most valued skills in corporate finance. However, while many business professionals are familiar with financial statements and accounting reports, few are truly proficient at building an accurate and effective financial model from the ground up. That's why, in The Financial Modeling Handbook, Jack Avon equips financial professionals with all the tools they need to precisely and effectively monitor a company's assets and project its future performance. Based on the author's extensive experience building models in business and finance—and teaching others to do the same—The Handbook of Financial Modeling takes readers step by step through the financial modeling process, starting with a general overview of the history and evolution of financial modeling. It then moves on to more technical topics, such as the principles of financial modeling and the proper way to approach a financial modeling assignment, before covering key application areas for modeling in Microsoft Excel. Designed for intermediate and advanced modelers who wish to expand and enhance their knowledge, The Handbook of Financial Modeling also covers: The accounting and finance concepts that underpin working financial models; How to approach financial issues and solutions from a modeler's perspective; The importance of thinking about end users when developing a financial model; How to plan, design, and build a fully functional financial model; And more. A nuts-to-bolts guide to solving common financial problems with spreadsheets, The Handbook of Financial Modeling is a one-stop resource for anyone who needs to build or analyze financial models.