Building financial models with Microsoft Excel : a guide for business professionals

• Main Author: Proctor, K. Scott (Author)
• Format: Book
• Language: English
• Published: Hoboken : Wiley, c2004
• Series: Wiley finance
• Subjects: Microsoft Excel (software); účetnictví; manažerské účetnictví; finance podniku; finanční management; Microsoft Excel; accounting; managerial accounting; business finance; financial management
• ISBN: 0471661031
• Physical Description: xix, 347 s. : il. ; 24 cm + 1 CD-ROM

Table of Contents:

• 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