Data inputs generate formula values, which are fully customizable as needed. Here is a quick summary of how data entry flows through the model.
It's important to note, formula values do not have to be customized at all. In fact, if you're happy with the linearish formula values you don't even have to go to these brown "Output Tabs" as the formula values will flow right to the "Financial Reports".
However, these linearish formula values are also fully customizable on the brown "Output Tabs". These tabs correspond to their "Input Tabs".
When or why would customize?
Let's say for example that you expect $20,000 a month of rent grown at 3%
At the start of year 3 you want to renovate and expect to generate $30,000 a month in rent, which will then grow at the same 3%.
However, to do this at the start of year 3 you will not be able to generate any rent as the renovations take place.
On the "Cash Inflow INputs" tab simply override the formula and enter $0 for the first month of year 3 and then enter $30,000 in the month after the renovations are complete.
The model will then automatically update the formula values moving forward with the new $30,000 value grown at 3%.
Lastly, at the end of the model we have “ChickenScratch” worksheets. They are there to give the option to build custom formulas that will flow to other parts of the model. For example, you can create your own custom formula here and have it flow to one of those "Output" worksheets and ultimately the Financial Reports. You can leave these blank if you have no need for custom formulas or create your own if you don’t like the layout.