|
|
Program
for Expansion
| Author: |
Dennis Martin -
Livestock Specialist/OMAFRA |
| Creation Date: |
05 September
1999 |
| Last Reviewed: |
15 October
1999 |
A week seldom goes by without a dairy farmer talking to me about
the merits of expansion. To assess the financial impact of expanding
your operation, you need hard, accurate numbers to determine the feasibility
of your plan. A new computer spreadsheet, developed by Ontario Ministry
of Agriculture, Food and Rural Affairs (OMAFRA) staff, can quickly
and easily provide those numbers.
To illustrate how this dairy expansion program works, Ive used
an actual farm as a case study. This family is seriously thinking
about building a new barn and asked for my opinion. Theyre milking
40 cows in an old, labour-intensive tie-stall barn in desperate need
of upgrading. Despite this drawback, production is above average.
However, this family has been culling a higher than normal percentage
of cows because of injury. Their plan is to build a new 70-cow free-stall
barn, parlour and manure storage. As well, they have projected the
purchase of 20 kilograms of quota and 20 cows. Heifers from the existing
herd would also contribute to the expansion.
Table 1 outlines the cost of the expansion proposal and Table 2 summarizes
debt-servicing requirements. Note the repayment scheduling on the
various loans. I often tell producers to be cautious about expansion
when annual principal and interest payments exceed 20 cents per litre
of milk sold. As you can see from this proposal, debt servicing per
litre of within-quota milk sold is 18 cents, two cents below the 20-cent
benchmark.
Table 1: Expansion Proposal
| Total Assets |
Current |
Proposed |
| $1,542,000 |
$2,202,000
|
|
Expansion Costs (excluding cows and quota)
|
|
Barn construction cost
|
|
$200,000
|
|
Parlour
|
|
$40,000
|
|
Feed storage
|
|
0
|
|
Manure storage
|
|
$40,000
|
|
Other (heifer and barn renovations)
|
|
0
|
|
Total
|
|
$280,000
|
|
Quota Purchases
|
|
20 kg
|
|
Unit cost of quota
|
|
$17,000
|
|
Cost of additional quota
|
|
$340,000
|
|
Livestock Purchases
|
|
Number of head to expand (not replacements)
|
|
20
|
|
Cost per cow
|
|
$2,000
|
|
Cost of additional livestock
|
|
$40,000
|
|
Operating Credit
|
|
Average operating loan
|
$15,000 |
$20,000
|
|
Operating loan interest rate
|
7.5% |
7.5%
|
|
Annual operating loan cost
|
$1,125 |
$1,500
|
|
Term Debt
|
|
Existing debt
|
$112,800 |
$96,184
|
|
Livestock
|
|
$40,000
|
|
Quota
|
|
$340,000
|
|
Facility expansion cost
|
|
$280,000
|
|
Total Debt (including operating loan)
|
$127,800 |
$776,184
|
Table 2: Debt Servicing
|
Quota Loan
|
$340,000
|
| Expected annual interest rate |
8%
|
| Amortized length of loan in years |
10
|
| Number of payments per year |
12
|
| Compounding periods per year |
2
|
| Total monthly payment |
$4,102
|
| Annual interest cost |
$27,200
|
| Annual quota loan cost (principal and interest) |
$49,221
|
|
Livestock Loan
|
$40,000
|
| Expected annual interest rate |
7.5%
|
| Amortized length of loan in years |
5
|
| Number of payments per year |
12
|
| Compounding periods per year |
2
|
| Total monthly payment |
$799
|
| Annual interest cost |
$3,000
|
| Annual livestock loan cost (principal and interest) |
$9,592
|
|
Facility Loan
|
$280,000
|
| Expected annual interest rate |
8.5%
|
| Amortized length of loan in years |
20
|
| Number of payments per year |
12
|
| Compounding periods per year |
2
|
| Total monthly payment |
$2,404
|
| Annual interest cost |
$23,800
|
| Annual facility loan cost (principal and interest) |
$28,848
|
|
Principal and Interest for Expansion (not
including existing debt)
|
$87,661
|
| |
Current |
Proposed |
|
Principal to be paid on existing debt
|
$16,616 |
$10,000
|
|
Interest to be paid on existing term debt
|
$10,933 |
$9,000
|
|
Operating interest
|
$1,125 |
$1,500
|
|
Principal and interest cost for existing debt
|
$28,674 |
$20,500
|
|
Total principal and interest
|
$28,674 |
$108,161
|
|
Principal and interest per litre of milk
sold
|
$0.07 |
$0.18
|
|
Debt per litre of within-quota milk sold
|
$0.35 |
$1.36
|
Table 3 outlines the economics of expanding from 44 to 70 cows. Based
on the projected income statement and debt-servicing capacity, this
operation would appear to have the option to expand. However, its
important to realize the cash surplus, shown at the bottom of Table
3, must provide for income tax, family living and savings. Personal
expenses generally run around $2,000 a month for a typical farm family.
This can be a major outlay, particularly when the business supports
more than one family.
Table 3: Expansion Economics
| |
Current |
Proposed |
|
Number of cows
|
44 |
70
|
|
Milk per cow
|
9,247 |
9,247
|
|
Daily quota
|
39.5 |
59.5
|
|
Litres of milk sold within quota
|
406,868 |
586,959
|
|
Litres of milk sold over quota
|
|
60,331
|
|
Fat test
|
|
3.7
|
|
Protein test
|
|
3.4
|
|
Tillable acres
|
189 |
189
|
|
Tillable acres per cow
|
4.3 |
2.7
|
|
Equity
|
92% |
65%
|
|
Debt/litre of within-quota milk sold
|
$0.35 |
$1.36
|
|
Total Debt
|
$127,800 |
$776,184
|
|
Cash Revenue
|
|
Milk and subsidy (gross)
|
$213,001 |
$332,794
|
|
Over quota sold at world price
|
0 |
$11,994
|
|
Livestock sales
|
$16,459 |
$19,751
|
|
Crop sales
|
$15,900 |
0
|
|
Other income
|
$1,649 |
$1,649
|
|
Total Cash Revenue
|
$247,009 |
$366,188
|
|
Farm Expenses
|
|
Purchased livestock (normal replacement
|
$1,825 |
$2,000
|
|
Purchased feed (concentrate, grain, forage)
|
$36,918 |
$62,022
|
|
Animal health and breeding
|
$12,542 |
$16,555
|
|
Other (livestock stablization, barn supplies)
|
$5,727 |
$8,018
|
|
Crop inputs (seed and plants)
|
$14,579 |
$13,121
|
|
Marketing/Transportation
|
$15,411 |
$23,367
|
|
Custom work/Equipment rental
|
$12,001 |
$12,001
|
|
Hired labour
|
$18,097 |
$20,269
|
|
Machinery expenses
|
$9,989 |
$9,989
|
|
Building, fence repairs
|
0 |
0
|
|
Heat, hydro, phone
|
$6,200 |
$9,300
|
|
Operating interest
|
$1,125 |
$1,500
|
|
Other cash operating expenses
|
$1,895 |
$1,895
|
|
Taxes/Insurance
|
$7,943 |
$8,737
|
|
Lease and rent payments
|
0 |
0
|
|
Interest payments
|
$10,933 |
$63,000
|
|
Total Cash Expenses
|
$155,185 |
$251,775
|
|
Cash revenue minus expenses
|
$91,824 |
$114,413
|
|
Total principal payments
|
$16,616 |
$43,661
|
|
Cash (surplus/deficit)
|
$75,208 |
$70,752
|
|
Debt servicing per litre of milk sold
|
$0.07 |
$0.18
|
You can download the dairy expansion program from the Web site listed
at the bottom of this page.
Here are some other important points to consider if youre considering
expansion:
Sacrifices: be prepared to make sacrifices, particularly when starting
up or expanding. Budget accordingly. The price of success has to be
paid before it can be collected.
Risk: remember, if everyone agreed about everything, the opportunity
for profit would quickly disappear. There will be people who question
what you are doing.
Spouse: make sure your spouse is part of the decision making on spending,
saving and investing.
Debt: debt is not necessarily bad. When youre green, youre
growing. Consider weekly instead of monthly payments, if possible,
to reduce the amount of interest you have to repay over the life of
your loan.
Vision: no one plans to fail, but many fail to plan. Dreams are important.
Goals are important. Write them down.
Attitude: Life is 10 per cent what happens to us and 90 per cent
how we react to what happens. Attitude is more important than anything
else. Be prepared for a higher level of stress while the expansion
is in progress.
Related Links
| Top of Page |
For more information:
Toll Free: 1-877-424-1300
Local: (519) 826-4047
E-mail: ag.info.omafra@ontario.ca
|