Shortcuts
Top of page (Alt+0)
Page content (Alt+9)
Page menu (Alt+8)
Your browser does not support javascript, some WebOpac functionallity will not be available.
PageMenu
-
Hauptmenü
-
Suchmenü
Einfache Suche
.
Erweiterte Suche
.
Zeitschriften-Suche
.
Suchergebnisse verfeinern
.
Neuerwerbungsliste nach Gruppen
.
Sortierreihenfolge
.
Benutzerdienste
Nutzeranmeldung
.
Mein Konto
.
Erwerbungsvorschlag
.
Fernleihe
.
Vormerkung
.
Verlängerung
.
Weitere Recherchemöglichkeiten
Datenbankinfosystem (DBIS)
.
Karlsruher virtueller Katalog (KVK)
.
Regensburger Systematik (RVK)
.
Elektronische Zeitschriften (EZB)
.
Zeitschriftendatenbank (ZDB)
.
Sitzung beenden
Katalog verlassen
.
Homepage WHZ
.
Hochschulbibliothek
.
© LIBERO v6.4.1sp240211
Page content
Sie befinden sich hier
:
>
Erwerbungsvorschlag
Katalogdatenanzeige
Katalogdatenanzeige
¬The¬ Handbook of Financial Modeling: A Practical Approach to Creating and Implementing Valuation Projection Models
.
Bookmark für diesen Satz setzen
Katalogdatensatz500198037
.
.
Wikipedia-Verfasserlink
.
.
LibraryThing
.
Kataloginformation
Katalogdatensatz500198037
.
Kataloginformation
Feldname
Details
Vorliegende Sprache
eng
Hinweise auf parallele Ausgaben
395923654 Druckausg.: ‡Avon, Jack: ¬The¬ Handbook of Financial Modeling
ISBN
978-1-4302-6205-3
Name
Avon, Jack
T I T E L
¬The¬ Handbook of Financial Modeling
Zusatz zum Titel
A Practical Approach to Creating and Implementing Valuation Projection Models
Verlagsort
Berkeley, CA ; s.l.
Verlag
Apress
Erscheinungsjahr
2013
2013
Umfang
Online-Ressource (X, 504 p. 299 illus, online resource)
Reihe
SpringerLink. Bücher
Notiz / Fußnoten
Description based upon print version of record
Weiterer Inhalt
Contents; Introduction; Chapter 1: Financial Modeling: An Overview; Financial Modeling: A Definition; Microsoft Excel as the Modeler's Tool; Where Are Financial Models Used?; The Role of the Financial Modeler; Chapter 2: Financial Modeling Best Practices; What Are the Best Practices of Financial Modeling?; Keep the Constituents Separate; Reduce Implicit Assumptions to a Minimum; Avoid Using Constants Inside Formulas; Let Inputs Drive Your Models, Not Calculations; Have Only One Input for Each Assumption; Specify Measurement Units for All Input Assumptions. The Logical Flow of Calculations and CircularityUse Consistent Formulas Across Rows; Avoid Mixing Time Periods of Different Lengths; Break Up Long Formulas into Simple Pieces; Include Automatic Error Checks; Errors Explained; The Reasons for Errors; Unskilled Users; Lack of Planning; Data and Recycling; Intrusions; Who Will Review or Check for Errors?; Real-Life Errors; A Tip on Errors; Catching and Trapping Errors; How to Work with Errors in Models; Adding Error Checks; Best Practices in a Nutshell; Case Study: Financial Model Gone Awry; The Non-best Practice Model; The Best Practice Model. Excel Formulas and Functions for ModelersMost Used Functions; IF( ); SUMIF( ), COUNTIF( ), AVERAGEIF( ); SUMIFS( ); Lookup Functions; VLOOKUP( ); MATCH( ); INDEX( ); OFFSET( ); CHOOSE( ); Date and Time Functions; NETWORKDAYS.INTL( ); DATEDIF( ); WORKDAY( ); EOMONTH( ); DAYS360( ); DATE( ); Math Functions; MOD( ); PRODUCT( ); SUM( ); Logical Functions; AND( ); OR( ); ISERROR( ); Functions That Use Arrays; SUMPRODUCT( ); Working with Custom Functions or UDFs; What Are UDFs?; When Would You Design and Use UDFs?; LINKADDRESS( ); EFFINDEX( ); SUMCOLOR( ); SUMTB( ); ISDATE( ); WORKSHEETSTATS( ). Typical Modeling Issues and How to Address Them with FunctionsDealing with Text When You Need Values; Case Study: Using Modeling Functions and Tools; Chapter 4: Planning Your Model; Introduction to the Financial Modeling Life Cycle; Here is a list of the ten key development stages:; Planning to Build a Model; Is There a Clear Understanding of Cash?; How Much Detail Is Required?; Create Scenario Analysis and Sensitivity Analysis; Assumptions: How Realistic Are They?; Missing Key Elements in Financial Statements; Developing a Feasibility Assessment; Scoping the Modeling Project. The Specification & StrategyThe Benefits of Model Specification; Defining Model Outputs; Defining Calculations: Techniques for the Model Specifications; Defining the Inputs; Chapter 5: Testing and Documenting Your Model; Testing the Financial Model; Why Test?; Who Should Test?; When to Test?; Types of Tests; Numeric Tests; Robustness Tests; Environment Tests; Boundary Tests; Macro Tests; Specification Tests; Unique Formulas Tests; Common Types of Errors to Test; Formulas Not Copied; Wrong Reference; Sum Over the Wrong Range; Relative and Absolute References; Unit Errors. Commonly Misused Functions
Titelhinweis
Druckausg.: ‡Avon, Jack: ¬The¬ Handbook of Financial Modeling
ISBN
ISBN 978-1-4302-6206-0
Klassifikation
KJ
BUS042000
658.150285
650
HF4999.2-6182
HD28-70
QP 710
Kurzbeschreibung
The ability to create and understand financial models that assess the valuation of a company, the projects it undertakes, and its future earnings/profit projections is one of the most valued skills in corporate finance. However, while many business professionals are familiar with financial statements and accounting reports, few are truly proficient at building an accurate and effective financial model from the ground up. That's why, in The Financial Modeling Handbook, Jack Avon equips financial professionals with all the tools they need to precisely and effectively monitor a company's assets and project its future performance. Based on the author's extensive experience building models in business and finance-and teaching others to do the same-The Handbook of Financial Modeling takes readers step by step through the financial modeling process, starting with a general overview of the history and evolution of financial modeling. It then moves on to more technical topics, such as the principles of financial modeling and the proper way to approach a financial modeling assignment, before covering key application areas for modeling in Microsoft Excel. Designed for intermediate and advanced modelers who wish to expand and enhance their knowledge, The Handbook of Financial Modeling also covers: The accounting and finance concepts that underpin working financial models; How to approach financial issues and solutions from a modeler's perspective; The importance of thinking about end users when developing a financial model; How to plan, design, and build a fully functional financial model; And more. A nuts-to-bolts guide to solving common financial problems with spreadsheets, The Handbook of Financial Modeling is a one-stop resource for anyone who needs to build or analyze financial models
1. Schlagwortkette
Finanzplanung
ANZEIGE DER KETTE
Finanzplanung
SWB-Titel-Idn
399525688
Signatur
Springer E-Book
Bemerkungen
Elektronischer Volltext - Campuslizenz
Elektronische Adresse
$uhttp://dx.doi.org/10.1007/978-1-4302-6206-0
Internetseite / Link
Volltext
Siehe auch
Volltext
Siehe auch
Cover
.
ISBD-Anzeige
Katalogdatensatz500198037
.
Kategorien-Anzeige
Katalogdatensatz500198037
.
Verwandte Werke
Katalogdatensatz500198037
.
Titel zur Titelsammlung hinzufügen
Katalogdatensatz500198037
.
Kataloginformation500198037
Datensatzanfang
.
Kataloginformation500198037
Seitenanfang
.
Titel vormerken
Katalogdatensatz500198037
Vollanzeige Katalogdaten
Auf diesem Bildschirm erhalten Sie Katalog- und Exemplarinformationen zum ausgewählten Titel.
Im Bereich
Kataloginformation
werden die bibliographischen Details angezeigt. Per Klick auf Hyperlink-Begriffe wie Schlagwörter, Autoren, Reihen, Körperschaften und Klassifikationen können Sie sich weitere Titel des gewählten Begriffes anzeigen lassen.
Der Bereich
Exemplarinformationen
enthält zum einen Angaben über den Standort und die Verfügbarkeit der Exemplare. Zum anderen haben Sie die Möglichkeit, ausgeliehene Exemplare vorzumerken oder Exemplare aus dem Magazin zu bestellen.
Schnellsuche
Suche nach