A template for Stock valuation

Reviews
Shared by: Rabia Khan
Stats
views:
1021
rating:
not rated
reviews:
0
posted:
3/26/2008
language:
English
pages:
0
2000/01 $ Whole farm Revenue Milksolids Cattle Grazing income Other farm income Less: Cattle purchases Gross Farm Revenue Cash Farm Expenditure Interest Rent &/or leases Cash Farm Surplus Stock value adjustment Minus depreciation Net Trading Profit Taxation Net Trading Profit after Tax Allocation of Funds add back Depreciation Reverse stock value adjustment Drawings Principal repayments Development Capital purchases Disposable Surplus/Deficit Other Cash Sources New borrowing Off-farm income Other cash income Net Cash Change Assets and Liabilities Farm, forest and building (Opening) Plant and machinery (Opening) Stock valuation (Opening) Total Farm Capital Total Debt Opening Equity (Assets-Liabilities) 2,184,760 160,000 612,227 2,956,987 1,215,078 1,741,909 5,408 396 1,515 7,319 3,008 4,312 14.42 1.06 4.04 19.52 8.02 11.50 2,823,020 190,000 653,619 3,666,639 1,365,078 2,301,561 0 8,535 0 121,757 0 21 0 301 0.00 0.06 0.00 0.80 0 8,535 0 41,864 44,260 -45,106 50,000 42,872 56,000 54,000 113,222 110 -112 124 106 139 134 280 0.29 -0.30 0.33 0.28 0.37 0.36 0.75 42,000 -3,565 52,000 44,643 24,000 52,000 33,329 3,500 810,109 325,027 77,782 2,901 404,399 45,106 44,260 405,245 88,305 316,940 9 2,005 805 193 7 1,001 112 110 1,003 219 785 0.02 5.35 2.15 0.51 0.02 2.67 0.30 0.29 2.67 0.58 2.09 3,500 857,651 363,139 116,032 2,900 375,580 3,565 42,000 337,145 169,608 167,537 746,020 64,510 0 3,079 1,847 160 0 8 4.92 0.43 0.00 0.02 773,202 84,870 0 3,079 per cow per kgMS Whole farm 2001/02f $ per cow 1,769 194 0 7 8 1,963 831 266 7 859 8 96 771 388 383 per kgMS 4.66 0.51 0.00 0.02 0.02 5.16 2.19 0.70 0.02 2.26 0.02 0.25 2.03 1.02 1.01 96 -8 119 102 55 119 76 0.25 -0.02 0.31 0.27 0.14 0.31 0.20 0 20 0 96 0.00 0.05 0.00 0.25 6,460 435 1,496 8,390 3,124 5,267 17.00 1.14 3.94 22.08 8.22 13.86 Southland Dairy 2000/01 $ Whole farm + + + + Revenue Milksolids Cattle Grazing income Other farm income Less: - Cattle purchases 746,020 64,510 3,079 3,500 810,109 325,027 77,782 2,901 per cow 1,847 160 0 8 9 2,005 805 193 7 per kgMS 4.92 0.43 0.00 0.02 0.02 5.35 2.15 0.51 0.02 = Gross Farm Revenue - Cash Farm Expenditure - Interest - Rent &/or leases - Cash Farm Surplus +/- Stock value adjustment - Minus depreciation = Net Trading Profit - Taxation = Net Trading Profit after Tax Allocation of Funds add back Depreciation Reverse stock value adjustment Drawings Principal repayments Development Capital purchases 404,399 45,106 44,260 405,245 59,972 345,273 1,001 112 110 1,003 148 855 2.67 0.30 0.29 2.67 0.40 2.28 + +/- 44,260 -45,106 50,000 42,872 56,000 54,000 141,555 110 -112 124 106 139 134 350 0.29 -0.30 0.33 0.28 0.37 0.36 0.93 = Disposable Surplus/Deficit Other Cash Sources + New borrowing + Off-farm income + Other cash income = Net Cash Change 8,535 0 21 0 372 0.00 0.06 0.00 0.99 150,090 + + + = - Assets and Liabilities Farm, forest and building (Opening) 2,184,760 Plant and machinery (Opening) 160,000 Stock valuation (Opening) 612,227 Total Farm Capital 2,956,987 Total Debt Opening 1,215,078 5,408 396 1,515 7,319 3,008 4,312 14.42 1.06 4.04 19.52 8.02 11.50 = Equity (Assets-Liabilities) 1,741,909 Southland Dairy 2000/01 $ Whole farm Farm Working Expenses Permanent wages Casual wages ACC Agricultural contracting Animal health Breeding Dairy shed exp Electricity Feed (hay & silage) Feed (grazing) Feed (other) Farm forestry costs Fertiliser Lime Freight (not elsewhere deducted) Regrassing costs Weed & pest control Fuel Vehicle costs (excl fuel) Repairs and maintenance Rates Water charges (irrigation) Communication costs (phone & mail) Insurance Accountancy Legal & consultancy Other admin Other expenditure Cash Farm Expenditure Calculated Ratios Economic Farm Surplus (or EBIT) Cash Farm Exp/GFR EFS/Total farm capital EFS/Equity Interest+rent+lease/GFR EFS/GFR 440,928 40% 14.9% 25.3% 10.0% 54.4% 1,091 2.91 411,077 42% 11.2% 17.9% 13.9% 47.9% 941 2.48 40,000 6,495 976 0 22,818 11,364 6,868 8,444 40,150 39,018 18,095 0 37,330 1,820 4,329 4,444 2,020 8,868 9,482 24,000 7,300 0 3,676 4,359 3,216 4,500 2,020 13,435 325,027 99 16 2 0 56 28 17 21 99 97 45 0 92 5 11 11 5 22 23 59 18 0 9 11 8 11 5 33 805 0.26 0.04 0.01 0.00 0.15 0.08 0.05 0.06 0.27 0.26 0.12 0.00 0.25 0.01 0.03 0.03 0.01 0.06 0.06 0.16 0.05 0.00 0.02 0.03 0.02 0.03 0.01 0.09 2.15 60,000 10,000 4,948 0 22,800 12,236 7,472 8,800 48,568 24,436 24,400 0 44,085 1,800 5,244 4,500 2,100 9,000 9,000 22,500 7,787 0 3,575 4,400 3,216 3,456 1,670 17,146 363,139 137 23 11 0 52 28 17 20 111 56 56 0 101 4 12 10 5 21 21 51 18 0 8 10 7 8 4 39 831 0.36 0.06 0.03 0.00 0.14 0.07 0.04 0.05 0.29 0.15 0.15 0.00 0.27 0.01 0.03 0.03 0.01 0.05 0.05 0.14 0.05 0.00 0.02 0.03 0.02 0.02 0.01 0.10 2.19 per cow per kgMS Whole farm 2001/02f $ per cow per kgMS Economic Farm Surplus (EFS) is calculated as follows: Gross Revenue+Change in Livestock Value-Farm Working Expenses-Depreciation-Wages of Management Wages of Management = $29,000 + 1% of Opening Total Farm Capital, to a maximum of $45,000

