Financial Modeling for Decision Making: Using MS-Excel in Accounting and Finance

Ron Messer
Kwantlen Polytechnic University, Canada

Product Details
01 Sep 2020
Emerald Publishing Limited
360 pages - 171 x 248mm
Most books on Microsoft Excel for accounting and finance serve primarily academic research purposes: they are relatively unstructured and dominated by discussions of rather esoteric and infrequently used applications. None addresses the growing need for an introduction to crucial data analytic skills (i.e., analysis of ‘big data’) and to the recent innovations by Microsoft Excel in this regard, including Power Query (data cleaning and management), Power Pivot (advanced pivot tables using databases) and Power BI (creating executive KPI dashboards). 

In Financial Modeling for Decision Making: Using MS-Excel in Accounting and Finance, Ron Messer provides just such a practical, advanced-level guide to this essential program. Crucially, he focuses on using Excel in situations encountered by accounting and finance students and professionals, and he structures these in terms of the past, present and future in order to reflect a typical operating cycle, which includes initial planning, exercising control, and receiving feedback. Throughout this book, Messer discusses real-life applications of this important analytical tool, which has become the industry standard for spreadsheet software. 

For its clear structure and emphasis on practical usage, Financial Modeling for Decision Making is essential reading for accounting and finance professionals, as well as accounting and finance students in post-secondary institutions.
Chapter 1. Better Learning Decisions
Chapter 2. Break Even Decisions
Chapter 3. Times Series Forecasting Decisions
Chapter 4. Capital Budgeting Decisions
Chapter 5. Regression Analysis Decisions
Chapter 6. Linear Programming Decisions
Chapter 7. Business Valuation Decisions
Chapter 8. Pivot Tables Decisions
Chapter 9. Financial Dashboard Decisions
Chapter 10. Budget Management Decisions
Chapter 11. Amortization Table Decisions
Chapter 12. Making a Lot of Decisions
Ron Messer is a faculty member of the School of Business at Kwantlen Polytechnic University whose research interests focus broadly on management accounting and decision-making. He is a Chartered Accountant and a Certified Management Accountant with 25 years of working experience in accounting, finance and information systems. His essays have appeared in publications in Canada, the United States, and the United Kingdom.

You might also be interested in..

« Back