Financial Analysis With Excel

Risk Analysts and Risk and Project Managers would obviously benefit from the chapters on creating "Risk Scenarios" and "Constrained Optimization." Depreciation functions and the differences between them are taught in detail-- something of use to all finance professionals. One chapter aims to quickly bring up-to-speed users who do not know about all the financial functions In Excel, especially the statistical, mathematical and other functions that are useful in financial analysis. (For example, Average, Permutations, etc.)

Contents
1 Writing Formulas
2 Copying/Cutting And Pasting Formulae
3 Paste Special
4 Inserting Functions
5 Tracing Cell References & Debugging Formula Errors
6 Loan Repayments
7 Discount Cash Flows
8 Securities Functions
9 Functions For Basic Statistics
10 Other Mathematics & Statistics Functions
11 Logical & Information Functions
12 ¡°Smart¡± Nested Functions That Respond To Formula Result
13 Add-Ins: Enhancing Excel
14 The SOLVER Tool For Constrained Linear Optimization
15 ¡°If-Then¡± Analysis: Scenarios And Goal Seek