Cash Flow - Revision history

Admin: /* Investment, Finance, Outgoing and Incoming */

2023-06-28T23:59:56Z

Investment, Finance, Outgoing and Incoming

← Older revision		Revision as of 23:59, 28 June 2023
Line 40:		Line 40:
	===Investment, Finance, Outgoing and Incoming===		===Investment, Finance, Outgoing and Incoming===

	'''1. Enter total Investment Sales and Purchases into the total column (B) and allocate percentages of Sales and Purchases to the corresponding months over the financial year.'''		'''1. Enter total Investment "Sales" and "Purchases" into the total column (B) and allocate percentages of "Sales" and "Purchases" to the corresponding months over the financial year.'''

Admin: /* Farm Income */

2023-06-28T23:58:48Z

Farm Income

← Older revision		Revision as of 23:58, 28 June 2023
Line 20:		Line 20:


	'''3. Allocate percentages of "Other Crops" and "Other Income" (if applicable) to the corresponding months over the financial year.''' For example, if 100% of "Other Crop" income is received in March then enter 100 in March and leave zero in the other months. This will allocate all of the Other Crop income to March.		'''3. Allocate percentages of "Other Crops" and "Other Income" (if applicable) to the corresponding months over the financial year.''' For example, if 100% of "Other Crop" income is received in March then enter 100 in March and leave zero in the other months. This will allocate all of the "Other Crop" income to March.

	* In the below example the the Other Crop income is spread out over the full year.		* In the below example the the "Other Crop" income is spread out over the full year.

Admin: /* Farm Income */

2023-06-28T23:58:12Z

Farm Income

← Older revision		Revision as of 23:58, 28 June 2023
Line 11:		Line 11:

	===Farm Income===		===Farm Income===
	'''1. Enter the Delivery Advances of sugar ($/t) for the corresponding month.''' For example, $285 in July, $0 in August and September, $10 in October, etc.		'''1. Enter the "Delivery Advances of sugar ($/t)" for the corresponding month.''' For example, $285 in July, $0 in August and September, $10 in October, etc.

	* '''Note:''' this total must equal the Sugar Price ($/t).		* '''Note:''' this total must equal the Sugar Price ($/t).

Admin at 23:57, 28 June 2023

2023-06-28T23:57:48Z

← Older revision		Revision as of 23:57, 28 June 2023
Line 1:		Line 1:
	This page enables you to download a Cash Flow Worksheet. When downloaded, the worksheet is pre-filled with specific information from the FEAT scenario such as revenues and expenses. The blue cells are pre-filled with information from the FEAT Online scenario you generated the worksheet from. The light grey cells are ones that you can enter data such as Delivery Advances of Sugar ($/t).		This page enables you to download a Cash Flow Worksheet. When downloaded, the worksheet is pre-filled with specific information from the FEAT scenario such as revenues and expenses. The blue cells are pre-filled with information from the FEAT Online scenario you generated the worksheet from. The light grey cells are ones that you can enter data such as "Delivery Advances of Sugar ($/t)".

	===How to access Cash Flow===		===How to access Cash Flow===

	To download the Worksheet, you need to click on the ~~‘Download Worksheet’~~ button and save the file to a familiar folder on your computer.		To download the Worksheet, you need to click on the "Download Worksheet" button and save the file to a familiar folder on your computer.


	[[File:Download Worksheet.png\|1000px\|frameless\|center\|link=]]		[[File:Download Worksheet.png\|1000px\|frameless\|center\|link=]]
Line 12:		Line 13:
	'''1. Enter the Delivery Advances of sugar ($/t) for the corresponding month.''' For example, $285 in July, $0 in August and September, $10 in October, etc.		'''1. Enter the Delivery Advances of sugar ($/t) for the corresponding month.''' For example, $285 in July, $0 in August and September, $10 in October, etc.

	- Note this total must equal the Sugar Price ($/t).		* '''Note:''' this total must equal the Sugar Price ($/t).
			* In the below example the delivery advances are spread out over the full year.
	- In the below example the delivery advances are spread out over the full year.


