欢迎来到相识电子书!

标签:金融建模

  • 财务金融建模

    作者:(美)本尼卡

    《财务金融建模》在理论与实践之间架起了一座桥梁,它提供了运用Excel电子表解决一般财务与金融建模问题的具体操作过程,告诉读者每个模型的实现步骤,说明了它们是如何用Excel来求解的。 期待已久的这部标准教科书的第三版继承了财务金融“食谱大全”和使用Excel工具的特点。这也是第一版和第二版之所以备受欢迎的原因。此外它还增加了非常新的内容,这些新章节涉及的主题包括:银行估值、最优化投资组合的Black-Litterman方法、蒙特卡罗方法及其在期权定价中的应用,以及数组函数和公式的使用;其他的章节包括:基本的财务计算、投资组合模型、计算方差—协方差矩阵,以及随机数生成。以上内容经过了修订,并采用了许多全新和已改进的资料。其他涉及领域包括:财务报表建模、租赁、标准的投资组合问题、受险价值、久期与免疫策略、期限结构建模。技术章节涉及的主题包括:模拟运算表、矩阵、高斯一塞德尔方法,以及使用Excel的提示。最后一部分内容涉及本书所需要的VBA技术。 本书光盘中含有各章例题的Excel工作表和习题解答。
  • Financial Modeling

    作者:Benninga, Simon

    Too often, finance courses stop short of making a connection between textbook finance and the problems of real-world business. Financial Modeling bridges this gap between theory and practice by providing a nuts-and-bolts guide to solving common financial models with spreadsheets. Simon Benninga takes the reader step by step through each model, showing how it can be solved using Microsoft Excel. The long-awaited third edition of this standard text maintains the "cookbook" features and Excel dependence that have made the first and second editions so popular. It also offers significant new material, with new chapters covering such topics as bank valuation, the Black-Litterman approach to portfolio optimization, Monte Carlo methods and their applications to option pricing, and using array functions and formulas. Other chapters, including those on basic financial calculations, portfolio models, calculating the variance-covariance matrix, and generating random numbers, have been revised, with many offering substantially new and improved material. Other areas covered include financial statement modeling, leasing, standard portfolio problems, value at risk (VaR), real options, duration and immunization, and term structure modeling. Technical chapters treat such topics as data tables, matrices, the Gauss-Seidel method, and tips for using Excel. The last section of the text covers the Visual Basic for Applications (VBA) techniques needed for the book. The accompanying CD contains Excel worksheets and solutions to end-of-chapter exercises.