Financial Modelling and Asset Valuation with Excel

Front Cover

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.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Whatifanalysis
3-4
PART II
3-32
Investments
6-10
Risk and portfolio models
7-16
PART III
8-38
Real estate
9-27
Bonds
10-21
Stocks
12-6
Options
13-13
PART IV
13-21
Copyright

Other editions - View all

Common terms and phrases

About the author (2013)

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

Bibliographic information