Taylor's Library

Normal view MARC view ISBD view

Practical financial modelling [electronic resource] : a guide to current practice / Jonathan Swan.

By: Swan, Jonathan, MBA.
Contributor(s): ScienceDirect (Online service).
Publisher: Burlington, MA : CIMA Publishing, c2008Edition: 2nd ed.Description: xxvii, 282 p. : col. ill.ISBN: 9780750686471; 0750686472.Subject(s): Microsoft Excel (Computer file) | Business enterprises -- Finance -- Mathematical models | Corporations -- Finance -- Mathematical modelsGenre/Form: Electronic books.Additional physical formats: No titleDDC classification: 658.150151 Online resources: An electronic book accessible through the World Wide Web; click for information
Contents:
Introduction; Definitions; Descriptions; Common approaches; Structure; Inputs; Workings; Outputs; Variations; Support; Documentation; Navigation; Content: Formulae; Range names; Corkscrews; Masks and switches; Recalculation; Circularities; Functions; Logical; Lookup; Financial; Other; Custom; Quality control: Audit; Audit sheet; Structural checks; Arithmetical checks; Financial checks; Model Use; Grouping; Data validation and Dropdown lists; Conditional and custom formats; Sensitivity analysis; Reporting - Reports, Charting, Printing; Automation; Macros; Appendix; Keyboard shortcuts; References; Further information; index.
Model structure -- Quality control -- Mainly formulas -- Mainly functions -- Model use -- Sensitivity analysis and scenarios -- Automation.
Item type Current location Call number Status Notes Date due Barcode
Main Collection Taylor's Library - Perpetual(TU)
658.150151 (Browse shelf) e-book TBSxx,44001,03,CL,PPT

Includes index.

Includes exercises and examples using Microsoft Excel.

Introduction; Definitions; Descriptions; Common approaches; Structure; Inputs; Workings; Outputs; Variations; Support; Documentation; Navigation; Content: Formulae; Range names; Corkscrews; Masks and switches; Recalculation; Circularities; Functions; Logical; Lookup; Financial; Other; Custom; Quality control: Audit; Audit sheet; Structural checks; Arithmetical checks; Financial checks; Model Use; Grouping; Data validation and Dropdown lists; Conditional and custom formats; Sensitivity analysis; Reporting - Reports, Charting, Printing; Automation; Macros; Appendix; Keyboard shortcuts; References; Further information; index.

Model structure -- Quality control -- Mainly formulas -- Mainly functions -- Model use -- Sensitivity analysis and scenarios -- Automation.

Electronic reproduction. Amsterdam : Elsevier Science & Technology, 2010. Mode of access: World Wide Web. System requirements: Web browser. Title from title screen (viewed on Jan. 14, 2010). Access may be restricted to users at subscribing institutions.