Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Building financial models with Microsoft Excel [[electronic resource] ] : a guide for business professionals / / K. Scott Proctor
| Building financial models with Microsoft Excel [[electronic resource] ] : a guide for business professionals / / K. Scott Proctor |
| Autore | Proctor K. Scott |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley, c2004 |
| Descrizione fisica | 1 online resource (369 p.) |
| Disciplina | 658.15/0285/554 |
| Collana | Wiley Finance |
| Soggetto topico | Corporations - Finance - Computer programs |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-280-26532-9
9786610265329 0-471-69320-0 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 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. |
| Record Nr. | UNINA-9910449821403321 |
Proctor K. Scott
|
||
| Hoboken, NJ, : Wiley, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Building financial models with Microsoft Excel [[electronic resource] ] : a guide for business professionals / / K. Scott Proctor
| Building financial models with Microsoft Excel [[electronic resource] ] : a guide for business professionals / / K. Scott Proctor |
| Autore | Proctor K. Scott |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley, c2004 |
| Descrizione fisica | 1 online resource (369 p.) |
| Disciplina | 658.15/0285/554 |
| Collana | Wiley Finance |
| Soggetto topico | Corporations - Finance - Computer programs |
| ISBN |
1-280-26532-9
9786610265329 0-471-69320-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 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. |
| Record Nr. | UNINA-9910783448603321 |
|
Proctor K. Scott
|
||
| Hoboken, NJ, : Wiley, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Building financial models with Microsoft Excel : a guide for business professionals / / K. Scott Proctor
| Building financial models with Microsoft Excel : a guide for business professionals / / K. Scott Proctor |
| Autore | Proctor K. Scott |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley, c2004 |
| Descrizione fisica | 1 online resource (369 p.) |
| Disciplina | 658.15/0285/554 |
| Collana | Wiley Finance |
| Soggetto topico | Corporations - Finance - Computer programs |
| ISBN |
1-280-26532-9
9786610265329 0-471-69320-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 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. |
| Record Nr. | UNINA-9910817073203321 |
|
Proctor K. Scott
|
||
| Hoboken, NJ, : Wiley, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Using Excel for business analysis : a guide to financial modelling fundamentals / / Danielle Stein Fairhurst
| Using Excel for business analysis : a guide to financial modelling fundamentals / / Danielle Stein Fairhurst |
| Autore | Fairhurst Danielle Stein |
| Edizione | [Revised edition.] |
| Pubbl/distr/stampa | Singapore : , : Wiley, , [2015] |
| Descrizione fisica | 1 online resource (443 p.) |
| Collana | Wiley finance series |
| Soggetto topico |
Corporations - Finance
Corporations - Finance - Computer programs Societats Finances |
| Soggetto genere / forma | Llibres electrònics |
| ISBN |
1-119-07001-5
1-119-06245-4 1-119-06244-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910131250803321 |
|
Fairhurst Danielle Stein
|
||
| Singapore : , : Wiley, , [2015] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Using Excel for business analysis : a guide to financial modelling fundamentals / / Danielle Stein Fairhurst
| Using Excel for business analysis : a guide to financial modelling fundamentals / / Danielle Stein Fairhurst |
| Autore | Fairhurst Danielle Stein |
| Edizione | [Revised edition.] |
| Pubbl/distr/stampa | Singapore : , : Wiley, , [2015] |
| Descrizione fisica | 1 online resource (443 p.) |
| Collana | Wiley finance series |
| Soggetto topico |
Corporations - Finance
Corporations - Finance - Computer programs Societats Finances |
| Soggetto genere / forma | Llibres electrònics |
| ISBN |
1-119-07001-5
1-119-06245-4 1-119-06244-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910819970403321 |
|
Fairhurst Danielle Stein
|
||
| Singapore : , : Wiley, , [2015] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Using Excel for business analysis : a guide to financial modelling fundamentals / / Danielle Stein Fairhurst
| Using Excel for business analysis : a guide to financial modelling fundamentals / / Danielle Stein Fairhurst |
| Autore | Fairhurst Danielle Stein |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Singapore : , : John Wiley & Sons Singapore Pte. Ltd., , 2012 |
| Descrizione fisica | 1 online resource (338 p.) |
| Disciplina | 658.150285554 |
| Collana | Wiley Finance |
| Soggetto topico |
Corporations - Finance
Corporations - Finance - Computer programs |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-119-19923-9
1-280-99530-0 9786613766915 1-118-13285-8 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals; Contents; Preface; Chapter 1: What Is Financial Modelling?; What's the Difference between a Spreadsheet and a Financial Model?; Types and Purposes of Financial Models; Tool Selection; Is Excel Really the Best Option?; Evaluating Modelling Tools; Budgeting and Forecasting; Microsoft Office Tools: Excel, Access, and Project; The Final Decision; What Skills Do You Need to Be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge
Aesthetic Design SkillsCommunication and Language Skills; Numeracy Skills; Ability to Think Logically; The Ideal Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Do You Really Need an Advanced Excel Course?; Summary; Chapter 2: Building a Model; Model Design; Practical Example 1-Assumptions Layout; Practical Example 2-Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, Where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above Use Multiple WorksheetsInclude Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues; Project Planning Your Model; How Long Does It Take to Build a Financial Model?; Building a Model under Pressure; Model Layout Flow Charting; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3: Best Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hard Coding; Only Enter Data Once; Avoid Bad Habits; Use Consistent Formulas Format and Label ClearlyMethods and Tools of Assumptions Documentation; In-Cell Comments; Footnoting; Hyperlinks; Hard-Coded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4: Financial Modelling Techniques; The Problem with Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; Avoiding Logic Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links Dealing with Links and the Potential Errors They Can CauseLinking Do's and Don'ts; Building Error Checks; Error Check Exercise; Allowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5: Using Excel in Financial Modelling; Formulas and Functions in Excel; Excel Versions; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Basic Excel Functions; SUM(); MAX(); MIN(); COUNT(); AVERAGE(); Combining Basic Functions Logical Functions |
| Record Nr. | UNINA-9910141441603321 |
|
Fairhurst Danielle Stein
|
||
| Singapore : , : John Wiley & Sons Singapore Pte. Ltd., , 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Using Excel for business analysis : a guide to financial modelling fundamentals / / Danielle Stein Fairhurst
| Using Excel for business analysis : a guide to financial modelling fundamentals / / Danielle Stein Fairhurst |
| Autore | Fairhurst Danielle Stein |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Singapore : , : John Wiley & Sons Singapore Pte. Ltd., , 2012 |
| Descrizione fisica | 1 online resource (338 p.) |
| Disciplina | 658.150285554 |
| Collana | Wiley Finance |
| Soggetto topico |
Corporations - Finance
Corporations - Finance - Computer programs |
| ISBN |
1-119-19923-9
1-280-99530-0 9786613766915 1-118-13285-8 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals; Contents; Preface; Chapter 1: What Is Financial Modelling?; What's the Difference between a Spreadsheet and a Financial Model?; Types and Purposes of Financial Models; Tool Selection; Is Excel Really the Best Option?; Evaluating Modelling Tools; Budgeting and Forecasting; Microsoft Office Tools: Excel, Access, and Project; The Final Decision; What Skills Do You Need to Be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge
Aesthetic Design SkillsCommunication and Language Skills; Numeracy Skills; Ability to Think Logically; The Ideal Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Do You Really Need an Advanced Excel Course?; Summary; Chapter 2: Building a Model; Model Design; Practical Example 1-Assumptions Layout; Practical Example 2-Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, Where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above Use Multiple WorksheetsInclude Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues; Project Planning Your Model; How Long Does It Take to Build a Financial Model?; Building a Model under Pressure; Model Layout Flow Charting; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3: Best Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hard Coding; Only Enter Data Once; Avoid Bad Habits; Use Consistent Formulas Format and Label ClearlyMethods and Tools of Assumptions Documentation; In-Cell Comments; Footnoting; Hyperlinks; Hard-Coded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4: Financial Modelling Techniques; The Problem with Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; Avoiding Logic Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links Dealing with Links and the Potential Errors They Can CauseLinking Do's and Don'ts; Building Error Checks; Error Check Exercise; Allowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5: Using Excel in Financial Modelling; Formulas and Functions in Excel; Excel Versions; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Basic Excel Functions; SUM(); MAX(); MIN(); COUNT(); AVERAGE(); Combining Basic Functions Logical Functions |
| Record Nr. | UNINA-9910830163603321 |
|
Fairhurst Danielle Stein
|
||
| Singapore : , : John Wiley & Sons Singapore Pte. Ltd., , 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Using Excel for business and financial modelling : a practical guide / / Danielle Stein Fairhurst
| Using Excel for business and financial modelling : a practical guide / / Danielle Stein Fairhurst |
| Autore | Fairhurst Danielle Stein |
| Edizione | [Third edition.] |
| Pubbl/distr/stampa | Chichester, West Sussex : , : Wiley, , 2019 |
| Descrizione fisica | 1 online resource (426 pages) |
| Disciplina | 332.0285/554 |
| Collana | Wiley finance |
| Soggetto topico |
Corporations - Finance
Corporations - Finance - Computer programs BUSINESS & ECONOMICS / Finance |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-119-52035-5
1-119-52034-7 1-119-52037-1 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Machine generated contents note: Chapter 1: What is Financial Modelling? What's the Difference Between a Spreadsheet and a Financial Model? Types and Purposes of Financial Models Tool Selection What Skills Do You Need to Be a Good Financial Modeller? The "Ideal" Financial Modeller Summary Chapter 2: Building a Model Model Design The Golden Rules for Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only Once Avoid Bad Habits Use Consistent Formulas Format and Label Clearly Methods and Tools of Assumptions Documentation Linked Dynamic Text Assumptions Documentation What Makes a Good Model? Summary Chapter 4: Financial Modelling Techniques The Problem with Excel Error Avoidance Strategies How Long Should a Formula Be? Linking to External Files Building Error Checks Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table Summary Chapter 12: Presenting Model Output Preparing an Oral Presentation for Model Results Preparing a Graphic or Written Presentation for Model Results Chart Types Working with Charts Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index. |
| Record Nr. | UNINA-9910467063403321 |
|
Fairhurst Danielle Stein
|
||
| Chichester, West Sussex : , : Wiley, , 2019 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Using Excel for business and financial modelling : a practical guide / / Danielle Stein Fairhurst
| Using Excel for business and financial modelling : a practical guide / / Danielle Stein Fairhurst |
| Autore | Fairhurst Danielle Stein |
| Edizione | [Third edition.] |
| Pubbl/distr/stampa | Chichester, West Sussex : , : Wiley, , 2019 |
| Descrizione fisica | 1 online resource (426 pages) |
| Disciplina | 332.0285/554 |
| Collana |
Wiley finance
THEi Wiley ebooks. |
| Soggetto topico |
Corporations - Finance
Corporations - Finance - Computer programs BUSINESS & ECONOMICS / Finance |
| ISBN |
1-119-52035-5
1-119-52034-7 1-119-52037-1 |
| Classificazione | BUS027000 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Machine generated contents note: Chapter 1: What is Financial Modelling? What's the Difference Between a Spreadsheet and a Financial Model? Types and Purposes of Financial Models Tool Selection What Skills Do You Need to Be a Good Financial Modeller? The "Ideal" Financial Modeller Summary Chapter 2: Building a Model Model Design The Golden Rules for Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only Once Avoid Bad Habits Use Consistent Formulas Format and Label Clearly Methods and Tools of Assumptions Documentation Linked Dynamic Text Assumptions Documentation What Makes a Good Model? Summary Chapter 4: Financial Modelling Techniques The Problem with Excel Error Avoidance Strategies How Long Should a Formula Be? Linking to External Files Building Error Checks Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table Summary Chapter 12: Presenting Model Output Preparing an Oral Presentation for Model Results Preparing a Graphic or Written Presentation for Model Results Chart Types Working with Charts Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index. |
| Record Nr. | UNINA-9910532298403321 |
|
Fairhurst Danielle Stein
|
||
| Chichester, West Sussex : , : Wiley, , 2019 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Using Excel for business and financial modelling : a practical guide / / Danielle Stein Fairhurst
| Using Excel for business and financial modelling : a practical guide / / Danielle Stein Fairhurst |
| Autore | Fairhurst Danielle Stein |
| Edizione | [Third edition.] |
| Pubbl/distr/stampa | Chichester, West Sussex : , : Wiley, , 2019 |
| Descrizione fisica | 1 online resource (426 pages) |
| Disciplina | 332.0285/554 |
| Collana |
Wiley finance
THEi Wiley ebooks. |
| Soggetto topico |
Corporations - Finance
Corporations - Finance - Computer programs BUSINESS & ECONOMICS / Finance |
| ISBN |
1-119-52035-5
1-119-52034-7 1-119-52037-1 |
| Classificazione | BUS027000 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Machine generated contents note: Chapter 1: What is Financial Modelling? What's the Difference Between a Spreadsheet and a Financial Model? Types and Purposes of Financial Models Tool Selection What Skills Do You Need to Be a Good Financial Modeller? The "Ideal" Financial Modeller Summary Chapter 2: Building a Model Model Design The Golden Rules for Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only Once Avoid Bad Habits Use Consistent Formulas Format and Label Clearly Methods and Tools of Assumptions Documentation Linked Dynamic Text Assumptions Documentation What Makes a Good Model? Summary Chapter 4: Financial Modelling Techniques The Problem with Excel Error Avoidance Strategies How Long Should a Formula Be? Linking to External Files Building Error Checks Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table Summary Chapter 12: Presenting Model Output Preparing an Oral Presentation for Model Results Preparing a Graphic or Written Presentation for Model Results Chart Types Working with Charts Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index. |
| Record Nr. | UNINA-9910813852303321 |
|
Fairhurst Danielle Stein
|
||
| Chichester, West Sussex : , : Wiley, , 2019 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
