The definitive guide to managing the numbers: the executive's fast-track to mastering spreadsheets, budgets, forecasts, investment metrics...

Abstract

Chapter 1. The Journey Starts Here Part 1. Attaining mastery over numbers First, I will help you suit up with the weapons and armour needed to do battle. Chapter 2 Where Managers and Numbers Meet reviews this magical kingdom and starts to show you how to use the numbers to your advantage. Chapter 3 How The Finance Director Thinks looks at mindset of the professionals with whom you will be dealing. Chapter 4 The Financial Wizard's Toolbox investigates the tools you use to hammer the numbers - primarily spreadsheets. Chapter 5 Taming Numbers - provides a refresher about some numerical techniques. Patr 2. Managing money Second, now you are forearmed, we can move on to income and expenditure. I will show you how to dominate every penny that comes into and flows out of your coffers. Chapter 6 Keeping Score reviews the rudiments of bookkeeping, with a special note on matters such as looking after the petty cash and dealing with expenses claims. Chapter 7 How to Analyze Figures in the Fourth Dimension introduces ways of looking at how numbers have changed over time - and how this highlights what is happening to the business. Chapter 8 How to Forecast Anything explains how to form a realistic view about potential future trends - with particular attention on forecasting sales. Chapter 9 Getting to Gross Profit touches on broader aspects of sales revenue. Chapter 10 Creating Capital considers the special factors surrounding capital spending (often huge outlays where there is longer-term benefit and perhaps short-term pain). Chapter 11 Controlling Costs looks at other spending - the cash that seems to go up in smoke instantly when you pay telephone bills, rent, and so on. Part 3. Doing the numbers Now you have a good understanding of number crunching techniques, as well as hands-on experience dealing with the figures that finance your business. You are now ready to pull them together for some serious business reporting, analysis and decision-making, and control. Chapter 12 Brilliant Budgets reviews the budgeting process. Chapter 13 Perfect Projects reveals the secrets of killer project management - feasibility studies, planning, decision and control. Good stuff applicable everywhere in surprising ways. Chapter 14 Producing a Profit investigates income statements, known in the UK and elsewhere as profit and loss accounts. These are just budgets or project plans restated. Chapter 15 Building a Balance Sheet looks at balance sheets - misunderstood (to say the least) medical reports about of the health of any business. Chapter 16 Controlling Cash Flow considers sources and uses of funds - highlighting ways of re-casting the figures already dealt with to give you better management control over cash. Part 4. Managing better By now, you are all set for success. Chapter 17 Seeing the Big Picture looks at how you pull all the components together - and how individual figures relate to and mesh with those of the enterprise as a whole. Chapter 18 Making Better Financial Decisions aim to help you do just that - covering questions such as how profitable is my business, which product lines are most profitable, and which business units are most vulnerable. Chapter 19 Managing the Numbers will let you manage financials better on a daily basis - with shortcuts to incisive analysis, tips for handling financial meetings, presentations and beanies, and so on. Chapter 20. When Things Go Wrong deals with the inevitable - what to do when things go wrong things such as cost overruns, economic recessions, unexpectedly low income, interest and exchange rate surprises, funding cuts, too much money budget under-runs and overruns, projects out of control, moved goal posts, forecasts that have to be revised, and asking for more.