top of page

Plotting the Cash Flow Table

In order to understand our web application you will have to be familiar with the concept of charting and specifically line plotting. If you are already familiar with plotting lines you can skip this introduction but if not, this introduction will explain how we get from a cash flow table to the charts that you see in our app.



This guide is for absolute beginners who might not be familiar with how you can take the cash flow table you see above on the left and turn it into the line plot that you see above on the right. Using mostly pictures, we will show you how this works here.


Below is an example of a Cash Flow Table with made up numbers. We expect that you are used to seeing Reserve Fund Forecasts in this format from all the Reserve Fund Studies your building has conducted. It's the standard way of representing a reserve fund forecast. We will now introduce you to a new way of representing a forecast.



Below is the same Cash Flow Table as above but with the following two columns highlighted: 'Year' and 'Closing Balance'. Remember, the 'Closing Balance' is the amount forecasted to be in the Reserve Fund at the end of the fiscal year (after Expenditures, Contributions and Interest is added or substracted).



Below we see the same 'Year' and 'Closing Balance' columns with the other columns removed.



Next, we rotate the previous image 90 degrees counter clockwise with no other changes. You can see the Years are now increasing from left to right instead of from top to bottom.



We see a bigger jump here. From the previous image, we have taken the dollar amounts in the 'Closing Balance' column and given them each a yellow bar with a height corresponding to the amount. The bigger the amount, the taller the bar is and vice versa.



This is where we see our first plotted line. All that means is that we've drawn a line along the top of each of the yellow bars. We are now representing the Closing Balance in two ways: with a line and with bars. In graphing terms, we would call these a line chart and a bar chart.



For this image we remove the bars with the numbers inside, but keep the same black line which we changed to a yellow line. The horizontal dotted lines are used to show you how the vertical space in this chart (i.e. the Y axis) represent the dollar values of the graphing space. Similarly, the horizontal space (i.e. the X axis) is being used to represent time in Years.



Now that the basic idea behind a line plot has been shown we are able to visually compare two sets of numbers. This was not possible in the original cash flow format which showed dollar amounts as numbers only. The yellow line here is still the original 'Closing Balance' but an additional blue line was added that represents what we call the 'Simulated' forecast. We can easily compare these lines and see that the blue line grows slower than the yellow one.



This final image shows how we represent uncertainty using a plotted line. The shaded light blue area that you see around the blue line, also called a cone, is used to represent the possible range of outcomes for the Simulated forecast. In reality, we can never forecast perfectly, so we use this cone to show what is possible where the solid blue line is the most likely outcome of what might happen.



Hopefully this gives you a good basis for reading the charts that you will see across our articles and inside of the app. Thanks for reading!


Comments


bottom of page
<