Corporate and Project Finance Modeling

Corporate and Project Finance Modeling
Author: Edward Bodmer
Publisher: John Wiley & Sons
Total Pages: 628
Release: 2014-11-10
Genre: Business & Economics
ISBN: 1118854365

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 and Valuation

Financial Modeling and Valuation
Author: Paul Pignataro
Publisher: John Wiley & Sons
Total Pages: 432
Release: 2013-07-10
Genre: Business & Economics
ISBN: 1118558766

Written by the Founder and CEO of the prestigious New York School of Finance, this book schools you in the fundamental tools for accurately assessing the soundness of a stock investment. Built around a full-length case study of Wal-Mart, it shows you how to perform an in-depth analysis of that company's financial standing, walking you through all the steps of developing a sophisticated financial model as done by professional Wall Street analysts. You will construct a full scale financial model and valuation step-by-step as you page through the book. When we ran this analysis in January of 2012, we estimated the stock was undervalued. Since the first run of the analysis, the stock has increased 35 percent. Re-evaluating Wal-Mart 9months later, we will step through the techniques utilized by Wall Street analysts to build models on and properly value business entities. Step-by-step financial modeling - taught using downloadable Wall Street models, you will construct the model step by step as you page through the book. Hot keys and explicit Excel instructions aid even the novice excel modeler. Model built complete with Income Statement, Cash Flow Statement, Balance Sheet, Balance Sheet Balancing Techniques, Depreciation Schedule (complete with accelerating depreciation and deferring taxes), working capital schedule, debt schedule, handling circular references, and automatic debt pay downs. Illustrative concepts including detailing model flows help aid in conceptual understanding. Concepts are reiterated and honed, perfect for a novice yet detailed enough for a professional. Model built direct from Wal-Mart public filings, searching through notes, performing research, and illustrating techniques to formulate projections. Includes in-depth coverage of valuation techniques commonly used by Wall Street professionals. Illustrative comparable company analyses - built the right way, direct from historical financials, calculating LTM (Last Twelve Month) data, calendarization, and properly smoothing EBITDA and Net Income. Precedent transactions analysis - detailing how to extract proper metrics from relevant proxy statements Discounted cash flow analysis - simplifying and illustrating how a DCF is utilized, how unlevered free cash flow is derived, and the meaning of weighted average cost of capital (WACC) Step-by-step we will come up with a valuation on Wal-Mart Chapter end questions, practice models, additional case studies and common interview questions (found in the companion website) help solidify the techniques honed in the book; ideal for universities or business students looking to break into the investment banking field.

Financial Modeling for Business Owners and Entrepreneurs

Financial Modeling for Business Owners and Entrepreneurs
Author: Tom Y. Sawyer
Publisher: Apress
Total Pages: 335
Release: 2014-09-22
Genre: Business & Economics
ISBN: 1484203704

Financial Modeling for Business Owners and Entrepreneurs: Developing Excel Models to Raise Capital, Increase Cash Flow, Improve Operations, Plan Projects, and Make Decisions may be one of the most important books any entrepreneur or manager in a small or medium-sized enterprise will read. It combines logical business principles and strategies with a step-by-step methodology for planning and modeling a company and solving specific business problems. You’ll learn to create operational and financial models in Excel that describe the workings of your company in quantitative terms and that make it far more likely you will avoid the traps and dead ends many businesses fall into. Serial entrepreneur and financial expert Tom Y. Sawyer shows how to break your company down into basic functional and operational components that can be modeled. The result is a financial model that, for example, you can literally take to the bank or bring to local angel investors to receive the funding you need to launch your business or a new product. Or it might be a model that shows with startling clarity that your new product development effort is a likely winner—or loser. Even better, you’ll learn to create models that will serve as guideposts for ongoing operations. You’ll always know just where you are financially, and where you need to be. The models you will learn to build in Financial Modeling for Business Owners and Entrepreneurs can be used to: Raise capital for startup or any stage of growth Plan projects and new initiatives Make astute business decisions, including go/no-go assessments Analyze ROI on your product development and marketing expenditures Streamline operations, manage budgets, improve efficiency, and reduce costs Value the business when it is time to cash out or merge In addition to many valuable exercises and tips for using Excel to model your business, this book contains a combination of practical advice born of hard-won lessons, advanced strategic thought, and the insightful use of hard skills. With a basic knowledge of Excel assumed, it will help you learn to think like an experienced business person who expects to make money on the products or services offered to the public. You’ll discover that the financial model is a key management tool that, if built correctly, provides invaluable assistance every step of the entrepreneurial journey. Tom Y. Sawyer has used the principles this book contains to create financial models of numerous startup and early-stage companies, assisting them in planning for and raising the capital that they needed to grow their businesses and ultimately exit with multiples of their initial investment. Financial Modeling for Business Owners and Entrepreneurs, a mini-MBA in entrepreneurship and finance, will show you how you can do the same. Note: This book is an updated version of Sawyer's 2009 title, Pro Excel Financial Modeling.

