Building financial models with Microsoft Excel : a guide for business professionals / K. Scott Proctor.

Format:

Book

Author/Creator:

Proctor, K. Scott.

Series:

Wiley Finance

Wiley Finance ; v.269

Language:

English

Subjects (All):

Corporations--Finance--Computer programs.

Corporations.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (369 p.)

Edition:

1st ed.

Place of Publication:

Hoboken, NJ : Wiley, c2004.

Language Note:

English

Summary:

A comprehensive guide to building financial models Building Financial Models with Microsoft Excel + CD-ROM provides beginning or intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow readers to build their own financial models. This comprehensive resource also covers important topics such as the concept of valuation, the concept of sensitivity analysis, the concepts of contribution margin a

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.

Notes:

Description based upon print version of record.

ISBN:

1-280-26532-9

9786610265329

0-471-69320-0

OCLC:

57351794