About the Book

A properly structured financial model can provide decision makers with a powerful planning tool that helps them identify the consequences of their decisions before they are put into practice. Introduction to Financial Models for Management and Planning enables professionals and students to learn how to develop and use computer-based models for financial planning. Providing critical tools for the financial toolbox, this volume shows how to use these tools to build successful models.

Placing a strong emphasis on the structure of models, the book focuses on developing models that are consistent with the theory of finance and, at the same time, are practical and usable. The authors introduce powerful tools that are imperative to the financial management of the operating business. These include interactive cash budgets and pro forma financial statements that balance even under the most extreme assumptions, valuation techniques, forecasting techniques that range from simple averages to time series methods, Monte Carlo simulation, linear programming, and optimization.

The tools of financial modeling can be used to solve the problems of planning the firm’s investment and financing decisions. These include evaluating capital projects, planning the financing mix for new investments, capital budgeting under capital constraints, optimal capital structure, cash budgeting, working capital management, mergers and acquisitions, and constructing efficient security portfolios.

While the primary emphasis is on models related to corporate financial management, the book also introduces readers to a variety of models related to security markets, stock and bond investments, portfolio management, and options.

This authoritative book supplies broad-based coverage and free access to @Risk software for Monte Carlo simulation, making it an indispensible text for professionals and students in financial management.