Difference between revisions of "Cash Flow"
Jump to navigation
Jump to search
| Line 23: | Line 23: | ||
===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 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. | # 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. | ||
| Line 28: | Line 29: | ||
# The next section will show all outgoing (expenses) and incoming (income) for the corresponding 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. | # Add in last year’s final balance if applicable. | ||
[[File:Cash Flow - Total.png|1400px|frameless|center]] | |||
===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 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. | # Navigate to ‘Cash Flow Summary’ to see a summary for each year. | ||
[[File:Cash Flow - Summary.png|1000px|frameless|center]] | |||
[[Cane Sensitivity]] ⇐ '''OR''' [[Other Crop Sensitivity]] ⇐|⇒ [[Optimum Ratoons]] | [[Cane Sensitivity]] ⇐ '''OR''' [[Other Crop Sensitivity]] ⇐|⇒ [[Optimum Ratoons]] | ||
Revision as of 00:02, 7 February 2022
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.
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 complete the Cash Flow Worksheet, users need to open the file and:
Farm Income
- Enter the Delivery Advances of sugar ($/t) for the corresponding month (e.g. $285 in July, $0 in August and September, $10 in October, etc.);
- Enter the percent of cane crop delivered (and paid) in each month over the harvest season;
- 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;
Variable Costs and Fixed Costs
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;
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.
- 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.
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.
Cane Sensitivity ⇐ OR Other Crop Sensitivity ⇐|⇒ Optimum Ratoons