MARC details
| 000 -LEADER |
|---|
| fixed length control field |
06322cam a22005174i 4500 |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20211104204549.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS |
|---|
| fixed length control field |
m u |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION |
|---|
| fixed length control field |
ta |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION |
|---|
| fixed length control field |
co ug ---a|||| |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
081212s2008 njua b 001 0 eng d |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER |
|---|
| LC control number |
2008038607 |
| 011 ## - LINKING LIBRARY OF CONGRESS CONTROL NUMBER [OBSOLETE] |
|---|
| Local cataloguing issues note |
BIB MATCHES WORLDCAT |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
0470997443 |
| Qualifying information |
cloth/cd |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9780470997444 |
| Qualifying information |
cloth/cd |
| 035 ## - SYSTEM CONTROL NUMBER |
|---|
| System control number |
(ATU)b11474762 |
| 035 ## - SYSTEM CONTROL NUMBER |
|---|
| System control number |
(OCoLC)253634139 |
| 040 ## - CATALOGING SOURCE |
|---|
| Original cataloging agency |
DLC |
| Language of cataloging |
eng |
| Description conventions |
rda |
| Transcribing agency |
DLC |
| Modifying agency |
BWKUK |
| -- |
BWK |
| -- |
BWX |
| -- |
YDXCP |
| -- |
CDX |
| -- |
ATU |
| 050 00 - LIBRARY OF CONGRESS CALL NUMBER |
|---|
| Classification number |
HG106 |
| Item number |
.R44 2008 |
| 082 00 - DEWEY DECIMAL CLASSIFICATION NUMBER |
|---|
| Classification number |
332.0151 |
| Edition number |
22 |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Rees, Michael, |
| Dates associated with a name |
1964- |
| Relator term |
author. |
| 9 (RLIN) |
444648 |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
Financial modelling in practice : |
| Remainder of title |
a concise guide for intermediate and advanced level / |
| Statement of responsibility, etc. |
Michael Rees. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE |
|---|
| Place of production, publication, distribution, manufacture |
Hoboken, NJ : |
| Name of producer, publisher, distributor, manufacturer |
Wiley, |
| Date of production, publication, distribution, manufacture, or copyright notice |
[2008] |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE |
|---|
| Date of production, publication, distribution, manufacture, or copyright notice |
©2008 |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
xvii, 270 pages : |
| Other physical details |
illustrations ; |
| Dimensions |
25 cm + |
| Accompanying material |
1 computer disc (12 cm). |
| 336 ## - CONTENT TYPE |
|---|
| Content type term |
text |
| Content type code |
txt |
| Source |
rdacontent |
| 336 ## - CONTENT TYPE |
|---|
| Content type term |
computer dataset |
| Content type code |
cod |
| Source |
rdacontent |
| Materials specified |
Accompanying material |
| 337 ## - MEDIA TYPE |
|---|
| Media type term |
unmediated |
| Media type code |
n |
| Source |
rdamedia |
| 337 ## - MEDIA TYPE |
|---|
| Media type term |
computer |
| Media type code |
c |
| Source |
rdamedia |
| Materials specified |
Accompanying material |
| 338 ## - CARRIER TYPE |
|---|
| Carrier type term |
volume |
| Carrier type code |
nc |
| Source |
rdacarrier |
| 338 ## - CARRIER TYPE |
|---|
| Carrier type term |
computer disc |
| Carrier type code |
cd |
| Source |
rdacarrier |
| Materials specified |
Accompanying material |
| 490 1# - SERIES STATEMENT |
|---|
| Series statement |
Wiley finance |
| 500 ## - GENERAL NOTE |
|---|
| General note |
Accompanied by: 1 computer disc (CD-ROM) |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE |
|---|
| Bibliography, etc. note |
Includes bibliographical references and index. |
| 505 00 - FORMATTED CONTENTS NOTE |
|---|
| Miscellaneous information |
1. |
| Title |
Building Blocks: Selected Excel Functions and Tools -- |
| -- |
Core Functions for Financial Modelling -- |
| -- |
Arithmetic Operations -- |
| -- |
Logical Operations -- |
| -- |
Financial Calculations -- |
| -- |
Database Functions, Features and Pivot Tables -- |
| -- |
Statistical Functions -- |
| -- |
Lookup and Reference Functions -- |
| -- |
Text Functions -- |
| -- |
Information Functions -- |
| -- |
Array Functions, Formulae and Matrix Calculations -- |
| -- |
GoalSeek and Solver -- |
| -- |
The Analysis ToolPak and Other Add-ins -- |
| -- |
Selected Excel Short-cuts -- |
| Miscellaneous information |
2. |
| Title |
Principles of Modelling -- |
| -- |
What is a Good Model? -- |
| -- |
Model Design -- |
| -- |
Selection of Model Variables and their Dependencies -- |
| -- |
Level of Detail or Aggregation -- |
| -- |
Model Structure and Planning -- |
| -- |
Logical Flow -- |
| -- |
Compactness -- |
| -- |
Named Ranges -- |
| -- |
Circular References -- |
| -- |
Model Building -- |
| -- |
Formatting and Comments -- |
| -- |
Creating Robust Formulae -- |
| -- |
Results Presentation and Other Uses of Sensitivity Analysis -- |
| -- |
General Remarks on Presentation -- |
| -- |
Using Data Tables to Conduct Sensitivity Analysis -- |
| -- |
Hiding and Protecting Models -- |
| -- |
Model Auditing -- |
| Miscellaneous information |
3. |
| Title |
Financial Statement, Cash Flow and Valuation Modelling -- |
| -- |
Financial Statement Modelling: Core Points and Example -- |
| -- |
General Comments -- |
| -- |
Income Statement Forecasting -- |
| -- |
Balance Sheet Forecasting -- |
| -- |
Cash Flow Statement Forecasting -- |
| -- |
Error Checks and Feasibility Checks -- |
| -- |
General Error Checking Tools -- |
| -- |
Feasibility Checking and Ratio Analysis -- |
| -- |
Adding Generality -- |
| -- |
Cash Flow Valuation -- |
| -- |
Calculation of Free Cash Flow -- |
| -- |
Discounting Free Cash Flow -- |
| -- |
Terminal Value Calculations -- |
| -- |
Further Adjustments -- |
| -- |
Sensitivity Analysis -- |
| Miscellaneous information |
4. |
| Title |
Risk Modelling -- |
| -- |
Benefits and Challenges of Risk Modelling -- |
| -- |
The Risk Modelling Process -- |
| -- |
An Introduction to Simulation Techniques -- |
| -- |
The Language of Probability Distributions -- |
| -- |
Quick Guide to using @RISK -- |
| -- |
Types of Dependency Relationships in Risk Models -- |
| -- |
The Selection and Use of Distributions -- |
| -- |
Pragmatic Approaches and Distributions -- |
| -- |
Data-Driven Approaches and Distributions -- |
| -- |
Scientific Approaches and Distributions: The Basics -- |
| -- |
Further Aspects of the Science of Distributions -- |
| -- |
Further Example Models -- |
| Miscellaneous information |
5. |
| Title |
Introduction to Options and Real Options Modelling -- |
| -- |
Financial Market Derivatives: An Introduction -- |
| -- |
Real Options Modelling -- |
| -- |
Uses and Relationships to Other Types of Analysis -- |
| -- |
Examples using Simulation -- |
| -- |
Examples using Trees -- |
| Miscellaneous information |
6. |
| Title |
VBA for Financial Modelling -- |
| -- |
Introduction -- |
| -- |
The Bare Essentials -- |
| -- |
Simple Examples -- |
| -- |
Building Blocks -- |
| -- |
Working with Ranges -- |
| -- |
Writing Robust Code -- |
| -- |
Further Topics -- |
| -- |
Object Orientation: An Introduction -- |
| -- |
Controlling Execution and Related Topics -- |
| -- |
Working with Functions -- |
| -- |
Checking and Debugging Code -- |
| -- |
Examples: Recording Macros and Related Topics -- |
| -- |
Introduction -- |
| -- |
Using GoalSeek and Solver -- |
| -- |
Examples: Simulation Modelling -- |
| -- |
Introduction -- |
| -- |
Examples: User-defined Functions -- |
| -- |
Creating Functions -- |
| -- |
Examples -- |
| -- |
Structure and Organisation: Further Topics. |
| 520 ## - SUMMARY, ETC. |
|---|
| Summary, etc. |
"Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level is a practical, comprehensive and in-depth guide to financial modelling designed to cover the modelling issues that are relevant to facilitate the construction of robust and readily understandable models. Based on the authors extensive experience of building models in business and finance, and of training others how to do so this book starts with a review of Excel functions that are generally most relevant for building intermediate and advanced level models (such as Lookup functions, database and statistical functions and so on). It then discusses the principles involved in designing, structuring and building relevant, accurate and readily understandable models (including the use of sensitivity analysis techniques) before covering key application areas, such as the modelling of financial statements, of cash flow valuation, risk analysis, options and real options. Finally, the topic of financial modelling using VBA is treated. Practical examples are used throughout and model examples are included in the attached CD-ROM. Aimed at intermediate and advanced level modellers in Excel who wish to extend and consolidate their knowledge, this book is focused, practical, and application-driven, facilitating knowledge to build or audit a much wider range of financial models ."--Publisher's website. |
| 588 ## - SOURCE OF DESCRIPTION NOTE |
|---|
| Source of description note |
Machine converted from AACR2 source record. |
| 630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE |
|---|
| Uniform title |
Microsoft Excel (Computer file) |
| 9 (RLIN) |
312953 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Finance |
| General subdivision |
Mathematical models |
| 9 (RLIN) |
370807 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Corporations |
| General subdivision |
Finance |
| -- |
Mathematical models. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Options (Finance) |
| General subdivision |
Mathematical models |
| 9 (RLIN) |
717240 |
| 830 #0 - SERIES ADDED ENTRY--UNIFORM TITLE |
|---|
| Uniform title |
Wiley finance series. |
| 9 (RLIN) |
267852 |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) |
|---|
| a |
.b11474762 |
| b |
03-11-20 |
| c |
27-10-15 |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) |
|---|
| -- |
b |
| -- |
c |
| Operator's initials, OID (RLIN) |
06-04-16 |
| Cataloger's initials, CIN (RLIN) |
m |
| First date, FD (RLIN) |
a |
| -- |
eng |
| -- |
nju |
| -- |
0 |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) |
|---|
| a |
332.0151 REE |
| g |
1 |
| i |
A468797B |
| j |
0 |
| l |
cmain |
| o |
- |
| p |
$139.85 |
| q |
- |
| r |
- |
| s |
- |
| t |
0 |
| u |
98 |
| v |
2 |
| w |
1 |
| x |
1 |
| y |
.i12934458 |
| z |
29-10-15 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Koha item type |
Book |
