Muutke küpsiste eelistusi

Financial Modeling in Excel For Dummies 2nd edition [Pehme köide]

3.79/5 (44 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 352 pages, kõrgus x laius x paksus: 231x185x25 mm, kaal: 476 g
  • Ilmumisaeg: 21-Mar-2022
  • Kirjastus: For Dummies
  • ISBN-10: 1119844517
  • ISBN-13: 9781119844518
Teised raamatud teemal:
  • Pehme köide
  • Hind: 37,94 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 44,64 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Financial Modeling in Excel For Dummies 2nd editionSuurem pilt
  • Formaat: Paperback / softback, 352 pages, kõrgus x laius x paksus: 231x185x25 mm, kaal: 476 g
  • Ilmumisaeg: 21-Mar-2022
  • Kirjastus: For Dummies
  • ISBN-10: 1119844517
  • ISBN-13: 9781119844518
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781119844518.html
Märksõnad:

Turn your financial data into insightful decisions with this straightforward guide to financial modeling with Excel 

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! 

Introduction 1(4)
About This Book
1(1)
Foolish Assumptions
2(1)
Icons Used in This Book
2(1)
Beyond the Book
3(1)
Where to Go from Here
3(2)
PART 1 GETTING STARTED WITH FINANCIAL MODELING
5(92)
Chapter 1 Introducing Financial Modeling
7(8)
Defining Financial Modeling
7(1)
What it is
8(1)
Who uses it
9(1)
Why it matters
10(1)
Looking at Examples of Financial Models
10(1)
Project finance models
11(1)
Pricing models
12(1)
Integrated financial statement models
12(1)
Valuation models
12(1)
Reporting models
13(2)
Chapter 2 Getting Acquainted with Excel
15(20)
Making Sense of the Different Versions of Excel
15(1)
A rundown of recent Excel versions
16(7)
Focusing on file formats
23(1)
Defining Modern Excel
23(2)
Recognizing the Dangers of Using Excel
25(1)
Capacity
26(1)
Lack of discipline
27(1)
Errors
28(3)
Looking at Alternatives and Supplements to Excel
31(4)
Chapter 3 Planning and Designing Your Financial Model
35(18)
Identifying the Problem That Your Financial Model Needs to Solve
35(4)
Designing How the Problem's Answer Will Look
39(6)
Gathering Data to Put in Your Model
45(1)
Documenting the Limitations of Your Model
46(1)
Considering the Layout and Design of Your Model
47(2)
Structuring your model: What goes where
49(1)
Defining inputs, calculations, and output blocks
50(1)
Determining your audience
51(2)
Chapter 4 Building a Financial Model by the Rulebook
53(18)
Document Your Assumptions
53(6)
Create Dynamic Formulas Using Links
59(2)
Only Enter Data Once
61(1)
Model with Consistent Formulas
62(2)
Build in Error Checks
64(2)
Allowing tolerance for error
66(1)
Applying conditional formatting to an error check
67(1)
Format and Label for Clarity
68(3)
Chapter 5 Using Someone Else's Financial Model
71(26)
Considering Templates for Building a Financial Model
72(1)
Why templates can be appealing
72(1)
What's wrong with using templates
72(2)
Why you should build your own model
74(1)
Inheriting a File: What to Check For
75(1)
Meeting a model for the first time
76(1)
Inspecting the workbook
77(7)
Using Audit Tools to Find and Correct Errors
84(1)
Checking a model for accuracy
85(3)
Making sense of the formulas
88(7)
Sharing and Version Control
95(2)
PART 2 DIVING DEEP INTO EXCEL
97(130)
Chapter 6 Excel Tools and Techniques for Financial Modeling
99(32)
Referencing Cells
100(1)
Relative cell referencing
101(2)
Absolute cell referencing
103(3)
Mixed cell referencing
106(3)
Naming Ranges
109(1)
Understanding why you may want to use a named range
109(1)
Creating a named range
110(1)
Finding and using named ranges
111(2)
Editing or deleting a named range
113(1)
Dynamic Ranges
113(1)
Linking in Excel
114(1)
Internal links
115(2)
External links
117(3)
Using Shortcuts
120(3)
Restricting and Validating Data
123(1)
Restricting user data entry
124(1)
Creating drop-down boxes with data validations
125(1)
Protecting and locking cells
126(1)
Goal Seeking
127(1)
Limiting project costs with a goal seek
128(1)
Calculating a break-even point with a goal seek
129(2)
Chapter 7 Using Functions in Excel
131(42)
Identifying the Difference between a Formula and a Function
131(1)
Finding the Function You Need
132(1)
Getting Familiar with the Most Important Functions
133(1)
Sum
134(1)
Max and Min
135(4)
Average
139(1)
Count and Counta
140(6)
Round, Roundup, and Rounddown
146(7)
If
153(3)
Countif and Sumif
156(2)
Reporting sales with SUMIF
158(3)
Vlookup, Hlookup, and Xlookup
161(9)
Being Aware of Advanced Functions and Functionality
170(3)
Chapter 8 Applying Scenarios to Your Financial Model
173(22)
Identifying the Differences among Types of Analysis
174(1)
Building Drop-Down Scenarios
175(1)
Using data validations to model profitability scenarios
175(3)
Applying formulas to scenarios
178(3)
Applying Sensitivity Analysis with Data Tables
181(1)
Setting up the calculation
181(1)
Building a data table with one input
182(2)
Building a data table with two inputs
184(2)
Applying probability weightings to your data table
186(3)
Using Scenario Manager to Model Loan Calculations
189(1)
Setting up the model
189(2)
Applying Scenario Manager
191(4)
Chapter 9 Charting and Presenting Model Output
195(32)
Deciding Which Data to Display
196(2)
Conveying Your Message by Charting Scenarios
198(2)
Deciding Which Type of Chart to Use
200(1)
Line charts
201(5)
Bar charts
206(3)
Combo charts
209(2)
Pie charts
211(3)
Charts in newer versions of Excel
214(5)
Dynamic Charting
219(1)
Building the chart on formula-driven data
219(1)
Linking the chart titles to formulas
220(1)
Creating dynamic text
221(4)
Preparing a Presentation
225(2)
PART 3 BUILDING YOUR FINANCIAL MODEL
227(64)
Chapter 10 Building an Integrated Financial Statements Model
229(34)
Getting to Know the Case Study
230(1)
Entering Assumptions
231(1)
Revenue assumptions
232(1)
Expense assumptions
233(1)
Other assumptions
234(1)
Calculating Revenue
234(1)
Projecting sales volume
235(2)
Projecting dollar sales
237(1)
Calculating Expenses
238(1)
Staff costs
238(1)
Other costs
239(1)
Depreciation and amortization
240(3)
Building the Income Statement
243(5)
Building the Cash Flow Statement
248(4)
Building the Balance Sheet
252(6)
Building Scenarios
258(1)
Entering your scenario assumptions
258(1)
Building a drop-down box
259(1)
Building the scenario functionality
260(3)
Chapter 11 Building a Discounted Cash Flow Valuation
263(10)
Understanding How the Discounted Cash Flow Valuation Works
264(1)
Step 1 Calculating Free Cash Flow to Firm
265(3)
Step 2 Calculating Weighted Average Cost of Capital
268(1)
Step 3 Finding the Terminal Value
269(1)
Discounting Cash Flows and Valuation
270(3)
Chapter 12 Budgeting for Capital Expenditure and Depreciation
273(18)
Getting Started
274(1)
Making a reusable budget model template
274(3)
Creating dynamic titles
277(1)
Output 1 Calculating Cash Required for Budgeted Asset Purchases
277(5)
Output 2 Calculating Budgeted Depreciation
282(1)
Useful life
283(1)
Written-down date
284(1)
The depreciation schedule for the current year
285(2)
Depreciation in prior periods
287(1)
Output 3 Calculating the Written-Down Value of Assets for the Balance Sheet
288(3)
PART 4 THE PART OF TENS
291(24)
Chapter 13 Ten Strategies for Reducing Error
293(10)
Using the Enter Key
293(1)
Checking Your Work
294(1)
Checking It Again
295(1)
Getting Someone Else to Check Your Work
296(1)
Documenting Assumptions
297(1)
Documenting Methodology with a Flowchart
297(1)
Stress-Testing with Sensitivity Analysis
298(1)
Conducting a Scenario Analysis
299(1)
Taking Note of Excel Error Values
300(2)
Including Error Checks
302(1)
Chapter 14 Ten Common Pitfalls to Avoid
303(12)
The Numbers Don't Add Up
303(1)
You're Getting #REF! Errors
304(1)
You Have Circular References
304(3)
The Model Has Too Much Detail
307(1)
The File Size Is Out of Control
307(2)
Your Model Is Full of "Spaghetti" Links
309(2)
The Formulas Are Unnecessarily Long and Complicated
311(1)
No One Is Paying Attention to the Model
312(1)
You Don't Want to Let Go
313(1)
Someone Messes Up Your Model
313(2)
Index 315
Danielle Stein Fairhurstis a Sydney-based financial modeling consultant who helps her clients create meaningful financial models for business analysis. She is regularly engaged around Australia and globally as a speaker and course facilitator. She received the Microsoft MVP Award in 2021 in recognition of her technical expertise and contributions to the community.