This section contains excel worksheets consisting of enterprise budgets, cash flow table and graph, sensitivity analysis table and buildings, machinery and production system costs for the Planning for Profit Enterprise Worksheet Commodities Series.
Note: This material including spreadsheets on this web section and all of the information it contains are provided "as is" without warranty of any kind, whether express or implied. All implied warranties, including, without limitation, implied warranties of merchantability, fitness for a particular purpose, and non-infringement, are hereby expressly disclaimed.
If you do not have Microsoft Excel, spreadsheet files can be viewed and printed using the Excel 2003 Viewer. It may be downloaded free of charge from the Microsoft website.
Cow Calf Contribution Margin Statement
(download excel file ) (XLS, 46KB)Cow Calf and Feeder Operation Financial StatementsThis Cow Calf Contribution Margin Worksheet can be used to develop a contribution margin per cow and total herd based on a your input of such items as Number of Cows, Herd Replacement, Weaning Percentage, Heifer Conception Rate, Average Calving Date, Cow Death Loss, Weaning Date, Cow-Bull Ratio.
(download excel (XLS, 176KB) and macro (XLM, 89KB) files)
Note: you will need to download both the excel file and the macro file.These worksheet and macro files provides a template for an Income and Expense Budget, Statement of Assets Liabilities and Equity, Cashflow Budget, Cashflow Analysis, Cow/calf Income Summary and Cow Herd Inventory, Feeder Budget, Feeder Inventory, & Income Statement, Crops Budget, Crops inventory & Income Statement, Supplies Inventory, Accounts Rec/Pay and Loan Schedule.