Line 20:		Line 20:


	'''3. Allocate percentages of ~~‘Other Crops’~~ and ~~‘Other Income’~~ (if applicable) to the corresponding months over the financial year.''' For example, if 100% of ~~‘Other Crop’~~ income is received in March then enter 100 in March and leave zero in the other months. This will allocate all of the Other Crop income to March.		'''3. Allocate percentages of "Other Crops" and "Other Income" (if applicable) to the corresponding months over the financial year.''' For example, if 100% of "Other Crop" income is received in March then enter 100 in March and leave zero in the other months. This will allocate all of the Other Crop income to March.

	- In the below example the the Other Crop income is spread out over the full year.		* In the below example the the Other Crop income is spread out over the full year.


Line 28:		Line 28:

	===Variable Costs and Fixed Costs===		===Variable Costs and Fixed Costs===
	'''Allocate percentages of ~~‘Variable Costs’~~ and ~~‘Fixed Costs’~~ to the corresponding months over the financial year.'''		'''Allocate percentages of "Variable Costs" and "Fixed Costs" to the corresponding months over the financial year.'''

	~~- For example, if approximately 25% of fertiliser costs are paid in August, September, October and November then enter 25 into each of these months and leave the other months zero.~~

	~~- Another example is if the costs were evenly distributed over the year you would put 1/12% for each month as per the below screenshot.~~

	~~- Soil test and laser levelling costs can also be included as a variable cost in the fertiliser and land preparation sections in [[Cane Growing Costs]] respectively.~~

	- '''Note:''' depreciation is not included in cashflow, and cane planting material costs are not downloaded automatically as it assumes growers will be using their own planting material. This explains why the end of year cashflow figure may be different to the FEAT Online profit figure.		* For example, if approximately 25% of fertiliser costs are paid in August, September, October and November then enter 25 into each of these months and leave the other months zero.
			* Another example is if the costs were evenly distributed over the year you would put 1/12% for each month as per the below screenshot.
			* Soil test and laser levelling costs can also be included as a variable cost in the fertiliser and land preparation sections in [[Cane Growing Costs]] respectively.
			* '''Note:''' depreciation is not included in cashflow, and cane planting material costs are not downloaded automatically as it assumes growers will be using their own planting material. This explains why the end of year cashflow figure may be different to the FEAT Online profit figure.


Line 46:		Line 43:


	'''2. Enter money coming into the business, via ~~‘New Borrowings’~~, ~~‘Contribution~~ from ~~Owners’~~ and ~~‘Interest Earned’~~ (under Finance heading), in each month over the financial year.'''		'''2. Enter money coming into the business, via "New Borrowings", "Contribution from Owners" and "Interest Earned" (under Finance heading), in each month over the financial year.'''


	'''3. Enter money going out of the business, via ~~‘Loan Repayments’~~ and ~~‘Drawings’~~ (under Finance heading), in each month over the financial year.'''		'''3. Enter money going out of the business, via "Loan Repayments" and "Drawings" (under Finance heading), in each month over the financial year.'''


Line 62:		Line 59:
	===Total Cash Flow, Year 2, Year 3, and Total Summary===		===Total Cash Flow, Year 2, Year 3, and Total Summary===

	'''1. Navigate to the sheets ~~‘Cash~~ Flow (Yr 2)’ and ~~‘Cash~~ Flow (Yr 3)’ if you wish to fill out those years.'''		'''1. Navigate to the sheets "Cash Flow (Yr 2)" and "Cash Flow (Yr 3)" if you wish to fill out those years.'''


	'''2. Navigate to ~~‘Cash~~ Flow ~~Summary’~~ to see a summary for each year.'''		'''2. Navigate to "Cash Flow Summary" to see a summary for each year.'''

Admin: /* Total Cash Flow, Year 2, Year 3, and Total Summary */

2023-06-27T23:58:15Z

Total Cash Flow, Year 2, Year 3, and Total Summary

← Older revision		Revision as of 23:58, 27 June 2023
Line 61:		Line 61:

	===Total Cash Flow, Year 2, Year 3, and Total Summary===		===Total Cash Flow, Year 2, Year 3, and Total Summary===
	# Navigate to the sheets ‘Cash Flow (Yr 2)’ and ‘Cash Flow (Yr 3)’ if you wish to fill out those years.
	# Navigate to ‘Cash Flow Summary’ to see a summary for each year.		'''1. Navigate to the sheets ‘Cash Flow (Yr 2)’ and ‘Cash Flow (Yr 3)’ if you wish to fill out those years.'''


			'''2. Navigate to ‘Cash Flow Summary’ to see a summary for each year.'''

