Excel Financial Calculations Professional Tutorial (1CD)

Author: Wang Xiaomin (Compiler)
Publisher:
Publish Date: 2004-03-01
Features: This book introduces the application of Excel in the financial industry. It is divided into 10 chapters. Chapter 1 discusses the computational tool Excel—more effective use of spreadsheet software; Chapter 2 covers the time value of money—the foundation of financial calculations; Chapter 3 explains basic accounting knowledge—financial statements and ratios for management; Chapter 4 discusses the principles of capital budgeting—the evaluation indicators for investment decisions; Chapter 5 covers risk and return—statistical principles and their applications; Chapter 6 discusses the Capital Asset Pricing Model (CAPM)—risk and return in the capital market; Chapter 7 explains security valuation—the pricing of bonds and stocks; Chapter 8 discusses the cost of capital and corporate value—the value of a business lies in creating wealth with capital; Chapter 9 covers capital structure and dividend policy—the theory and empirical analysis of financial leverage and dividend distribution; Chapter 10 discusses options and real options—from financial instruments to investment management concepts. This book is suitable for business professionals seeking further education and is also a reference for students majoring in finance, securities, accounting, management, and other fields (including various types of MBA students).