Includes index.

Overview of budgets and financial models -- Operating budget : assumptions, sales, and collections -- Operating budget : cost of goods sold, inventory, and purchases -- Operating budget: operating expenses -- Operating budget : income statement -- Financial budget : capital budget and cash budget -- Financial budget : balance sheet -- Consolidated financial statements -- Free cash flows and dashboard -- Sensitivity analysis -- Contribution margin analysis -- Financial ratios analysis -- Valuation -- Capitalization chart.

"Building Financial Models with Microsoft Excel, Second Edition offers a detailed and easy-to-understand guide for anyone who needs to build or analyze financial models using Microsoft Excel 2007. Written in a straightforward and accessible manner, it is a comprehensive resource for business professionals with a beginner or intermediate level of experience in both Microsoft Excel, and finance or accounting. K. Scott Proctor provides a thoughtful and coherent link between financial/accounting theory and common Wall Street practice by addressing key questions in financial modeling like what to build, how to build, and how to analyze."--BOOK JACKET.