Application of Excel in Financial Model Analysis

Author: Liu Shancun
Publisher:
Publish Date: 2004-06-01
Features: This book combines practical applications in finance and focuses on introducing how to use Excel for analyzing project investment decisions, investment portfolio hedging strategies, and bond immunization strategies. It also covers how to use Excel to calculate the efficient frontier of an investment portfolio, how to use Excel to plot the Capital Market Line (CML) and Security Market Line (SML), and how to use Excel to implement the binomial option pricing model and the Black-Scholes option pricing model. The book primarily introduces modern financial models such as project evaluation financial basic models, the efficient frontier theory of securities investment portfolios, the Capital Asset Pricing Theory (CAPM), option pricing theory, portfolio hedging strategies, bond duration theory, and immunization strategies, along with their implementation processes using Excel. The book explains, verifies, and solves abstract financial models through Excel's data processing and graphical forms, emphasizing the implementation process of Excel. It aims to help readers become familiar with current financial theory models, their meanings, and concepts, while also mastering Excel's powerful functions in handling matrices, statistics, optimization, and VBA applications. This book can serve as a reference for securities professionals and financial management and analysis personnel, as well as a textbook for undergraduate and graduate students in economics and finance at universities and colleges.