Difference between revisions of "Cash Flow"
| Line 20: | Line 20: | ||
===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. 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. | 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.</blockquote> | |||
[[File:Cash Flow - Variable and Fixed Costs.png|1400px|frameless|center]] | [[File:Cash Flow - Variable and Fixed Costs.png|1400px|frameless|center]] | ||
===Investment, Finance, Outgoing and Incoming=== | ===Investment, Finance, Outgoing and Incoming=== | ||
Revision as of 04:13, 13 December 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
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).
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.
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