Auto filling your cash flow

You can automatically enter cash flow values for entire rows, columns or spreadsheets. If you’re auto filling values for a row or a column, select the appropriate row or column first.

Note: The option is only available for a projected cash flow.

1. Click Auto Fill … on the Cash Flow dialogue box. The Auto Fill dialogue box opens.
2. To auto fill an entire a row, select the Row tab and select one of the following options:
   • Set each period in the current row to the following amount - Enter a dollar amount. The projected value for each cell in the selected row will be set to this amount.
   • Set the first amount of the current row to - Enter a dollar amount. It will be entered in the first projected period of the selected row.
   • Then successive periods increase by the following percentage - Enter a percentage. Each successive cell in the selected row will be adjusted by this percentage. 
   For example, if you entered $500.00 and a percentage of 10, the first cell would be set to $500.00, the second cell would be set to $550.00 (10% x $500.00 = $50.00. $500.00 + $50.00 = $550.00), and so on.
   • Set the first amount of the current row to - Enter a dollar amount. It will be entered in the first projected period of the selected row. 
   • Then successive periods change by the following amount - Enter a dollar amount. Each successive cell in the selected row will change by this amount. 
   For example, if you entered $500.00 for the first value and $50.00 for the second value, the first cell would be set to $500.00, the second cell would be set to $550.00, and so on. 
   • Adjust each of the amounts in the current row by the following - Enter a percentage. Any cash flow amounts in the selected row will be adjusted by this percentage.
   For example, if you entered 10 per cent and the values $100.00, $200.00, $300.00 existed in the row, they’d be adjusted to $110.00, $220.00 and $330.00. 
   • Set the current row to the budget amounts for this account from the following fiscal year - Enter a year. The values in the selected row will be set to those entered in the budget in the specified year.
   • Set the current row to the actual transaction amounts for this account from the following fiscal year - Enter a year. The values in the selected row will be set to the actual values from the specified year. 
3. To auto fill an entire column, select the Column tab and then select one of the following options:
   • Adjust each of the amounts in the current column by the following - Enter a percentage. Any cash flow amounts in the selected column will be adjusted by this percentage.
   For example, if you entered 10 per cent and the values $100.00, $200.00 and $300.00 existed in the selected column, they’d be adjusted to $110.00, $220.00 and $330.00.
   • Set the current column to the budget amounts for this account from the following fiscal year - Enter a year. The values in the selected column will be set to those entered in the budget in the specified year. 
   • Set the current column to the actual transaction amounts for this account from the following fiscal year - Enter a year. The values in the selected column will be set to the actual values from the specified year. 
4. To auto fill an entire worksheet, select the Entire Worksheet tab and then select one of the following options:
   • Adjust each of the amounts in the current sheet by the following - Enter a percentage. Any cash flow amounts in the worksheet will be adjusted by this percentage.
   For example, if you entered 10 per cent and the amounts $100.00, $200.00, $300.00 existed in the worksheet, they’d be adjusted to $110.00, $220.00 and $330.00.
   • Set the entire worksheet to the budget amounts from the following fiscal year - Enter a year. The values in the worksheet will be set to those entered in the budget in the specified year.
   • Set the entire worksheet to the actual transaction amounts from the following fiscal year - Enter a year. The values in the worksheet will be set to the actual values from transactions entered in the specified year.
   • Set the entire worksheet to the projected transaction amounts from the following fiscal year – Enter a year. The values in the worksheet will be set to the projected values for the specified year.
5. Click Apply.

Last updated on August 27, 2013 by FCC AgExpert