Excel-Based Financial Modeling: A Practitioner's Guide

Author: Dai Yu Mei
Publisher:
Publish Date: 2004-06-01
Features: This book is highly practical and provides a method that is not covered in either corporate finance textbooks or Excel manuals. It is a guide to model design methods, designed to save you time and make your work more efficient. Used in conjunction with the accompanying CD-ROM, it will enable finance professionals and business school students to excel and become more professional in constructing Excel financial models, as well as apply corporate finance concepts more effectively. This book is suitable for CFOs, financial directors, financial managers, analysts, accountants, corporate finance staff, inventory managers, risk managers, general managers, decision-makers in banks, companies, and government agencies, as well as students in universities, business schools, and MBA programs. This book is highly practical and provides readers with a method not covered in corporate finance textbooks or Excel manuals. It is a guide to model design methods, specifically designed to save readers' time and improve their work efficiency. Used in conjunction with the accompanying CD-ROM, it will enable finance professionals and business school students to excel and become more professional in constructing Excel financial models, as well as apply corporate finance concepts more effectively. This book addresses many core questions, including: How to build more powerful Excel models; How to add more advanced features to Excel models; How to make the answers provided by the model more convincing; How to conduct deeper analysis of your models. Alastair L. Dai has worked in the finance industry for 20 years, involved in activities such as capital trading and leasing management, marketing management, etc. He initially worked for NFC, handling capital trading and leasing management. With the privatization of NFC in 1980, he shifted to market operations. In the 1980s, he became the chairman of a leasing company, which rapidly grew through projects in IT, printing, and industrial manufacturing. In the late 1980s, Chairman Alastair L. Dai sold the company to a listed public company. In 1990, Alastair L. Dai founded System Finance PLC, serving as an advisor and financial lessor for the computer and communications industry. He holds a degree in economics and German from the University of London and an MBA in business administration from the Open University Business School, where he also served as an associate lecturer in corporate finance. In addition to his other works, such as The Finance Director's Guide to Purchasing and Leasing, he has developed numerous software products. Furthermore, he offers both public and internal courses covering a wide range of topics, including financial modeling, leasing, credit, and cash flow analysis, as well as other corporate finance issues.