Financial Modeling in Excel For Dummies
Financial Modeling in Excel For Dummies
Fairhurst, Danielle Stein
John Wiley & Sons Inc
03/2022
352
Mole
Inglês
9781119844518
15 a 20 dias
442
Part 1: Getting Started with Financial Modeling 5
Chapter 1: Introducing Financial Modeling 7
Chapter 2: Getting Acquainted with Excel 15
Chapter 3: Planning and Designing Your Financial Model 35
Chapter 4: Building a Financial Model by the Rulebook 53
Chapter 5: Using Someone Else's Financial Model 71
Part 2: Diving Deep into Excel 97
Chapter 6: Excel Tools and Techniques for Financial Modeling 99
Chapter 7: Using Functions in Excel 131
Chapter 8: Applying Scenarios to Your Financial Model 173
Chapter 9: Charting and Presenting Model Output 195
Part 3: Building Your Financial Model 227
Chapter 10: Building an Integrated Financial Statements Model 229
Chapter 11: Building a Discounted Cash Flow Valuation 263
Chapter 12: Budgeting for Capital Expenditure and Depreciation 273
Part 4: The Part of Tens 291
Chapter 13: Ten Strategies for Reducing Error 293
Chapter 14: Ten Common Pitfalls to Avoid 303
Index 315
Part 1: Getting Started with Financial Modeling 5
Chapter 1: Introducing Financial Modeling 7
Chapter 2: Getting Acquainted with Excel 15
Chapter 3: Planning and Designing Your Financial Model 35
Chapter 4: Building a Financial Model by the Rulebook 53
Chapter 5: Using Someone Else's Financial Model 71
Part 2: Diving Deep into Excel 97
Chapter 6: Excel Tools and Techniques for Financial Modeling 99
Chapter 7: Using Functions in Excel 131
Chapter 8: Applying Scenarios to Your Financial Model 173
Chapter 9: Charting and Presenting Model Output 195
Part 3: Building Your Financial Model 227
Chapter 10: Building an Integrated Financial Statements Model 229
Chapter 11: Building a Discounted Cash Flow Valuation 263
Chapter 12: Budgeting for Capital Expenditure and Depreciation 273
Part 4: The Part of Tens 291
Chapter 13: Ten Strategies for Reducing Error 293
Chapter 14: Ten Common Pitfalls to Avoid 303
Index 315