Excel Financial Calculations Professional Tutorial

Author: Wang Xiaomin (Editor)
Publisher:
Publish Date: 2004-03-01
Features: Capital operations are a topic of common interest among the business community, the financial industry, and academia. The goal of this book is to provide you with introductory knowledge of financial calculations using the Excel tool. On one hand, the content emphasizes the practicality of computational techniques, while on the other hand, it strives to maintain the completeness of the financial theory system. Therefore, this book is suitable for business professionals seeking further education, as well as students majoring in finance, securities, accounting, management, and various types of MBA programs. Additionally, the numerous real-world examples and calculation models in the book can serve as references for corporate managers, especially those in senior financial management positions. As an advanced application of Excel, this book assumes that you have mastered the basic operations of Excel. It introduces the application of Excel in the financial industry, 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—foundations of financial calculations; Chapter 3 discusses basic accounting knowledge—financial statements and ratios for management; Chapter 4 explains the principles of capital budgeting—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 covers security valuation—pricing issues for 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—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, as well as students majoring in finance, securities, accounting, management (including various types of MBA students) for reference.