Financial Modelling and Asset Valuation with Excel

Author:   Morten Helbæk (North-Trøndelag University College, Norway) ,  Ragnar Løvaas ,  Jon Olav Mjølhus
Publisher:   Taylor & Francis Ltd
ISBN:  

9780415630580


Pages:   432
Publication Date:   07 June 2013
Format:   Paperback
Availability:   In Print   Availability explained
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Our Price $183.00 Quantity:  
Add to Cart

Share |

Financial Modelling and Asset Valuation with Excel


Add your own review!

Overview

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.

Full Product Details

Author:   Morten Helbæk (North-Trøndelag University College, Norway) ,  Ragnar Løvaas ,  Jon Olav Mjølhus
Publisher:   Taylor & Francis Ltd
Imprint:   Routledge
Dimensions:   Width: 17.40cm , Height: 2.50cm , Length: 24.60cm
Weight:   0.748kg
ISBN:  

9780415630580


ISBN 10:   0415630584
Pages:   432
Publication Date:   07 June 2013
Audience:   College/higher education ,  Undergraduate ,  Postgraduate, Research & Scholarly
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print   Availability explained
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

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

Reviews

Author Information

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

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

MRG2025CC

 

Shopping Cart
Your cart is empty
Shopping cart
Mailing List