I&I

GIDE Financial Modelling

Why reinvent the wheel when the wheel has been created for you? Spreadsheets are great, I’ve used them for 30+ years, but sometimes it makes sense to utilise software and other tools that are available that make yours and your client’s life that much better.I fully agree with the review by Capterra: “MYGIDE is the most powerful and business friendly financial modelling, budgeting, rolling forecast and strategic planning software on the market today. It combines the versatility and do it yourself quality of spreadsheets, with a powerful and error free calculation engine of expensive tailor-made systems, supporting real time work-group collaboration. Designed by corporate financiers to make life easier for financial professionals and investment managers, business analysts, controllers, and budget and strategic planners.”From monthly general ledger extracts, one is able to consolidate a group of companies and roll them up to provide future valuation estimates for investors, utilising what-if functionality and scenario planning. Preparing the next year’s budget can be easily streamlined and forecasts updated collaboratively with ease.The customer service and support has been outstanding, and I can’t thank Jaro Malach enough for his patience…

Comments Off

I&I

Analysis: The A of FP&A

Analysis that leads to new insights and reveals that your biggest customer has a very low contribution margin is something that most management teams should do something about. But until it is laid out for them to see, it could be lost in the overall scheme of things.Analysis can appear to be simple, but often the gathering of the data is what takes all the time and effort, especially the initial set-up of groups, categories, and whatever else you may need to do a deep dive into.Probably key to any business is the analysis of sales:Sales Revenue by customer, by region, by product group, by sales rep, by sales channelCosts of serving your customers, by region, by product group, by sales channelProfits by customer, by region, by product group, by sales channelCustomers – New vs Existing, how are your key clients performing?Products – New vs Existing, by supplier, seasonalProduct mix what has changed in the last quarter?Supply chain analysis – what are the transportation and warehousing costs? Should you outsource or keep in house?When do your existing customer contracts end? Is this information easily…

Comments Off