Corporate and Project Finance Modeling is a comprehensive guidebook for creating, interpreting, and analyzing complex financial models. The book offers the information needed to master difficult modeling problems and shows how to build highly structured models from the ground up. Using the suggestions and techniques outlined in this important text, beginners and experienced professionals can hone their skills and take their performance to the next level in order to analyze and create flexible, efficient, and stable model structures. Edward Bodmer, an international expert in the field, covers the technical aspects of building and analyzing financial models and presents results from a wide range of alternative models. To gain a clear understanding of the process, the author reveals why particular modeling features are generally included in one kind of model but not in others. The book also introduces unique modeling techniques that address many complex issues that are not typically used by even the most experienced modelers. For example, the author shows how to build user-defined functions to solve circular logic without cumbersome copy and paste macros. The book explains how to derive ratios of enterprise value to earnings before interest, taxes, depreciation, and amortization (EV/EBITDA) that account for asset life, historical growth, taxes, return on investment, and cost of capital. In addition to explaining how to solve a modeling problem, Corporate and Project Finance Modeling explores the finance theory underlying how to construct models with an exact approach. The author addresses modeling issues ranging from the fundamental structure of financial models to the creation of user-defined VBA functions that resolve circular references. Each issue covered includes a theoretical discussion and an explanation of the modeling mechanics as applied to various corporate structures. The book covers a wide range of vital topics including a review of valuation in the context of project finance, corporate finance, and acquisition finance; cash flow waterfalls; credit analysis in corporate and project finance; debt structuring; determination of items that should be in the bridge between enterprise value and equity value; and many other subjects. To enhance the text, the modeling problems are explained with illustrative diagrams and screen shots from actual models. This comprehensive text includes a companion website that contains exercises, model examples, video explanations, and case studies. Designed as a flexible resource, Corporate and Project Finance Modeling gives professionals the information needed to borrow subtle concepts from solutions to many different modeling problems so they can apply them to their own models.