國立高雄大學圖資館 |

Language: English

Back

Practical financial modellinga guide...

ScienceDirect (Online service)

Practical financial modellinga guide to current practice /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Practical financial modellingJonathan Swan.
Reminder of title:	a guide to current practice /
Author:	Swan, Jonathan,
Published:	Burlington, MA :CIMA Publishing,c2008.
Description:	xxvii, 282 p. :col. ill. ;24 cm. +1 CD-ROM (4 3/4 in.)
Notes:	Includes index.
Notes:	Includes exercises and examples using Microsoft Excel.
Subject:	Business enterprisesFinance
Online resource:	An electronic book accessible through the World Wide Web; click for information
ISBN:	9780750686471

Practical financial modellinga guide to current practice /
Swan, Jonathan,MBA.

Practical financial modellinga guide to current practice /[electronic resource] :Jonathan Swan. - 2nd ed. - Burlington, MA :CIMA Publishing,c2008. - xxvii, 282 p. :col. ill. ;24 cm. +1 CD-ROM (4 3/4 in.)

Includes index.

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. --.

This second edition of Practical Financial Modelling is vital tool for all finance and management professionals whose work involves the production and development of complex spreadsheets and financial models. The author bridges the gap between the Excel manual and financial literature with a wealth of practical advise and useful tips. The book identifies good practice and highlights those areas which are prone to error and inconsistency resulting in a refreshingly simple approach to building and using financial models suitable for novice and experienced modellers. By using practical worked examples the most effective ways in which problems can be solved are explored. Key themes include: model structure, audit formulae and functions and model use. New to the second edition: Instructive information on Excel 2007 and its enhanced modelling functions and feature; Risk controls in developing and using financial models; Test-yourself modelling problems and applied examples in every chapter; Substantial information related to reporting and charting techniques and an appendix devoted to parallel comparison of how-to in Excel 2003 and 2007. . Instructive information on Excel 2007 and its enhanced modelling functions and features . Risk controls in developing and using financial models . Test-yourself modelling problems and applied examples in every chapter . Substantial information relating to reporting and charting techniques . An appendix devoted to a parallel comparison of how-to in Excel 2003 and Excel 2007.

Electronic reproduction.
Amsterdam :
Elsevier Science & Technology,
2010.

Mode of access: World Wide Web.

ISBN: 9780750686471

Source: 141496:141640Elsevier Science & Technologyhttp://www.sciencedirect.comSubjects--Uniform Titles:

Microsoft Excel (Computer file)
Subjects--Topical Terms:

455058
Business enterprises
--FinanceIndex Terms--Genre/Form:

214472
Electronic books.

LC Class. No.: HG4012 / .S93 2008

Dewey Class. No.: 658.150151 22

Practical financial modellinga guide to current practice /
LDR:03772nmm 2200349Ia 4500 001 257118
003 OCoLC
005 20100729101520.0
006 m d
007 cr cn|||||||||
008 100818s2008 maua s 001 0 eng d
020 $a 9780750686471
020 $a 0750686472
035 $a (OCoLC)500570910
035 $a ocn500570910
037 $a 141496:141640 $b Elsevier Science & Technology $n http://www.sciencedirect.com
040 $a OPELS $b eng $c OPELS
049 $a TEFA
050 1 4 $a HG4012 $b .S93 2008
082 0 4 $a 658.150151 22 $2 22
100 1 $a Swan, Jonathan, $c MBA. $3 455057
245 1 0 $a Practical financial modelling $h [electronic resource] : $b a guide to current practice / $c Jonathan Swan.
250 $a 2nd ed.
260 $a Burlington, MA : $b CIMA Publishing, $c c2008.
300 $a xxvii, 282 p. : $b col. ill. ; $c 24 cm. + $e 1 CD-ROM (4 3/4 in.)
500 $a Includes index.
500 $a Includes exercises and examples using Microsoft Excel.
505 0 $a 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. --.
505 0 $a Model structure -- Quality control -- Mainly formulas -- Mainly functions -- Model use -- Sensitivity analysis and scenarios -- Automation.
520 $a This second edition of Practical Financial Modelling is vital tool for all finance and management professionals whose work involves the production and development of complex spreadsheets and financial models. The author bridges the gap between the Excel manual and financial literature with a wealth of practical advise and useful tips. The book identifies good practice and highlights those areas which are prone to error and inconsistency resulting in a refreshingly simple approach to building and using financial models suitable for novice and experienced modellers. By using practical worked examples the most effective ways in which problems can be solved are explored. Key themes include: model structure, audit formulae and functions and model use. New to the second edition: Instructive information on Excel 2007 and its enhanced modelling functions and feature; Risk controls in developing and using financial models; Test-yourself modelling problems and applied examples in every chapter; Substantial information related to reporting and charting techniques and an appendix devoted to parallel comparison of how-to in Excel 2003 and 2007. . Instructive information on Excel 2007 and its enhanced modelling functions and features . Risk controls in developing and using financial models . Test-yourself modelling problems and applied examples in every chapter . Substantial information relating to reporting and charting techniques . An appendix devoted to a parallel comparison of how-to in Excel 2003 and Excel 2007.
533 $a Electronic reproduction. $b Amsterdam : $c Elsevier Science & Technology, $d 2010. $n Mode of access: World Wide Web. $n System requirements: Web browser. $n Title from title screen (viewed on Jan. 14, 2010). $n Access may be restricted to users at subscribing institutions.
630 0 0 $a Microsoft Excel (Computer file) $3 190780
650 0 $a Business enterprises $x Finance $x Mathematical models. $3 455058
650 0 $a Corporations $x Finance $x Mathematical models. $3 266246
655 7 $a Electronic books. $2 local. $3 214472
710 2 $a ScienceDirect (Online service) $3 307425
776 1 $c Original $z 9780750686471 $z 0750686472 $w (OCoLC)184827856
856 4 0 $3 ScienceDirect $u http://www.sciencedirect.com/science/book/9780750686471 $z An electronic book accessible through the World Wide Web; click for information
994 $a C0 $b TEF