Admin: /* Investment, Finance, Outgoing and Incoming */

2023-06-27T23:57:39Z

Investment, Finance, Outgoing and Incoming

← Older revision		Revision as of 23:57, 27 June 2023
Line 42:		Line 42:

	===Investment, Finance, Outgoing and Incoming===		===Investment, Finance, Outgoing and Incoming===
	# Enter total Investment Sales and Purchases into the total column (B) and allocate percentages of Sales and Purchases to the corresponding months over the financial year.
	# Enter money coming into the business, via ‘New Borrowings’, ‘Contribution from Owners’ and ‘Interest Earned’ (under Finance heading), in each month over the financial year.		'''1. Enter total Investment Sales and Purchases into the total column (B) and allocate percentages of Sales and Purchases to the corresponding months over the financial year.'''
	# Enter money going out of the business, via ‘Loan Repayments’ and ‘Drawings’ (under Finance heading), in each month over the financial year.
	# The next section will show all outgoing (expenses) and incoming (income) for the corresponding month over the financial year.
	# Add in last year’s final balance if applicable.		'''2. Enter money coming into the business, via ‘New Borrowings’, ‘Contribution from Owners’ and ‘Interest Earned’ (under Finance heading), in each month over the financial year.'''


			'''3. Enter money going out of the business, via ‘Loan Repayments’ and ‘Drawings’ (under Finance heading), in each month over the financial year.'''


			'''4. The next section will show all outgoing (expenses) and incoming (income) for the corresponding month over the financial year.'''


			'''5. Add in last year’s final balance if applicable.'''

Admin: /* Variable Costs and Fixed Costs */

2023-06-27T23:56:50Z

Variable Costs and Fixed Costs

← Older revision		Revision as of 23:56, 27 June 2023
Line 28:		Line 28:

	===Variable Costs and Fixed Costs===		===Variable Costs and Fixed Costs===
	Allocate percentages of ‘Variable Costs’ and ‘Fixed Costs’ to the corresponding months over the financial year.		'''Allocate percentages of ‘Variable Costs’ and ‘Fixed Costs’ to the corresponding months over the financial year.'''
	<blockquote>For example, if approximately 25% of fertiliser costs are paid in August, September, October and November then enter 25 into each of these months and leave the other months zero. Another example is if the costs were evenly distributed over the year you would put 1/12% for each month as per the below screenshot.</blockquote>

	~~Also~~, ~~soil test and laser levelling~~ costs ~~can also be included as a variable cost~~ in the ~~fertiliser and land preparation sections in [[Cane Growing Costs]] respectively~~.		- For example, if approximately 25% of fertiliser costs are paid in August, September, October and November then enter 25 into each of these months and leave the other months zero.

	~~Please note that~~ depreciation is not included in cashflow, and ~~that~~ cane planting material costs are not downloaded automatically as it assumes growers will be using their own planting material. This explains why the end of year cashflow figure may be different to the FEAT Online profit figure.		- Another example is if the costs were evenly distributed over the year you would put 1/12% for each month as per the below screenshot.

			- Soil test and laser levelling costs can also be included as a variable cost in the fertiliser and land preparation sections in [[Cane Growing Costs]] respectively.

			- '''Note:''' depreciation is not included in cashflow, and cane planting material costs are not downloaded automatically as it assumes growers will be using their own planting material. This explains why the end of year cashflow figure may be different to the FEAT Online profit figure.

Admin: /* Farm Income */

2023-06-27T23:43:45Z

Farm Income

