Financial Modeling Books

5.22K viewsGeneral Discussion
0

Hi all,
I think building financial models is both an art and a tecnique; my job is a passion and I need to improve my skills ever and ever.

Is here anyone who can suggest me some books on Financial Modeling/Corporate Finance that he considered useful also
with Quantrix (and not only for Excel ;-)?

Regards

0

[color=black:1c2spwwr][font=Arial:1c2spwwr]Guide to Business Modelling, Second Edition (Economist Series)[/font:1c2spwwr][/color:1c2spwwr]
[color=black:1c2spwwr][font=Arial:1c2spwwr]John Tennent and Graham Friend[/font:1c2spwwr][/color:1c2spwwr]

[color=black:1c2spwwr][font=’Verdana’,’sans-serif’]The book is not expensive (Amazon $23.07) and it covers a lot of material including the modeling process. The examples are in Excel but are easy to convert into Quantrix formulas.[/font][/color:1c2spwwr]

0

Guide to Business Modelling, Second Edition (Economist Series)

By John Tennent and Graham Friend

The book is not expensive (Amazon $23.07) and it covers a lot of material including the modeling process. The examples are in Excel but are easy to convert into Quantrix formulas.

0

[quote="Chris Drost":1gp1dxth]Guide to Business Modelling, Second Edition (Economist Series)

By John Tennent and Graham Friend

The book is not expensive (Amazon $23.07) and it covers a lot of material including the modeling process. The examples are in Excel but are easy to convert into Quantrix formulas.[/quote:1gp1dxth]

Thanks Chris; I’ve read a lot of books, especially in italian, but it’s not enough for me. AI think I must begin to look at amazon for a more variety of books.

Regards
Carlo

0

Hi Carlo,

[quote="Carlo Capasso":49nui8dz]Hi all,
I think building financial models is both an art and a tecnique;
[/quote:49nui8dz]

This is certainly right – and for sure, only the technical aspects can be taught, I guess. The rest – the art – comes with practical experience.

[quote:49nui8dz]
Is here anyone who can suggest me some books on Financial Modeling/Corporate Finance that he considered useful also
with Quantrix (and not only for Excel ;-)?
[/quote:49nui8dz]

Well, having read the first part of your question I just intended to start quickly to provide you a list about books in english language which might be of great interest for you. There are some interesting books available. But having read the last part of your statement “…not only for Excel….” I doubt whether it really is what you are looking for. All the books I would like to recommend to you are certainly demonstrating the financial modeling part using Excel exclusively as a tool.

To say it straight forward: I am absolutely sure that there is currently no book available in the global book market which discusses Financial Modeling / Corporate Finance topics based on Quantrix Modeler as a tool. Somewhere here in the forum there used to be an interesting discussion around the suggestion of the user “DOM” to write such a book. Somehow it became very calm around this suggestion – for whatever reason.

On the other hand, if you are still are interested in some additional suggestions regarding Financial Modeling even in case that they purely focus on Excel as a tool, then let me now. I will then start to create this list here in the forum.

Best regards,

Joachim

Regards[/QUOTE]

0

[quote="Josh10":2lcr2hn5]…

On the other hand, if you are still are interested in some additional suggestions regarding Financial Modeling even in case that they purely focus on Excel as a tool, then let me now. I will then start to create this list here in the forum.

Best regards,

Joachim

Regards[/quote:2lcr2hn5]

Hi Joachim,
I had no intention to exclude the books that use MS Excel as a tool. I asked if there was a book on the “tecnique” of Financial Modeling, as subject in general.
Obviously I’m very interested to read the list of books you will publish.

Regards
Carlo

0

Hi Carlo,

sorry for the long delay in reply to your last post. I had already written a reply and then – unfortunately – I lost everything before saving because I needed a certain time to prepare the list. I provided an exhaustive comment to every book. This was a mistake. Obviously the time was too long for the forum software. When I tried to post it, I needed to login again. Trying this I made a mistake (using the wrong password) and when I hit the back button, everything was lost. So I was a bit angry and needed some time to recover
😉 Sorry again.

[quote="Carlo Capasso":f2jr7tc1]…Obviously I’m very interested to read the list of books you will publish.
[/quote:f2jr7tc1]

And here again the list – this time without comments. 😉

[list=1:f2jr7tc1]
[*:f2jr7tc1]Michel Schlosser, Business Finance Applications, Models and Cases; Prentice Hall, 2002[/*:m:f2jr7tc1]
[*:f2jr7tc1]Michel Schlosser, Corporate Finance A Model Building Approach, 2nd edition, Prentice Hall 1992[/*:m:f2jr7tc1]
[*:f2jr7tc1]Simon Beninga, Financial Modeling, 2nd edition, 2001, MIT Press[/*:m:f2jr7tc1]
[*:f2jr7tc1]K. Scott Proctor, Building Financial Models with Microsoft Excel – A Guide for Business Professionals, Wiley 2004[/*:m:f2jr7tc1]
[*:f2jr7tc1]Wayne L. Winston, Excel 2007 Data Analysis and Business Modeling, 2007 Microsoft Press[/*:m:f2jr7tc1]
[*:f2jr7tc1]Cecilia L. Wagner, Financial Management with the Electronic Spreadsheet, Harper Collins College Publishers, 1995 [/*:m:f2jr7tc1][/list:o:f2jr7tc1]
There are some a few more in my bookshelf – unfortunately they are all in German language exclusively. Although I can see that your English language skills are pretty good (much better than mine) I guess the probability that you do speak German additionaly is understandably quite low. Why should a reasonable person learn a language like German… Therefore I would suggest, in case I am wrong with my assumption and you do indeed speak German, please let me know, then I will enhance the list accordingly.

If you do have or know some other interesting English books about Business modeling (unfortunately I do not speak Italian 😉 ) I of course would be interested to read some recommendations. By the way I will check whether I still can find some electronic papers about the modeling topic on my old hard drives… Unfortunately I lost pretty much a couple of years ago, when I was still so stupid not to make regular backups… Anyway, somewhere I might have something and will post it here.

All right Carlo, enjoy the literature (some of the books might be difficult to get nowadays, maybe by second hand only) and in case you build the one or the other model of these books using the modeler, it would be nice to read about this here.

Best regards,

Joachim

0

Hi Carlo,

I knew that I still had some interesting books on my Amazon wish list… 😉
I just checked them again and by doing this I followed additionaly the recommendations given by Amazon. The result is the compiled list below. I think two or three of them I made a recommendation because I think they might be very helpful (have a look for the annotations).

[list=1:88odrq4g]
[*:88odrq4g]John Tjia, Building Financial Models, McGraw-Hill Finance & Investing[/*:m:88odrq4g]
[*:88odrq4g]Dr Michael Rees, Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level with CD ROM (The Wiley Finance Series) (Hardcover)[/*:m:88odrq4g]
[*:88odrq4g]Keith A. Allman, Modeling Structured Finance Cash Flows with Microsoft[/*:m:88odrq4g]
[*:88odrq4g]Evan Tick, Excel: A Step-by-Step Guide.Book & CD-ROM (Paperback)[/*:m:88odrq4g]
[*:88odrq4g]Structured Finance Modeling with Object-Oriented VBA (Wiley Finance) (Hardcover) [color=”Red”]
Annotation to the last book: [i:88odrq4g]Maybe quite a bit out of fashion, politically incorrect and cyncal at the moment 😉 but certainly interesting.[/i:88odrq4g][/color][/*:m:88odrq4g]
[*:88odrq4g]Keith A. Allman, Reverse Engineering Deals on Wall Street with Microsoft Excel: A Step-by-Step Guide (Wiley Finance) (Paperback)
[color=”Red”]Annotation: Well, similar like the former book…[/color][/*:m:88odrq4g]
[*:88odrq4g]William PreinitzA Fast Track To Structured Finance Modeling, Monitoring and Valuation: Jump Start VBA (Wiley Finance) (Hardcover)[/*:m:88odrq4g]
[*:88odrq4g]Keith A. Allman, Corporate Valuation Modeling: A Step-by-Step Guide (Wiley Finance) (Paperback)[/*:m:88odrq4g]
[*:88odrq4g]Aswath Damodaran The Dark Side of Valuation: Valuing Young, Distressed, and Complex Businesses (2nd Edition) (Hardcover)
[color=”red”]Annotion: This seems to have no direct relation to practical business modeling by showing how it it is done in Excel, but it gives you certainly some useful theoretical insights in some specialities of business modeling in the truest sense of the word. Modeling is more than technicalities and the author seems to describe this.[/color][/*:m:88odrq4g]
[*:88odrq4g]Tom Y. Sawyer, Pro Excel Financial Modeling: Building Models for Technology Startups (Paperback)[/*:m:88odrq4g]
[*:88odrq4g]Stephen G. Powell, Modeling for Insight: A Master Class for Business Analysts (Paperback)
[color=”red”]Annotation: This seems to be a very interesting book. One of the next books I probably will order.[/color][/*:m:88odrq4g]
[*:88odrq4g]Elliot Bendoly, Excel Basics to Blackbelt: An Accelerated Guide to Decision Support Designs (Hardcover)[/*:m:88odrq4g]
[*:88odrq4g]Robert T. Clemen, Making Hard Decisions with Decision Tools Suite Update Edition (Hardcover)
[color=”red”]Annotation: This also sounds interesting from a theoretical, business related perspective but also having a relation to practical usage by decision making tools.[/color][/*:m:88odrq4g]
[*:88odrq4g]S. Christian Albright, Data Analysis and Decision Making with Microsoft Excel, Revised (with CD-ROM and Decision Tools and Statistic Tools Suite) (Hardcover)[/*:m:88odrq4g]
[*:88odrq4g]Simon Benninga, Principles of Finance with Excel: Includes CD (Hardcover)[/*:m:88odrq4g]
[*:88odrq4g]Conrad Carlberg, Excel for Accountants: Tips, Tricks & Techniques (Paperback)[/*:m:88odrq4g]
[*:88odrq4g]Conrad Carlberg, Business Analysis with Microsoft Excel (3rd Edition) (Paperback)[/*:m:88odrq4g]
[*:88odrq4g]Jonathan Swan, Practical Financial Modelling, Second Edition: A guide to current practice (Paperback)[/*:m:88odrq4g]
[*:88odrq4g]Alastair Day, Mastering Financial Modelling in Microsoft Excel: A practitioner’s guide to applied corporate finance (2nd Edition) (Paperback)[/*:m:88odrq4g]
[*:88odrq4g]Alastair Day, Mastering Financial Mathematics in Microsoft Excel: A Practical Guide for Business Calculations (Paperback)[/*:m:88odrq4g]
[*:88odrq4g]Alastair L. Day, Mastering Risk Modelling: A Practical Guide to Modelling Uncertainty With Microsoft Excel (Financial Times Series) (Paperback)[/*:m:88odrq4g]
[*:88odrq4g]Mary Jackson, Advanced modelling in finance using Excel and VBA (Hardcover)[/*:m:88odrq4g]
[*:88odrq4g]Financial Analysis and Modeling Using Excel and VBA (Wiley Finance) (Paperback)[/*:m:88odrq4g]
[*:88odrq4g]Chandan Sengupta, Financial Analysis and Modeling Using Excel and VBA (Wiley Finance) (Paperback)[/*:m:88odrq4g]
[*:88odrq4g]Gerald Knight, Analyzing Business Data with Excel [/*:m:88odrq4g]
[*:88odrq4g]Bill JelenGuerilla Data Analysis Using Microsoft Excel [/*:m:88odrq4g]
[*:88odrq4g]Ivana Taylor, Bill Jelen, Excel for Marketing Managers (Excel for Professionals series) [/*:m:88odrq4g]
[*:88odrq4g]Ivana Taylor, Excel for Marketing Managers (Excel for Professionals series) (Paperback)[/*:m:88odrq4g][/list:o:88odrq4g]

Best regards,

Joachim

P.S.: Will there ever be a similar list showing the topic of Business Modeling using Quantrix Modeler? 😉

0

…for the time you spent for me.
You’re right when you suppose I don’t speak German.
The list is very long so I have a lot of books to read.

Regards

Carlo