A Fast Track To Structured Finance Modeling, Monitoring and Valuation: Jump Start VBA (Hardcover) (結構性金融建模、監控與估值的快速入門:VBA 快速啟動)

William Preinitz

  • 出版商: Wiley
  • 出版日期: 2009-02-01
  • 售價: $4,090
  • 貴賓價: 9.5$3,886
  • 語言: 英文
  • 頁數: 744
  • 裝訂: Hardcover
  • ISBN: 0470398124
  • ISBN-13: 9780470398128
  • 相關分類: Excel
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

相關主題

商品描述

This book is designed to start with simple examples that progressively develop the reader's confidence to take on more complex tasks. There is very little theoretical discussion about computer science, operations research algorithms, mathematics, or finance. The thrust of the book is to teach the reader to break complex tasks down into simple tasks. It then looks to implement those simple tasks into VBA code using a critical subset of the features of the language.

The tentative contents is: (1) Why? What? Who? Where? and How? (2) Common Sense (3) Securitizing A Loan Portfolio (4) Understanding the Excel Waterfall (5) Designing the VBA Model (6) Laying the Model Groundwork (7) Recorded Macros: A First Look at the VBA Language (8) Writing Menus: An Introduction to Data, Ranges, Arrays, and Objects (9) Controlling the Flow of the Model (10) Building Messaging Capabilities (11) Designing the Model’s Reports (12) Main Program and Menus (13) Writing the Collateral Selection Code (14) Calculating the Cash Flows (15) Running the Waterfall: Producing Initial Results (16) Debugging the Model (17) Validating the Model (18) Running the Model (19) Building Additional Capabilities (20) Documentation of the Model (21) Managing the Growth of the Model (22) Building Portfolio Monitoring Model (23) Valuation Techniques: How do we Determine Price? (24) Challenging Times For the Deal (25) Parting Admonitions

商品描述(中文翻譯)

本書旨在從簡單的範例開始,逐步提升讀者的信心,以應對更複雜的任務。書中對於計算機科學、運籌學算法、數學或金融的理論討論非常少。書的重點在於教導讀者將複雜的任務拆解為簡單的任務。接著,將這些簡單的任務實現為VBA代碼,使用該語言的一個關鍵子集功能。

暫定內容包括:(1) 為什麼?什麼?誰?在哪裡?以及如何? (2) 常識 (3) 對貸款組合進行證券化 (4) 理解Excel的瀑布圖 (5) 設計VBA模型 (6) 建立模型基礎 (7) 錄製宏:VBA語言的初步了解 (8) 編寫菜單:數據、範圍、數組和對象的介紹 (9) 控制模型的流程 (10) 建立消息功能 (11) 設計模型報告 (12) 主程序和菜單 (13) 編寫擔保品選擇代碼 (14) 計算現金流 (15) 執行瀑布圖:產生初步結果 (16) 調試模型 (17) 驗證模型 (18) 執行模型 (19) 建立額外功能 (20) 模型文檔 (21) 管理模型的增長 (22) 建立投資組合監控模型 (23) 評價技術:我們如何確定價格? (24) 交易的挑戰時期 (25) 最後的忠告