Model Structure and Navigation

Feanut Model
A free video tutorial from Feanut Model
Financial modeling for a peanut
3.9 instructor rating • 1 course • 1,039 students

Lecture description

In this video you will learn about the main sections of the models and about features that will help you to navigate through the spreadsheet.

Key topics:

  • Model structure
  • Numbering and color-coding
  • Links between worksheets
  • Navigation in the model

Learn more from the full course

Start-up financial modeling for non-finance professionals

A guide for non-finance start-up entrepreneurs to prepare their financial projections hassle-free.

03:55:12 of on-demand video • Updated June 2016

  • Understand financial modeling for start-up business
  • Use provided end-to-end financial model to prepare start-up financial projections
  • Create their own start-up financial plan using the provided financial model
  • Understand key data inputs in the start-up financial model
  • Perform quick scenario modeling in the provided financial model
English [Auto] Hi and welcome back to see that financial model online course in this video I will introduce you to the financial model to its structure to individual worksheets and do its basic functionalities for those of you that purchased the Finot financial model. Take each from us whether you received was a blank version of Phina financial model as well as a model example called pand factory Incorporated which is the example that we really was also over the course of these video lectures. He also received a financial model guide which is basically a guide that explains step by step how to create a financial model using feet up so you get the reference back to this to this guy. And basically we will follow the individual chapters in this in this model guide during our video lectures. So today we'll start with the model introduction and let me John back to the Excel file. So the Exel file any open opened the first page or for the word see is just the cover page. You can click here to go to menu. This is the main menu. All of them all display contains the structure of the mall. Which means individual worksheets in them all and how they are interconnected. Let me quickly explain what you will find in the mall and how you can distinguish between different parts of the mall. So as part of financial modeling best practice we separate individual worksheets into several sections. The first one is called data. And essentially these will be the most important part of the model for you because these are the worksheets where you will populate the data and as a businessman or someone does not have a deep financial knowledge you just need to understand what sort of data are you have to populate into the stables and all the rest is calculated and taken care by the mall itself. So we will spend a lot of time exploring together. What are the requirements on date. I think it's for respire over the mall. The next part of the model is called financial statements. So in here these are actually the modal outcomes. These are Tomalin pools and everything here are the outcomes of the moiling. So what you will get is four different financial statements. The next section you'll get a summary of calculated financial ratios. A simplified version of business valuation and also a worksheet for scenario Amasis which is a very useful option or feature of the model that allows you to model several different scenarios over your financial projections without changing the original data and was so very useful various functionality to play play with. Once you populated your initial data input into the mall and we have some summary section where you will find some pre-designed charts as well as a two page executive summary that takes the key data and key charts from the financial model and also provides a boxes where you can put your comments on different sections of your financial plan. These arrows here shows the flow of the information through the model. So obviously starting with data IPOs that is fed into the financial statements then fire to the analysis section and finally to summarize. There are also three more worksheets that I call a technical worksheet. If you if you will one of them scroll up a summary. This is a worksheet that just summarizes the key input that you provide here in this section of the mall and it summarizes then a ne single single chart where you can put some comments on the assumptions that you use for for a date that you provided in the data and those can be useful alongside with your executive summary. So if you will be presenting the summary of your financial model to someone it might be useful to have a separate worksheet with the comments on the key assumptions key date and good data using them on the next one is least under the table tables. And that's just like a table of contents of all the different tables in the model. This one is useful for you to navigate through the through them all very quickly because everything is linked and interconnected. So if you are looking for some particle table them although you can you can go in here and just click through that part of the model that you are interested and last Lovibond very useful feature call control sheet we will spend more time on these later and it will be a separate video that he gets to control she but basically control she controls whether everything in the model works correctly. And it provides recommendations on solve any potential issues the issues that you can see when you will work with the model could be for example some issue of a more or less technical nature for example you will set up a starting date for your business plan and then some of the daytime stable's you will provide a day that is before your start of the business plan and the and the financial model does not understand it. So for example you will in the daytime but table for your sales you will populate a day that you will start produce again selling certain products at let's say 2000 and 14 but the first period of the your financial model is 2015. If something like that happens you will find this error highlighted in a. That's just one example. And then there could be another sort of errors that are more related to the bee's knees and the result of the financial modeling itself. And this could be for example or some issues related to cash flow. So for example you will Mobil's sales and cost and capital expenditure projections in here as well as some financing data and puts was the model caleche late month by month and year by year. Your financial model may realize that in certain periods you will be you will have a negative cash balance even dead. If that happens in the model the model will highlight that in the outer section and we'll provide you recommendations how you can deal with that situation. Most likely will be you have to either change something in your cost or sell side or you have to change something in your financing. But we will talk about that later in a much more detail. So there was a structure over them all maybe you already realize that there are some there are some different colors and numbers in the model the number and color coding should help you to navigate through it more. So you can see that daytime into worksheet are numbered 0 and are in our color. In light blue Dan financial statements start with number one and are colored color blue. And let you start with number two in our court in a dark blue and so on and so on. So when you are in the mall or you can very quickly say whether you are in a date good worksheet or whether you are someone else's worksheet there is also some additional color coding. Again this is a standard in financial modeling. And this differentiates different self in the model. So whenever the model requires you to put some data I include somewhere DOS fellas are highlighted in yellow and that's the color blue whereas for the calculation the cells are white and the text color is black. So thanks to this color coding you will be able to say immediately whether you are in a date I would sell or whether that cell is a calculation I will go through some examples in in a minute but just to summarize this may you what do you see here is the structure of the model or some explanations or the color coding and numbering all the worksheets. And there is also one useful functionality in here. Everything has hyperlinks in here so you can actually click through these different Botham's and go directly to individual worksheet. So for example if I would like to go to main input worksheet I can just go in here click on the bottom and it will take me to the daytime worksheet for some may a date. And of course I can go back to my menu by clicking the link here in this in this corner and that will take me back to the to the main menu of them all. So you can very quickly navigate through the model just by clicking on these buttons so I can go for example to the list of the tables that I mentioned earlier and click in here. And that will get me to the list of all the tables that are in the model. And again everything is linked here as well. I can click on the worksheet here and that will take me to the main menu worksheet. And here are the individual tables when you click on the name of the table that will take you back to the list of the table. So I click here and it will take me back to the lead of the day I can click on some other table in this list let's say valuations put in the main worksheet I'll click on that and again it will take me to the main input worksheet in here. Evaluation input table. And again I can click on the name of the table and that will take me back to the list of the tables. Here I can click to the manually and that will take me back to the main menu. So you can you can try that by yourself. You will find out that it's actually very easy to navigate through them all. Using these links so you don't have to use the bar at the bottom. And you can very quickly switch from one worksheet to another so that there is it in terms of structure of the model some color coding links between worksheets and in that video we will start with the data input section of the model and we will start with the main input. We will talk about what you will find in this section of the model where the data you populating part over the model will basically start working with our example which is called Band factory which is a fictional business plan or business model that we really use to create a financial model during these online financial modeling course. So whenever we are ready just proceed to the next video and we'll start right from here.