← Older revision		Revision as of 23:43, 27 June 2023
Line 10:		Line 10:

	===Farm Income===		===Farm Income===
	1. Enter the Delivery Advances of sugar ($/t) for the corresponding month.		'''1. Enter the Delivery Advances of sugar ($/t) for the corresponding month.''' For example, $285 in July, $0 in August and September, $10 in October, etc.
	~~<blockquote>~~For example, $285 in July, $0 in August and September, $10 in October, etc. ~~Note this total must equal the Sugar Price ($/t). In the below example the delivery advances are spread out over the full year. </blockquote>~~

	~~2. Enter~~ the ~~percent of cane crop delivered~~ (~~and paid~~) ~~in each month over the harvest season~~.		- Note this total must equal the Sugar Price ($/t).

	3. Allocate percentages of ‘Other Crops’ and ‘Other Income’ (if applicable) to the corresponding months over the financial year.		- In the below example the delivery advances are spread out over the full year.
	~~<blockquote>~~For example, if 100% of ‘Other Crop’ income is received in March then enter 100 in March and leave zero in the other months. This will allocate all of the Other Crop income to March. In the below example the the Other Crop income is spread out over the full year.~~</blockquote>~~

			'''2. Enter the percent of cane crop delivered (and paid) in each month over the harvest season.'''


			'''3. Allocate percentages of ‘Other Crops’ and ‘Other Income’ (if applicable) to the corresponding months over the financial year.''' For example, if 100% of ‘Other Crop’ income is received in March then enter 100 in March and leave zero in the other months. This will allocate all of the Other Crop income to March.

			- In the below example the the Other Crop income is spread out over the full year.

Admin at 00:44, 30 March 2023

2023-03-30T00:44:08Z

← Older revision		Revision as of 00:44, 30 March 2023
Line 1:		Line 1:
	This page enables you to download a Cash Flow Worksheet. When downloaded, the worksheet is pre-filled with specific information from the FEAT scenario such as revenues and expenses. The blue cells are pre-filled with information from the FEAT Online scenario you generated the worksheet from. The light grey cells are ones that you can enter data such as Delivery Advances of Sugar ($/t).		This page enables you to download a Cash Flow Worksheet. When downloaded, the worksheet is pre-filled with specific information from the FEAT scenario such as revenues and expenses. The blue cells are pre-filled with information from the FEAT Online scenario you generated the worksheet from. The light grey cells are ones that you can enter data such as Delivery Advances of Sugar ($/t).

			===How to access Cash Flow===

	To download the Worksheet, you need to click on the ‘Download Worksheet’ button and save the file to a familiar folder on your computer.		To download the Worksheet, you need to click on the ‘Download Worksheet’ button and save the file to a familiar folder on your computer.
Line 5:		Line 7:
	[[File:Download Worksheet.png\|1000px\|frameless\|center\|link=]]		[[File:Download Worksheet.png\|1000px\|frameless\|center\|link=]]

	To complete the Cash Flow Worksheet, you need to open the file and:		To complete the Cash Flow Worksheet, you need to open the file and follow the below instructions:

	===Farm Income===		===Farm Income===

Admin at 23:12, 29 March 2023

2023-03-29T23:12:17Z

← Older revision		Revision as of 23:12, 29 March 2023
Line 1:		Line 1:
	This page enables ~~users~~ to download a Cash Flow Worksheet. When downloaded, the worksheet is pre-filled with specific information from the FEAT scenario such as revenues and expenses. The blue cells are pre-filled with information from the FEAT Online scenario you generated the worksheet from. The light grey cells are ones that you can enter data such as Delivery Advances of Sugar ($/t).		This page enables you to download a Cash Flow Worksheet. When downloaded, the worksheet is pre-filled with specific information from the FEAT scenario such as revenues and expenses. The blue cells are pre-filled with information from the FEAT Online scenario you generated the worksheet from. The light grey cells are ones that you can enter data such as Delivery Advances of Sugar ($/t).

	To download the Worksheet, ~~users~~ need to click on the ‘Download Worksheet’ button and save the file to a familiar folder on ~~their~~ computer.		To download the Worksheet, you need to click on the ‘Download Worksheet’ button and save the file to a familiar folder on your computer.

	[[File:Download Worksheet.png\|1000px\|frameless\|center\|link=]]		[[File:Download Worksheet.png\|1000px\|frameless\|center\|link=]]

	To complete the Cash Flow Worksheet, ~~users~~ need to open the file and:		To complete the Cash Flow Worksheet, you need to open the file and:

	===Farm Income===		===Farm Income===