This book provides accounting students in post-secondary institutions with an advanced level understanding of how to use MS-Excel to make business decisions. It reflects real-life applications of this important analytical tool, which has become the accepted industry standard for spreadsheet software.

This book is mainly focused on the development of tools for decision-makers in finance, ranging from treasurers of firms to professional investors and bank managers. It presents a broad variety of applications using techniques and methodologies from various fields such as econometrics, operations research and financial mathematics. The tools for decision-making have been modified towards financial decision support systems. The role of the decision-maker has become dominant, both in the development and in the use of the decision support systems. The developments in both the computer hardware and software for computers simplify the design of individualized decision support systems. Financial modelling functions as a liason between theoretical financial expertise and practice.

Too often, finance courses stop short of making a connection between textbook finance and the problems of real-world business. "Financial Modeling" bridges this gap between theory and practice by providing a nuts-and-bolts guide to solving common financial problems with spreadsheets. The CD-ROM contains Excel* worksheets and solutions to end-of-chapter exercises. 634 illustrations.

This handbook in two parts covers key topics of the theory of financial decision making. Some of the papers discuss real applications or case studies as well. There are a number of new papers that have never been published before especially in Part II.Part I is concerned with Decision Making Under Uncertainty. This includes subsections on Arbitrage, Utility Theory, Risk Aversion and Static Portfolio Theory, and Stochastic Dominance. Part II is concerned with Dynamic Modeling that is the transition for static decision making to multiperiod decision making. The analysis starts with Risk Measures and then discusses Dynamic Portfolio Theory, Tactical Asset Allocation and Asset-Liability Management Using Utility and Goal Based Consumption-Investment Decision Models.A comprehensive set of problems both computational and review and mind expanding with many unsolved problems are in an accompanying problems book. The handbook plus the book of problems form a very strong set of materials for PhD and Masters courses both as the main or as supplementary text in finance theory, financial decision making and portfolio theory. For researchers, it is a valuable resource being an up to date treatment of topics in the classic books on these topics by Johnathan Ingersoll in 1988, and William Ziemba and Raymond Vickson in 1975 (updated 2 nd edition published in 2006).

Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level is a practical, comprehensive and in-depth guide to financial modelling designed to cover the modelling issues that are relevant to facilitate the construction of robust and readily understandable models. --From publisher's description.

Financial Modeling for Business Owners and Entrepreneurs: Developing Excel Models to Raise Capital, Increase Cash Flow, Improve Operations, Plan Projects, and Make Decisions may be one of the most important books any entrepreneur or manager in a small or medium-sized enterprise will read. It combines logical business principles and strategies with a step-by-step methodology for planning and modeling a company and solving specific business problems. You’ll learn to create operational and financial models in Excel that describe the workings of your company in quantitative terms and that make it far more likely you will avoid the traps and dead ends many businesses fall into. Serial entrepreneur and financial expert Tom Y. Sawyer shows how to break your company down into basic functional and operational components that can be modeled. The result is a financial model that, for example, you can literally take to the bank or bring to local angel investors to receive the funding you need to launch your business or a new product. Or it might be a model that shows with startling clarity that your new product development effort is a likely winner—or loser. Even better, you’ll learn to create models that will serve as guideposts for ongoing operations. You’ll always know just where you are financially, and where you need to be. The models you will learn to build in Financial Modeling for Business Owners and Entrepreneurs can be used to: Raise capital for startup or any stage of growth Plan projects and new initiatives Make astute business decisions, including go/no-go assessments Analyze ROI on your product development and marketing expenditures Streamline operations, manage budgets, improve efficiency, and reduce costs Value the business when it is time to cash out or merge In addition to many valuable exercises and tips for using Excel to model your business, this book contains a combination of practical advice born of hard-won lessons, advanced strategic thought, and the insightful use of hard skills. With a basic knowledge of Excel assumed, it will help you learn to think like an experienced business person who expects to make money on the products or services offered to the public. You’ll discover that the financial model is a key management tool that, if built correctly, provides invaluable assistance every step of the entrepreneurial journey. Tom Y. Sawyer has used the principles this book contains to create financial models of numerous startup and early-stage companies, assisting them in planning for and raising the capital that they needed to grow their businesses and ultimately exit with multiples of their initial investment. Financial Modeling for Business Owners and Entrepreneurs, a mini-MBA in entrepreneurship and finance, will show you how you can do the same. Note: This book is an updated version of Sawyer's 2009 title, Pro Excel Financial Modeling.

The comprehensive, broadly-applicable, real-world guide to financial modelling Principles of Financial Modelling – Model Design and Best Practices Using Excel and VBAcovers the full spectrum of financial modelling tools and techniques in order to provide practical skills that are grounded in real-world applications. Based on rigorously-tested materials created for consulting projects and for training courses, this book demonstrates how to plan, design and build financial models that are flexible, robust, transparent, and highly applicable to a wide range of planning, forecasting and decision-support contexts. This book integrates theory and practice to provide a high-value resource for anyone wanting to gain a practical understanding of this complex and nuanced topic. Highlights of its content include extensive coverage of: Model design and best practices, including the optimisation of data structures and layout, maximising transparency, balancing complexity with flexibility, dealing with circularity, model audit and error-checking Sensitivity and scenario analysis, simulation, and optimisation Data manipulation and analysis The use and choice of Excel functions and functionality, including advanced functions and those from all categories, as well as of VBA and its key areas of application within financial modelling The companion website provides approximately 235 Excel files (screen-clips of most of which are shown in the text), which demonstrate key principles in modelling, as well as providing many examples of the use of Excel functions and VBA macros. These facilitate learning and have a strong emphasis on practical solutions and direct real-world application. For practical instruction, robust technique and clear presentation, Principles of Financial Modelling is the premier guide to real-world financial modelling from the ground up. It provides clear instruction applicable across sectors, settings and countries, and is presented in a well-structured and highly-developed format that is accessible to people with different backgrounds.