One-Off Event Analysis by cuiliqing

VIEWS: 2 PAGES: 5

									One-Off Event Analysis
EVENT:                  2013 DROUGHT

LOSS OF INCOME                                                                                                           Value

Milk Income                               kgMS Lost              x   payout
Quality Grades                            kgMS                   x   lost payout

Stock Sales
         Bulls                            kg cc lost / hd        x   no. head      x            schedule
        Steers                            kg cc lost / hd        x   no. head      x            schedule
       Heifers                            kg cc lost / hd        x   no. head      x            schedule
        Cows                              kg cc lost / hd        x   no. head      x            schedule
        Lambs                             kg cc lost / hd        x   no. head      x            schedule

Crops (cash)
        Maize                               lost yield (t/ha)    x   area (ha)     x            contract price
        Other                               lost yield (t/ha)    x   area (ha)     x            contract price

ADDITIONAL EXPENSES          (over and above normal purchases)                            Total Lost Income      (A)


Feed Purchased          Palm Kernel
                        Maize
                        Silage
                        Meal
                        Hay
Grazing / Lease
Electricity (Pumping)
Animal Health
Re-Grassing
Nitrogen
.
.
.

                                                                                   Total Additional Expenses     (B)

                                                                                           Total Event Costs (C = A+B)
PARTIAL BUDGET                         Date:
              INCOME                     MARCH   APRIL   MAY   TOTAL


Milk Income
Stock Sales
less Stock Purchaes             less
Net Stock Sale Income


Dividends
Off Farm Income
Other
GROSS FARM INCOME                (A)

             EXPENSES

Wages
Animal Health
Breeding
Effluent
Electrical
Feed
Cartage and freight
Fertiliser
Seeds not crop
Weed and pest control
Shed expenses
Repairs and maintenance
Vehicle expenses
Admin expenses
Standing Charges
Short term Grazing
GST @ 12.5% (exc wages)
GST payable
FARM WORKING EXP                 (B)

Debt Servicing (incl HP, C/C)
Overdraft Interest
Tax
Drawings
Capital Expenditure Planned
Buffer
OTHER EXPENSES                  (C )

CASH RESULT (D=A-B-C)            (D)
CASH - BREAK-EVEN
Monthly Fixed Costs (AP's, D/D's)                         Amount        MONTH:

Wages
Electricity
Shed Expenses
Fuel
Term Loan Payments
Overdraft Interest
HP Payments
Tax
Lease / Rent
Groceries
General Insurance
Life Insurance
Superannuation / Savings
Other
Total Monthly Fixed Costs                                                  (A)

Monthly Income                                                             (B)

Cash Available to Pay Variable Costs                                    C = (B-A)

MONTHLY VARIABLE COSTS                                    Planned                   Amended

Animal Health
Breeding
Effluent
Feed
Cartage & Freight
Fertiliser
Seeds
Weed and Pest
Shed Expenses
Repairs and maintenance
Vehicle expenses
Admin expenses
Standing Charges
Short term Grazing
Capital Expenditure
Total Monthly Variable Costs                                               (D)


Shortfall / Surplus                                                     E = (C-D)


Question: is your overdraft facility sufficient to cover a shortfall?
EXISTING FINANCIAL POSITION                                                 Date

                                 LIABILITIES                                                     ASSETS

                      I/Rate                    Charges      VALUE         LAND AND BUILDINGS                        VALUE
                                                                           Area       Location
LOAN
LOAN
LOAN
LOAN
                                                                           PLANT AND MACHINERY
OVERDRAFT


FAMILY DEBT                                                                VEHICLES


HP
                                                                           STOCK ON HAND           No.    Price/hd
CREDIT CARD DEBT                                                           MA Dairy Cows
                                                                           R2yr Heifers
                                                                           R1yr Heifers
CREDTORS                                                                   Calves
                                                                           MA Beef Cows
                                                                           R2yr Heifers
                                                                           R1yr Heifers
                                                                           Calves
                                                                           Breeding Bulls
                                                                           R3yr Strs/Bulls
                                                                           R2yr Strs/Bulls
                                                                           R1yr Strs/Bulls
TOTAL LIABILITIES                       (B)                                MA Ewes
                                                                           Ewe Hoggets
                                                                           Whether Hoggets
                                                                           Rams
EQUITY                           C = (A-B)                                 Other Stock
(Total assets less Total liabilities)

                                                                           SHARE PORTFOLIO


                                                                           SAVINGS


                                                                           SUPERANNUATION


                                                                           DEBTORS


TOTAL                                                                      TOTAL ASSETS                     (A)




                                              107e89fd-8fbe-4431-a069-55653993825d.xls
107e89fd-8fbe-4431-a069-55653993825d.xls

								
To top