Related docs
Template Form for Stock Valuation
Views: 1055  |  Downloads: 113
Stock Valuation Investment Templates
Views: 1091  |  Downloads: 270
Mine Stock Valuation from Aussieontop
Views: 623  |  Downloads: 64
Stock Valuation Template
Views: 602  |  Downloads: 90
Constant Growth Valuation Template.
Views: 1152  |  Downloads: 121
Discounted Dividend Valuation Model Template
Views: 834  |  Downloads: 81
A Template for Bond Valuation and Risk
Views: 1597  |  Downloads: 197
VALUATION MEASURES Report
Views: 434  |  Downloads: 44
stock valuation
Views: 644  |  Downloads: 119
premium docs
Other docs by Rabia Khan
USACE Master- In-house Data Call Template
Views: 817  |  Downloads: 35
Pool Acquisition Template
Views: 760  |  Downloads: 41
Pivot Point Release Notes
Views: 715  |  Downloads: 51
PF Budget Plan Template
Views: 1617  |  Downloads: 109
Interest Shortfall Rec Template
Views: 704  |  Downloads: 43
Interest Rate Template
Views: 1015  |  Downloads: 85
Electronic Remittance Template
Views: 981  |  Downloads: 24
BTL Referral Template
Views: 691  |  Downloads: 9
Bill Tracking Report Template
Views: 936  |  Downloads: 39
WACC template
Views: 1664  |  Downloads: 148
Variance Report Template 06 MidYear FINAL
Views: 636  |  Downloads: 21
Variance Report Template 05 YearEnd
Views: 824  |  Downloads: 37
Use of the Guidelines on Common Reporting -CoRep
Views: 537  |  Downloads: 5