The Essentials of Financial Modeling in Excel: A Concise Guide to Concepts and Methods 1st Edition

The Essentials of Financial Modeling in Excel: A Concise Guide to Concepts and Methods 1st Edition- Ebook Instant Download/Delivery ISBN(s): 9781394157785,1394157789,9781394157808, 1394157800

Product details:

• ISBN 10: 1394157800
• ISBN 13:9781394157808
• Author: Michael Rees

In The Essentials of Financial Modeling in Excel: A Concise Guide to Concepts and Methods, veteran quantitative modeling and business analysis expert Dr. Michael Rees delivers a practical and hands-on introduction to financial modeling in Excel. The author offers readers a well-structured and strategic toolkit to learn modeling from scratch, focusing on the core economic concepts and the structures commonly required within Excel models.

Divided into six parts, the book discusses the use of models and the factors to consider when designing and building models so that they can be as powerful as possible, yet simple

Table contents:

1 Modeling and Its Uses

2 Principles of Model Design

3 Menus, Operations, Functions, and Features

4 Sensitivity and Scenario Analysis

5 Growth Calculations for Forecasting

6 Modular Structures and Summary Reports

7 Scaling and Ratio‐driven Forecasts

8 Corkscrews and Reverse Corkscrews

9 Waterfall Allocations

10 Interpolations and Allocations

11 Breakeven and Payback Analysis

12 Interest Rates and Compounding

13 Loan Repayment Calculations

14 Discounting, Present Values, and Annuities

15 Returns and Internal Rate of Return

16 The Cost of Capital

17 Financial Statement Modeling

18 Corporate Valuation Modeling

19 Ratio Analysis

20 Statistical Analysis and Measures

21 Data Preparation: Sourcing, Manipulation, and Integration

People also search:

the essentials of financial analysis samuel weaver pdf

basic financial modeling in excel

financial modeling in excel pdf

objectives of financial modelling

the essentials of finance and accounting for nonfinancial managers