This book deliberately combines essential theory with real-world application, using short, sharp chapters to help you find what you need and focus your attention. And since spreadsheets have become an indispensable tool for the business of finance, also shows how to implement these techniques in excel.The topics include : risk and return, total risk, optimal portfolio, diversification, systematic risk, CAPM and the cost of capital, downside risk, risk-adjusted returns, valuation models, bonds, prices and yields, defaul and market risk, duration and convexity, NPV and IRR, real option, coporate value creation, options, futures and forwards, currencies, statistics, normality and regerssion analysis