1st Edition
Financial Modelling and Asset Valuation with Excel
448 Pages
329 B/W Illustrations
by
Routledge
446 Pages
329 B/W Illustrations
by
Routledge
448 Pages
329 B/W Illustrations
by
Routledge
Also available as eBook on:
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... Read more
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
Biography
Morten Helbæk is Associate Professor at North-Trøndelag University College, Norway.
Ragnar Løvaas is Research and Development Engineer at Nortroll AS, Norway
Jon Olav Mjølhus is Senior Lecturer at Buskerud University College, Norway
