TY  - BOOK
AU  - Helbaek, Morten
AU  - Lovaas, Ragnar
AU  - Mjolhus, Jon Olav
TI  - Financial modelling and asset valuation with Excel
SN  - 9781138948143
U1  - 332.0285554 
PY  - 2022///
CY  - Oxon
PB  - Routledge
KW  - Finance--Mathematical models--Computer programs
KW  - Microsoft Excel (Computer file)
KW  - Capital assets pricing model
KW  - Hedging (Finance)
N1  - Table of Contents
Part I: Excel  1. Getting Started  2. Formulas and Functions  3. Charts and Tables  4. What-If Analysis  5. Data Analysis  Part II: Basic Finance  6. Time Value of Money  7. Investments  8. Risk and Portfolio Models  Part III: Valuation  9. Valuation of investments and projects  10. Real Estate  11. Bonds  12. Stocks  13. Options  Part IV: Simulations  14. Monte Carlo Simulations  Part V: VBA  15. Visual Basic for Applications  16. Programming in VBA  17. Control Structures  18. Working with VBA  19. Procedures  20. Arrays  21. UserForms
N2  - Book Description
Finance is Excel! This book takes you straight into the fascinating world of Excel, the powerful tool for number crunching. In a clear cut language it amalgamates financial theory with Excel providing you with the skills you need to build financial models for private or professional use. A comprehensive knowledge of modeling in Excel is becoming increasingly important in a competitive labour market.

The chapters in part one start with the most basic Excel topics such as cell addresses, workbooks, basic formulas, etc. These chapters get more advanced through part one, and takes you in the end to topics such as array formulas, data tables, pivot tables, etc.  The other parts of the book discusses a variety of subjects such as net present value, internal rate of return, risk, portfolio theory, CAPM, VaR, project valuation, asset valuation, firm valuation, loan, leasing, stocks, bonds, options, simulation, sensitivity analysis, etc
ER  -