Annual Update for Controllers

This guide covers leading-edge topics in managerial accounting and finance. It's packed with useful tips and practical guidance controllers and financial managers can apply immediately. You'll also gain insight into hot topics such as:

• Power Pivot
• Integrated Reporting
• Bitcoin
• Technology trends

In addition, this guide includes a case study covering three chapters using Excel tools, working capital trends and technology changes.

Jim Lindell, CPA, CGMA, MBA, is the president of Thorsten Consulting Group Inc., a Wisconsin-based provider of strategic and financial consulting, professional speaking, training and executive coaching. He has an extensive background in senior management, including positions as chief financial officer, corporate controller and corporate assistant controller. Jim has worked with a variety of industries, including manufacturing health care, not for profit, distribution and food processing.

Chapter 1 1-1

Economic Update — Glass Half Full or Half Empty? 1-1

Transportation indicators — Economy 1-53

Practice questions 1-61

Chapter 2 2-1

Power BI, Pivot and Excel Tips and Techniques for the Controller 2-1

Lean and your skill set 2-3

Practice questions 2-56

Appendix 2A Chapter 2, A-1

Practice questions Chapter 2, A-4

Chapter 3 3-1

People — Human Resources Trends, Employee Engagement, Automation, and Social Recruiting 3-1

Practice questions 3-34

Chapter 4 4-1

Accounting as a Complement to the Sales Function 4-1

Practice questions 4-19

Chapter 5 5-1

Trends in Working Capital 5-1

Current trends in working capital 5-6

Practice questions 5-30

Chapter 6 6-1

Coronavirus, Ransomware, Contingencies, and Black Swan Events 6-1

Practice questions 6-18

Chapter 7 7-1

Big Data, Predictive Analytics, Information Technology, and the Controller 7-1

Practice questions 7-32

Chapter 8 8-1

The Future — Innovation and Trends That Affect All Aspects of Our Culture 8-1

Welcome to the future! 8-2

Practice questions 8-18

Glossary Glossary 1

Index Index 1

Solutions Solutions 1

Chapter 1 Solutions 1

Chapter 2 Solutions 3

Chapter 3 Solutions 5

Chapter 4 Solutions 7

Chapter 5 Solutions 8

Chapter 6 Solutions 9

Chapter 7 Solutions 10

Chapter 8 Solutions 12

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.