Home » Excel Modeling In Investments by Craig W. Holden
Excel Modeling In Investments Craig W. Holden

Excel Modeling In Investments

Craig W. Holden

Published
ISBN : 9780131424265
Paperback
192 pages
Enter the sum

 About the Book 

This book with accompanying CD-ROM gives readers the necessary information and skills theyll need to build step-by-step financial models in Excel. Updated coverage keeps this book current and relevant, and practical, real-world examples provideMoreThis book with accompanying CD-ROM gives readers the necessary information and skills theyll need to build step-by-step financial models in Excel. Updated coverage keeps this book current and relevant, and practical, real-world examples provide exciting learning opportunities. The book progresses from simple examples to more complex topics, including Portfolio Optimization that uses real data on 20 stocks to calculate the efficient frontier, the tangent line, the weights of the tangent portfolio, and then graph everything- US Yield Curve Dynamics that shows a movie of 30 years of monthly zero-coupon yield curves highlighting the dynamics of the US yield curve history- and a 50-Period Binomial Option Pricing model using a stock volatility that readers can estimate from real data. Other subjects addressed are bonds/fixed income securities- stocks/security analysis- and options/futures/derivatives. An excellent resource tool for security and stock analysts, brokers, and financial planners.