Modeling Structured Finance Cash Flows with Microsoft Excel

Modeling Structured Finance Cash Flows with Microsoft Excel
Author: Keith A. Allman
Publisher: John Wiley & Sons
Total Pages: 230
Release: 2010-12-28
Genre: Business & Economics
ISBN: 1118044665

A practical guide to building fully operational financial cash flow models for structured finance transactions Structured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. Modeling Structured Finance Cash Flows with Microsoft Excel provides readers with the information they need to build a cash flow model for structured finance and securitization deals. Financial professional Keith Allman explains individual functions and formulas, while also explaining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called "Model Builder," in which Allman translates the theory into functions and formulas. In addition, the companion website features all of the modeling exercises, as well as a final version of the model that is created in the text. Note: Companion website and other supplementary materials are not included as part of eBook file.

Alternative Finance

Alternative Finance
Author: Mina Fanea-Ivanovici
Publisher: Taylor & Francis
Total Pages: 309
Release: 2024-11-06
Genre: Business & Economics
ISBN: 1040166482

The alternative financing space has grown exponentially in the last few decades, namely as a consequence of the financial crisis, technological advancement, niche customer segments, and more recently the pandemic. Now, with the inclusion of Fintech, online lenders, crowdfunding, accelerators, venture capitalists, or angel investors, this funding channel is no longer seen as a substitute for formal financing, but rather a core one. This book is a comprehensive guide to alternative financing methods, offering insights into emerging trends, the role of FinTech, and the intersection of finance with sustainability, innovation, and entrepreneurship. It fills a knowledge gap by exploring innovative financing channels such as fintech, green finance, and venture capital as well as other non-traditional ways of raising funds, which have become crucial for startups and businesses. It discusses the impact of financial technology (FinTech) on these methods and their function in supporting entrepreneurship and sustainable business, while also examining the implications of these technological advancements in the wider financial sector. It addresses challenges and opportunities for entrepreneurs and explores how alternative financing options can support growth and innovation, particularly in the context of environmentally and socially focused ventures, including how to integrate economic, social, and environmental considerations. The emphasis on sustainability and green finance aligns with the growing global concern for responsible business practices and the Sustainable Development Goals. While the primary audience for the book is scholars, researchers, and students, the inclusion of case studies, and the exploration of various financing options, extends practical cues for policymakers and practitioners and contributes to the understanding of how finance, entrepreneurship, and sustainability intersect in real-world business scenarios.

Real Options in Capital Investment

Real Options in Capital Investment
Author: Lenos Trigeorgis
Publisher: Praeger
Total Pages: 0
Release: 1995-01-24
Genre: Business & Economics
ISBN: 0275946169

This compilation integrates various new contributions to the growing real options literature. Recent developments in the valuation of capital investment opportunities seen as real options (e.g. to defer, expand, abandon, or switch) have provided the tools and unlocked the possibilities to revolutionize the field of capital budgeting. The resulting insights, strategies, and techniques enable quantifying the thus far elusive elements of managerial operating flexibility and strategic interactions. These are vital to successfully capitalize on favorable future investment opportunities or limit losses from adverse market developments. This book presents various models and operating strategies, and a variety of applications ranging from acquisitions and divestitures, to natural resource development and pollution compliance. It is intended for both the academic and the professional market. The book's contributions are divided into five parts, covering sections on real options and alternative valuation paradigms for capital investment analysis; on the analysis of general exchange or switching options, and interdependencies among multiple such options; on strategic acquisitions, infrastructure, and foreign investment options; on mean reversion/ alternative formulations in natural resource investments, shipping, and start-up ventures; and on other applications in pollution compliance, land development, flexible manufacturing, and financial default options. Both academic and practitioner interest in these developments is unusually high. The book can serve as supplementary material for the academic market, e.g., in advanced finance courses in option pricing or capital budgeting, in doctoral seminars, and as a library resource. It may also be of interest to the professional market (e.g. corporate planners and finance executives in the oil, pharmaceutical, auto and a variety of other industries), academics from related areas (e.g. decision analysts or economists), as well as to international readers (academics, doctoral students, and professionals).