
Financial Modeling in Excel For Dummies
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
Interested in learning how to build practical financial models and forecasts but concerned that you don't have the math skills or technical know-how? We've got you covered! Financial decision-making has never been easier than with Financial Modeling in Excel For Dummies. Whether you work at a mom-and-pop retail store or a multinational corporation, you can learn how to build budgets, project your profits into the future, model capital depreciation, value your assets, and more.
You'll learn by doing as this book walks you through practical, hands-on exercises to help you build powerful models using just a regular version of Excel, which you've probably already got on your PC. You'll also:
* Master the tools and strategies that help you draw insights from numbers and data you've already got
* Build a successful financial model from scratch, or work with and modify an existing one to your liking
* Create new and unexpected business strategies with the ideas and conclusions you generate with scenario analysis
Don't go buying specialized software or hiring that expensive consultant when you don't need either one. If you've got this book and a working version of Microsoft Excel, you've got all the tools you need to build sophisticated and useful financial models in no time!
More details
Other editions
Additional editions

Person
Content
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
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.