bodybuilding diet excel spreadsheet
alright... why use a financial model so we're just going to start with a little bit theoretical then we'll get to the good example which is the the more interesting part here and it helps you better deliver your programs or services or products that are needed in in your market and it can help you say okay we
have 27 programs going on for example but we really need to focus in as we think about these three or four from a financial perspective they're our biggest economic drivers so it can help you do that and it can engage other folks like you said not everyone is a finance person so models are a way that you can engage people on in a more
meaningful conversation often using some charts and graphs and data visualization and two to help people who don't like looking at you know an income statement or a balance sheet and then lastly i think this is important if you don't tell your financial story someone else is going to so if you don't have a model or some sort of tool that helps you say
when this might happen here's how it will impact us other people are going to write that story for you and so it's important to get ahead of this ok a few things we want to think about when we talk about financial modeling so number one who's your audience who are you building this model for is it to be
used by your membership department and if so what stuff do they care about they probably care about number of members may be more than they care about the revenue and they might care about a member engagement and how does this model help track that and so so models don't have to be only dollar signs we see a lot of models and are good ones i
think have a lot of operational data in them as well is your is your audience board members or finance committee members and what sort of data is helpful for them and how do they like to consume so building up the last presentation talking about if you have a bunch of millennials as the audience for your financial model and not sure at this
point and that would be your main audience but if you do how do millennials like to consume data it's a lot different than your your gen xer gen-y folks and the other people who might use your financial model a beneficiary from your organization and a key partner watchdog group sometimes we'll look at financial models and if
these are things you make available publicly most often we see financial models are internal tools but sometimes it might be something that you would put out on your website say for folks to see what is the financial modeling is some things it's not others and it's a tool that animates the key drivers so we're boiling your whole organization down
into what things matter most generally from a financial perspective but you can look at others as well so it's langley boiling it down to say what are the key drivers of our organization it's only as good as the people and process wrapped around it and we talked about this a lot of cla in terms of even when we do a project like this who's on the team you
need a really strong modeler someone who can build cool stuff in excel or whatever tool and you also need people who can facilitate the process i would often argue that the process is more important and as we get to some of those quotes from this this organization we did this with what to me was most enlightening is a lot of a lot of their
quotes a lot of their feedback was really about getting people in the organization speaking the same language when it came to financial performance not necessarily i really liked this graph right so it's more about are we talking about the same things and meeting them in the same way something that can be built into the rhythm of
your organization what we hope is that a financial model is not some cool thing you build once and then it sits in that why drive or whatever your filing system is and you know people pull it out every five years when you do strategic planning that's that's not ideal and i would say best-case scenario your management team is using this model
real-time every single management meeting so that you say what if we did this and then you can model out the strategy behind it one of the models that will show you is something that's really good for that that interactive lifetime type of a situation but it's not and this is where like people who really like modeling so
so i'm kind of like on the middle of the spectrum i like modeling i don't love modeling by like what modeling can do and sometimes people who love modeling think it's an excuse to say look how complicated we are look how complex everything at this organization is that's kind of the opposite of what you want to do you want
this thing to be really user-friendly which means boiling it down again that the biggest things that matter and not necessarily going into every single detail financial models are not one-size-fits-all as i look over here at and john tower who's here from from la from minneapolis and he and i talked a lot about product izing things so what
are things we can make a product that we can bring to people in a really efficient way and my pushback on financial modeling is always yes there are baseline models that we can start with but models really need to be customized to the organization and so we can't just have this off-the-shelf here's your financial model go use it
and because your organizations are all pretty unique and then lastly it's it's not an answer to a question so i would really recommend that you not build a financial model to say okay what is the the size of our budget can be five years from now or what is our net income going to be next year it's not a budget and it
bodybuilding diet excel spreadsheet,shouldn't answer one question it should
allow you to play out a number of different scenarios and see what the possible impact is
src="https://www.youtube.com/embed/6_hTanI2WD8?rel=0" frameborder="0"
allowfullscreen>
Comments
Post a Comment