Application of Excel in Corporate Finance

Author: Xie Lan
Publisher:
Publish Date: 2004-05-01
Features: In practical work, many functions provided by Excel are not fully utilized, especially when combined with professional applications, users need to possess both extensive computer knowledge and solid professional expertise. Currently, many users still only use Excel for relatively simple data calculations and report processing. This book focuses on introducing how to use Excel to solve specific problems in corporate finance and investment. The content includes the application of Excel in financial statement preparation and financial analysis; the application of Excel in investment decision-making, security investment analysis, security investment portfolio analysis, security investment technical analysis (K-line chart drawing), fixed asset investment decision analysis, housing loan problems, capital cost analysis, and capital structure decision analysis. This book not only helps readers master and consolidate relevant knowledge in corporate finance and investment but also guides them in utilizing the powerful functions of Excel to easily complete various practical problems. The book emphasizes practicality and can serve as a reference for economic management personnel, financial analysts, and accountants in enterprises (especially the financial industry). It can also be used as a textbook or reference for undergraduate, graduate, and MBA students in economics and management-related fields at universities and colleges.