Filetype Excel XLS | Posted on 07 Jul 2022 | 3 years ago
Authentication
digital resources
152x Filetype XLS File size 0.15 MB Source: nre.tas.gov.au
Sheet 1: Summary
| DESIGNING A SUCCESSFUL BUSINESS | (updated May 2013) | |||||||||||
| The purpose of this series of worksheets is to analyse the profitability of a business in its current form as well as to examine the consequences of changes to enterprise mix, enterprise profitability, capital investment and debt. | ||||||||||||
| The first three sheets can be used to examine the current situation and the last three to examine potential future developments. | ||||||||||||
| What is the current situation? | ||||||||||||
| 1 | Enterprises & margins | |||||||||||
| 2 | Capital investment & debt | |||||||||||
| 3 | Profitability | |||||||||||
| What is the proposal for the future? | ||||||||||||
| 4 | Enterprises & margins | |||||||||||
| 5 | Capital investment & debt | |||||||||||
| 6 | Profitability | |||||||||||
| INSTRUCTIONS: | ||||||||||||
| Data only needs to be entered into the blue shaded cells: | ||||||||||||
| Users are also welcome to add further enterprises. However, those who do not have experience with an enterprise should seek professional advice in relation to all of the input and output assumptions. | ||||||||||||
| Initial Gross Margin data required to complete these sheets can be obtained using the relevant spreadsheets included in the portfolio of Enterprise Returns. | ||||||||||||
| None of the inputs listed should be treated as recommendations. | ||||||||||||
| Please read the attached | Important Information and Disclaimer | document before using the spreadsheets. | ||||||||||
| If you have any comments, queries or suggestions for further development please contact AgriGrowth Tasmania, GPO Box 44, Hobart TAS 7001 Phone: 1300 292 292 |
||||||||||||
| Email: | Agrigrowth@dpipwe.tas.gov.au | |||||||||||
| Website: | www.dpipwe.tas.gov.au | |||||||||||
| Summary | |||||||||
| Important Information and Disclaimer | |||||||||
| By using this workbook you accept all the terms of this disclaimer. | |||||||||
| The information, models and spreadsheet tools accessible using this workbook have been prepared to assist in making farm management and investment decisions and are intended as planning tools. As such, users will need to adapt the models for their own circumstances. Users of this workbook are encouraged to vary the input costs, yields and return assumptions to better represent their own situation. | |||||||||
| The agricultural sector is subject to significant variations in costs, returns and yields over time and as such budget projections will need to be reviewed to reflect the prevailing circumstances. | |||||||||
| Changes can be readily made to the models by varying the values in the blue-shaded cells in the individual gross margin worksheets. Users of the models are also welcome to change the basic set-up of each gross margin or add further enterprises. | |||||||||
| The Crown in Right of Tasmania (“Crown”) which commissioned the development of these models and spreadsheet tools, and the consultants Armstrong Ketelar Consulting who undertook the development work, expressly disclaim all and any legal liability and responsibility whatsoever arising from or connected with: | |||||||||
| • | the accuracy, reliability, validity, currency or completeness of any information on this website including the models and spreadsheets; | ||||||||
| • | the accuracy, reliability, validity, currency or completeness of any results obtained from the use of the information on this website including the models and spreadsheets; | ||||||||
| • | the consequences of anything done or omitted to be done by any person, either in whole or in part, in reliance of any such information, models spreadsheet or results; | ||||||||
| • | any combination of any of the above. | ||||||||
| None of the input costs and projected yield information listed in the workbook should be treated as recommendations or advice and the information, models and spreadsheet tools accessible in this workbook are made available on the understanding that the Crown and Armstrong Ketelar Consulting are not providing professional advice. The use of this workbook and information obtained from its use is not a substitute for independent professional advice and users should obtain any appropriate professional advice relevant to their particular circumstances. | |||||||||
| Copyright | |||||||||
| Copyright of all information (including the models and spreadsheets) published in this workbook (“information”) is owned by the Crown. All information is protected so far as is allowed by the provisions of the Copyright Act 1968 (Cth) ("the Act"). | |||||||||
| Apart from any use permitted by the Act, the Crown grants users of this site a licence (within the meaning of the Act) to download, use, print and otherwise reproduce the information. This licence is granted on the condition that the Crown (as represented by the Department of Primary Industries, Parks, Water and Environment (“Department”)) must be acknowledged as the source of that information. Furthermore, users must ensure any third party is aware that the disclaimer applies in respect of the reproduction, quotation and use of the information. | |||||||||
| For permission to reproduce or use the information beyond this limited licence, permission must be sought from the Department. | |||||||||
| Summary | |||||||||
| Summary | ||||||||||
| DESIGNING A SUCCESSFUL BUSINESS | ||||||||||
| Step 1: Current Enterprises | ||||||||||
| (1) Livestock Gross Margins | ||||||||||
| Area Grazed (ha): | 1000 | |||||||||
| Livestock | Number | DSE Rating | Area Grazed | Stocking Rate | ||||||
| total | per ha | |||||||||
| (hd) | (dse/hd)* | (% of total) | (dse) | dse/ha | ||||||
| 1 | Beef Breeding | 12 | 0 | 0.0 | ||||||
| 2 | Beef Trading | 10 | 0 | 0.0 | ||||||
| 3 | Wool Sheep | 1.6 | 0 | 0.0 | ||||||
| 4 | First Cross Ewes | 2 | 0 | 0.0 | ||||||
| Total | CHECK DATA | 0 | ||||||||
| *Default dse ratings have been included, but the user may change these to suit the individual enterprise. | ||||||||||
| Livestock | Investment in Stock | Gross Margin | ||||||||
| per hd | per dse | per ha | Total | per dse | OR | per ha | Total | |||
| ($/hd) | ($/dse) | ($/ha) | ($) | ($/dse) | Enter your GMs here | ($/ha) | ($) | |||
| 1 | Beef Breeding | 0 | 0 | 0 | 0 | |||||
| 2 | Beef Trading | 0 | 0 | 0 | 0 | |||||
| 3 | Wool Sheep | 0 | 0 | 0 | 0 | |||||
| 4 | First Cross Ewes | 0 | 0 | 0 | 0 | |||||
| Total | 0 | 0 | ||||||||
| (2) Crop Gross Margins | ||||||||||
| Includes any margin from finishing livestock - eg lucerne, winter wheat, grass seed etc. | ||||||||||
| Note; This data can be obtained using the Crop Gross Margin tools included in the portfolio of Enterprise Returns | ||||||||||
| Crop | Area | Gross Margin | ||||||||
| per ha | Total | |||||||||
| (ha) | ($/ha) | ($) | ||||||||
| 1 | Barley | 0 | ||||||||
| 2 | Wheat | 0 | ||||||||
| 3 | Oats | 0 | ||||||||
| 4 | Canola | 0 | ||||||||
| 5 | Grass seed | 0 | ||||||||
| 6 | Clover seed | 0 | ||||||||
| 7 | Lucerne * | 0 | ||||||||
| 8 | Poppies | 0 | ||||||||
| 9 | Broccoli | 0 | ||||||||
| 10 | Butter beans | 0 | ||||||||
| 11 | Carrots | 0 | ||||||||
| 12 | Cauliflower | 0 | ||||||||
| 13 | Garlic | 0 | ||||||||
| 14 | Onions | 0 | ||||||||
| 15 | Potatoes - fresh | 0 | ||||||||
| 16 | Potatoes - seed | 0 | ||||||||
| 17 | Pumpkins | 0 | ||||||||
| 18 | Peppermint * | 0 | ||||||||
| 19 | Pyrethrum * | 0 | ||||||||
| 20 | Raspberries* | 0 | ||||||||
| 21 | Blueberries* | 0 | ||||||||
| 22 | Strawberries* | 0 | ||||||||
| 23 | Hazelnuts* | 0 | ||||||||
| Total | 0 | 0 | ||||||||
| * For current perennial crops, use the actual Gross Margin for this year. If the crop is not yet producing, but there are direct costs associated with this crop, the Gross Margin may actually be negative. | ||||||||||
| Summary | ||||||||||
no reviews yet
Please Login to review.
