Cash Flow Analysis Worksheet
Cash Flow Analysis Worksheets — 5 —
Part 2: The Analysis Worksheet
The structure of the analysis worksheet is the same as that for the cash budget worksheet. All of
the categories and their sub categories are carried over from the cash budget worksheet, so any
changes made to the categories will be carried through. The analysis worksheet depicts all costs
on a total acre per crop basis and on a whole farm. The two columns that make the analysis
worksheet different are the percent of operating expenses column and the adjustment column.
Percent of Operating Expenses Column
This area calculates the percent of the total operating expenses for each category for each crop.
This calculation will help define the areas where the majority of the cash expenses occur
(Figure 3, part 1).
This column is used for making adjustments to individual categories for each crop listed. Adjust-
ments can be made on a percentage increase or decrease (Figure 3, part 2). The adjustment
column is the only area where entries are allowed to be made. All other information is either
carried forward from the cash budget worksheet or is automatically calculated.
Cash Flow Analysis Worksheet PDF
Favor this template? Just fancy it by voting!
39 Page(s) | 6411 Views | 32 Downloads
17 Page(s) | 5408 Views | 91 Downloads
1 Page(s) | 908 Views | 32 Downloads
1 Page(s) | 882 Views | 31 Downloads
6 Page(s) | 1897 Views | 13 Downloads