All Collections
Scenario planning
Setting up
Updating Scenario Proposition - Income & Expenses
Updating Scenario Proposition - Income & Expenses

The proposition tab is where you build out your scenario - here we'll build out the income & expenses

Alexandra Henley avatar
Written by Alexandra Henley
Updated over a week ago

Once your opening position has been set, you can continue on to build out the remainder of your scenario - including adding in new assets, liabilities, and entering your income & expenses. 

You're able to enter in any additional income & expenses that will be incurred throughout the scenario as well.
​ 

Updating your Income

In your proposition you can have four main types of income - livestock, milk, cropping, horticulture and other income which will contain all other revenue accounts.

You can add new forms of income at any time using the button below.

Adding Milk Production

Add any milk production, fill in all details of the milk production like region & supplier. 

You'll be provided an additional year for your milk tracker, this year will run prior to the first year of your scenario and filling this in will then calculate the deferred payments in the first year of your scenario.

If your milk tracker did not exist prior to the first year of your scenario - then you can leave this first column / year blank.

If more granular detail is required, you have the ability to customise your monthly milk production, monthly prices and any milk premiums by ticking 'Use custom monthly values'.  Here you can enter your very own custom milk production curve and copy to all future yeas of your scenario

NOTE: If your farm is banking with BNZ, your milk prices are set automatically for you.

Adding Livestock Production

Add your desired livestock type and enter in any movements within the stock classes. Clicking on the blue numbers in the grid will allow you to enter transaction details. Once you have entered all transactions for year one of your scenario you have the ability to copy those transactions to all future years by clicking the 'Copy' button.  You can then edit any future year's transactions, as required.
​ 
Ageing, births, and deaths can be auto-calculated based on the settings available under the livestock management configuration page.

If you're using a milk tracker and dairy cattle tracker, a dairy livestock tracker can be added and the Net Sales from it can be calculated by using the $/kgMS that flows from the milk tracker - as opposed to entering individual sales & purchases for each stock class.

Add a dairy cattle tracker as above, and ensure you click into the $/kgMS tab. This cannot be changed back to a detailed view once created.

 

Adding Cropping Income

Add in cropping income by specifying your crop type and then entering area planted, yield, total sold and sale price.   The opening crop on hand (if any) will flow through from the opening position.  

Adding Horticulture Income

Add in horticulture income by specifying your horticulture type and then entering area planted, yield, total sold and sale price.   The opening produce on hand (if any) will flow through from the opening position.  

Adding Other Income

All other income can be added in under the Other Income tab - the accounts shown are based on all revenue type accounts held in your farms chart of accounts

Values can be entered for the first year of your scenario and "spread" across the subsequent years using the button and % box provided, or they can be manually entered.

Adding Non Taxable Income

This tab has the same functionality as the Other Income tab, except all income entered in this section will not be included in the tax calculation based on your yearly gross profit. 

Updating your expenses

Under your expenses all interest from any liabilities will be automatically calculated and brought forward to your expenses. All other parts of your expenses can be configured using + Add Expenses.

Farm Working Expenses

Farm working expenses can be added as $, $/kgMS, $/cow, or $ha depending on the items you have added to your scenario.

They can also be entered as one of the three views - total, grouped, or detailed.

Values can be entered for the first year of your scenario and "spread" across the subsequent years using the button and % box provided, or they can be manually entered.

 

All Other Expenditure

You can update all other farm expenditure in the same way as FWE with the same tools available - $, $/kgMS, $/cow, and $/ha.

You can also adjust the interest rates / utilisations for any loans or overdrafts under your expenses section.

Interest on overdraft is calculated off the overdraft limit using the utilisation percentage.  

For example, if you have an overdraft limit of $100,000 and and a utilisation percentage of 70%, interest with be calculated off a $70,000 overdraft. 

NOTE: Taxation is currently a manual calculation and should be entered once you have completed your scenario and know what your Net Profit is.

Did this answer your question?