Financial Modeling for Decision Making

Using MS-Excel in Accounting and Finance

Ron Messer

Emerald

This book can be opened with

Paperback / softback

9781789734140

01 September 2020

£50.99

eBook (PDF)

9781789734133

01 September 2020

£72.99

eBook (ePub)

9781789734157

01 September 2020

£72.99

Note on our eBooks and Audiobooks: you can read our eBooks (ePUB or PDF) and listen to audiobooks on the free Emerald Books app on iOS, Android, and desktop. Or read and listen on Emerald's online reader (ePUB eBooks and audiobooks only). To purchase a digital book you will need to create an account if you don’t already have one. After purchasing you will receive instructions on how to get started.

Description
Contents
About

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 DecisionsChapter 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.