<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Lance Rubin on Medium]]></title>
        <description><![CDATA[Stories by Lance Rubin on Medium]]></description>
        <link>https://medium.com/@lancerubin?source=rss-43a6fc2d8cfc------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*y5E-3FiiLs-f9Eit.</url>
            <title>Stories by Lance Rubin on Medium</title>
            <link>https://medium.com/@lancerubin?source=rss-43a6fc2d8cfc------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 00:39:44 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@lancerubin/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[THE FUTURE OF FINANCE IS HERE NOW FOR DATA, MODELLING, ANALYTICS AND AI]]></title>
            <link>https://medium.com/making-informed-relevant-and-purposeful-decision/the-future-of-finance-is-here-now-for-data-modelling-analytics-and-ai-b8140d4b620e?source=rss-43a6fc2d8cfc------2</link>
            <guid isPermaLink="false">https://medium.com/p/b8140d4b620e</guid>
            <category><![CDATA[financial-modelling]]></category>
            <category><![CDATA[finance]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[accounting]]></category>
            <dc:creator><![CDATA[Lance Rubin]]></dc:creator>
            <pubDate>Mon, 24 Apr 2023 06:45:01 GMT</pubDate>
            <atom:updated>2023-04-24T06:56:22.468Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IY98zUQhoRr3UQ4rMDM0rQ.png" /></figure><h3>INTRODUCTION</h3><p>As the opening article for this knowledge series, I think it’s important to really understand the key aspect of what we see today in AI.</p><p>For many years I showed how I could change an Excel model through a visual presentation surface called Modeler and back then someone thought that was AI.</p><p>There are exciting verticals of AI like the generalised language models in ChatGPT, text and video synthesis I showed recently and of course some of the more widely used forms of algorithmic-driven advanced, predictive and prescriptive analytics (data science).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*pQIKiqrTiS2n_S0ZCN0aaw.png" /></figure><p>But the reality is there’s a lot that we can and need to do before we get to fully leverage AI, let’s walk before we run or strap on a jet pack!</p><p>This is not to say that I am not excited, but it’s also not to say that we need to panic or invest too heavily too quickly in the hype cycle.</p><p>Panic has already impacted our accounting and finance industry. The cries from bad marketers calling the death of compliance, accounting and auditing for decades, whilst the complete opposite is true.</p><p>The demand for well-trained, data-literate accounting and finance professionals is well in excess of the supply, and there’s a severe, almost tragic shortage of talented accounting, and finance people with those skills.</p><p>Many students in universities just don’t want to go down that career path for fear of disruption and automation of their jobs.</p><p>To be clear, the main purpose of the series is to give hope to accounting and finance professionals and educate readers on actual use cases, and foundations in data literacy and filter some of this craziness.</p><p>In the end, it all comes back down to data!</p><p>Human plus AI is better than AI alone!</p><h3>UNDERSTANDING DATA LITERACY (FUNDAMENTAL)</h3><p>The series will hopefully help us realise that this is the golden age for our profession. Many don’t see it yet or feel it. But it requires a new type of accountant. One that is data literate and tech-savvy.</p><p>We have been a data-centric profession and function for decades with everything about accounting and finances being numbers, which is still data only now we need to structure how we work with data.</p><p>However, we do have to lift our game in the data space and become more data literate.</p><p>Equally important is tech savvy with concepts like Financial Modelling, Automation, Data Analytics, and of course the new scary AI.</p><p>AI is hitting us all square between the eyes at the moment with the likes of the ChatGPT hype cycle.</p><h3>SHOW ME THE DETAILS!</h3><p>This series will be broken into 6 main themes and we will release articles, videos and other content (some AI some not).</p><p>The topics are intended to help the complex workforce we have in accounting and finance with all the different generations working together, from digital natives to Baby Boomers.</p><p>We should remember this critical turning point and time in our profession which is both exhilarating and frightening at the same time. These are the themes we will cover in the series:</p><ol><li>What are the current obstacles facing Accounting &amp; Finance Today</li><li>AI and its Impact on Accounting and Finance</li><li>Business Intelligence for the Intelligent Accountant</li><li>Training your teams to enable decision-making during uncertainty</li><li>Business modelling skills are a must!</li><li>Risks of doing nothing, in the face of change</li></ol><h3>DATA INTERPRETATION, COMMUNICATION AND SOFT SKILLS</h3><p>One of the more important elements in the series is to recognize that it’s not just about technical skills. There are a lot of soft, communication skills that we need to understand and embrace let alone change management and human resources impacting the way people feel about all of this.</p><p>We have to prioritise making people feel supported and secure or at the very least a vital part of the process. A can-do attitude to embrace change, learning and leading people through this very uncertain time.</p><p>Most people are still stuck on copying and pasting, v-lookups, and pivot tables whilst the general awareness and use of data power tools (Power Query, Power BI etc) are very limited.</p><p>There is also a gap in embracing key skills and concepts, like Financial Modelling and Data Analytics, and more importantly communication and visualisation and storytelling in relation to those areas.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KPWpLtlCFyLQ89L7efeeag.png" /></figure><p>The fortunate ones will learn these new skills and have awesome career opportunities.</p><p>Typically finance has spent most of its time preparing and doing, and now we have to find new skills for communicating and influencing which is a massive paradigm shift that needs to happen.</p><p>We will be successful when we do this by combining the technical skills, technology, insights support, and training, wrapped around the soft skills.</p><h3>DEVELOPING YOUR TEAMS THROUGH CONTINUED LEARNING</h3><p>The other important elements of the series are education and learning. We need to first become aware and familiar with what all this stuff is and how it impacts us.</p><p>How would you train your team in all of these dimensions whilst balancing careful change management and adoption? There is so much to work on whether it is automation or modelling skills, data analytics and advanced data modelling heading towards AI.</p><p>It’s a very big leap that we have to take and staring straight into the face of ChatGPT almost mocks us imitating potentially how easily our jobs are quickly replaceable.</p><p>In some use cases, this might be true but it’s not true for all areas, especially for the data-literate accountant and finance professional.</p><p>What I would say to you is the jobs we used to do are replaceable, but the jobs we need to do in the future will not be replaced for some time, and we will go through that in the series.</p><p>Some jobs have yet to be created as a result of the new tech.</p><h3>CHALLENGES AND OPPORTUNITIES (RISKS THAT EXIST AND YOU NEED TO BE AWARE OF)</h3><p>Of course, with all change, be it technology or otherwise, there is a risk if you buy the wrong technology, solve the wrong problem or invest in the wrong people.</p><p>There’s a risk that you get the timing of all of this wrong and actually, fundamentally your business model doesn’t suit the current times. Innovation just for the sake of it is dangerous so we have to be strategic and focused on outcomes, not blindly flowing the flock.</p><p>There are risks with everything, but the biggest risk of all is doing nothing!</p><p>AI has accelerated this year more than any other and yet a lot of what is done in accounting and finance has not changed.</p><p>We simply cannot ignore the impact of AI particularly generalized language models.</p><p>No, it’s not perfect and it gets things very wrong too, but it’s getting better and we will showcase some of these areas.</p><h3>CONCLUSION</h3><p>So join me for an exciting journey through this series as we wander from Financial and Business Modelling, Analytics, Automation and of course AI. This is about fundamentally revisiting the future of accounting and finance in the context of AI.</p><p>I believe this is the golden age for our profession with so much potential if we are willing to embrace it.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b8140d4b620e" width="1" height="1" alt=""><hr><p><a href="https://medium.com/making-informed-relevant-and-purposeful-decision/the-future-of-finance-is-here-now-for-data-modelling-analytics-and-ai-b8140d4b620e">THE FUTURE OF FINANCE IS HERE NOW FOR DATA, MODELLING, ANALYTICS AND AI</a> was originally published in <a href="https://medium.com/making-informed-relevant-and-purposeful-decision">Making informed, relevant and purposeful decision with insight.</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Spreadsheeting to Financial Modelling Secrets]]></title>
            <link>https://medium.com/series/spreadsheeting-to-financial-modelling-secrets-cf08d2d9a4e2?source=rss-43a6fc2d8cfc------2</link>
            <guid isPermaLink="false">https://medium.com/p/cf08d2d9a4e2</guid>
            <dc:creator><![CDATA[Lance Rubin]]></dc:creator>
            <pubDate>Wed, 28 Aug 2019 00:39:25 GMT</pubDate>
            <atom:updated>2019-10-30T00:17:21.590Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Mindset of embracing the grey</strong></h3><p>28 August 2019 Written by Lisa Barham and Lance Rubin</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/587/1*Uo0ZoYi3nG5RGtNPB7IcMQ.png" /></figure><h3>Introduction to the co-author</h3><p>Lisa is a co-founder of a <a href="http://effigyconsulting.com.au/">consulting firm</a> that works with management teams to create confident decisions backed by data. She uses financial modelling as a way to help her clients articulate their vision, bring colour through the numbers and break the strategy down into actionable steps.</p><p>Her company name, <a href="http://effigyconsulting.com.au/">Effigy Consulting</a>, is based around our belief that a financial model is a representation of the business: The model is a safe space where you can test a business model and assumptions rather than destroying the actual business.</p><p>She is also passionate about efficiency, helping people keep “the main thing the main thing” and giving teams access to the data they need. Consequently, Effigy Consulting have expanded their business into the finance transformation project space as well as providing outsource capacity to manage the full finance function or supplement internal finance teams.</p><h3>Why did Lisa select the topic and why is she passionate about it</h3><p>The topic sparked my interest as it’s something that’s taken me a while to master. I thought writing the article would be a good way to bring together my learning to date.</p><p>To give an example of where I had to reposition my mindset, I had a CFO Services client who needed to put a budget in place. The CEO keeps herself 100% focussed on what McKinsey describes as the third horizon (a.k.a. Bill George’s True North, Bob Proctor’s C Type goal or Jim Collins’ Big Hairy Audacious Goal). Suggesting to her that she needed a ‘budget’ for the year was totally against her personal philosophy: she didn’t want anything holding her back. Once I explained that a financial model could be used to break down the business’s vision into a series of assumptions, drivers and actionable steps, she was willing to give it a try.</p><p>The assumptions are based around her long-term vision, so bringing it back to a shorter timeframe required aggressive growth rates, which would have made my eyes water in the past. But once I embraced the grey I was able to build a “Financial Model for Growth” that the client loves. It’s easily my most creative engagement and a really fun team to work with!</p><p>Developing a mindset of embracing the grey is the first step in moving from being a spreadsheeter to becoming a financial modeller.</p><h3>Topic and context in no more than 3 sentences</h3><p>Getting comfortable with the grey can be challenging for spreadsheeters looking to become financial modellers, particularly those who have come from the black and white of the accounting profession, where we are repeatedly told we aren’t creative and indeed creative accounting could land us in jail!</p><p>However, we must and can learn to thrive in the grey, so long as we are open to changing our mindset of thinking in relatives rather than absolutes and some action is better than no action when looking forward.</p><p>Mindset has been popularised in recent times and whilst it might be perceived as “airy fairy” in our quant driven finance community, it is in fact based in the science of psychology when it first emerged in the late 19th century.</p><h3>If you had to teach this topic in a class to school kids what key tips would you give them to focus on</h3><p>I don’t think kids need to learn this topic, more so adults need to unlearn what they already know. School kids are inherently creative and curious, but the education system, working practices and society reduces this as we age and become more risk averse and fearful of failure.</p><p>This is being addressed in early childhood education and emerging pedagogy’s such as the <a href="https://www.earlylife.com.au/walker-learning">Walker approach encourage creativity</a> through play based learning.</p><p>Here is an exercise that might be useful on mindset.</p><p>If your life was a movie, what kind of movie is it?</p><p>Who are the characters?</p><p>What’s the plot line for today, in a month, in a year or in 10 years’ time?</p><p>How do you feel about your movie, what would you like to change?</p><h3>What practical steps can people take now to learn more</h3><p>The key in developing any skills, especially mindset is to gain knowledge and practice. Read widely and spend time with like-minded individuals as well as those who bring a different perspective (in person courses are a fantastic opportunity to expand your thinking, look for programs that build a community as well as delivering great content).</p><p>Spend time outside of the business e.g. immersed in nature or in new cultural environments in order to gain different perspectives on life and thereby breaking down biases.</p><p>Maintain a healthy lifestyle, sleep well, exercise regularly, eat a balanced diet.</p><p>Make time to ‘think’ as well as ‘do’ by reflecting on where you are today and what part of your “movie” you like and don’t like.</p><p>Work with a mentor or coach and seek varying opinions of your “movie”.</p><h3>Where are good places (links) to find out more on the topic</h3><p>Here is a list of some useful links that might spark a few thoughts on the world around us and hopefully kick us into some action.</p><p>· <a href="https://www.ted.com/talks/carol_dweck_the_power_of_believing_that_you_can_improve?utm_campaign=tedspread&amp;utm_medium=referral&amp;utm_source=tedcomshare">The Power of believing that you can improve — by Carol Dweck on Growth Mindset</a></p><p>· <a href="http://www3.weforum.org/docs/WEF_Future_of_Jobs.pdf">Future of Jobs</a></p><p>· <a href="http://web.a.ebscohost.com.ezproxy.library.uq.edu.au/bsi/pdfviewer/pdfviewer?vid=1&amp;sid=97958312-623f-4348-aba3-85f0669117b5%40sdc-v-sessmgr02">How to Embrace Change Using Emotional Intelligence, Harvard business review, by Kandi Wiens and Darin Rowell, December 2018</a></p><p>· <a href="https://www.inc.com/ryan-jenkins/this-is-most-in-demand-skill-of-future.html">This Is the Most In-Demand Skill of the Future: The future of work belongs to those who possess emotional and social skills. Here’s why</a></p><p>· <a href="https://www.forbes.com/sites/bernardmarr/2019/04/29/the-10-vital-skills-you-will-need-for-the-future-of-work/#12e1f3fa3f5b">10 vital skills you need for the future of work</a></p><p>1. Creativity</p><p>2. Emotional intelligence (EQ)</p><p>3. Analytical (critical) thinking</p><p>4. Active learning with a growth mindset</p><p>5. Judgment and decision making</p><p>6. Interpersonal communication skills</p><p>7. Leadership skills</p><p>8. Diversity and cultural intelligence</p><p>9. Technology skills</p><p>10. Embracing change</p><p>· <a href="https://en.wikipedia.org/wiki/William_James#Pragmatism_and_%22cash_value%22">William James 1900 psychologist — </a>“The greatest discovery of my generation is that human beings can alter their lives by altering the attitudes of their mind”</p><h3>How important is this skill in the context of learning FM?</h3><p>A successful financial modeller needs to be able to listen to someone’s conceptual vision, extract the important elements and model the relationship between the key drivers and the outcomes they want to achieve.</p><p>Often this means working with incomplete data, particularly relevant for SME’s, where data may not be available due to immature data and IT architecture or when entering into new markets where data sets are small or non-existent.</p><p>The lack of data causes a lot of grey to emerge requiring the modeller to fill the gaps and make assumptions.</p><p>The realisation that even with accurate data no model is 100% accurate and the value is in the relative outcome compared to the absolute. It’s the value on the what-ifs and various scenarios that we can find some tangible benefits.</p><p>To get more comfortable with this grey when building a model one should focus on the following key elements:</p><p>· <strong>Structure: </strong>Making sure you invest the time to build it in the simplest way possible with assumptions and outputs that allow the user to follow the logic (and spot logic flaws), following the ‘rule of thumb’ and inbuilt error checks. Look out for more on this soon.</p><p>· <strong>Sensitivities:</strong> The accuracy around assumptions is always going to be grey given the nature of all models. Sensitivities can highlight which drivers have the biggest impact, allowing the user to devote more time to increasing certainty of those key assumptions. Look out for the upcoming article on this.</p><p>· <strong>Scenarios: </strong>Building several different scenarios encourage the mindset that there is never one right answer and the model is merely a fancy tool to calculate the outcomes under a variety of different situations. Make sure you read the article coming soon.</p><p>· <strong>Sense-checking: </strong>Looking at the model’s outputs from 30,000 ft is often very useful, particularly when that 30,000 ft is graphic. It can paint a picture and highlight any issues and reinforce whether the overall results make sense. If you cannot communicate this picture simply and tell the story, you either need to spend more time understanding it or there might be something wrong with the model.</p><h3>How does all this disruption, AI and automation talk impact this topic</h3><p>There is no doubt that technology and innovation is having an impact on our lives and Financial Modelling is no different. The development of certain add-in technologies inside and around Excel will allow the modeller to build out the structural elements quickly and accurately with a fraction of the effort it takes manually. Re-usable pieces of models can now be created, shared and replicated within a few clicks.</p><p>Machine learning allows large data sets to be analysed and for trends to be extracted. These data sets were previously too difficult for the human mind to digest but can now be analysed and modelled so that we can gain hindsight, insight and foresight that will enable further clarity.</p><p>Both of these technologies mean there will be more time to focus on how changes in the business trading conditions impact the financial and predictive models. These may result in potentially increasing complexity of the driver and outcome relationships.</p><p>As a result of these innovations, highly sought-after skills will change in favour of problem solving, critical thinking, creativity and the ability to deal with complexity and ambiguity compared to producing the reports, graphs and financial models in a labour-intensive manner.</p><h3>Table Based Financial Modeling</h3><p>10 September 2019 Written by Craig Hatmaker and Lance Rubin</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/604/0*KnnN3xTnEGr1ZJjK" /></figure><h3>Introduction to the co-author</h3><p>Craig lives in the US which is why he says he “spells modeling more efficiently ;) ” and the rest of the article is not written in the Queen’s English.</p><p>Craig is an IT executive with strength in systems, but he is no stranger to business and finance. His finance experience started working for a mortgage banker when US interest rates were double digits and debt instruments using the rule of 78s created negative amortization.</p><p>That was a long time ago when he used to model in code (ex. Basic, C, Cobol, etc.) because spreadsheets didn’t exist back then.</p><p>Spreadsheets revolutionized business, finance and modeling and impowered SMEs (Subject Matter Experts) to model on their own much faster than the IT department, which typically lacked the business or finance context, but not Craig.</p><h3>Why did Craig select this topic and why is he passionate about it?</h3><p>Finance SMEs are sometimes ‘spreadsheeters’ because they build models for themselves. When modelling for ourselves we are free to neglect labeling because we know what each value is. We are free to neglect structure because we know where everything is. We are free to use the most complicated, convoluted formulas we wish because we know what they do. We are free to neglect data validation because we know what is and is not acceptable. And if our models have errors, we will fix them as we find them and move on.</p><p>It is not until we have to create solutions for someone else that we realize we need certain disciplines within our spreadsheets. Our Models must be understandable by others so labeling, structure, and simplicity are required. Our models must not have errors so data validation, error checks, and protection are required. And if we model for many different customers, our value can increase greatly if our models are flexible enough to grow and accommodate a variety of situations.</p><p>As someone who models for others, those disciplines are key to my career and one relatively new Excel feature helps me address several of those areas better than anything else: Tables.</p><h3>Topic Introduction</h3><p>To be innovative in any field one must think outside the box. Being innovative is not just about adopting a new piece of technology or helping to develop that new technology but to find different and often better ways to do the same thing we do today but with existing technology.</p><p>This can be far more valuable as we are asked to do more with less and keep a tight leash on all costs. Being innovative and adopting a new approach to the same technology costs nothing other than our time to learn this new way and perhaps suck up a bit of ego and admit there is indeed a better way to do things.</p><p>But of course, we have options and this new way won’t necessarily meet all the requirements achieved in the old way, but nonetheless its worth taking a growth mindset and looking at it closer.</p><p>Lance has seen a table-based modeling approach being used in operational 3-way financial modelling with a high degree of structural integrity and flexibility with rolling data flowing through the model and updating it for changes in logic and line items.</p><p>Lance also publish a 3-way financial model visualised in PowerBI, but his horizontal timeseries model had to be converted into a vertical table format to allow this to occur. PowerBI was only visualising the outputs which were made vertical rather than being able to model all the key drivers within it, which would be possible on a table-based approach.</p><p>If we are going to push the boundaries of our skills today, which is what the SS to FM series is all about, then we need to think of new possible and alternative approaches to explore.</p><p>So let’s get into it.</p><p>Tables can add a ‘physical’ structural element that facilitates organizing our model’s ‘logical’ structure with dynamic ranges that automate formula documentation and consistency.</p><h3>How would you teach this to school kids? What key tips would you give them?</h3><p>To make it simple think “Kind Vertical Lists”.</p><p>As a kid we quickly learn that we have a ‘list’ of all sorts of things in our life. The homework we need to complete, the list of new words we need to learn for spelling at school each week.</p><p>If something has repeating elements, such as a formula that repeats across or down, it probably belongs in a list. Tables are lists inside Excel.</p><p>Think ‘vertical’ (the hardest part for any ‘traditional horizontal’ financial modeller to get their heads around). Lists that go down a page can be converted to tables using CTRL-T. Financial Modelers generally prefer horizontal based models so making this adjustment is not easy.</p><p>Think ‘kind’. Table formulas are more kind to people. They use words instead of cell references. There are literally dozens of attempts in technology development to make formula construction more natural language based so we can reader better rather than having cell ranges with absolute and relative references. As an example, in a column labeled “Gross Profit” might be a formula that reads “=[@Revenue] — [@[Cost of Goods Sold]]” which is much more kind for humans than “=E$24-E$25”.</p><p>Now once you have those Kind Vertical Lists, there are a whole lot of other aspects that you gain from your list.</p><p>Think of the ‘future’ particularly for operational models. Lists typically grow, I know the list our wives give us can grow quickly.</p><p>Time based lists often need more periods, item based lists need more elements such as accounts, products, regions, customers, etc. Tables grow automatically and with ease with little changes required to the overall structure when you add a new item to the list.</p><p>How easily can you add a new item to that horizontal structure of yours with native Excel (without buying software to do it for you)?</p><p>Think of ‘reuse’. Tables are easier to port to other models. Reusing model components speeds model development and drives out errors as we learn from our mistakes and build on our successes.</p><p>Think ‘connections’. Tables can connect to other tables through Excel’s advanced features: Data Model, Power Query, and Power Pivot. Connecting reduces formula count which reduces potential failure points and suddenly sees the often talked about merging of the two disciplines of Financial Modeling and Data Analytics.</p><p>Think ‘integrated relationships’. Table are like a flexible glue. Tables help ensure that formulas and references remain connected, easily integrating new data. Writing one formula copies it down a whole column and reduces the need to go back and copy formulas down to include the new data.</p><p>The two sides of the same data coin but often poles apart in thinking. Can we bring them closer together?</p><h3>What practical steps can modelers take to learn more?</h3><p>Craig has kindly provided (for free) a practical comparison of the traditional horizontal 3-way financial model to the table based financial model.</p><p>Here Craig compares a traditional three statement financial model offered by the Corporate Finance Institute’s (CFI) for download to a functionally equivalent Table Based Financial Model built by Craig’s company Beyond Excel (BXL). The model that CFI offers for download follows their single worksheet layout. CFI is well aware of multi-worksheet layouts so I assume they offer the single worksheet version because it is easiest for beginners to understand. BXL standards require multi-worksheet layouts to keep inputs separate from processes and outputs so the BXL model is more complex for this reason alone and not due to it being table based.</p><p>However, on the plus side, the table version is fully dynamic, self-documenting and structured in reading order. You can find both models in the Links and Resources section below along with a comparison of the outputs.</p><p>This first step proves that a 3-way Financial Model can indeed be functionally converted to a table based financial model. The next step demonstrates how tables are better for addressing multidimensional scenarios. Examine Craig’s entry to Paul Mireault’s Multidimensional Spreadsheet Challenge presented at the last EuSpRIG conference. Craig’s model leverages tables, Power Query, Power Pivot, Pivot Charts and Slicers to create a dynamic model with BI like interactions. The user experience can be enhanced with an optional add-in: Appify.xlam. Find links to the challenge, the model, and add-in in the <em>Links and Resources</em> section</p><p>To learn more about Craig’s methodology see BXL’s (under construction) online Advanced Excel Modeling curriculum. See <em>Links and Resources</em> section.</p><h3>I’ve heard this before from Craig and you guys don’t get it this is analytics not modelling?</h3><p>Craig says modeling with analytics is far more valuable than models without. Consider the mult-dimensional model for Paul Mireault’s challenge. In the challenge’s requirements we could see which month lost money, but we could not see in which sector. Craig changed the model from using aggregated data to detail data by allocating costs down to each transaction. The results of this new model produced identical results AND added the ability to determine profitability by any dimension revealing which sector caused that loss (click Sectors’ slicer tab for results). Modeling without analytics shows gains and losses. Models with analytics reveals why.</p><p>This is a topic that has been investigated before at length and many a financial modeler has probably had robust discussions with Craig on this approach in social media or directly and nothing has changed. Lance too saw Craig’s approach many years ago, but he also failed to see its benefits until now. So what’s changed?</p><p>Let’s take a step back and consider for a moment any traditional industry that doesn’t cater for customer’s user interface (UI) and user experience (UX).</p><p>All well-constructed financial models of complex multi-product, currency and division can be reasonably difficult to navigate and understand, even with a hyperlinked table of contents.</p><p>Dashboards can of course give you further transparency but to distribute that knowledge widely in an operational sense for say monthly rolling forecasts then you have spreadsheets flying everywhere.</p><p>So if you wanted to distribute the outputs of a robust 3-way financial model on mass and enable the user to slice, dice and investigate it closer without opening Excel, then you have issues around version control etc if everyone were trying to use the same Excel file.</p><p>With the advances in Excel’s own data modeling capability and its integration with PowerBI means that this distributed operational dashboard reporting is indeed possible.</p><p>Does the user really care about how the formulas are constructed, or just the engineer who built it?</p><p>What if it gave them the exact same answer? Do they really care?</p><p>Does the user really want an easy to use, visually appealing presentation of the model with its outputs and key assumptions?</p><p>When you buy a smartphone, or an app, do you ask to look at the coding language or just whether it looks good and works?</p><p>What if more IT experts, like Craig, were to learn more about accounting and finance and apply this table based scalable approach, would you still need the traditional modeler of today?</p><p>If we are going to truly move the Financial Modeling industry forward we should be open to alternatives. This isn’t about killing the old horizontal approach of model building but being open to alternatives.</p><p>In fact, it probably doesn’t really make sense for deal modelling to use this approach as there isn’t a lot of new data rolling through the model on a regular basis and the items tend to be reasonable stable through the life of the model building process. Perhaps a few tweaks here and there.</p><h3>Links and resources on tables and models</h3><p><a href="https://corporatefinanceinstitute.com/resources/knowledge/modeling/3-statement-model/">CFI’s Three Statement Model:</a></p><p><a href="https://www.dropbox.com/s/60eagh8cy89r93d/BXL3Way.xlsx?dl=0">BXL’s Recreation of CFI’s Three Statement Model:</a></p><p><a href="https://www.dropbox.com/s/87lk66whapqcc1s/BXLModel%20PowerQuery%20And%20Pivot%20Charts%20Appified.xlsx?dl=0">Multi-Dimensional Spreadsheet Challenge — Excel Model (xlsx):</a></p><p><a href="https://www.dropbox.com/s/vyt8ph5b3r1uqmv/BXL%20Model.pdf?dl=0">Multi-Dimensional Spreadsheet Challenge — User Guide (PDF):</a></p><p><a href="https://support.office.com/en-us/article/using-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e">Using structured references with Excel tables:</a></p><p><a href="https://arxiv.org/abs/1802.01628">Proposed Spreadsheet Transparency Definition and Measures:</a></p><p><a href="https://sites.google.com/site/beyondexcel/project-updates/advancedexcelmodeling-introduction">BXL’s Advanced Excel Modeling Curriculum:</a></p><p><a href="https://alfapeople.com/uk/makes-power-bi-market-leader-according-gartner/">What makes Power BI the market leader according to Gartner:</a></p><h3>Lets take a closer look at the 2 modeling approaches</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*UNTjqJFIL3kjZoEY" /></figure><p>So we can see from an output perspective the 2 models are exactly the same, but under the hood they are quite different.</p><p>Below is an even deeper look at the model and formula construction and flow along with identified key statistics like number of unique formulae.</p><p>CFI Model Analyzed</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/759/0*hXzBHuzvCCC2ZCBw" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Zpv0f0L0BWvuirrV" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/955/0*1I8kEQcj92-DDE0L" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*--wf9x17eBXaIOAu" /></figure><p>BXL Model Analyzed</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/754/0*coyKKCeUYsYJV_-8" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*PvJxFU7801mMFTKj" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/653/0*GhfnWQJWorobg8Zb" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*2dSSvoIcoKzL8fwx" /></figure><p>Whilst the CFI model uses no tables and pivot charts, has less formulas (unique and total) and arguably a simpler model in flow and design it isn’t scalable for future changes to new line items unlike the table based approach which is dynamic around new data.</p><p>The detailed analysis seen above of both models can be <a href="https://www.dropbox.com/sh/zgjvwgbhe64pd8a/AADJH90zYzASpKMXME1H3hKOa?dl=0">downloaded here</a>.</p><p>How important is this skill in the context of learning FM?</p><p>Tables greatly improve model flexibility, reusability, understandability and transparency which can drive out errors and can cut model building time. Tables work well with Power Query which we can leverage to download the most recent historical records/actuals instead of error-prone, time consuming, hard-to-keep-current hand keying.</p><p>Power Query can also replace a sea of LOOKUP formulas reducing potential failure points and improving reliability (but the recently released XLOOKUP could help too).</p><p>Tables work well with Power BI which we can leverage to present our models to anyone on any device, anywhere on the planet.</p><p>How does all this disruption, AI and automation talk impact this topic?</p><p>Microsoft is fighting, and appears to be winning, for dominance in the BI space (see image below)….oops another list.</p><p>This fight introduced into Excel: Tables, the Data Model, Power Pivot, Power Query, and Power BI.</p><p>These are extremely powerful tools that are responsible for catapulting Microsoft to the top of the BI space. While aimed squarely at data analysis, we can leverage these features to add data analytics to our financial models giving our customers insights into what might be hindering meeting their financial objectives and what changes can optimize those results.</p><p>But adding these tools and the table based financial modelling methodology requires dramatic changes in the current modeling standards. Table based Financial Modeling is currently incompatible with the most popular industry standards such as FAST, Corality, BPM, Operis, etc.</p><p>But just as digital replaced film, disruptive technologies and innovative thinking typically push old standards aside. Craig believes we may very well be witnessing a “Kodak Moment” in Financial Modeling with old methods giving way to Financial Modeling merged with BI.</p><p>Time will tell.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/0*ryxfySPDmi2cwrwE" /></figure><p><a href="https://www.experfy.com/blog/a-comparison-of-tableau-and-power-bi-the-two-top-leaders-in-the-bi-market">Experfy: A Comparison of Tableau and Power BI, the two Top Leaders in the BI Market</a></p><h3>Excel Spreadsheet vs Excel Model for FP&amp;A</h3><p>19th September Written by Cindy Rogers and Lance Rubin</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/959/1*dbDmDrvl9BX1GUo0neNihQ.jpeg" /></figure><h3>Introduction to the co-author</h3><p>Cindy is a CPA and FP&amp;A (Financial planning and analysis) practitioner with senior technical and leadership experience, mainly in Canada’s Energy sector.</p><p>She has worked at small private companies to larger multinational public companies in various capacities including supporting strategic initiatives, leading budgets and forecasts and implementing business improvement processes.</p><p>She has been involved with the Association for Financial Professionals (AFP) since 2012, writing and reviewing exam questions for the FP&amp;A certification exam.</p><p>She believes in continuous learning and sharing of expertise and experience, which is why she decided to join as a Director on two Boards. One is a non-profit organization with a cause she is passionate about; providing mentorship and assistance to new immigrants to help navigate the Canadian job market in hopes of successful employment. The other is a profitable start-up fitness studio with a national presence in Canada.</p><h3>Why did Cindy select the topic and is passionate about it?</h3><p>I have worked in the FP&amp;A area most of my career and find this to be the most rewarding area of Accounting and Finance. FP&amp;A provides the finance professional the chance to be a business partner leading and supporting strategic initiatives across the entire organization. Providing models that integrate financial data to drive operational decision is very rewarding. A key function of an FP&amp;A practitioner is providing the model (mostly in Excel) as a mechanism for liaising between Accounting and Operations to drive better decisions and value creation.</p><h3>Topic and context in no more than 3 sentences</h3><p>The simplest way to describe the difference between a spreadsheet and a FP&amp;A model is that the spreadsheet is the simplified tool to manipulate and report data whereas the model can be used to test assumptions, predict and analyse future outcomes of business decisions.</p><p>The spreadsheet can therefore be very static generally whereas the model will be dynamic around decision making.</p><p>An FP&amp;A model should be structured with assumptions and outputs that provide the reader with useful information that guides decisions that would either mimic the actual business or predict what the business would look like if certain key financial decisions were made.</p><h3>If you had to teach this topic in a class to school kids what key tips would you give them to focus on</h3><p>The first would be to focus on Financial literacy (knowledge and understanding).</p><p>Understand the interrelationship (think puzzle pieces) of the financial statements (think lots of numbers on those puzzle pieces) and how to build forecasts and assumptions for each business decision (think of future dreams and stories).</p><p>For example, if the company is increasing how much it spends (e.g. capital expenses), how would that affect their profit (income statement), their financial position (balance sheet) and how much money they made or need to make (cash flow)?</p><p>The FP&amp;A model (think big calculator), would then need to link all those pieces and tie them together (think marriage), happily ever after.</p><p>Next would be Business acumen.</p><p>In the FP&amp;A model it can be different for every company depending on the business model (think different shops or candy stores).</p><p>You don’t need to know the technical aspects of your business, but you’ll need to know the drivers, business environment and risks (think about all the people that visit the shop and what they buy).</p><p>Next would be focusing on Communication skills.</p><p>If you are going to be a good FP&amp;A modeler (think builder of a house) being able to work with others (like the electrician, plumber etc.) and extracting the right information required for the assumptions is important. In the FP&amp;A model (think of the plans to build the house) a key to building a useful FP&amp;A model would be people can use (think understanding the plans and live in the house).</p><p>Aside from clear verbal and written communication skills, a good FP&amp;A model’s logic and flow should be easy to follow and aesthetically pleasing (think well landscaped castle with clear entrance gate).</p><p>Next would be your Aptitude for Technology (think going to school on a hover board not in a car).</p><p>Strong excel skills are essential to ensure the most efficient formulas are used so that you can spend more time on analysing and communicating the results rather than manipulating and reconciling data.</p><p>Being able to get up to speed quickly on different software applications is important so that you can navigate through different systems and extract or link the right data to the FP&amp;A model is just as important.</p><p>Lastly would be Data integrity (having all the correct game pieces for your board game)</p><p>If you are going to build a house, the land that you are going to build on needs to be clean and all trees or rubbish removed. It must be organized and ready to be used. There are often many things that can change during the process and will need amending, so ensure your model versions are backed up and saved so you can tell the story of why you did what you did if someone asks you.</p><p>Each version should show clearly defined changes and supporting back up (emails, meeting notes etc) from the group or people providing the changes in assumptions.</p><p>If you are missing game cards for your board game, it won’t be good.</p><p>As the builder of the model (house) it’s your responsibility to ensure things don’t go wrong. There should be built in checks and balances in your model so that the data you’re using does not have errors (mistakes) otherwise the output could be materially incorrect (roof caves in or you can’t finish your game).</p><h3>What practical steps can people take now to learn more</h3><p>At a minimum, take some accounting courses so you understand how each assumption affects the various financial statements.</p><p>Even though the FP&amp;A model is forward looking, you need to understand what happened in the past so that your financials carry forward in the appropriate places.</p><p>Learn about the business and the company’s strategic direction.</p><p>Build trust and get to know people from the Sales or Operations team (other departments depending on your business). You’ll need their input for assumptions into the model and they’ll need your help with financial impacts to those assumptions.</p><p>Brush up on your Excel skills and be open to continuous learning.</p><p>Be flexible.</p><p>Once a model is built, it can always be refined and improved upon.</p><p>Keep it simple.</p><p>When building the FP&amp;A model, have a mindset that this model will be used by another person. The most complex formulas that only you can understand may be fun and fancy but does not necessarily result in more accurate forecasts.</p><h3>Where are good places (links) to find out more on the topic</h3><p>The following links are useful to find out more</p><p><a href="https://www.afponline.org/">https://www.afponline.org/</a></p><p><a href="https://www.mrexcel.com/">https://www.mrexcel.com/</a></p><p>Your company’s management discussion and analysis (MD&amp;A) or another company in the same sector as your company might be private or doesn’t produce one. This would help with business acumen and partnering.</p><h3>How important are these skill in the context of learning FM?</h3><p>These are some of the core skills required in the context of learning financial modelling.</p><p>Ability to create an FP&amp;A model and communicate financial data is a key component of financial modelling and driving better decision making and value for the company and its stakeholders and customers.</p><h3>How does all this disruption, AI and automation talk impact this topic</h3><p>Ideally AI and automation will be a key part of FP&amp;A everywhere.</p><p>It would be a powerful thing to combine this with the FP&amp;A model.</p><p>AI could support and provide real-time data, improve the quality and speed of the FP&amp;A function so that the FP&amp;A Professionals have more time to analyse and tell the story.</p><p>I see this as a complement to the FP&amp;A function and can level up the skills of financial modellers.</p><p>The FP&amp;A model is dynamic, constantly changing and pulling in from different data sources, therefore this is just another change (albeit huge) that FP&amp;A can embrace and transform into a more skilled resource for the company.</p><p>If you want to find out more and follow the rest of the article series be sure to download the <a href="https://fmwiki.glideapp.io/">Financial Modelling App</a></p><p>If you want to find more information on financial modelling and content visit the <a href="http://www.model.citizn.com/">Model Citizn website</a>.</p><h3>History of Spreadsheets &amp; Financial Modelling</h3><p>8 October 2019 written by Dave Theron, Colin Human and Lance Rubin</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XyBmZA3Q1c5arBJYyLs3cA.png" /></figure><h3>Introduction to the co-authors</h3><p>Colin Human</p><p>My first introduction into financial modelling was in 1978 when I was the Group CEO of an aluminium company in SA. We were expanding the business both geographically and across the product range. This resulted in internal cash generation being insufficient to fund the growth.</p><p>Our banker (Conrad Strauss subsequently Chairman of Standard Bank) suggested that we needed to do some longer-term financial planning. Enter my friend Dave Theron.</p><p>Dave and his partner Dieter had formed a business called Decision Information (1973) to build financial models. In those years, there was no Lotus 123, or Excel and I seem to recall the use of products such as Quatro Pro and VisiCalc. Subsequently Dave embraced Lotus 123, and I think became the Lotus distributor in SA.</p><p>In 1978, I convinced him to become the Group CFO for Kool Aluminium with the specific goal of building a model. Patently at that time, I knew nothing about modelling, and he was the model builder.</p><p>We used an ICL programming language called Prosper — and punch cards — and ran the model on a big mainframe.</p><p>So, my participation was to supply him with all the key drivers of the business case, which he converted into the model.</p><p>Obviously given my involvement in the model build, I did learn a little about Lotus and spreadsheets.</p><p>In 1980 I resigned and started my own company utilising some of my fledgling modelling skills.</p><p>To the best of my memory, Excel was launched in South Africa in 1985 and initially was nowhere near as good as Lotus. By this time, my new company had taken over Kool Aluminium and I was once again at the helm. My business focus was sales and marketing and operations — more so than finance and modelling.</p><p>Dave had moved on, and finally in 1989 I sold the company and retired @ 46.</p><p>I then got deeply involved in other companies, ceramics and granite and some private equity and capital raising from 1989 to 1998.</p><p>I was using Excel for my own purposes to build strategic planning and budgeting models for these companies.</p><p>Only in 1999 did I deliver my first financial modelling training course to the Kuwait Investment Authority at Dave’s behest.</p><p>My involvement in financial modelling and training courses was quite irregular in the late 90’s and early 2000’s — basically filling in for Dave when needed.</p><p>All course material was his creation as where the Excel files and training models</p><p>Dave Theron</p><p>In 1971 I was employed by a company called Illings (Mazda) as their “Profit Planning Accountant”.</p><p>On the day I took up my post my boss, the Financial Director, and the Managing Director set off for a month’s stint in Japan. As he was leaving, my boss handed me a manual from ICL computers called Prosper with the remark that he really did not know what it was about, but it might help me.</p><p>Having no real clue as to what a “Profit Planning Accountant” did, I spent many hours in the CA library doing research (no Google in those days) and came across the concept of financial modelling. Only then did it begin to dawn on me that the book I had been handed was ICL’s manual on a punch card-based financial modelling language which they called Prosper.</p><p>There was only one person in South Africa who knew anything about Prosper (but nothing about accounting or financial modelling), and that was a computer geek employed by ICL by name of Barry Strong. With his help I built my first financial model for Illings (from production floor to balance sheet and cash flow) and presented it to my bosses on their return from Japan. This made quite an impression, and my status was upgraded to “Corporate Planning Manager”, with an increase in salary and a Mazda RX2 at my disposal.</p><p>Three years later my boss was headhunted by BMW as their financial director in South Africa and he took me along with him as BMW’s Financial Controller. I built BMW (SA)’s first financial model.</p><p>After a year or so (and still being very much in contact with Barry Strong) I decided to leave the big corporate life. Barry Strong, his colleague Dieter Schaeffer, and I formed a company called “Decision Information” to exploit this thing called financial modelling.</p><p>This was hard going at this time as we first had to sell the concept and then our services</p><p>The term “financial modelling” was unknown at the time, though, in fact, accountants had been preparing financial models (in the form of budgets) for years. Most companies prepared their budgets every year, by hand with pencil &amp; paper, and it was a huge task.</p><p>Very few companies also projected their balance sheets into the future, (let alone their cash flows) as this was a very time-consuming task.</p><p>Whilst the budget was an attempt to represent a company’s income statement projected into the future (and thus a type of model), because everything had to be done manually, making “what-if” type of changes (e.g. what if there is a change in the foreign exchange rate), or interrogating the budget, was just not practical.</p><p>Technology just did not exist to turn these pencil &amp; paper budgets into real models where assumptions could easily be changed and the effects on the company’s bottom line be measured in an instant, thus tempting one to test the effect of various changes.</p><p>During the 3 years we were active in Decision Information we were lucky enough to meet three (what I called) enlightened managers who gave Decision Information their first contracts.</p><p>The first was one Malcolm Macdonald who had been seconded to a company called Ferrovorm by the IDC (Industrial Development Corporation) as their financial director. (Malcolm went on to become the financial director of the IDC, and later Iscor). The second was Colin Human, the CEO of Kool Aluminium, who quickly grasped the concept of modelling and attended our very first “Prosper” modelling course. The third was Rob Jeffrey, the CEO of Irvin Chapman (later the MD of Econometrix).</p><p>After 3 years the three partners decided to mothball Decision Information, and I joined Colin Human as the financial director of Kool Aluminium (Tvl). I was with him for another 3 years and then left to exploit financial modelling on my own. During this period, I developed courses on financial modelling and at the same time teamed up with Chris Leal as a shareholder of Spartan Computers with the intention of using financial modelling as a vehicle for selling Apple and IBM PCs.</p><p>After twelve years of this I again headed out on my own (first taking a 3-month “vacation” to sail across the Med from England to Greece with my wife and friend and his wife in his 37 foot Moody yacht that he had just had built for himself in Plymouth, England.</p><p>On my return to South Africa in 1992 (now running courses in financial modelling as well as building models) I worked very closely with the two professors of accounting at Wits university. It was here that I became of the opinion that success in business is a combination of grasped opportunities and luck, as, at this time, a company specialising in conferences (AIC) contacted the professors and asked them if they knew anyone who knew anything about financial modelling. They responded that they did and referred AIC to me. Then, whilst running the first financial modelling course for AIC, their Singapore office contacted them and asked them if they knew anyone who knew anything about financial modelling. And so, began a journey for me that took me all around the world running courses in financial modelling for many years.</p><p>Probably the biggest challenge for me at this time was keeping the courses up to date with technology changes from the punch card based Prosper to program-based EPS and then spreadsheets Lotus 1–2–3 and Excel.</p><h3>Let’s look a little closer at this history (by Theron)</h3><p>Around 1971, ICL (International Computers Limited, the huge British computer company) introduced a piece of software to South Africa called Prosper.</p><p>This was in fact a high-level language designed to run on the large ICL computers (in those days a large computer had a memory of 64k!), and, I believe, originated during world war II to control Britain’s radar installations. Its purpose was to enable end-users to “build” models.</p><p>Prosper was designed to accept inputs, process them with user-input formulas, and report on the results.</p><p>Thus, the system required one to construct the model in 3 sections — a section containing “Inputs”, a section containing the calculations (the “Logic”), and a section containing the output the “Report”.</p><p>In those days one communicated with a computer via punched cards.</p><p>A punched card would typically consist of 80 columns and 10 rows (the first row being row 0)</p><p>A Prosper model would basically consist of three categories of cards:</p><p>1. “Input cards”: a “format 4” card (meaning that the very first hole punched into the card would be in character position 1 in row 4)</p><p>2. “Logic” cards: a “format 5” card (meaning that the very first hole punched into the card would be in character position 1 in row 5). These cards contained the formulas that were required to process the Inputs and create results.</p><p>3. “Report” cards: a “format 9” card (meaning that the very first hole punched into the card would be in character position 1 in row 9).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/526/0*pjaKv39Mm2JmSj-0" /></figure><p>Doing a “What-if” required one to finger one’s way through all the format 4 cards (which formed the bulk of the model), identify the one you wish to change, remove it, punch a new card, replace the card you removed, and feed them all back into the computer.</p><p>In the early days one had to learn to read the punched holes to identify the card, but later with the advent of the print punch, the details would be typed along the top of the card, making identification much easier.</p><p>The sequence of the format 5 and format 9 cards was critical. If the cards were inadvertently dropped it could take hours to get them back in sequence before feeding them into the computer.</p><p>One of my first Prosper models was a departmental budget prepared for Ferrovorm (an IDC company), and consisted of 40,000 cards, 30,000 of which were the untyped input (format 4) cards. Doing a “what-if” was a real mission just to find the relevant card! It then took 3 hours to load the cards, and another 3 hours to calculate the model. 6 hours for 1 run!</p><p>Around the middle of the 70s saw the introduction of terminal-based modelling systems, meaning that communication with the computer was done via a keyboard on a terminal. This was a huge advance as one no longer needed to load thousands of cards into the computer and calculation times were significantly improved — minutes rather than hours. The terminals could either be on-site or remote. The first remote terminal I used was a “Silent 700” manufactured by Texas Instruments in the USA and could communicate over the normal telephone lines (provided there was no “crackle” on the line or thunderstorms in the area). One would dial up the mainframe computer on your telephone and when hearing the signal, quickly plug it into the rubber cups on Silent 700.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/129/0*rpWLs6tFAyqB5Bl8" /></figure><p>Silent 700</p><p>Spreadsheets were still unheard of at that time, so the modelling systems were high-level programming languages. The two available at that time were FCS (later changing its name to EPS) and available on the IBM mainframe computer, and IFPS, available on the ICL mainframe computer. The main difference between the two was that FCS calculated row-by-row, and IFPS column-by-column.</p><p>Models built in these languages needed big mainframe power, only available in computer bureaux or large companies. For us at that time it meant buying computer time from companies like Old Mutual and Currie Motors from midnight to 8am (if we weren’t working through a computer bureau which was expensive). One run of the model I built for the JD Group would cost R100,000! (But still they felt it was worth it).</p><p>Then around 1980 along came the Apple II computer, with memory upgradeable to 64k. Around the same time a modelling language called Micromodeller made its appearance.</p><p>To my amazement the Micromodeller “language” was the same high-level language as EPS — but it ran on an Apple! A lot slower, but so what! The Apple computer and the Micromodeller software sold for a once-off sum of around R6500!</p><p>With the advent of the Apple came the very first spreadsheet — Visicalc — comprising 8 columns and 64 rows and only available on the Apple. At this stage it really was only a “Visible Calculator” but this heralded the advent of the spreadsheet.</p><p>Microsoft tried to persuade the authors of Visicalc to make the software available on its operating software — PCDOS (becoming MSDOS) — but they did not or could not. This opened the way for Lotus 1–2–3 to jump into the gap.</p><p>The first Lotus 1–2–3 spreadsheet was still only a one-sheet system, but with 64 columns and around 1024 rows, significantly enhanced from Visicalc. (It was created by a former employee of Visicalc).</p><p>Lotus 1–2–3 became the de-facto modelling spreadsheet of the time followed several other rival spreadsheet programs, e.g. Framework, Multiplan, Supercalc. Excel, and Quattro-Pro (Lotus’ main competitor).</p><p>Then IBM (who had acquired Lotus) made the decision to move away from desktop applications and concentrate on its communications software (Lotus Notes), and this opened the door for Excel.</p><p>Today Excel is the de facto modelling system worldwide.</p><h3>How have people evolved (or not) using Excel? Are things getting better or worse as the proliferation of spreadsheets grows with the work force?</h3><p>According to Human, “Depending on the level of tertiary education, whether it was financial in nature, their post study experience, profession and their activity in their current employment — whether financial or not, we find quite a significant variance in modelling knowledge.”</p><p>Typically, most trainee delegates overestimate their Excel knowledge and capability — miss construe their knowledge of Excel (data management and data manipulation) — and often are deficient in those specific functions applicable to financial modelling.</p><p>The knowledge of basic accounting, financial statements and corporate finance theory varies wildly dependent on tertiary education, profession, and involvement in matters of corporate finance.</p><p>Given the (sad) lack of education pertaining to financial modelling at our universities and in the profession (SAICA, CIMA, CFA) etc., it is quite understandable the area of least knowledge and competence is financial modelling best practice methodology.</p><p>Hence the creation of certification institutes like the Financial Modelling Institute.</p><p>Human concludes, “Provided that aspiring modellers have been on a quality training course, I think that they are getting better at modelling and the application of best practice modelling methodology.”</p><h3>How has functionality improved over that time (Excel and other tools) to support Financial Modelling?</h3><p>Both Lotus 1–2–3 and Excel were originally 1-sheet spreadsheet systems and were competing with the more powerful and flexible financial modelling program-type systems (EPS, IFPS &amp; Micromodeller).</p><p>Spreadsheets, however, were easier to understand, and their popularity increased, urging Lotus 1–2–3 (at that point the most popular package) and Excel (nibbling at Lotus’ heels) to enhance their systems. Lotus’ response was to bring out multi-sheet spreadsheets (now calling them workbooks), thus increasing the dimension of the spreadsheet from 2-dimensional to 3-dimensional. Excel followed suit, improving on Lotus’ offering dramatically. (In Lotus it was initially not possible to group the sheets and insert formulas into all the grouped sheets at once. If you did group the sheets, all the sheets in the group took on the characteristics of the 1st sheet in the group, often resulting in an unholy mess).</p><p>Then came the facility to link workbooks by formula — a major advance in spreadsheet technology.</p><p>Around 2003 Lotus 1–2–3 emerged with its own macro (programming) language as part of its spreadsheet offering. This improved its functionality, and it became a real contender to the program-type of modelling system. Excel shortly followed suit with its macro language. This original macro language (now known as “Excel 4 macro language”) still exists in Excel but is no longer supported by Microsoft — so no help screens available. A pity, in my opinion, as this macro language is far easier to understand than VBA. (I still use it in preference to VBA).</p><p>As the memory in PCs increased, so did the size of the spreadsheets. Today Excel spreadsheets are limited only by the memory of the computer.</p><p>The ability to link Excel spreadsheets to other Microsoft applications (like MSWord) further enhanced their functionality.</p><h3>What’s the single thing that remains critical as the rise in demand for Financial Modelling increases?</h3><p>According to Theron, “As far as building good models is concerned, knowledge of model structure is still a limiting factor, as people still tend to do things like hard-coding data, do not use drop-down lists to minimise errors of input, do not display warning messages, etc.”</p><p>According to Human, “Of course, the very first step in building a successful model is to really understand and comprehend the business case.”</p><p>There are four main building blocks for successful financial modelling, namely: -</p><p>a. Essential Excel for financial modelling</p><p>b. Basic accounting and financial statements</p><p>c. Corporate Financial metrics and evaluation processes</p><p>d. Financial modelling best practice methodology”</p><p>The structure of the model and the need to understand the implications of changing the input data appears to be the most critical aspect of understanding Financial Modelling.</p><h3>Where are your good places (links) to find out more on the topic</h3><p>Given the wildly ranging skills in financial modelling, Colin’s financial modelling training company Goalfix Financial Modellers — introduced the “<a href="https://www.goalfix.co.za/courses/course-selector/">Course Selector</a>” on their website.</p><p>It is simply a method to assist delegates to understand “where they are” when it comes to modelling.</p><p>There are also numerous other training providers on the <a href="https://fminstitute.com/atp/">Financial Modeling Institute (FMI) website</a> which includes Model Citizn, Plum Solutions amongst others in Australia and around the globe.</p><p>There are also a fair number of financial modelling templates and example models both paid and free on the <a href="https://www.eloquens.com/">Eloquens website</a> which help with showing what a good model looks like.</p><p>If you want to get a bit more technical in the financial modelling space download the <a href="https://www.icaew.com/-/media/corporate/files/technical/information-technology/excel-community/financial-modelling-code.ashx?la=en">Financial Modelling Code</a> or wait for the upcoming series with Kenny Whitelaw-Jones on Financial Modelling standards.</p><h3>How important do you think the skill of Financial Modelling is in today’s business world (by Human)?</h3><p>In our (early) days, there were no rules, no conventions, no guidelines — it was all homespun.</p><p>Today there are a number of recognised financial modelling standards and codes of best practice namely F1F9 (FAST Standard), Financial Modelling Code (ICAEW), Corality (SMART) and Best Practice Spreadsheet Modelling Standards (BPSMS) and a plethora of approved training providers per the Financial Modeling Institute <a href="https://fminstitute.com/">website</a> .</p><p>All the trainers employ a best practice methodology and many of whom publish free guidelines available on the internet. Additionally, you can purchase model templates from Eloquens, eFinancial Models and CFI to name a few as well as getting access to free templates.</p><p>Understandably, if the “modeller” has never seen a properly built model and doesn’t work with “proper” models built by colleagues, the process is something new and not always intuitive.</p><p>Self-education is available to all in the modern world — and serious practitioners of modelling have numerous sources of information and aids available.</p><p>Of course, too much, too easy doesn’t always make for success. You need to ride the bicycle to get good at it.</p><p>There is becoming a much greater awareness about financial modelling globally and the benefits of properly built, flexible financial models.</p><p>350 people attended Human’s presentation at the Finance Indaba in South Africa, the most he had seen in a long time wanting to learn more.</p><p>Human supports the FMI and the different levels AFM (L1), CFM (L2) and MFM (L3) that they offer, given its importance and believes financial modelling should be a professional qualification, like the CFA qualification for investment and banking professionals.</p><p>Financial modelling should become a corner stone skill for all accounting and finance professionals heading into the digital era.</p><h3>How does all this disruption, AI and automation talk impact this topic</h3><p>Despite the development of automation in many areas, including financial modelling, the skill of understanding Excel, Accounting, Finance, Business and Problem Solving is still very much human led.</p><p>Design thinking and customer centric problem solving will not go away anytime soon (both human focused) and the fact remains there is no AI that can build an integrated 3-way financial statement model means that humans will still be required in building and using financial models.</p><p>Whilst technology will enable us to build models quicker and visualise them in ways we have never done before using software like Modeler and PowerBI if anything humans with the skills of financial modelling are still very much in demand in today’s digital world with all the data we have access to.</p><p>The inter-connectedness of data via APIs will even further accelerate this demand for a combination of data science and financial modelling where these skills start to converge.</p><p>If you want to find out more and follow the rest of the article series be sure to download the <a href="https://fmwiki.glideapp.io/">Financial Modelling App</a></p><p>If you want to find more information on financial modelling and content visit the <a href="http://www.model.citizn.com/">Model Citizn website</a>.</p><h3>Deal Model vs Operational Model</h3><p>17 October 2019 written by Ruby Liu and Lance Rubin</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1zEWamfOcZ0CSiHASS9EQw.jpeg" /></figure><h3>Introduction to the co-author</h3><p>Before joining the KPMG Australia valuation team, Ruby has over 11 years of commercial and training experience from a statistics tutor at the University of Queensland, an authorised trainer for project finance courses, head of KPMG Sydney modelling team, to head of corporate finance at TransGrid.</p><p>Her experience covers financial model build and audit, corporate finance, project finance, and infrastructure valuation.</p><p>She is currently committed herself in infrastructure value enhancement and joined the KPMG Australia valuation team. She is keen to help her clients to further understand key value drivers of their assets and improve both value growth and dividend yield.</p><h3>Why did Ruby select the topic and why is she passionate about it?</h3><p>Through my career I have seen many companies continue to use the acquisition (deal) model as their operational model post financial close. This is not the correct purpose for which it was built in the first place, and can potentially create a significant risk of errors.</p><p>The “re-purposed” models ultimately cause internal frustrations and even incorrect management decisions into the future.</p><p>I am therefore taking this opportunity to share my views on the differences between models created for a particular transaction (“Deal Model”) and ones used in an ongoing manner for business operations and management (“Operational Model”), with the goal of encouraging robust discussions of this topic and improving the usage of both model types.</p><h3>Topic and context in no more than 3 sentences</h3><p>It is important to understand the differences between a Deal and Operational Model, as they are fundamentally designed to meet two different purposes.</p><p>As such this article seeks to answer the questions:</p><p>(i) What is a deal model;</p><p>(ii) What is an operational model; and</p><p>(iii) When and how should each be used.</p><h3>If you had to teach this topic in a class to school kids what key tips would you give them to focus on</h3><p>Before one tries to understand when and how two tools should be applied in practice, it is important to fully understand the purpose of the tools and the design logic behind them.</p><p>What is a Deal Model?</p><p>A Deal Model is designed specifically for a transaction. The purpose of the model is to represent the performance forecast of a project, a company, or a portfolio of assets in a “simplified” version, which then assists management in making an informed investment decision at a point in time.</p><p>A Deal Model usually has the following characteristics:</p><ul><li>Is designed to be (at least should be) used for a singular transaction — i.e. to facilitate a particular transaction to reach a financial close;</li><li>Will be amended multiple times within a short timeframe (both functional and structural changes during the negotiation process of a deal);</li><li>Will be more focused on cash flows primarily instead of accounting treatment or how the numbers will be presented or disclosed in balance sheet; and</li><li>Are often audited as Investment Committee, Banks, and sometimes governments will rely on the model audit report to ensure the model’s integrity.</li></ul><p>What is an Operational Model?</p><p>An Operational Model is designed for a business to manage its ongoing operations where they make either tactical or strategic decisions.</p><p>An Operational Model usually has the following characteristics:</p><ul><li>Will be used repeatedly by the company’s internal finance team on a regular basis for example monthly, quarterly or annually;</li><li>Will be amended multiple times within a long timeframe (driven by changes within the business or reporting requirements from the Boards);</li><li>Will be focused on both cash and accounting; and</li><li>Are often unfortunately not audited independently and left to the internal teams to ensure a “peer” review is undertaken at the very least. In some cases, even a peer review is not done until a material error is identified, then an independent model audit might be called upon when it is often either too late or in a panic.</li></ul><h3>What practical steps can people take now to learn more</h3><p>Now we understand the key differences between a Deal Model and an Operational Model, we should ensure each type of model is used for its designed purpose.</p><p>Based on my experience, almost every Deal Model will be amended many times during a transaction, and it is difficult to determine how that change will manifest at the outset of the transaction. Therefore, the modeller should try to allow maximum model structural flexibility at the beginning of the build.</p><p>In addition, although practitioners tend to focus more on cash flows analysis, accounting is still important in a Deal Model. The level of detail is not required to the extent that we need to cross check with the accounting standards, but the balance sheet MUST balance as an integrated three-way financial model (which is included in almost every deal model).</p><p>Regarding an Operational Model, the first focus in my opinion, should be aligning the business to reality as much as possible.</p><p>In my experience often Deal Models are used as Operational Model post the transaction and include outdated business assumptions or cash flows waterfall logic.</p><p>Those models could provide incorrect analysis, which causes inaccurate strategic decision making.</p><p>Therefore, it is important to consult internal finance teams and other key stakeholders before developing an Operational Model in order to understand:</p><ul><li>The purpose of the model whether this be for simply tracking purposes, scenario and what-if analysis, for meeting any bank covenant, or board reporting requirements;</li><li>Who is responsible for the maintenance and review of the model on a regular basis;</li><li>What is the current business situation the model tries to represent and how this might change;</li><li>What internal control procedures are in place to ensure that the model remains both accurate and fit for purpose; and</li><li>What are the required model outputs?</li></ul><p>Unlike developing a Deal Model, it is critical to do a detailed model specification before building an Operational Model.</p><h3>Where are good places (links) to find out more on the topic</h3><p>We have found that there are very few discussions on the differences and uses of the Deal and Operational Models, which is one of the reasons we chose this topic. It would be good to hear from others who can contribute to the conversation.</p><h3>How important is this skill in the context of learning FM?</h3><p>Deal and Operational Models are two of the most commonly used financial models in business today. Understanding both of these models and their purpose will help people better utilise the skills and models for enhanced decision making and value creation.</p><h3>How does all this disruption, AI and automation talk impact this topic</h3><p>I personally do not think the current technology disruptions will impact the deal modelling. In a deal environment, bespoke analysis is needed to be completed quickly where the structure can change overnight.</p><p>Excel is still the best software for developing Deal Models due to its flexibility and affordable initial cost investment — i.e. I cannot foresee a consortium investing $1m in an artificial intelligence (“AI”) or sophisticated business intelligence (“BI”) system for an early feasibility assessment of a potential investment opportunity.</p><p>On the other hand, operational modelling could be impacted by the current evolving technologies (e.g. AI, machine learning, and automation).</p><p>Excel still has strong advantages compared to other BI software, but I can see large Operational Models being transferred into different BI systems, especially those that need to process large datasets (e.g. daily transactions, etc.).</p><p>If you want to find out more and follow the rest of the article series be sure to download the <a href="https://fmwiki.glideapp.io/">Financial Modelling App</a></p><p>If you want to find more information on financial modelling and content visit the <a href="http://www.model.citizn.com/">Model Citizn website</a>.</p><h3>Project Finance vs other Deal Modelling</h3><p>Written by Matthew Bernath and Lance Rubin</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1000/0*bEdAZXnsrn-uUKPf" /></figure><h3>Introduction to the co-author</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*6GIu6aWTk8u8u1dv" /></figure><p>Matthew is an entrepreneur, engineer, CFA® charterholder, trainer and Excel addict with a love for finance, data science, process optimisation, data visualisation and building businesses.</p><p>As a qualified engineer, Matthew has consulted to five of the largest South African banks and numerous corporates and parastatal.</p><p>He runs regular, highly rated in-house and public Excel, VBA, financial modelling and dashboards training courses. With practical insight and a broad client base,</p><p>Matthew has never been rated less than 5 out of 5 for subject matter expertise.</p><p>Before joining RMB’s Infrastructure Finance division, Matthew was a Director at Seoketso (an advisory, technology and training firm) and prior to that Head of IT &amp; Operations Consulting at a consulting firm.</p><p>As a member of KPMG’s Green IT team, he honed his love for green and renewable energy.</p><h3>Why is he so passionate about the topic</h3><p>Underlying every large deal is a financial model which holds all of the deal complexity, logic and structure in one place.</p><p>I often say that if you understand the financial model, you understand the deal!</p><p>Infrastructure finance involves both financial structuring and building large projects which benefit the public with new roads, renewable energy resources and even new social infrastructure assets like schools, hospitals and police stations to name a few.</p><p>It’s a really tangible form of finance, on the one hand you have a highly structured financial model, but on the other hand you can go and visit the wind farm or ride the train that you helped to finance.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*rGcNDWsCuLvAljbI" /></figure><h3>Topic and context in no more than 3 sentences</h3><p>Project or Infrastructure Finance is arguable one of the most complex forms of financial modelling and the outcome most beneficial for the public, compared to other corporate finance and M&amp;A like an initial public offering (IPO).</p><p>Ask any professional financial modeller and they will agree with this aspect. Until you have built a project finance model, you have not gone beyond the realms of complexity in all areas of modelling as compared to most of the traditional business focused financial modelling:</p><ul><li>Project Finance revolves around the financing of long-term infrastructure construction and operations like roads, bridges, renewable energy projects, specialised real estate and property and many more that make our world work and look like it does today around us.</li><li>The debt and equity funding for projects are often highly structured and long dated (up to 30 years) resulting in them being complex transactions to negotiate and build a model.</li><li>It’s very heavily cash flow based, but is also an audited 3-way model with a balanced balance sheet. The project won’t get funded no matter how good the cash flows look if the balance sheet doesn’t balance and the model is wrong!</li></ul><h3>If you had to teach this topic in a class to school kids what key tips would you give them to focus on</h3><p>To understand why a project finance model (think of a very big Excel spreadsheet, unlikely to be a Google Sheet) is so complex, firstly we must understand project finance.</p><p>Amongst banks and investors it is also known as Infrastructure Finance as infrastructure (roads, bridges, buildings, energy supply, schools, hospitals, police and justice buildings etc) is what it typically finances.</p><p>It’s the really big big calculator with lots of potentially complex formulas to help people decide if they are going to build a road, bridge or even a new power source for people to use.</p><p>When you wake up in the morning you turn on the lights, the power station that supplies electricity for you to do so (and your homework you love doing) has been project financed.</p><p>If it wasn’t for Project Finance we would all be sleeping in the dark (sadly the homework you can’t get rid of that easily)!</p><p>When you go to the kitchen to make breakfast you will be using more electricity. If it wasn’t for Project Finance and the modelling that sits behind it you would have to start a fire to warm up water for tea or coffee.</p><p>Schools are often referred to as social infrastructure and also form part of project finance and likely to have a complex financial model behind it — social infrastructure can also refer to public transport such as trains.</p><p>Project finance is a form of finance that benefits the public at large as its core purpose (its why?).</p><h3>What practical steps can people take now to learn more</h3><p>There is a lot of research on project finance available online, and also many example project finance models and model templates.</p><p>The best place to start is by spending time drilling down into an existing project finance model and understanding how it works, how the distinct construction and operations phases are modelled, how the funding is structured and how revenue is generated and expenses incurred.</p><p>Think of it like unpicking a rainbow ball of wool into each of the different colours before the cat and the kids got hold of it and mixed it up for you.</p><p>A project finance model should (in most, but not all cases) be approached in two parts:</p><p><strong>Construction phase</strong></p><ul><li>Where the project is being built and debt is generally not being serviced (but sometimes interest is serviced by drawing down on the debt). This is often referred to as interest capitalisation.</li><li>The interest during construction is capitalised onto the balance sheet and the payment for such interest is added to the amount owing to the funders.</li><li>This often results in interest on interest and compounding which is why small movements in interest rate can actually have very big impacts on the overall viability of the project and why interest rates tends to be locked in using interest rate swaps.</li></ul><p><strong>Operations phase</strong></p><ul><li>Where the project is built and starts to generate some revenue, albeit often at a suboptimal rate initially and then later in a more stable and economic manner.</li><li>This initial period is often referred to as a ramp up phase as more aspects of the project asset become operational. The debt is also required to be serviced for both interest and debt repayments.</li><li>To guard against operational fluctuations there is often various multiple cash reserves required to be established and also built up as part of the commencement of operations as a buffer.</li></ul><p>Cash is paid from the projects through what’s called a cash flow waterfall that can often be fairly complex especially when reserves are building up and being depleted over the construction and operations period.</p><h3>Where are good places (links) to find out more on the topic</h3><p>The<a href="https://financialmodellingpodcast.com/"> Financial Modelling Podcast</a> has episodes and blog posts on the complexity of project finance modelling.</p><p>Corality and Operis are also great places to look for examples and explanations online.</p><h3>How important is this skill in the context of learning FM?</h3><p>Building a project finance model from scratch will enable a financial modeller to understand the importance of structuring a model to be flexible, and be able to run multiple different scenarios.</p><p>Due to the changing nature of a project finance deal from origination to close, the more modular and well built a model is, the easier it will be to work with going forward.</p><p>A project finance model has all of the traditional financial modelling elements, together with some more complex elements such as distinct operations and construction periods, Debt Service Reserve Accounts that are funded as part of project costs and usually some macros to avoid circular references.</p><h3>How does all this disruption, AI and automation talk impact this topic</h3><p>Project finance models are unlikely to be significantly automated in the short term due to their bespoke nature. That said, model templates do exist and there is room for automation in scenario analysis and understanding the optimal hedging structure to minimise both risk and hedging costs.</p><p>If you want to find out more and follow the rest of the article series be sure to download the <a href="https://fmwiki.glideapp.io/">Financial Modelling App</a></p><p>If you want to find more information on financial modelling and content visit the <a href="http://www.model.citizn.com/">Model Citizn website</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=cf08d2d9a4e2" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[WHY A TRULY INTEGRATED BUSINESS PLANNING SOLUTION REQUIRES A FLEXIBLE DUAL ARCHITECTURE KNOWN AS…]]></title>
            <link>https://medium.com/making-informed-relevant-and-purposeful-decision/why-a-truly-integrated-business-planning-solution-requires-a-flexible-dual-architecture-known-as-d755062dc41?source=rss-43a6fc2d8cfc------2</link>
            <guid isPermaLink="false">https://medium.com/p/d755062dc41</guid>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[business]]></category>
            <category><![CDATA[financial-modelling]]></category>
            <category><![CDATA[digital-transformation]]></category>
            <category><![CDATA[finance]]></category>
            <dc:creator><![CDATA[Lance Rubin]]></dc:creator>
            <pubDate>Sun, 25 Aug 2019 23:38:34 GMT</pubDate>
            <atom:updated>2019-08-25T23:41:32.394Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Why a truly integrated business planning solution requires a flexible dual architecture known as core and edge.</strong></h3><p><em>Authors Michael Huthwaite &amp; Lance Rubin</em></p><p>Managing a successful FP&amp;A (Finance) department requires balancing the right blend of People, Processes and Technology. Of course, this construct is nothing new, we’ve all heard this many times before.</p><p>However, when it comes to running your organization’s FP&amp;A function, establishing the optimal mix of these three critical elements is surprisingly less obvious than one would think.</p><h3>WHY TECHNOLOGY IS VERY TELLING</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ojj3598pPwK8Vy6QkwC1CA.png" /></figure><p>Normally, addressing technology first is a terrible idea. That’s because technology is never the driving factor. In fact, leading with technology is like trying to suggest an answer without really knowing the underlying problem. In leadership, we are often told to suspend judgement until we have all the facts. So, jumping to solution mode too quickly, especially on your most important infrastructure, can be very costly down the track.</p><p>Yet, a lot can be learned by studying a company’s “current state” or existing technical footprint because it has a lot to say about how you currently address the people and processes</p><p>Does your FP&amp;A function value process over people? Is the reverse true (people over process)? Or is the organization able to balance both efficiently and effectively?</p><h3>WHEN PLANNING IS ABOUT PROCESS OVER PEOPLE</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/584/1*ze6ikeIGVnRH8KL5VTCFBQ.png" /></figure><p>Tactical planning (Budgeting and Forecasting) is a highly process driven activity. Let’s face it, putting together the Annual Budget and reforecasting it throughout the year is an exercise in Process Management (time to get your calendar out and block out whole chunks of it).</p><p>As FP&amp;A professionals, we would all like to spend more time analyzing the data and helping make better and more insightful decisions with less time spent in the process. However, when it comes to tactical planning, the reality is we’re often up to our eyeballs in process managment (hence the need for purpose-built technology).</p><p>So, in order to handle a heavy dose of process driven planning, we leverage technology known as Enterprise Performance Management Suites (EPM/CPM). These solutions are great for collecting and validating data across the entire Enterprise with the goal of streamlining a “single version of the truth” (SVOT) across the entire organization.</p><p>Often times, what makes these tools so powerful is their centralized or “Core” architecture. In short, Core architecture involves using a centralized database (on-premises or in the cloud) to store large amounts of data so that information can be leveraged by others throughout the organization.</p><p>Naturally, deciding who has access to view and enter data is a key concern that is addressed by a heavy dose of both access controls and pre-defined workflow rules (a key feature set of any EPM solution).</p><p>The outcome is a solution with robust yet rigid swim lanes which is ideal for centralized control, collection and coordination of data across the entire organization.</p><p>Key buzzwords for Core architecture are often phrases such as “Connected Planning”, “Budgeting and Forecasting”, “Single Version of the Truth” or “Enterprise Planning”.</p><h3>WHEN PLANNING IS ABOUT PEOPLE OVER PROCESS</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/426/1*Pr_08FIYEGd9qXnxpfR3Xg.png" /></figure><p>Of course, not all financial planning and forecasting is process driven. What happens when you are looking to shape the future direction of the business and need to evaluate alternative investments and strategies that are new to the organisation? New divisions or products that don’t exist in the current “Core” architecture.</p><p>Strategic Planning, Investment/Acquisition Screening and other forms of Corporate Development (growth initiatives) are optimized when people drive the process (not the other way around).</p><p>Under this approach, literally anyone can initiate a plan (financial model) and invite or share it with others when the time is right. Once shared, users are free to suggest their own perspectives on that plan in terms of the assumption needing to change or even amending the logic. This is the optimal approach for team-based planning (business partnering), where the individuals involved are treated as peers and as a result work together to influence each other and facilitate real discussion and debate around financial alternatives that are more fluid and dynamic in nature.</p><p>This form of agile planning is optimized under a technical architecture referred to as “Edge” architecture.</p><p>Edge architecture is great for experimentation of alternatives where, much of what is being evaluated has a very short shelf-life and is either thrown away or proven invalid by other peers. As a result, there is little desire to centralize that data for enterprise consumption. Only the ideas/plans that make the most sense and prove to be valuable make their way to the Core, everything else is considered “noise” from the perspective of the enterprise and either remains or dies at the Edge.</p><p>Unlike, Core architecture that leverages a centralized database, Edge architecture typically leverages a distributed database architecture. Distributed databases are a collection of one or more databases that operate independently of one another, but exchange messages between each other in a network relationship.</p><p>This approach enables individuals to evaluate their own alternative scenarios and model configurations while relying on the system to capture and sync the “messages” occurring on the edge network. The result is an agile approach to modeling that facilitates the proper discussion and debate of alternatives required to form consensus.</p><h3>INTEGRATED BUSINESS PLANNING</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/469/1*rxiz0rwPw5uOauaL_UgR1w.png" /></figure><p>Integrated Business Planning should not be about prioritizing People and Process. Rather it should be about optimizing the harmony of both Tactical Planning (process over people) and Strategic/Agile Planning (people over process).</p><h3>DISPELLING THE MYTHS</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fHqBP-HAOKm1ZNj5ynznOA.jpeg" /></figure><p>A common myth about adopting a dual architecture approach to Integrated Business Planning is that it some how creates an integration (mapping) challenge. Yet the reality is that over time, the integration points remain pretty constant. This is because the Edge architecture only requires aggregate data from the Core architecture (data that rarely changes).</p><p>In return, only the consensus scenario(s) are passed back down keeping the integration points rather compact and consistent over time.</p><p>The real “Strategy Gap” occurs when organizations try to address “Edge” questions using “Core” solutions or vice versa.</p><p>For sure, data mapping and metadata alignment can be improved if vendors adopted shared APIs, common languages or other collaborative approaches, but this should not be a reason to hold off on adopting a dual Core and Edge toolset.</p><h3>THE ROLE OF EXCEL</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/603/1*ekm0z7kMCcAUyVnWgwcZJA.png" /></figure><p>So where does Excel play a role in Core and Edge? Well, it’s important to realize that when we talk about Core and Edge we are referring to database architecture. Excel on its own is not a database.</p><p>But of course, it can be linked to a backend database. We see this in BI with tools like PowerPivot, PowerQuery and PowerBI. In addition, Most Core (EPM) vendors also have add-ins to Excel. Some vendors even require users to use Excel as the frontend.</p><p>However, what we don’t see right now is a proliferation of edge modeling tools that enable teams to uncover alternative strategies by constantly screening for alternative strategies that can be thoroughly discussed and debated without creating a myriad of version control related issues. So as familiar and flexible as Excel is, this remains to be a problem without proper edge architecture in place.</p><h3>CONCLUSION</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*tD7UehEv67_8-Zbuz4kaMw.jpeg" /></figure><p>In the future FP&amp;A teams will demand this flexible dual architecture as new generations of employees enter the workforce requiring more connectivity and integration of all systems through the use of open API technology.</p><p>The next generation already use APIs on a daily basis to login to various apps using their Facebook login for example and will expect to see similar connectivity within the Finance architecture.</p><p>Furthermore, this new wave of employees embrace working as a team on engagements that are built with agile frameworks. This is the future of financial modeling with greater collaboration and real time results driven modeling and analytics capabilities</p><p>Be forewarned, an organization’s inability to balance Core and Edge architecture is likely to be a key factor in determining whether an organization will attract and retain the best talent.</p><p>If you are not adopting cutting “edge” solutions that make their jobs easier and expecting them to swim in a sea of spreadsheets we think they will reconsider taking those roles.</p><p>And if you are about to enter a large organization within the FP&amp;A team be sure to ask the question on their Core and Edge architecture or strategy.</p><p>We certainly would be.</p><h3>Want to know more?</h3><p>I encourage you to take a peak at my past articles on financial modeling which is the foundation of business decision making, planning and forecasting.</p><p>We will continue to discuss this topic and you can click to follow us on Twitter or LinkedIn or subscribe to our short but sweet newsletter.</p><p>Be sure to check out our <a href="https://www.modelcitizn.com/pods-videos/">pods and video</a> page.</p><p>Here are also some past blogs that might be of interest.</p><p>Here are also some past/present blogs that might be of interest.</p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/3/14/forecasting-skills-doesnt-guarantee-good-modeling-skills">Forecasting skills doesn’t guarantee good modeling skills</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/3/12/how-technology-will-change-fpampa-forever">How Technology Will Change FP&amp;A Forever</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/2/1/why-so-many-unemployed-accountants-are-already-strugglingand-how-i-can-help">Why so many unemployed accountants are already struggling..and how I can help?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/1/29/father-battles-cancer-son-battles-career-extinction">Father battles cancer, son battles career extinction</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/1/9/why-being-a-1-manwomen-vcfo-business-is-a-really-bad-idea">Why being a 1-man/women VCFO business is a really bad idea?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/5/2/excel-is-dead">Excel is dead!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/4/25/financial-modeling-innovation-predictive-analytics-vs-financial-modeling">Financial Modeling Innovation: Predictive analytics vs Financial Modeling</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/4/19/financial-modeling-diamonds-in-the-rough">Financial Modeling: Diamonds in the rough</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/4/11/why-monte-carlo-will-change-the-way-you-make-financial-decisions-and-think-about-scenarios">Why Monte Carlo will change the way you make financial decisions and think about scenarios?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/11/28/driver-based-planning-forecasting-in-the-context-offpa">Driver Based Planning &amp; Forecasting in the context of FP&amp;A</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/11/5/inside-the-mind-of-a-spreadsheeter-vs-a-financial-modeler">Inside the mind of a spreadsheeter vs a financial modeler</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/10/18/virtual-cfo-the-good-bad-and-theugly">Virtual CFO the Good, Bad and the Ugly</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/the-airbnb-of-spreadsheets">Part 3 of Finance Innovation — The Airbnb of spreadsheets — first major wave of spreadsheet innovation</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/8/22/do-you-model-off-against-the-masters-of-financial-modelling">Do You Model Off against the Masters of Financial Modelling?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/advisory-survey-xero">NEED HELP searching for the best advisory tool in the market?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/7/18/part-2-of-finance-innovation-big-data-and-data-analytics-is-not-financial-modeling">Part 2 of Finance Innovation — Data Analytics / Big Data is not Financial Modeling</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/consulting-advisory-finance-and-the-art-of-influencing-is-about-to-change-forever">Consulting, Advisory, Finance and the art of influencing is about to change forever.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/your-financial-model-can-save-lives-">Your Financial Model can save lives !</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/https/mediumcom/making-informed-relevant-and-purposeful-decision/why-financial-modelling-skills-will-be-a-big-career-door-opener-for-emerging-accounting-and-finance-8ef3b9cac5f3">Why financial modelling skills will be a big career door opener for emerging accounting and finance talent.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/the-demand-for-financial-modeling-skills-reaches-new-heights">The Demand for Financial Modeling Skills Reaches new Heights</a></p><p>Lance Rubin is the Founder of Model Citizn, partner of theOutperformer, approved training provider to the Financial Modeling Institute and Group CFO for SequelCFO.</p><p>Lance has more than 20 years of combined experience working in model audit, investment banking, corporate finance, finance business partner and Fintech CFO.</p><p>Organisations he has worked with include PwC, KPMG, National Australia Bank, Investec Bank and Banjo small business lender.</p><p>We have a YouTube channel dedicates to the <a href="https://www.youtube.com/channel/UC2_5lHYRDtQPZW1t0PHBInA">Future of Financial Modeling</a> and also provide access to <a href="https://www.eloquens.com/channel/lance-rubin">Models via Eloquens</a> with thousands of viewers and downloads.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d755062dc41" width="1" height="1" alt=""><hr><p><a href="https://medium.com/making-informed-relevant-and-purposeful-decision/why-a-truly-integrated-business-planning-solution-requires-a-flexible-dual-architecture-known-as-d755062dc41">WHY A TRULY INTEGRATED BUSINESS PLANNING SOLUTION REQUIRES A FLEXIBLE DUAL ARCHITECTURE KNOWN AS…</a> was originally published in <a href="https://medium.com/making-informed-relevant-and-purposeful-decision">Making informed, relevant and purposeful decision with insight.</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[INSIDE THE MIND OF A SPREADSHEETER VS A FINANCIAL MODELER]]></title>
            <link>https://medium.com/making-informed-relevant-and-purposeful-decision/inside-the-mind-of-a-spreadsheeter-vs-a-financial-modeler-50491ea12b43?source=rss-43a6fc2d8cfc------2</link>
            <guid isPermaLink="false">https://medium.com/p/50491ea12b43</guid>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[financial-modelling]]></category>
            <category><![CDATA[finance]]></category>
            <category><![CDATA[accounting]]></category>
            <category><![CDATA[excel]]></category>
            <dc:creator><![CDATA[Lance Rubin]]></dc:creator>
            <pubDate>Wed, 07 Aug 2019 02:07:11 GMT</pubDate>
            <atom:updated>2019-08-07T02:07:11.164Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*riu08h2OGqRb6mq1xDr5yQ.jpeg" /></figure><h3>INTRODUCTION</h3><p>There is certainly a big difference between a spreadsheeter and a financial modeler.</p><p>However, the problem is who draws that line and determines who is placed on either side of it.</p><p>I have met, witnessed and trained many people over the past 20 years and it is still amazing to see how wide this spectrum can be, not to mention the opaqueness of that line.</p><p>Apart from there being no single method of measuring this difference, you will even struggle to get a bunch of expert modelers to agree what are the definitive criteria or standards are to follow in order to draw that line very clearly.</p><p>Everyone is scared the other might “own it” and desperately hold onto their own approach so sadly there are 3 that would call themselves a financial modeling standard.</p><p>We prefer to use <a href="http://www.ssrb.org/standards">BPSMS</a> (was the first standard developed), but in reality they are all very similar in overall approach and consistency.</p><p>I even saw a list of formulas on the axis of evil by a leading accounting firm, yet a world champion proceeded to use one of those “evil” formulas in his demonstration during a <a href="https://gtc.modeloff.com/">Modeloff Global Training Camp</a>.</p><p>So it would be very dangerous for me to even attempt drawing such a hard line but I can certainly attempt to layout a framework.</p><p>I will try explain and give readers food for thought when looking at the mindset of the two, which is more based on me having met thousands of Excel users across Australia, South Africa, Sri Lanka, India and Hong Kong.</p><p>Having previously transitioned myself from a spreadsheeter to a professional modeler, I can’t even say exactly when it was that I moved over to the other (perhaps dark) side.</p><p>Perhaps the day I unplugged my mouse and started to use only shortcut keys.</p><p>Or was it the day I learnt Index(Match) and no longer used Vlookup or perhaps Offset or my first copy/paste and goal seek macros….nah…has to be that day I started using data tables or a solver driven macro button.</p><p>Now you can see the problem.</p><p>Here is a short list that hopefully helps people assess personally where they might be and what might need to change to progress toward improving themselves toward being as a Financial Modeler and away from being a Spreadsheeter</p><h3>SPREADSHEETER</h3><ol><li>Believes he/she has <strong>little if any errors</strong> in their spreadsheet and denies or avoids thinking about them.</li><li>A spreadsheeter just wants to get the job done and will rush through the process, even occasionally <strong>hardcoding numbers in formulas</strong> to balance a balance sheet and hide it in other debtors or creditors when it might be out of balance. Or have a “balancing item” / “historical balancing” as an unreconciled difference. Maybe make other assets equal the difference between net assets and total equity to <strong>force a balanced balance sheet</strong>…I know all the tricks because I used them a long time ago.</li><li>A spreadsheeter likes the fact that their spreadsheet is <strong>really complex in its design </strong>which nobody, apart from them, is able to interpret what is contained in it. Even the simplest of tasks identifying where the assumptions are located is a game of hide and seek within the <strong>spiderweb of formulas</strong>. They aim to make things complex (job protection).</li><li>A spreadsheeter takes <strong>days sometimes weeks to roll forward spreadsheets </strong>and lots of <strong>manual copy and paste</strong>. They will spend more of their time preparing it and <strong>little time analysing, running sensitivities and scenarios</strong>. Its rare you will find scenario and sensitivity analysis in the spreadsheet. They might even use the words “it is what it is cause the model says so”. It’s like the model has it’s own brain and can never be wrong or changed dynamically. Spreadsheeters hardly ever build macros to automate the complexity.</li><li>The spreadsheet would and <strong>could never be served to anyone, let alone a queen</strong>. The intention is not to ever explain or show it to someone in detail only to create a few fancy dashboard which are then printed or saved to PDF format so nobody has to look under the hood. It’s not pretty for those that have had the pleasure of having to review another spreadsheeters spreadsheet when they go on leave or change jobs. I had 2 staff members that struggled for weeks to switch roles purely due their different spreadsheeting skills.</li><li>Spreadsheeter <strong>uses their mouse a lot </strong>and knows very <strong>few shortcut keys </strong>apart from Ctrl C (copy) and Ctrl V(paste) (which they use a lot). Maybe occasionally Ctrl S (save).</li></ol><h3>FINANCIAL MODELER</h3><ol><li>Recognises that <strong>all spreadsheets will contain errors</strong> when first built and therefore actively develops error trapping and reporting/flagging within a model to detect and resolve them.</li><li>A modeler actively goes<strong> looking for errors</strong> and writes formulas carefully to minimise errors and enforce consistency. A balance sheet that doesn’t balance is a cardinal sin and worthy of punishment by public humiliation.</li><li>A modeler builds models so they are <strong>easily navigated and well structured. </strong>Whilst the formulas might be complex depending on the business logic and flexibility the Modeler strives to enable others to easily use and navigate the key assumptions and outputs. They <strong>aim to make things simple</strong> (it’s actually harder to make complex models simple) so others can use and navigate it.</li><li>A modeler will find every angle possible to <strong>reduce the time spent on updating a spreadsheet </strong>so that they can spend <strong>more time on possible scenarios and potential impacts</strong> of changes to key assumptions<strong>.</strong> The modeler recognises it’s a matter of relativities across different scenarios rather than an absolute single outcome. Not matter what the model reflects as outputs it will never be 100% accurate. A modeler would use <strong>macros and probably run Monte Carlo simulations</strong> if required to lower error risk.</li><li>Presentation is key. The model is built as if it were an <strong>expensive cuisine being served to the queen. </strong>There would certainly not be a bunch of excel errors hanging around like egg shell pieces in scrambled eggs. Not really a pleasant experience eating egg shells.</li><li>Financial modeler <strong>hones his/her shortcut key strokes </strong>and might even remove the mouse all together. They are also known to remove the F1 key as its just a waste of a key and given the frequent use of the F2 key (to understanding basic formulas and logic) is right next door.</li></ol><h3>CONCLUSION</h3><p>There are sadly a lot more spreadsheeters out there than modelers (2% of Excel users would be professional modelers), however fear not as there are tools and educators to help, like me and others.</p><p>There are literally truck loads of free online materials and YouTube channels to get up the curve.</p><p>I was once a spreadsheeter feeling proud that I was the only person that could understand what I had created.</p><p>Whilst I thought this was a great place to be, I soon realized that the painful process of maintaining the spreadsheet all by myself eventually became boring and I could use my time to add more value outside the spreadsheet through conversations whilst the spreadsheet was merely the decision making tool, not the bible.</p><p>Being able to drive real business conversations and help drive performance face to face with people and not behind spreadsheets is truly life changing.</p><p>We are human and whilst machines can do a lot for us, right now influencing decision making with other humans still needs our experience, our personal connections and care for others being successful as it’s the best way we too can become successful.</p><p>I encourage you to also take a peak at my past/present articles on financial modeling which is the foundation of business decision making, planning and forecasting.</p><p>We have also redesigned our website to help you along your journey of levelling up in this space.</p><p>We will continue to discuss this topic and you can click to follow me on Twitter or LinkedIn or subscribe to our short but sweet newsletter.</p><p>Be sure to check out our <a href="https://www.modelcitizn.com/pods-videos/">pods and video</a> page.</p><p>Here are also some past/present blogs that might be of interest.</p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/3/14/forecasting-skills-doesnt-guarantee-good-modeling-skills">Forecasting skills doesn’t guarantee good modeling skills</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/3/12/how-technology-will-change-fpampa-forever">How Technology Will Change FP&amp;A Forever</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/2/1/why-so-many-unemployed-accountants-are-already-strugglingand-how-i-can-help">Why so many unemployed accountants are already struggling..and how I can help?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/1/29/father-battles-cancer-son-battles-career-extinction">Father battles cancer, son battles career extinction</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/1/9/why-being-a-1-manwomen-vcfo-business-is-a-really-bad-idea">Why being a 1-man/women VCFO business is a really bad idea?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/1/9/why-using-vlookup-instead-of-indexmatch-says-a-lot-about-your-lack-of-embracing-change-innovation-and-better-excel-skills">Why Vlookup (vs Index(match) shows your lack of embracing change, innovation and better Excel skills</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/8/11/why-a-truly-integrated-business-planning-solution-requires-a-flexible-dual-architecture-known-as-core-and-edge">Why a Truly Integrated Business Planning Solution Requires a Flexible Dual Architecture known as Core and Edge.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/5/2/excel-is-dead">Excel is dead!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/4/25/financial-modeling-innovation-predictive-analytics-vs-financial-modeling">Financial Modeling Innovation: Predictive analytics vs Financial Modeling</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/4/19/financial-modeling-diamonds-in-the-rough">Financial Modeling: Diamonds in the rough</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/4/11/why-monte-carlo-will-change-the-way-you-make-financial-decisions-and-think-about-scenarios">Why Monte Carlo will change the way you make financial decisions and think about scenarios?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/11/28/driver-based-planning-forecasting-in-the-context-offpa">Driver Based Planning &amp; Forecasting in the context of FP&amp;A</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/10/18/virtual-cfo-the-good-bad-and-theugly">Virtual CFO the Good, Bad and the Ugly</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/the-airbnb-of-spreadsheets">Part 3 of Finance Innovation — The Airbnb of spreadsheets — first major wave of spreadsheet innovation</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/8/22/do-you-model-off-against-the-masters-of-financial-modelling">Do You Model Off against the Masters of Financial Modelling?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/advisory-survey-xero">NEED HELP searching for the best advisory tool in the market?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/7/18/part-2-of-finance-innovation-big-data-and-data-analytics-is-not-financial-modeling">Part 2 of Finance Innovation — Data Analytics / Big Data is not Financial Modeling</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/13/why-i-disrupted-my-own-role-and-you-should-do-the-same">Why I disrupted my own role and you should do the same?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/consulting-advisory-finance-and-the-art-of-influencing-is-about-to-change-forever">Consulting, Advisory, Finance and the art of influencing is about to change forever.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/your-financial-model-can-save-lives-">Your Financial Model can save lives !</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/the-machines-are-not-coming-they-are-here">The Machines Are Not Coming… they are here!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/https/mediumcom/making-informed-relevant-and-purposeful-decision/why-financial-modelling-skills-will-be-a-big-career-door-opener-for-emerging-accounting-and-finance-8ef3b9cac5f3">Why financial modelling skills will be a big career door opener for emerging accounting and finance talent.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/the-demand-for-financial-modeling-skills-reaches-new-heights">The Demand for Financial Modeling Skills Reaches new Heights</a></p><p>Lance Rubin is the Founder of Model Citizn, partner of theOutperformer, approved training provider to the Financial Modeling Institute and Group CFO for SequelCFO.</p><p>I have more than 20 years of combined experience working in model audit, investment banking, corporate finance, finance business partner and Fintech CFO.</p><p>Organisations I have worked with include PwC, KPMG, National Australia Bank, Investec Bank and Banjo small business lender.</p><p>I have a YouTube channel dedicates to the <a href="https://www.youtube.com/channel/UC2_5lHYRDtQPZW1t0PHBInA">Future of Financial Modeling</a> and also provide access to <a href="https://www.eloquens.com/channel/lance-rubin">Models via Eloquens</a> with thousands of viewers and downloads.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=50491ea12b43" width="1" height="1" alt=""><hr><p><a href="https://medium.com/making-informed-relevant-and-purposeful-decision/inside-the-mind-of-a-spreadsheeter-vs-a-financial-modeler-50491ea12b43">INSIDE THE MIND OF A SPREADSHEETER VS A FINANCIAL MODELER</a> was originally published in <a href="https://medium.com/making-informed-relevant-and-purposeful-decision">Making informed, relevant and purposeful decision with insight.</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[HOW TECHNOLOGY WILL CHANGE FP&A FOREVER]]></title>
            <link>https://medium.com/making-informed-relevant-and-purposeful-decision/how-technology-will-change-fp-a-forever-91ee1005546d?source=rss-43a6fc2d8cfc------2</link>
            <guid isPermaLink="false">https://medium.com/p/91ee1005546d</guid>
            <category><![CDATA[afp]]></category>
            <category><![CDATA[financial-modelling]]></category>
            <category><![CDATA[big-data]]></category>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[financial-modeling]]></category>
            <dc:creator><![CDATA[Lance Rubin]]></dc:creator>
            <pubDate>Sat, 22 Jun 2019 06:12:06 GMT</pubDate>
            <atom:updated>2019-06-22T06:12:06.374Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*cauKjxka5Bjq0JPYAECONw.jpeg" /></figure><p>This article is co-written by <a href="https://www.linkedin.com/in/cashflowmodeling/">Lance Rubin</a> and <a href="https://www.linkedin.com/in/andersliulindberg/">Anders Liu-Lindberg</a></p><p>You don’t have to be a data scientist or technologist to know that the impact of technology on FP&amp;A will be significant. If you are skeptical look at previous blogs written by Lance where he <a href="https://www.linkedin.com/pulse/why-i-disrupted-my-own-role-you-should-do-same-lance-rubin/">disrupted his own role</a>.</p><p>But one of the biggest challenges of automation (RPA) and AI/machine learning technologies is our mindset. It is critical for the success in our careers and the companies where we aim to drive the right strategic choices.</p><p>However, with so many new acronyms and complex terms it’s proving difficult for us to get comfortable with it and the mindset shift appears somewhat crippling, but it doesn’t have to be.</p><p>To tackle this and help you gain some insight we assess this by adopting the four attributes of curiosity, courage, crystal ball, and clarity which was defined in the mindset article as the critical attributes to future success of FP&amp;A.</p><p><strong>Curiosity</strong>: Sparks new found curiosity on how much of the boring stuff can be automated, giving us more time to build relationships, find value creating opportunities and listen to our key stakeholders.</p><p><strong>Courage</strong>: It will no doubt take a huge dose of courage to not only start but execute on the transformation. These are often not “out of the box”, “plug n play” solutions and will require us to spend time learning new skills in process automation, analytics and financial modeling. We don’t need to know exactly how to do it for all of these but at least understand how they work, where they can add value and where they won’t.</p><p><strong>Crystal ball</strong>: AI based machine learning and predictive analytics will start to give us more powerful crystal balls. Adopting more advanced Monte Carlo simulation. This is a space that is largely unexplored and represents immense potential for us to understand, interpret, communicate and execute on these predictions. At times even call out when they might be wrong (which won’t be often but can still happen).</p><p><strong>Clarity</strong>: Technology will help guide our roles more clearly over time and the mindset shift will hopefully become more tangible and easy to absorb.</p><p>Just as well as our mindset is on a journey when it comes to understanding innovative technologies so is data. Data is travelling from Sources to Uses, with the hourglass as a metaphor of gathering vast amounts, processing and then disseminating.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/234/1*5sMVRCuzfxYZl014u50QAg.png" /></figure><p>More data is being created (IOT as an example) and captured (Cloud), and our ability to analyze it as humans is magnified by automation (RPA).</p><p>We need the tools to keep up, but the tools also need us to be effective (Analytics).</p><p>Goal is analytics to insight that can then be shared via any number of mechanisms (Mobile and Social being just examples).</p><h3>EXPLORING THE TECH STACK SMORGASBORD</h3><p>To further help you understand how technology will change FP&amp;A let’s explore the art of the possible. Paresh Mistry has published a blog which provides a good framework as a starting point. <a href="https://www.accaglobal.com/us/en/member/member/accounting-business/2017/10/in-focus/robot-process.html">Read more here</a></p><p>As visualized above we’ll use the ICRAMS model (Internet of Things (I), Cloud ©, Robotic process automation (R), Analytics (A), Mobile (M) and Social (S)). ‘ICR’ acts as the enabler and sensors; ‘AMS’ is the feedback and decision-making engine.</p><p>Let’s focus on the ones that have had the biggest impact to date and proven business outcomes.</p><p>Cloud</p><p>No question the leaders in this SME space are Xero and Intuits QBO. The API (application protocol interface — how machines talk to each other) connected ecosystem of apps is a game changer.</p><p>Something the larger ERP systems can learn from with decentralized app development. Most ERPs are closed systems meaning they won’t necessarily suit everyone and as a result ERPs sometimes result in more spreadsheets not less.</p><p>RPA</p><p>It comes in many different shapes and sizes that range in complexity. I love the way Chris Argent explained RPA with micro and macro macros.</p><p>There are a few out there:</p><p><em>Excel automation (micro macro/tools)</em></p><p>The often-forgotten Excel macro (VBA code based), Excel add-ins like Modano and DataDear for a range of data importing, model building and automation of manual processes within Excel without coding (managed Excel), Excel’s own in-built tools for getting data like PowerQuery, PowerPivot and the ever-increasing functionality like dynamic arrays etc. Excel enterprise management tools like Vena solutions for example which contain a range of other tools surrounding the Excel enterprise environment.</p><p><em>Cross system (macro macros)</em></p><p>Macro macros with cross system process automation like Automation Anywhere, Solvexia, Blue Prism, UiPath, Xceptor and Redwood.</p><p>RPA is the enabler for creating more time to explore other technologies and free up substantial amounts of time that is needed to learn new skills. The spare capacity can also be used to focus on value adding decision making tasks and therefore should be an opportunity, not a threat.</p><p>Analytics</p><p>Firstly, it includes all forms of analytics which are heavily data-driven. Especially clean data or even enriched data which brings financial and non-financial information together can be powerful.</p><p>As the reliance on data-driven decisions becomes more prevalent in Finance, there is a need to manage data better and remove data anomalies or errors in the “cleansing” process. The “dirty” data can cause false positives or other issues as a result of the data being incorrect, often caused by a human.</p><p>Once cleansed its possible to enrich the data for example a customer name and ID is not as valuable as the customer’s postal code, income bracket or other spending habits which could be enriched from data collected from Google for example. This enriched data can then inform the marketing team more specifically the personas and buying habits for their products and in order to achieve higher ROI from marketing spend.</p><p>There are even some technologies which can extract insight from not so “clean” data to identify trends and anomalies.</p><p>The forms of analytics are typically descriptive, diagnostic, predictive and prescriptive, each of which have a focus either backward looking or forward looking and range in complexity as a result.</p><p>These will certainly give you lots of insight and some very narrowly defined foresight, but unlikely to ever be widely defined 3-way predictions for Finance.</p><p>3-way predictions or forecasts typically include the Income Statement, Balance Sheets and Cash Flow Statements. These forecasts are more aligned to financial modeling, rather than analytics as they include the balance sheet positions, cash flows and profitability in an integrated manner.</p><p>Technologies used in Analytics include applications like PowerBI, Tableau, Qlik, Domo and many more. The predictive and prescriptive aspects require the use of machine learning and other code-based languages like Python and R scripts.</p><p>The Analytics applications include data visualization tools as well as data ingesting capabilities across numerous sources from web pages to databases to core accounting systems.</p><p>Financial Modeling</p><p>Modeling can come in various forms including predictive modeling and data modeling mentioned above.</p><p>Generally Financial Modeling is extensively used within Excel. Major investment banks and project and infrastructure finance but also for business in robust cash flow modeling. It’s possible to build models on other applications like Google Sheets etc., but these tend to be for simpler models.</p><p>However, there are other powerful add-ins like Modano for building 3-way models quickly, DataDear for extracting and pushing data between the cloud package and spreadsheets and interactive modeling visualization of Modeler which also has 2-way data flows. The combination of these make it very powerful as well as visually appealing.</p><p>We know that is a lot to take in but simply showing you the art of the possible should prepare you for what’s coming your way. It should also help you formulate an ambition for how you want to use technology in your FP&amp;A transformation.</p><h3>IT’S NOT THE TECHNOLOGY STUPID</h3><p><em>AI + Human &gt; AI alone.</em></p><p>This is a fact, so whilst large parts of what we do today will change, most of what we are going to be doing in the future is still uncharted and more opportunities will be created as a result as we create innovative solutions by applying what’s often open source i.e. “free”. Only if we are open to them though.</p><p>In the great words of Dr Carol Dweck, “Yet”.</p><p>We might not yet be ready, but we certainly can be if we embrace the massive opportunity we have, to leverage data, technology and value creation through softer skills of influencing and story-telling. The technology is there and will only get better. What matters is how we as humans adopt this technology and embed it into our way of working.</p><p>The longer we resist the more opportunities we miss out on. Technology presents a massive opportunity for FP&amp;A to enable the transformation that must happen. Excel is great if you know how to use it properly yet the clear majority of us don’t. Therefore, technology might help give you the boost you need to let go of low value-adding tasks and start driving the right strategic choices in the company.</p><p>What’s your approach to technology? Are you embracing everything that’s coming at you or taking a skeptical approach thinking what you have is just fine? We would love to hear about successful technology adoptions or even how you managed to boost your productivity by simply using Excel better so show us what you’ve got!</p><p>You can also take a peak at my past articles on financial modeling which is the foundation of business decision making, planning and forecasting.</p><p>We will continue to discuss this topic and you can click to follow me on Twitter or LinkedIn or subscribe to our short but sweet newsletter.</p><p>Be sure to check out our <a href="https://www.modelcitizn.com/pods-videos/">pods and video</a> page.</p><p>Here are also some past/present blogs that might be of interest.</p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/3/14/forecasting-skills-doesnt-guarantee-good-modeling-skills">Forecasting skills doesn’t guarantee good modeling skills</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/2/1/why-so-many-unemployed-accountants-are-already-strugglingand-how-i-can-help">Why so many unemployed accountants are already struggling..and how I can help?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/1/29/father-battles-cancer-son-battles-career-extinction">Father battles cancer, son battles career extinction</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/1/9/why-being-a-1-manwomen-vcfo-business-is-a-really-bad-idea">Why being a 1-man/women VCFO business is a really bad idea?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/1/9/why-using-vlookup-instead-of-indexmatch-says-a-lot-about-your-lack-of-embracing-change-innovation-and-better-excel-skills">Why Vlookup (vs Index(match) shows your lack of embracing change, innovation and better Excel skills</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/8/11/why-a-truly-integrated-business-planning-solution-requires-a-flexible-dual-architecture-known-as-core-and-edge">Why a Truly Integrated Business Planning Solution Requires a Flexible Dual Architecture known as Core and Edge.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/5/2/excel-is-dead">Excel is dead!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/4/25/financial-modeling-innovation-predictive-analytics-vs-financial-modeling">Financial Modeling Innovation: Predictive analytics vs Financial Modeling</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/4/19/financial-modeling-diamonds-in-the-rough">Financial Modeling: Diamonds in the rough</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/4/11/why-monte-carlo-will-change-the-way-you-make-financial-decisions-and-think-about-scenarios">Why Monte Carlo will change the way you make financial decisions and think about scenarios?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/11/28/driver-based-planning-forecasting-in-the-context-offpa">Driver Based Planning &amp; Forecasting in the context of FP&amp;A</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/11/5/inside-the-mind-of-a-spreadsheeter-vs-a-financial-modeler">Inside the mind of a spreadsheeter vs a financial modeler</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/10/18/virtual-cfo-the-good-bad-and-theugly">Virtual CFO the Good, Bad and the Ugly</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/the-airbnb-of-spreadsheets">Part 3 of Finance Innovation — The Airbnb of spreadsheets — first major wave of spreadsheet innovation</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/8/22/do-you-model-off-against-the-masters-of-financial-modelling">Do You Model Off against the Masters of Financial Modelling?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/advisory-survey-xero">NEED HELP searching for the best advisory tool in the market?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/7/18/part-2-of-finance-innovation-big-data-and-data-analytics-is-not-financial-modeling">Part 2 of Finance Innovation — Data Analytics / Big Data is not Financial Modeling</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/13/why-i-disrupted-my-own-role-and-you-should-do-the-same">Why I disrupted my own role and you should do the same?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/consulting-advisory-finance-and-the-art-of-influencing-is-about-to-change-forever">Consulting, Advisory, Finance and the art of influencing is about to change forever.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/your-financial-model-can-save-lives-">Your Financial Model can save lives !</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/the-machines-are-not-coming-they-are-here">The Machines Are Not Coming… they are here!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/https/mediumcom/making-informed-relevant-and-purposeful-decision/why-financial-modelling-skills-will-be-a-big-career-door-opener-for-emerging-accounting-and-finance-8ef3b9cac5f3">Why financial modelling skills will be a big career door opener for emerging accounting and finance talent.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/the-demand-for-financial-modeling-skills-reaches-new-heights">The Demand for Financial Modeling Skills Reaches new Heights</a></p><p>Lance Rubin is the Founder of Model Citizn, partner of theOutperformer, approved training provider to the Financial Modeling Institute and Group CFO for SequelCFO.</p><p>I have more than 20 years of combined experience working in model audit, investment banking, corporate finance, finance business partner and Fintech CFO.</p><p>Organisations I have worked with include PwC, KPMG, National Australia Bank, Investec Bank and Banjo small business lender.</p><p>I have a YouTube channel dedicates to the <a href="https://www.youtube.com/channel/UC2_5lHYRDtQPZW1t0PHBInA">Future of Financial Modeling</a> and also provide access to <a href="https://www.eloquens.com/channel/lance-rubin">Models via Eloquens</a> with thousands of viewers and downloads.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=91ee1005546d" width="1" height="1" alt=""><hr><p><a href="https://medium.com/making-informed-relevant-and-purposeful-decision/how-technology-will-change-fp-a-forever-91ee1005546d">HOW TECHNOLOGY WILL CHANGE FP&amp;A FOREVER</a> was originally published in <a href="https://medium.com/making-informed-relevant-and-purposeful-decision">Making informed, relevant and purposeful decision with insight.</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[WHAT IS YOUR FINANCE CADENCE? ARE YOU KEEPING UP TO SPEED?]]></title>
            <link>https://medium.com/making-informed-relevant-and-purposeful-decision/what-is-your-finance-cadence-are-you-keeping-up-to-speed-982cd7921d41?source=rss-43a6fc2d8cfc------2</link>
            <guid isPermaLink="false">https://medium.com/p/982cd7921d41</guid>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[cash-flow]]></category>
            <category><![CDATA[financial-modelling]]></category>
            <category><![CDATA[financial-modeling]]></category>
            <category><![CDATA[finance]]></category>
            <dc:creator><![CDATA[Lance Rubin]]></dc:creator>
            <pubDate>Sat, 22 Jun 2019 06:06:02 GMT</pubDate>
            <atom:updated>2019-06-22T06:06:02.929Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BbZiIrF_lSWHmWz5UHrt-Q.jpeg" /></figure><h3>Introduction</h3><p>Typically in finance we have a particular type of cadence. This cadence is largely consistent across different organisations no matter what the industry you support. We are likely to have some or all of these:</p><ol><li>Monthly reporting,</li><li>Quarterly reporting and forecasting,</li><li>Half year reporting (if listed),</li><li>Annual statutory reporting and tax filing (we all have this one),</li><li>Annual budget process and</li><li>Longer range strategic planning for 3 to 5 years.</li></ol><p>Now that’s a pretty full dance card if you ask me.</p><p>So how do we keep up with all those requirements whilst making sure that we are not just hitting the deadlines but actually accelerating the value that we add to the business</p><p>The short answer is the above is not negotiable therefore the value that we add to the business becomes a nice to have, in a world where this just isnt good enough.</p><p>Not meeting the reporting requirements to regulators, the board, investors is highly problematic.</p><p>So in typical traditional finance fashion the value we add to the business is de-prioritised ahead of the compliance-related requirements of keeping the lights on.</p><p>Therefore as a result the finance cadence is certainly not accelerating if anything it’s slowing down as the requirements become more arduous and we are expected to do more with less (staff — cost cutting), without the much needed investment in systems and processes.</p><p>So embracing change and transformation through technology becomes increasingly more difficult as we just strugg to keep up with the requirements we have to today, let alone embrace something new and undergo a much needed transformation.</p><h3>Where to start (without a big price tag)?</h3><h3>1. EXCEL IS NOT DEAD!</h3><p>It is also the source of a lot of waste, errors and frankly rusty chains and squeaky wheels affecting our cadence.</p><p>But a large scale transformation to remove the spreadsheet also doesn’t work.</p><p>It doesn’t allow us to be nimble and do proper modelling with scenarios and simulations (Monte Carlo).</p><p>So to get started, simply get started small.</p><p>Look to improve and streamline Excel within Excel and outside with tools that embrace it, not remove it.</p><p>I removed 75% of my efforts using these tools.</p><p>The tools are here now.</p><p>Surprisingly these tools are not expensive.</p><p>There is a huge problem with the expensive enterprise solutions. The more expensive it is the more valuable people believe they will be.</p><p>Not to mention the cost of maintenance and specialists consultants for that software. Few enable the team to truly self serve.</p><p>Model Citizn is software agnostic, we find the best solutions for the problem.</p><h3>2. DIAGNOSE THE PROBLEM AND RE-TRAIN YOUR STAFF TO USE THEIR EXISTING TOOLS BETTER.</h3><p>Be careful and selective what tools you bring in, don’t just follow the industry magic quadrant everyone else is following.</p><p>Some tools might not suit your context.</p><p>Context is key!</p><p>Technology is only a tool, its not a miracle cure for thinking!</p><p>It’s an enabler of change, not a driver of change.</p><p>People drive change and need to be trained how to do this change, if they dont know already (most don’t).</p><h3>3. FOCUS ON AUTOMATION TO DRIVE EFFICIENCIES. START SMALL AND EXPAND.</h3><p>One of the biggest frustrations I come across is finance just not having the time to implement or play with new tools.</p><p>The old chicken and egg problem.</p><p>But at the same time there are actually tools and technology that can automate a lot of the mundane work but this costs money and of course more time, no to mention the elephant in the room which is job security when starting this process.</p><p>You have to trust the process and management but also lead a team that embraces change and sees it as a path to new careers be that inside your company or outside.</p><p>We are all going to have to change at some stage or another, we simply cannot continue as we are today.</p><h3>Conclusion</h3><p>If you want to learn more in 2019 and also understand how you can upskill in FM be sure to reach out to us or stay tuned.</p><p>I encourage you to also take a peak at my past articles on financial modeling which is the foundation of business decision making, planning and forecasting.</p><p>We have also redesigned our website to help you along your journey of levelling up in this space.</p><p>We will continue to discuss this topic and you can click to follow me on Twitter or LinkedIn or subscribe to our short but sweet newsletter.</p><p>Be sure to check out our <a href="https://www.modelcitizn.com/pods-videos/">pods and video</a> page.</p><p>Here are also some past blogs that might be of interest.</p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/3/14/forecasting-skills-doesnt-guarantee-good-modeling-skills">Forecasting skills doesn’t guarantee good modeling skills</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/3/12/how-technology-will-change-fpampa-forever">How Technology Will Change FP&amp;A Forever</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/2/1/why-so-many-unemployed-accountants-are-already-strugglingand-how-i-can-help">Why so many unemployed accountants are already struggling..and how I can help?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/1/29/father-battles-cancer-son-battles-career-extinction">Father battles cancer, son battles career extinction</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/1/9/why-being-a-1-manwomen-vcfo-business-is-a-really-bad-idea">Why being a 1-man/women VCFO business is a really bad idea?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2019/1/9/why-using-vlookup-instead-of-indexmatch-says-a-lot-about-your-lack-of-embracing-change-innovation-and-better-excel-skills">Why Vlookup (vs Index(match) shows your lack of embracing change, innovation and better Excel skills</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/8/11/why-a-truly-integrated-business-planning-solution-requires-a-flexible-dual-architecture-known-as-core-and-edge">Why a Truly Integrated Business Planning Solution Requires a Flexible Dual Architecture known as Core and Edge.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/5/2/excel-is-dead">Excel is dead!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/4/25/financial-modeling-innovation-predictive-analytics-vs-financial-modeling">Financial Modeling Innovation: Predictive analytics vs Financial Modeling</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/4/19/financial-modeling-diamonds-in-the-rough">Financial Modeling: Diamonds in the rough</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/4/11/why-monte-carlo-will-change-the-way-you-make-financial-decisions-and-think-about-scenarios">Why Monte Carlo will change the way you make financial decisions and think about scenarios?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/11/28/driver-based-planning-forecasting-in-the-context-offpa">Driver Based Planning &amp; Forecasting in the context of FP&amp;A</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/11/5/inside-the-mind-of-a-spreadsheeter-vs-a-financial-modeler">Inside the mind of a spreadsheeter vs a financial modeler</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/10/18/virtual-cfo-the-good-bad-and-theugly">Virtual CFO the Good, Bad and the Ugly</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/the-airbnb-of-spreadsheets">Part 3 of Finance Innovation — The Airbnb of spreadsheets — first major wave of spreadsheet innovation</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/8/22/do-you-model-off-against-the-masters-of-financial-modelling">Do You Model Off against the Masters of Financial Modelling?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/advisory-survey-xero">NEED HELP searching for the best advisory tool in the market?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/7/18/part-2-of-finance-innovation-big-data-and-data-analytics-is-not-financial-modeling">Part 2 of Finance Innovation — Data Analytics / Big Data is not Financial Modeling</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/13/why-i-disrupted-my-own-role-and-you-should-do-the-same">Why I disrupted my own role and you should do the same?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/consulting-advisory-finance-and-the-art-of-influencing-is-about-to-change-forever">Consulting, Advisory, Finance and the art of influencing is about to change forever.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/your-financial-model-can-save-lives-">Your Financial Model can save lives !</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/the-machines-are-not-coming-they-are-here">The Machines Are Not Coming… they are here!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/https/mediumcom/making-informed-relevant-and-purposeful-decision/why-financial-modelling-skills-will-be-a-big-career-door-opener-for-emerging-accounting-and-finance-8ef3b9cac5f3">Why financial modelling skills will be a big career door opener for emerging accounting and finance talent.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/the-demand-for-financial-modeling-skills-reaches-new-heights">The Demand for Financial Modeling Skills Reaches new Heights</a></p><p>Lance Rubin is the Founder of Model Citizn, partner of theOutperformer, approved training provider to the Financial Modeling Institute and Group CFO for SequelCFO.</p><p>I have more than 20 years of combined experience working in model audit, investment banking, corporate finance, finance business partner and Fintech CFO.</p><p>Organisations I have worked with include PwC, KPMG, National Australia Bank, Investec Bank and Banjo small business lender.</p><p>I have a YouTube channel dedicates to the <a href="https://www.youtube.com/channel/UC2_5lHYRDtQPZW1t0PHBInA">Future of Financial Modeling</a> and also provide access to <a href="https://www.eloquens.com/channel/lance-rubin">Models via Eloquens</a> with thousands of viewers and downloads.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=982cd7921d41" width="1" height="1" alt=""><hr><p><a href="https://medium.com/making-informed-relevant-and-purposeful-decision/what-is-your-finance-cadence-are-you-keeping-up-to-speed-982cd7921d41">WHAT IS YOUR FINANCE CADENCE? ARE YOU KEEPING UP TO SPEED?</a> was originally published in <a href="https://medium.com/making-informed-relevant-and-purposeful-decision">Making informed, relevant and purposeful decision with insight.</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How do you recruit strong financial modeling skills in your team?]]></title>
            <link>https://medium.com/making-informed-relevant-and-purposeful-decision/how-do-you-recruit-strong-financial-modeling-skills-in-your-team-97985d7ea949?source=rss-43a6fc2d8cfc------2</link>
            <guid isPermaLink="false">https://medium.com/p/97985d7ea949</guid>
            <category><![CDATA[financial-modelling]]></category>
            <category><![CDATA[accounting]]></category>
            <category><![CDATA[recruitment]]></category>
            <category><![CDATA[finance]]></category>
            <category><![CDATA[financial-modeling]]></category>
            <dc:creator><![CDATA[Lance Rubin]]></dc:creator>
            <pubDate>Sun, 05 May 2019 22:22:40 GMT</pubDate>
            <atom:updated>2019-06-22T06:02:58.744Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VBGDFDVFG0B3ltZjsOAipA.jpeg" /></figure><h3>BACKGROUND</h3><p>Not too long ago I was the leader of a finance team in a large organisation.</p><p>One of the many challenges as a leader of any finance team was hiring new talent. But not just any talent or skill, I was after strong financial modelling (“FM”) skills and problem solving/lateral thinking.</p><p>My team were supporting the finance business partners in adding value to the business. I had been a finance partner so I had a reasonably good idea the sort of talent we needed and we didn’t have a lot of it</p><p>I even got some of the finance partners to interview the candidates, but after I had filtered to ensure the candidate had FM skills. Just to make sure they were happy with who we were hiring to support them.</p><p>So how did I solve this skills gap and how might you learn from my experience.</p><p>Hiring a gun financial modeler is easier than you think today too, if you read below.</p><h3>STEP 1.</h3><p>Make the decision to hire based on the way people think and communicate not what it says on paper.</p><p>Especially what is stays about where they have worked or what qualifications/memberships they might have.</p><h3>STEP 2.</h3><p>Make them prove it first.</p><p>Get them to build a financial model based on assumptions you give them on the business they are supporting.</p><p>No model, no interview.</p><p>I did this and I immediately saved myself bucket loads of time as people self selected and pulled out before their first interview.</p><p>They lacked the confidence to solve something they weren’t familiar with. Nobody had ever asked for this before an interview and it scared them as they felt exposed.</p><p>Check to see if they naturally built a 3-way model, but don’t specify that requirement.</p><p>If they did without promoting that’s a really good sign. If they didn’t (which is likely to be the vast majority), after the interview request a resubmission of a 3-way model before agreeing to hire them.</p><p>Can they problem solve? You will soon find out.</p><h3>STEP 3.</h3><p>Make sure they can explain what they did (high level) in their first round of interviews and what they found challenging.</p><p>Ask questions like:</p><p>Explain some of the more complex logic that was required.</p><p>Why they didn’t build a 3-way model only PL (which was a lot of them in my case).</p><p>How did they go about building the model?</p><p>What insight did they gain and actions they might take to drive performance based on the model.</p><p>Ask them to explain this as if you were the business owner.</p><h3>STEP 4.</h3><p>Make sure your team and key stakeholders like them in the next round of interviews.</p><p>Can they work as a team and get on well with people.</p><h3>STEP 5.</h3><p>Repeat steps 1 to 4 till you find your needle in the haystack.</p><h3>CONCLUSION</h3><p>Following our workshops/events and speaking to over 1,000 finance professionals and accountants, financial modeling is still a significant skills gap.</p><p>But fortunately my 5 steps above can be shortened even further using AI embedded hiring technologies, like Vervoe, which Model Citizn has since used to find the single diamond amongst a pile of rocks.</p><p>Training is one lever to transform your finance team.</p><p>But hiring talent is far quicker, assuming you know where to look for the right skills.</p><p>To change and transform finance, we have to change and transform the way we hire people.</p><p>Doing the same thing and expecting a different outcome (Einstein insanity) merely based on requiring different skills, without actually testing them, is never going to work.</p><p>Very few finance professionals have what it takes to build a good model, but if you use the above steps you can find those diamonds as I did and continue to help the business.</p><p>Its like changing someones title to Finance Business Partner and expect them to suddenly add value.</p><p>It doesn’t work that way, never will without the right training and hiring.</p><p>Being an advanced excel user (not that anyone can succintly explain exactly what that means) helps, but its certainly not the only criteria.</p><p>If you want us to review your hiring methods reach out and we can help.</p><p>To read more see our past blogs.</p><p>If you want to learn more follow us and read more about the content we are planning to release and FOFM and Future of Finance destinations for 2019.</p><p>I encourage you to take a peak at my past articles on financial modeling which is the foundation of business decision making, planning and forecasting.</p><p>We have also redesigned our website to help you along your journey of levelling up in this space.</p><p>We will continue to discuss this topic and you can click to follow me on Twitter or LinkedIn or subscribe to our short but sweet newsletter.</p><p>Be sure to check out our <a href="https://www.modelcitizn.com/pods-videos/">pods and video</a> page.</p><p>Here are also some past blogs that might be of interest.</p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/5/2/excel-is-dead">Excel is dead!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/13/why-i-disrupted-my-own-role-and-you-should-do-the-same">Why I disrupted my own role and you should do the same?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/your-financial-model-can-save-lives-">Your Financial Model can save lives!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/https/mediumcom/making-informed-relevant-and-purposeful-decision/why-financial-modelling-skills-will-be-a-big-career-door-opener-for-emerging-accounting-and-finance-8ef3b9cac5f3">Why financial modelling skills will be a big career door opener for emerging accounting and finance talent.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/the-demand-for-financial-modeling-skills-reaches-new-heights">The Demand for Financial Modeling Skills Reaches new Heights</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/7/18/part-2-of-finance-innovation-big-data-and-data-analytics-is-not-financial-modeling">Data Analytics / Big Data is not Financial Modeling</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/8/22/do-you-model-off-against-the-masters-of-financial-modelling">Do You Model Off against the Masters of Financial Modelling?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/10/18/virtual-cfo-the-good-bad-and-theugly">Virtual CFO the Good, Bad and the Ugly</a></p><p>Lance Rubin is the Founder of Model Citizn, partner of theOutperformer, approved training provider to the Financial Modeling Institute and Group CFO for SequelCFO.</p><p>Lance has more than 20 years of combined experience working in model audit, investment banking, corporate finance, finance business partner and Fintech CFO.</p><p>Organisations he has worked with include PwC, KPMG, National Australia Bank, Investec Bank and Banjo small business lender.</p><p>We have a YouTube channel dedicates to the <a href="https://www.youtube.com/channel/UC2_5lHYRDtQPZW1t0PHBInA">Future of Financial Modeling</a> and also provide access to <a href="https://www.eloquens.com/channel/lance-rubin">Models via Eloquens</a> with thousands of viewers and downloads.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=97985d7ea949" width="1" height="1" alt=""><hr><p><a href="https://medium.com/making-informed-relevant-and-purposeful-decision/how-do-you-recruit-strong-financial-modeling-skills-in-your-team-97985d7ea949">How do you recruit strong financial modeling skills in your team?</a> was originally published in <a href="https://medium.com/making-informed-relevant-and-purposeful-decision">Making informed, relevant and purposeful decision with insight.</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[FORECASTING SKILLS DOESN’T GUARANTEE GOOD MODELING SKILLS]]></title>
            <link>https://medium.com/making-informed-relevant-and-purposeful-decision/forecasting-skills-doesnt-guarantee-good-modeling-skills-d9f12df9accb?source=rss-43a6fc2d8cfc------2</link>
            <guid isPermaLink="false">https://medium.com/p/d9f12df9accb</guid>
            <category><![CDATA[future-of-finance]]></category>
            <category><![CDATA[financial-modeling]]></category>
            <category><![CDATA[modeling]]></category>
            <category><![CDATA[finance]]></category>
            <category><![CDATA[financial-modelling]]></category>
            <dc:creator><![CDATA[Lance Rubin]]></dc:creator>
            <pubDate>Thu, 14 Mar 2019 04:53:54 GMT</pubDate>
            <atom:updated>2019-03-14T04:53:54.629Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8eegqrqzJ2l1_iP1wyalJA.jpeg" /></figure><p><strong>Introduction</strong></p><p>Just because you can drive a car doesn’t mean you can be a Formula 1 race car driver.</p><p>Playing T20 cricket doesn’t guarantee you will be a great test cricketer.</p><p>The same goes for forecasting and financial modeling.</p><p><strong>Let’s start from the beginning.</strong></p><p>Shortly after leaving investment banking corporate finance, where my financial models produced forecasts for investors or shareholders and needed to be audited, I joined a traditional finance team.</p><p>One day, as the finance business partner, I was debating the concept of financial modelling with one of the FPA team leaders.</p><p>A claim was made that as a result of building many forecasts this would naturally mean he had lots of financial modelling skills. …. (no auditor had ever checked those forecasts, so there are bound to be errors….there always are unless its audited…and even then its not guaranteed.)</p><p>However, I had a different view.</p><p>He had certainly developed the ability to build a forecast spreadsheet but could he actually build a good (dynamic) financial model with multiple scenarios and simulations?</p><p>Whilst I agree there are certain skills that are similar, there are still many gaps that most are not even aware of.</p><p>So lets really define the spreadsheet in comparison to a financial model.</p><p><strong>Forecasting vs Modeling</strong></p><p>In my experience having reviewed many forecasts produced by finance professionals including members of my own team, I noticed the following common differences between a good financial model and a forecast spreadsheet.</p><p>Lets compare simply</p><p><strong>Structure</strong></p><p><strong>Finance Forecast</strong></p><p>Difficult to see any formal structure in the models, especially when wanting to understand where you might find the assumptions to the model and the key outputs, KPIs etc. Its difficult to see where it started and ended.</p><p>I have seen very limited examples of a really good finance forecasts built like a financial model.</p><p>It’s like walking to someone’s house and you’ve walking through the garden at the back and you just don’t know where to find the toilets or where the people hangout.</p><p><strong>Financial Model</strong></p><p>The financial model has clearly delineated assumptions and outputs.</p><p>It may even have navigation links (hyperlinks) in a table of contents to make it really easy.</p><p>Ease of navigation and whilst there might be different styles applied, it is important to even to show on a “cellular” level the assumptions and outputs should be easily visiable.</p><p><strong>Formulas</strong></p><p><strong>Finance Forecast</strong></p><p>In the finance spreadsheets the formulas are often hard-coded values and seldom will they be consistent horizontally.</p><p><strong>Financial Model</strong></p><p>In the financial model this is a rule that is never broken.</p><p>Formulas are always written on a consistent horizontal basis to enable flexibility of logic.</p><p>If hardcoded it renders it model inflexible which is one of the pivotal parameters of a good financial model.</p><p><strong>Error detection and prevention</strong></p><p><strong>Finance Forecast</strong></p><p>A finance spreadsheet will seldom have error detection and definitely in very very few circumstances error prevention.</p><p>I have seen some error detection in spreadsheets, but hardly any (less than 1% have I seen with error prevention, like data validation.</p><p><strong>Financial Model</strong></p><p>All good models have lots of error detection (the more the better). Its like adding all these safety belts, airbags and many more to your racing car.</p><p>Some really good ones come with built prevention so you cannot even make an error even if you tried.</p><p>Its like your breatherliser test built into the car that says you are too tipsy to be allowed to change this model.</p><p><strong>Scenario management, simulations and sensitivities</strong></p><p><strong>Finance Forecast</strong></p><p>The purpose of a finance forecast generally doesnt include scenario management and simulation is unheard of. Happy to hear otherwise.</p><p>The purpose of a finance forecast is to get a forecast which becomes the budget for the following year…or perhaps in some quarters an update or quarterly business review.</p><p>There’s a lot of pressure, with lots of stakeholders and it’s not possible to always add this very important step to the budgeting and forecasting process.</p><p>It takes too long and generally there is limited strong skills that can build something like that robustly.</p><p><strong>Financial Model</strong></p><p>The entire purpose of building a financial model is absolutely to do scenario analysis and sensitivities as well as Monte Carlo simulation.</p><p>The whole purpose of building the model is it’s the engine to your financial decision making, so this is highly valuable.</p><p><strong>Value Drivers (driver based) vs Growth rates (run-rate based)</strong></p><p><strong>Finance Forecast</strong></p><p>Because a finance spreadsheet is not built for the purposes of doing scenario analysis, but really to get lots of people to agree to a number (including the board), the value drivers are often left out.</p><p>Shortcuts to get to the forecast are put in its place and the output (often top down) It given as the outcome others need to work out to achieve.</p><p>Its like building the building and then asking the architect to draw it. That sounds like a really stupid idea.</p><p><strong>Financial Model</strong></p><p>All good financial models are built from the ground up based on the detailed drivers, not just the past results.</p><p>Building a model with actual value drivers that you can go back test and also look at the accruracy of those drivers (you unlikely to get it correct the first time) is the best result as the model improves in accuracy over time.</p><p><strong>Graphs, charts and other outputs</strong></p><p><strong>Finance Forecast</strong></p><p>Very few finance forecast actually have a lot of graphs and outputs</p><p>Seldom do people recognise that a chart can actually show accuracy of the model and be very useful, not just pretty pictures for a deck.</p><p><strong>Financial Model</strong></p><p>In many, if not all cases, a financial model is built with charts as a means of using them as a sniff test mechanism and for some pretty pictures.</p><p>Whether it’s cash going backwards or certain key ratios, it’s important to know whether those go out of a certain tolerances graphically.</p><p><strong>User instructions or guide like a table of contents</strong></p><p><strong>Finance Forecast</strong></p><p>If you dont have the luxury of someone waking you through the spreadsheet succinctly, you wont even have a map or understanding of where you going.</p><p>It can feel like you have dropped in the middle of the desert not sure which way to go to the oasis.</p><p><strong>Financial Model</strong></p><p>Financial modelers take a lot of pride in their work.</p><p>A financial modeler will build a model in a way that the experience is plesent.</p><p>Nice visibly appealing and interactive, like a great host with easy-to-navigate structure and table of contents with hyperlinks.</p><p>They really make it easy for you to enjoy your time while you understand what the models is currently modelling and forecasting for the future.</p><p><strong>Conclusion</strong></p><p>If you want to learn more in 2019 and also understand how you can upskill in FM be sure to reach out to us or stay tuned.</p><p>I encourage you to also take a peak at my past articles on financial modeling which is the foundation of business decision making, planning and forecasting.</p><p>We have also redesigned our website to help you along your journey of levelling up in this space.</p><p>We will continue to discuss this topic and you can click to follow me on Twitter or LinkedIn or subscribe to our short but sweet newsletter.</p><p>Be sure to check out our <a href="https://www.modelcitizn.com/pods-videos/">pods and video</a> page.</p><p>Here are also some past blogs that might be of interest.</p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/5/2/excel-is-dead">Excel is dead!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/13/why-i-disrupted-my-own-role-and-you-should-do-the-same">Why I disrupted my own role and you should do the same?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/your-financial-model-can-save-lives-">Your Financial Model can save lives!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/https/mediumcom/making-informed-relevant-and-purposeful-decision/why-financial-modelling-skills-will-be-a-big-career-door-opener-for-emerging-accounting-and-finance-8ef3b9cac5f3">Why financial modelling skills will be a big career door opener for emerging accounting and finance talent.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/the-demand-for-financial-modeling-skills-reaches-new-heights">The Demand for Financial Modeling Skills Reaches new Heights</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/7/18/part-2-of-finance-innovation-big-data-and-data-analytics-is-not-financial-modeling">Data Analytics / Big Data is not Financial Modeling</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/8/22/do-you-model-off-against-the-masters-of-financial-modelling">Do You Model Off against the Masters of Financial Modelling?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/10/18/virtual-cfo-the-good-bad-and-theugly">Virtual CFO the Good, Bad and the Ugly</a></p><p>Lance Rubin is the Founder of Model Citizn, partner of theOutperformer, approved training provider to the Financial Modeling Institute and Group CFO for SequelCFO.</p><p>I have more than 20 years of combined experience working in model audit, investment banking, corporate finance, finance business partner and Fintech CFO.</p><p>Organisations I have worked with include PwC, KPMG, National Australia Bank, Investec Bank and Banjo small business lender.</p><p>I have a YouTube channel dedicates to the <a href="https://www.youtube.com/channel/UC2_5lHYRDtQPZW1t0PHBInA">Future of Financial Modeling</a> and also provide access to <a href="https://www.eloquens.com/channel/lance-rubin">Models via Eloquens</a> with thousands of viewers and downloads.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d9f12df9accb" width="1" height="1" alt=""><hr><p><a href="https://medium.com/making-informed-relevant-and-purposeful-decision/forecasting-skills-doesnt-guarantee-good-modeling-skills-d9f12df9accb">FORECASTING SKILLS DOESN’T GUARANTEE GOOD MODELING SKILLS</a> was originally published in <a href="https://medium.com/making-informed-relevant-and-purposeful-decision">Making informed, relevant and purposeful decision with insight.</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[HOW TECHNOLOGY WILL CHANGE FP&A FOREVER]]></title>
            <link>https://medium.com/@lancerubin/how-technology-will-change-fp-a-forever-b79a620b2275?source=rss-43a6fc2d8cfc------2</link>
            <guid isPermaLink="false">https://medium.com/p/b79a620b2275</guid>
            <category><![CDATA[financial-modelling]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[cloud-computing]]></category>
            <category><![CDATA[financial-modeling]]></category>
            <category><![CDATA[big-data]]></category>
            <dc:creator><![CDATA[Lance Rubin]]></dc:creator>
            <pubDate>Mon, 11 Mar 2019 21:20:33 GMT</pubDate>
            <atom:updated>2019-03-11T21:20:33.315Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MM8wHA3tr4aKNK9NZXYnKw.jpeg" /></figure><p>This article is co-written by <a href="https://www.linkedin.com/in/cashflowmodeling/">Lance Rubin</a> and <a href="https://www.linkedin.com/in/andersliulindberg/">Anders Liu-Lindberg</a></p><p>You don’t have to be a data scientist or technologist to know that the impact of technology on FP&amp;A will be significant. If you are skeptical look at previous blogs written by Lance where he <a href="https://www.linkedin.com/pulse/why-i-disrupted-my-own-role-you-should-do-same-lance-rubin/">disrupted his own role</a>.</p><p>But one of the biggest challenges of automation (RPA) and AI/machine learning technologies is our mindset. It is critical for the success in our careers and the companies where we aim to drive the right strategic choices.</p><p>However, with so many new acronyms and complex terms it’s proving difficult for us to get comfortable with it and the mindset shift appears somewhat crippling, but it doesn’t have to be.</p><p>To tackle this and help you gain some insight we assess this by adopting the four attributes of curiosity, courage, crystal ball, and clarity which was defined in the mindset article as the critical attributes to future success of FP&amp;A.</p><p><strong>Curiosity</strong>: Sparks new found curiosity on how much of the boring stuff can be automated, giving us more time to build relationships, find value creating opportunities and listen to our key stakeholders.</p><p><strong>Courage</strong>: It will no doubt take a huge dose of courage to not only start but execute on the transformation. These are often not “out of the box”, “plug n play” solutions and will require us to spend time learning new skills in process automation, analytics and financial modeling. We don’t need to know exactly how to do it for all of these but at least understand how they work, where they can add value and where they won’t.</p><p><strong>Crystal ball</strong>: AI based machine learning and predictive analytics will start to give us more powerful crystal balls. Adopting more advanced Monte Carlo simulation. This is a space that is largely unexplored and represents immense potential for us to understand, interpret, communicate and execute on these predictions. At times even call out when they might be wrong (which won’t be often but can still happen).</p><p><strong>Clarity</strong>: Technology will help guide our roles more clearly over time and the mindset shift will hopefully become more tangible and easy to absorb.</p><p>Just as well as our mindset is on a journey when it comes to understanding innovative technologies so is data. Data is travelling from Sources to Uses, with the hourglass as a metaphor of gathering vast amounts, processing and then disseminating.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/234/1*2S5_SBc0MdBLqWyJL7bamw.png" /></figure><p>More data is being created (IOT as an example) and captured (Cloud), and our ability to analyze it as humans is magnified by automation (RPA).</p><p>We need the tools to keep up, but the tools also need us to be effective (Analytics).</p><p>Goal is analytics to insight that can then be shared via any number of mechanisms (Mobile and Social being just examples).</p><h3>EXPLORING THE TECH STACK SMORGASBORD</h3><p>To further help you understand how technology will change FP&amp;A let’s explore the art of the possible. Paresh Mistry has published a blog which provides a good framework as a starting point. <a href="https://www.accaglobal.com/us/en/member/member/accounting-business/2017/10/in-focus/robot-process.html">Read more here</a></p><p>As visualized above we’ll use the ICRAMS model (Internet of Things (I), Cloud ©, Robotic process automation (R), Analytics (A), Mobile (M) and Social (S)). ‘ICR’ acts as the enabler and sensors; ‘AMS’ is the feedback and decision-making engine.</p><p>Let’s focus on the ones that have had the biggest impact to date and proven business outcomes.</p><p><strong>Cloud</strong></p><p>No question the leaders in this SME space are Xero and Intuits QBO. The API (application protocol interface — how machines talk to each other) connected ecosystem of apps is a game changer.</p><p>Something the larger ERP systems can learn from with decentralized app development. Most ERPs are closed systems meaning they won’t necessarily suit everyone and as a result ERPs sometimes result in more spreadsheets not less.</p><p><strong>RPA</strong></p><p>It comes in many different shapes and sizes that range in complexity. I love the way Chris Argent explained RPA with micro and macro macros.</p><p>There are a few out there:</p><p><em>Excel automation (micro macro/tools)</em></p><p>The often-forgotten Excel macro (VBA code based), Excel add-ins like Modano and DataDear for a range of data importing, model building and automation of manual processes within Excel without coding (managed Excel), Excel’s own in-built tools for getting data like PowerQuery, PowerPivot and the ever-increasing functionality like dynamic arrays etc. Excel enterprise management tools like Vena solutions for example which contain a range of other tools surrounding the Excel enterprise environment.</p><p><em>Cross system (macro macros)</em></p><p>Macro macros with cross system process automation like Automation Anywhere, Solvexia, Blue Prism, UiPath, Xceptor and Redwood.</p><p>RPA is the enabler for creating more time to explore other technologies and free up substantial amounts of time that is needed to learn new skills. The spare capacity can also be used to focus on value adding decision making tasks and therefore should be an opportunity, not a threat.</p><p><strong>Analytics</strong></p><p>Firstly, it includes all forms of analytics which are heavily data-driven. Especially clean data or even enriched data which brings financial and non-financial information together can be powerful.</p><p>As the reliance on data-driven decisions becomes more prevalent in Finance, there is a need to manage data better and remove data anomalies or errors in the “cleansing” process. The “dirty” data can cause false positives or other issues as a result of the data being incorrect, often caused by a human.</p><p>Once cleansed its possible to enrich the data for example a customer name and ID is not as valuable as the customer’s postal code, income bracket or other spending habits which could be enriched from data collected from Google for example. This enriched data can then inform the marketing team more specifically the personas and buying habits for their products and in order to achieve higher ROI from marketing spend.</p><p>There are even some technologies which can extract insight from not so “clean” data to identify trends and anomalies.</p><p>The forms of analytics are typically descriptive, diagnostic, predictive and prescriptive, each of which have a focus either backward looking or forward looking and range in complexity as a result.</p><p>These will certainly give you lots of insight and some very narrowly defined foresight, but unlikely to ever be widely defined 3-way predictions for Finance.</p><p>3-way predictions or forecasts typically include the Income Statement, Balance Sheets and Cash Flow Statements. These forecasts are more aligned to financial modeling, rather than analytics as they include the balance sheet positions, cash flows and profitability in an integrated manner.</p><p>Technologies used in Analytics include applications like PowerBI, Tableau, Qlik, Domo and many more. The predictive and prescriptive aspects require the use of machine learning and other code-based languages like Python and R scripts.</p><p>The Analytics applications include data visualization tools as well as data ingesting capabilities across numerous sources from web pages to databases to core accounting systems.</p><p><strong>Financial Modeling</strong></p><p>Modeling can come in various forms including predictive modeling and data modeling mentioned above.</p><p>Generally Financial Modeling is extensively used within Excel. Major investment banks and project and infrastructure finance but also for business in robust cash flow modeling. It’s possible to build models on other applications like Google Sheets etc., but these tend to be for simpler models.</p><p>However, there are other powerful add-ins like Modano for building 3-way models quickly, DataDear for extracting and pushing data between the cloud package and spreadsheets and interactive modeling visualization of Modeler which also has 2-way data flows. The combination of these make it very powerful as well as visually appealing.</p><p>We know that is a lot to take in but simply showing you the art of the possible should prepare you for what’s coming your way. It should also help you formulate an ambition for how you want to use technology in your FP&amp;A transformation.</p><h3>IT’S NOT THE TECHNOLOGY STUPID</h3><p><strong><em>AI + Human &gt; AI alone.</em></strong></p><p>This is a fact, so whilst large parts of what we do today will change, most of what we are going to be doing in the future is still uncharted and more opportunities will be created as a result as we create innovative solutions by applying what’s often open source i.e. “free”. Only if we are open to them though.</p><p>In the great words of Dr Carol Dweck, “Yet”.</p><p>We might not yet be ready, but we certainly can be if we embrace the massive opportunity we have, to leverage data, technology and value creation through softer skills of influencing and story-telling. The technology is there and will only get better. What matters is how we as humans adopt this technology and embed it into our way of working.</p><p>The longer we resist the more opportunities we miss out on. Technology presents a massive opportunity for FP&amp;A to enable the transformation that must happen. Excel is great if you know how to use it properly yet the clear majority of us don’t. Therefore, technology might help give you the boost you need to let go of low value-adding tasks and start driving the right strategic choices in the company.</p><p>What’s your approach to technology? Are you embracing everything that’s coming at you or taking a skeptical approach thinking what you have is just fine? We would love to hear about successful technology adoptions or even how you managed to boost your productivity by simply using Excel better so show us what you’ve got!</p><p>You can also take a peak at my past articles on financial modeling which is the foundation of business decision making, planning and forecasting.</p><p>We will continue to discuss this topic and you can click to follow me on Twitter or LinkedIn or subscribe to our short but sweet newsletter.</p><p>Be sure to check out our <a href="https://www.modelcitizn.com/pods-videos/">pods and video</a> page.</p><p>Here are also some past blogs that might be of interest.</p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/5/2/excel-is-dead">Excel is dead!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/13/why-i-disrupted-my-own-role-and-you-should-do-the-same">Why I disrupted my own role and you should do the same?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/your-financial-model-can-save-lives-">Your Financial Model can save lives!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/https/mediumcom/making-informed-relevant-and-purposeful-decision/why-financial-modelling-skills-will-be-a-big-career-door-opener-for-emerging-accounting-and-finance-8ef3b9cac5f3">Why financial modelling skills will be a big career door opener for emerging accounting and finance talent.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/the-demand-for-financial-modeling-skills-reaches-new-heights">The Demand for Financial Modeling Skills Reaches new Heights</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/7/18/part-2-of-finance-innovation-big-data-and-data-analytics-is-not-financial-modeling">Data Analytics / Big Data is not Financial Modeling</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/8/22/do-you-model-off-against-the-masters-of-financial-modelling">Do You Model Off against the Masters of Financial Modelling?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/10/18/virtual-cfo-the-good-bad-and-theugly">Virtual CFO the Good, Bad and the Ugly</a></p><p>Lance Rubin is the Founder of Model Citizn, partner of theOutperformer, approved training provider to the Financial Modeling Institute and Group CFO for SequelCFO.</p><p>I have more than 20 years of combined experience working in model audit, investment banking, corporate finance, finance business partner and Fintech CFO.</p><p>Organisations I have worked with include PwC, KPMG, National Australia Bank, Investec Bank and Banjo small business lender.</p><p>I have a YouTube channel dedicates to the <a href="https://www.youtube.com/channel/UC2_5lHYRDtQPZW1t0PHBInA">Future of Financial Modeling</a> and also provide access to <a href="https://www.eloquens.com/channel/lance-rubin">Models via Eloquens</a> with thousands of viewers and downloads.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b79a620b2275" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[WHY SO MANY UNEMPLOYED ACCOUNTANTS ARE ALREADY STRUGGLING..AND HOW I CAN HELP.]]></title>
            <link>https://medium.com/making-informed-relevant-and-purposeful-decision/why-so-many-unemployed-accountants-are-already-struggling-and-how-i-can-help-582344db0413?source=rss-43a6fc2d8cfc------2</link>
            <guid isPermaLink="false">https://medium.com/p/582344db0413</guid>
            <category><![CDATA[cashflow-modeling]]></category>
            <category><![CDATA[financial-modeling]]></category>
            <category><![CDATA[future-of-finance]]></category>
            <category><![CDATA[financial-modelling]]></category>
            <dc:creator><![CDATA[Lance Rubin]]></dc:creator>
            <pubDate>Thu, 14 Feb 2019 23:13:27 GMT</pubDate>
            <atom:updated>2019-02-14T23:29:06.117Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>WHY SO MANY UNEMPLOYED ACCOUNTANTS ARE ALREADY STRUGGLING..AND HOW I CAN HELP?</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*abPWIhfa7vdZuG46_YGucA.jpeg" /></figure><h3>BACKGROUND</h3><p>I often get direct messages on LinkedIn from people asking me for either a job, career advice or helping them understand financial modelling and how do they apply for jobs in Australia, thinking Australia is immune to accountants losing jobs or unable to get them.</p><p>It’s quite surprising that still despite the availability of some great information online, most of which is free, many of the people that I talk to you are really stuck and unable to get a job or just not able to really navigate the sort of challenges that we have in accounting and finance today.</p><h3>ALL IS NOT LOST, WE HAVE OPTIONS (IF WE TAKE THEM)</h3><p>Part of the problem is there is too much information, fake news and marketing messages that tell the story that all accountants will be replaced by robots.</p><p>This sweeping statement, (regularly refuted) is starting to ring true for those unwilling to learn new skills and technology or invest the time reading and discovering them online.</p><p>LinkedIn has got to be the best place to start, yet many people just don’t leverage it nearly enough to learn, not just to connect. I am learning every day from many people in LinkedIn, especially those on Ander’s Masters list.</p><p>My personal take is that accountants that do not evolve and change with technology will be replaced. But for the rest that are keen to learn, there is lots of great opportunities.</p><p>Technology will enable and in some cases force change to occur. For those not willing to evolve its already proving challenging.</p><p>I am living proof of capitalising on those great opportunities, I hope that I can inspire people not to give up but also to evolve and learn new things.</p><p>I know of many qualified people that have been out of a job for a fairly extensive period of time and just unable to get employment.</p><p>I have also spoken to recruiters who have many qualified chartered accountants on their books with great cv’s just not able to get their next role. Just see the number of “looking new opportunities” in LinkedIn.</p><p>What is equally disturbing is many of those highly trained and qualified individuals are having to downgrade the jobs they take just to have something.</p><p>A manual record keeping/bookkeeping job done by qualified chartered accountants or an MBA graduate cannot be good for one’s self esteem. No disrespect to bookkeepers of course.</p><h3>TOP 10 CHALLENGES FACING FINANCE PROFESSIONALS</h3><p>These are the top 10 challenges I see facing this group of ever increasing and lost finance professionals based on my interactions with them. Many of these people:</p><p>1) are not aware they need to up skill despite having great CVs and big company/overseas work experience. Big names on CVs don’t mean as much these days as they did in the past.</p><p>2) do not really understanding deeply the concept of a finance business partner, only that its something they know they need to get into or be seen as one but have never been one. They cannot clearly articulate what it means to be one.</p><p>3) are blissfully unaware of how fast things have already changed in the finance industry (whilst they were employed) and enhancements to their best software package #Excel. Most never even heard of 3-way modeling, #PowerQuery and #PowerPivot the backbone of #PowerBI….don’t even get me started on Monte Carlo simulation.</p><p>4) think getting an MBA qualification is the answer, yet not willing to spend money and invest in practical skills vs a traditional qualification/certificate. Most are not even aware of the #FMI (Financial Modeling Institute) or #Modeloff (World Financial Modeling championships). Or the difference between Analytics and Modelling.</p><p>5) are unaware that #FinancialModeling is not just spreadsheeting and the gap between their #Excel and a robust 3-way rolling model is massive.</p><p>6) think running a small business as a VCFO will solve all their problems only to find more problems as they dont have the infrastructure to scale their business.</p><p>7) are not being tech savvy regarding cloud adoption, accounting apps or listening to podcasts (which are free) or find much needed answers is a big issue. Many don’t even know what an API is or that we are already living in the matrix of interconnected machines.</p><p>8) are unaware of the many social media thought leaders who share free ideas and concepts.</p><p>9) are confused and believing that their accounting body has their best interests at heart and can help them navigate these challenges.</p><p>10) have a mindset that is stuck in the past like all their fellow accountants who are equally ill-equipped to advise them on what to do next.</p><h3>HOW I CAN HELP?</h3><p>Having recently spoken to over 500 professionals in 4 countries face to face or online, all I can say is that are not alone.</p><p>You are certainly not going mad and no someone is not out to get you or ruin your career and life. I thought that for a short time.</p><p>A lot of accountants are confused, frustrated and feeling the profession is letting them down. Being an accountant today is not as rosy at it used to be.</p><p>I presented at AccountechLive in Nov 2018 to provide some helpful tips for delivering CFO services. But assume you don’t want to take that leap and start your own consultancy.</p><p>What should you do?</p><p>What would I do if faced with similar challenge?</p><h3>7 STEPS YOU CAN TAKE TODAY.</h3><p>Here are a few basic steps I would highly recommend you to do…best part it will cost you nothing but some time.</p><p>Please share with your friends, family or colleagues that are potentially also stuck.</p><p>1. Spend your travel or dog walking time (as I do) listening to some or all of these podcasts/webinars which are focused on finance and accounting.</p><p>Here are links to some helpful podcasts and webinars. I learn a lot of the many thought leaders and their guests on the podcasts. out there in Finance.</p><p><a href="https://financialmodellingpodcast.com/">THE FINANCIAL MODELLING POSTCAST</a> -with Matthew Bernath</p><p><a href="https://www.fromthetrenches.com.au/">FROM THE TRENCHES</a> — with David Boyar and Paul Meissner</p><p><a href="https://sitnshow.com/">STRENGTH IN THE NUMBERS</a> — with Andrew Codd</p><p><a href="https://generationcfo.com/podcast/">GENERATION CFO</a> — Chris Argent</p><p>Here is a <a href="https://www.modelcitizn.com/pods-videos">link</a> to the ones where we specifically discussed Financial Modelling.</p><p>2. Follow these thought leaders in finance and accounting and read their posts, blogs and comments. Interact and even maybe… If you feel brave, start to write some yourself. Someone might notice.</p><p>3. Get up the skills curve in financial modelling. You might want to start with this blog post I wrote a while back.</p><p>4. Understand the world of analytics and start to play with tools like PowerBI. It’s free with Excel, so no excuses you cannot afford it. Lots of free help videos.</p><p>5. Attend meetups, networking events and get away from behind your PC and talk to people out there. If Excel is your passion come to the #financial modelling in Excel meetup which is hosted around the world. They are free too.</p><p>6. Stop making excuses and blaming others or the system you live in, take action and do something about it.</p><p>7. Read Dr Carol Dweck book on Mindset or simply watch her TED talk.</p><p>The world is changing and sadly being a qualified chartered accountant is no longer guaranteed employment. If you haven’t changed jobs in the last 5 years you probably unaware of this. I was certain my career was safe in a large corporate with more than 30,000 staffs. I was so wrong</p><h3>CONCLUSION</h3><p>All is not lost as it might seem in the media, but the time to act is now and the gaps that exist today will only widen and opportunities to add value will be more complex.</p><p>I trust this is post is useful to you in planning your 2019.</p><p>I encourage you to take a peak at my past articles on financial modeling which is the foundation of business decision making, planning and forecasting.</p><p>We have also redesigned our website to help you along your journey of levelling up in this space.</p><p>We will continue to discuss this topic and you can click to follow me on Twitter or LinkedIn or subscribe to our short but sweet newsletter.</p><p>Be sure to check out our <a href="https://www.modelcitizn.com/pods-videos/">pods and video</a> page.</p><p>Here are also some past blogs that might be of interest.</p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2018/5/2/excel-is-dead">Excel is dead!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/13/why-i-disrupted-my-own-role-and-you-should-do-the-same">Why I disrupted my own role and you should do the same?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/6/10/your-financial-model-can-save-lives-">Your Financial Model can save lives!</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/https/mediumcom/making-informed-relevant-and-purposeful-decision/why-financial-modelling-skills-will-be-a-big-career-door-opener-for-emerging-accounting-and-finance-8ef3b9cac5f3">Why financial modelling skills will be a big career door opener for emerging accounting and finance talent.</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/the-demand-for-financial-modeling-skills-reaches-new-heights">The Demand for Financial Modeling Skills Reaches new Heights</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/7/18/part-2-of-finance-innovation-big-data-and-data-analytics-is-not-financial-modeling">Data Analytics / Big Data is not Financial Modeling</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/8/22/do-you-model-off-against-the-masters-of-financial-modelling">Do You Model Off against the Masters of Financial Modelling?</a></p><p><a href="https://www.modelcitizn.com/cashflowmodeling/2017/10/18/virtual-cfo-the-good-bad-and-theugly">Virtual CFO the Good, Bad and the Ugly</a></p><p>Lance Rubin is the Founder of Model Citizn, partner of theOutperformer, approved training provider to the Financial Modeling Institute and Group CFO for SequelCFO.</p><p>I have more than 20 years of combined experience working in model audit, investment banking, corporate finance, finance business partner and Fintech CFO.</p><p>Organisations I have worked with include PwC, KPMG, National Australia Bank, Investec Bank and Banjo small business lender.</p><p>I have a YouTube channel dedicates to the <a href="https://www.youtube.com/channel/UC2_5lHYRDtQPZW1t0PHBInA">Future of Financial Modeling</a> and also provide access to <a href="https://www.eloquens.com/channel/lance-rubin">Models via Eloquens</a> with thousands of viewers and downloads.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=582344db0413" width="1" height="1" alt=""><hr><p><a href="https://medium.com/making-informed-relevant-and-purposeful-decision/why-so-many-unemployed-accountants-are-already-struggling-and-how-i-can-help-582344db0413">WHY SO MANY UNEMPLOYED ACCOUNTANTS ARE ALREADY STRUGGLING..AND HOW I CAN HELP.</a> was originally published in <a href="https://medium.com/making-informed-relevant-and-purposeful-decision">Making informed, relevant and purposeful decision with insight.</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>