Financial Modeling with Excel and over 2 million other books are available for Amazon Kindle . Learn more


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading Financial Modeling with Excel on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Financial Modelling and Asset Valuation with Excel [Hardcover]

Morten Helbæk , Ragnar Løvaas , Jon Olav Mjølhus
4.0 out of 5 stars  See all reviews (2 customer reviews)
RRP: £120.00
Price: £112.46 & FREE Delivery in the UK. Details
You Save: £7.54 (6%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 25 Oct.? Choose Express delivery at checkout. Details

Formats

Amazon Price New from Used from
Kindle Edition £30.88  
Hardcover £112.46  
Paperback £35.25  

Book Description

7 Jun 2013 0415625963 978-0415625968

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.


Special Offers and Product Promotions

  • Between 20-26 October 2014, spend £10 in a single order on item(s) dispatched from and sold by Amazon.co.uk and receive a £2 promotional code to spend in the Amazon Appstore. Here's how (terms and conditions apply)


Product details

  • Hardcover: 448 pages
  • Publisher: Routledge (7 Jun 2013)
  • Language: English
  • ISBN-10: 0415625963
  • ISBN-13: 978-0415625968
  • Product Dimensions: 25 x 17 x 3 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

About the Author

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


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:


Customer Reviews

5 star
0
3 star
0
2 star
0
1 star
0
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
4.0 out of 5 stars Fills a gap 8 May 2014
Format:Paperback
Many standard finance books are aimed at an academic audience, and there is of course nothing is wrong with that. But such books may not be all that useful in practical applications. Worse, some texts are pretty technical and tempting to be shelved under the label "will-read-when-have-more-time."
The same can be said about the thick-as-a-brick excel/VBA "bibles" (of which I have quite a few laying about the attic).
Finance practioneers, often looking to build financial spreadsheet models, in my experience don't have all that much material to choose from, at least not in one volume.
This book is one of the more practical of the lot, combining basic finance theory with excel/VBA; a strong command of which is an absolute must for finance and economics practioneers. This text is just on the money in this respect.

The book is more a reference book rather than a text book. The finance content is for the most part basic and introductory (and hence easy to understand -and perhaps even applicable for home use?) Professionals and advanced students who thirst for more "rigour" must look elsewhere. Nevertheless, practical excel application of advanced topics such as the Black-Scholes option model or Monte Carlo simulation is likely to enhance understanding and may also serve as building blocks for further development, armed with new-found excel insights. I recommend this book.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
By sw
Format:Paperback|Verified Purchase
I've just finished working through the entire book and all the examples and questions.

I've done the CFA, so all of the concepts presented in the book were already familiar to me. However, I've not worked in all asset classes, so the book provided a very interest bridge between theory and putting the theory to practice. Okay... not all the way to the point of you being in an investment firm, but close. Rather than list all topics covered (which would just repeat the table of contents) let me just say which areas of the book were highlights:

1) The section on risk and portfolio optimisation was good. It builds you to the point of determining a market portfolio from a basket of stocks and charting the market portfolio.

(There is a brief bit of material on VAR. As a value investor I think it interesting to see the theory applied, even if you think it a dangerous concept. At least you can see what others are doing) - Sorry, I digress

2) There is a particularly good section on binomial and Black-Scholes option valuation with lots of worked examples and problems. This was really worthwhile as the theory I had learned left me far away from assessing some put options I have been thinking of buying recently. I now had the toolkit to assess the prices offered in the market and to act. There is a good initial discussion on concepts like the time value of an option, but the analysis stops short of a full analysis of the the 'greeks".

3) There is a good starting guide to programming in VBA. Again, examples are there which help to build you up to a level where you can start to put concepts to practice.

4) The bond section was fairly good too.
Read more ›
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 5.0 out of 5 stars  1 review
5.0 out of 5 stars Five Stars 6 July 2014
By Richard Soat - Published on Amazon.com
Format:Paperback|Verified Purchase
5
Was this review helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback