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
- Writing Formulas
- Copying/Cutting And Pasting Formulae
- Paste Special
- Inserting Functions
- Tracing Cell References & Debugging Formula Errors
- Loan Repayments
- Discount Cash Flows
- Securities Functions
- Functions For Basic Statistics
- Other Mathematics & Statistics Functions
- Logical & Information Functions
- SmartNested Functions That Respond To Formula Result
- Add-Ins: Enhancing Excel
- The SOLVER Tool For Constrained Linear Optimization
- If-ThenAnalysis: Scenarios And Goal Seek
Possibly Related Softwares
Financial Statement Analysis Scorecard for Excel
Measure Financial performance with Financial Statement Analysis Scorecard fo...
Sale Price:iDecide: Personal Edition
Analyse risks and make better decisions using Monte Carlo simulation. Stand-alone app that includes drag-n-drop interface, tons of examples and 'What-If' analysis. Produces lots of graphs and charts to help understand the results. While no...
Sale Price:Financial Excel All Programs Edition
Our Financial Excel All Programs Edition provides 150 business finance spreadsheets which will help you manage financial assets, analyze investments, control cash flows, set up budgets and model financial statements and forecasts quickly an...
Sale Price:







