Mastering Financial Modelling: A practitioner's guide to applied corporate finance (Market Editions) (英語) ペーパーバック – 2003/7/25
Kindle 端末は必要ありません。無料 Kindle アプリのいずれかをダウンロードすると、スマートフォン、タブレットPCで Kindle 本をお読みいただけます。
Mastering Financial Modelling is a practical book and disk combination that will help finance professionals and business students alike to become more proficient in building Microsoft Excel models and applying corporate finance concepts.
Alastair Day has worked in the finance industry for 20 years in treasury and marketing functions. He worked originally for the NFC, negotiating funding and administering leases, and switched to marketing finance upon the privatization of NFC in 1980. During the 1980s he was a director of a leasing company whose rapid growth was based on programmes in the IT, print and machine tool industries. The directors sold the company to a PLC at the end of the decade. In 1990 he established Systematic Finance as a consultancy and financial lessor concentrating on the computer and communications industries.
Alastair has a degree in Economics and German from London University, an MBA from the Open University Business School, and is an associate lecturer in corporate finance with the OUBS. Other publications include books such as The Financial Director's Guide to Purchasing Leasing published by the Financial Times Prentice Hall and a range of software products. In addition, he develops and presents public and in-house courses on a range of topics including financial modelling, leasing, credit and cash flow analysis, and other corporate finance topics.
I believe "Mastering Financial Modelling" is not only one of the best books on the subject, but it is simple to read and understand, and convinces the reader that creating your own financial models is a lot of fun. I'm not sure you can acquire the same sense of satisfaction after reading its competition.
If you aren't sure about this book's utility as regards your immediate needs, feel free to visit [...] which gives a superficial representation of what you'll find in the book.
PS: I owned Benninga's "Financial Modelling" for about 4 years, before I sold it so that I could buy Day's book. Benninga's book is good for finance formulars and so on, but Day goes a step farther and gives you real models with the formulars and explains in greater detail how things like Combo Boxes work and so forth.
The only quirk with this book is that it does not come with a CD-Rom as promised on the website. I was pretty upset at first and e-mailed the author about it. But he quickly referred me to the Financial Times website, where I was able to obtain free downloads. If you own a MAC the files might not work for you. Nonetheless, I believe this is a relatively minor distraction in an otherwise fantastically put together piece of work.
Even more disappointingly, the password prevents you from using Excel's audit function to trace formulae components.
This means that to understand formulae one must resort to the tedious, stone-age method of looking in the formula bar and noting down by hand that the formula is, for example," = (sum (A6:G12)) * [next sheet!]Q7 + ([sheet 7!]T78 / [sheet 3!] c24)", and then translating it all into English.
In summary, if you want to teach yourself from this book it will cost you a very substantial time investment in addition to the book's cover price.
The author has password protected the spreadsheets so you can't customize them to your own needs. A serious drawback for the serious user, clearly the intended readership for this book.