Docstoc

Profit Loss Statement Trucking - Excel - Excel

Document Sample
Profit Loss Statement Trucking - Excel - Excel Powered By Docstoc
					                  IRS Data Based Cow-Calf Cost Calculator
                                        Template Main Menu

                                 Texas Cooperative Extension
                                      Template Version: 5/16/05

                             Authors: Jim McGrann and Larry Falconer
                                 Programmer: Christy Waggoner

     First, locate the IRS Cost Menu on your toolbar. If it is not visible, make sure the toolbar has
     been selected by right clicking on the toolbar to display a toolbar options dialog box (to view
        there should be a check mark beside "IRS Cost"). Use the "VIEW" pull-down menu for
                  navigation between sheets and the "PRINT" menu for printing options.




                                            Printed
Filename: a11829c0-7f1e-40aa-a031-39c94a751922.xls 7/11/2011 , 7:12 PM                                  Page 3 of 5
                                  Ranch Property and Resource Description
  IRSCOW
  Fiscal Year For Analysis

  Date of Description Summary:                                   Name of Analysis:

  Main Objectives of Ranch Ownership:



  Sources of Investment Capital and Non-ranch Income to Support the Ranch:



  Labor and Management - Who is Involved?



                                                     Used By Cow           Used By Cow
  Type of Pasture or Crop Land                        Grazing              Raised Feed   Total
                                                       Acres                  Acres      Acres
  Native Unimproved                                           0                     0              0
  Native Improved                                             0                     0              0
  Improved Perennial                                          0                     0              0
  Annual Pasture or Forage Crop                               0                     0              0
  Woodland (Grazeable Forestland)                             0                     0              0
  Crop Aftermath                                              0                     0              0

  Total Acres of Land:                                       0                       0             0

  Water Facilities Description:



  Pasture and Grazing System Description:



  Wildlife and Livestock Enterprise Description:


  Ranch Resource Stewardship Objectives:


  Winter Feeding Program Description by Cattle Enterprise:



  Buildings Description:



  Residence Description:


  Livestock Handling Facilities and Equipment Description:



  Other Comments:



                                               7/11/2011, 7:12 PM
Filename: a11829c0-7f1e-40aa-a031-39c94a751922.xls                                       Data Page 1 of 5
                                       Summary of Cattle Production and Sales for Fiscal Year
                         0                  Fiscal Year For Analysis                              0

 Number of Cows Exposed to Produce Calves Weaned                                                 0 Hd.         Calf Crop or Weaning Percentage             0.0
 Breeding Cows at Beginning of Fiscal Year                                                       0 Hd.

                                                                                        Total             Total Net        Average    Average       Average
 Weaned Calves Production and Values                               Head               Payweight            Value $          Weight     Price         Price
                                                                                         Lb.                               Lb./Head    $/Cwt.       $/Head
   Bull Calves Weaned
          Sold                                                             0                     0            $0.00               0      $0.00             $0

             Retained                                                      0                     0            $0.00               0      $0.00             $0


   Subtotal Bull Calves                                                    0                     0            $0.00               0      $0.00             $0

   Steer Calves Weaned
          Sold                                                             0                     0            $0.00               0      $0.00             $0

             Retained                                                      0                     0            $0.00               0      $0.00             $0

   Subtotal Steer Calves                                                   0                     0            $0.00               0      $0.00             $0

   Heifer Calves Weaned
          Sold                                                             0                     0            $0.00               0      $0.00             $0

             Retained                                                      0                     0            $0.00               0      $0.00             $0

                                                                                                         Base Value
            Heifers Kept for Replacements                                  0                     0            $0.00               0      $0.00             $0


   Subtotal Heifer Calves                                                  0                     0            $0.00               0      $0.00             $0

 Total Weaned Calves Production and Value
 of Sales, Retained or Kept for Replacement                                 0                    0            $0.00               0      $0.00             $0

 ---------------------------------------------------------------------------------------------
                                                                                             Total        Total Net        Average    Average       Average
 Cull or Breeding Cattle Sales                                        Head                Payweight        Value $          Weight     Price         Price
                                                                                               Lb.                         Lb/Head.    $/Cwt.       $/Head
   Aged Female Sales
   Culls for Cows Slaughter Raised                                            0                    0          $0.00               0      $0.00             $0
   Culls for Cows Slaughter Purchased                                         0                    0          $0.00               0      $0.00             $0

   Culled Replacement Heifers Raised                                       0                     0            $0.00               0      $0.00             $0
   Culled Replacement Heifers Purchased                                    0                     0            $0.00               0      $0.00             $0

   For Breeding
   Open & Bred Raised                                                      0                                  $0.00                                        $0
   Open & Bred Purchased                                                   0                                  $0.00                                        $0

   With Calves (pairs) Raised                                              0                                  $0.00                                        $0
   With Calves (pairs) Purchased                                           0                                  $0.00                                        $0

   Subtotal Aged Female Sales                                              0                                  $0.00                                        $0

   Aged Bull Sales
   Culls for Slaughter Raised                                              0                     0            $0.00               0      $0.00             $0
   Culls for Slaughter Purchased                                           0                     0            $0.00               0      $0.00             $0

   Breeding Bulls Raised                                                   0                                  $0.00                                        $0
   Breeding Bulls Purchased                                                0                                  $0.00                                        $0

   Subtotal Cull & Breeding Bulls                                          0                                  $0.00                                        $0

 Total Cull & Breeding Cattle Sales                                        0                                  $0.00


Filename: a11829c0-7f1e-40aa-a031-39c94a751922.xls                             7/11/2011, 7:12 PM                                                Data Page 2 of 5
           Actual Cow-Calf Weaned Calf SPA Production Calculation Worksheet

                                             $0     Fiscal Year For Analysis                     0

        Number of Breeding Females Exposed                 0

        Calf Crop Based on Females Exposed           #DIV/0! %

                                                                Weaning                  Total
                                                       Head     Weight         Wt./Hd.   Value       Price/Cwt

         Weaned Bulls Sales or Retained                    0          -       NA             $0      NA
         Weaned Steers Sales or Retained                   0          -       NA             $0      NA
         Weaned Heifer Sales or Retained                   0          -       NA             $0      NA
        Subtotal Weaned Calf Sales or Retained             0          -       NA              0      NA

         Heifers For Replacements                          0              0 NA               $0 NA


        Total Calves Weaned                                0              0 NA               $0 NA




        Breeding Cows at Beginning of Fiscal Year                         0



        Select SPA Measures Calculated

        Calf Crop or Weaning Percentage                           #DIV/0!

        Actual Weaning Weight (lbs./hd.)
         Steers/Bulls                                             #DIV/0!
         Heifers                                                  #DIV/0!
         Average Weaning Weight                                       NA

        Pounds Weaned per Exposed Female                         #VALUE!

        Payweight Calf Prices ($/cwt.)
         Steers/Bulls                                             #DIV/0!
         Heifers                                                  #DIV/0!
         Weighted Average                                             NA




                                             7/11/2011, 7:12 PM
Filename: a11829c0-7f1e-40aa-a031-39c94a751922.xls                                                        Reports Page 1 of 5
                     Summary Data for Cow-Calf Enterprise Costs and Returns

                                                                          Name of Analysis:                  0

Total Base Value of Quantity Transferred to Raised Replacement Stock                                                         $0

Total Increase in Base Value of Quantity Transferred to Raised Breeding Cattle                                               $0

Gain/Loss on Sale/Death of:                                                         Sales          Deaths          Total
  Total Raised Replacement Heifers                                                          $0              $0               $0
  Total Raised Bulls                                                                        $0              $0               $0
  Culled/Aged Breeding Cows                                                                 $0              $0               $0
  Culled/Aged Breeding Bulls                                                                $0              $0               $0
                    Total Raised Breeding Cattle                                            $0              $0               $0

   Purchased Livestock
   Culled Replacement Heifers                                                               $0              $0               $0
   Culled/Aged Breeding Bulls                                                               $0              $0               $0
   Culled/Aged Breeding Cows                                                                $0              $0               $0
                Total Purchased Breeding Cattle                                             $0              $0               $0

Summary Data for Statement of Cash Sales

Cash From Sales                                                                                  Cash Sales
  Raised Replacement Heifers                                                                              $0
  Raised Replacement Bulls                                                                                $0
  Raised Breeding Stock - Cows                                                                            $0

   Purchased Breeding Stock - Cows                                                                          $0
                          - Bulls                                                                           $0
                          - Replacement Heifers                                                             $0

                           Total Cash from Sales                                                            $0




                                              7/11/2011, 7:12 PM
   Filename: a11829c0-7f1e-40aa-a031-39c94a751922.xls                                                  Reports Page 4 of 5
              Accrual Values to Adjust to the Fiscal Year Cash Accounting Data
                  Name of Analysis:            0
                        Fiscal Year:          0           Beginning        End
                                                           of Year       of Year    Change
              REVENUE - Accrual Adjustments

              Accounts Receivable                                   $0         $0        $0

              Other                                                 $0         $0        $0

              Other                                                 $0         $0        $0

              Other                                                 $0         $0        $0

              Other                                                 $0         $0        $0

              Other                                                 $0         $0        $0

              TOTAL REVENUE - Accrual Adjustments                   $0         $0        $0


              EXPENSES - Accrual Adjustments

              Inventories
                Purchased Feed                                      $0         $0        $0

               Raised Feed                                          $0         $0        $0

               Supplies                                             $0         $0        $0

              Prepaid Expenses                                      $0         $0        $0

              Prepaid Leases                                        $0         $0        $0

              Investment in Growing Crops                           $0         $0        $0

              Inventories
                Raised Feed                                         $0         $0        $0

               Purchased Feed                                       $0         $0        $0

               Supplies                                             $0         $0        $0


              Accounts Payable                                      $0         $0        $0

              Accrued Interest                                      $0         $0        $0

              Accrued Taxes
               Property Tax                                         $0         $0        $0
               Income & Self Employment Tax                         $0         $0        $0

              Accrued Employee Payroll Expenses                     $0         $0        $0

              Other                                                 $0         $0        $0

              Other                                                 $0         $0        $0

              Other                                                 $0         $0        $0


              TOTAL EXPENSES - Accrual Adjustments                  $0         $0        $0

                                               7/11/2011, 7:12 PM
Filename: a11829c0-7f1e-40aa-a031-39c94a751922.xls                                            Data Page 5 of 5
                           Cow-Calf Enterprise Revenue and Cost Calculation Using an Accrual Adjusted IRS Format
       Name of Analysis:                          0                   Calf Crop %                0.0                                        Cow            Total
                                                                                                         Ave. Wt.                           Herd           Herd                    $/Cow
   Revenue / Number of Cows at Beginning of Fiscal Year                                            0                         Total         Percent
   Total Weaned Calves                                                                             0               0
   Cash Weaned Calf Sales                                                                          0                            $0.00          100               $0                   $0.00
   Net Value Calves at Weaning Retained                                                            0                            $0.00          100               $0                   $0.00
   Base Value of Replacement Saved (from gain & loss)                                              0                            $0.00          100               $0                   $0.00
   Non-Weaned Calf Revenue                                                                                                                     100               $0
         Increase in Base Value of Saved Raised Replacements                                                                         $0        100               $0                   $0.00
   Gains (losses) in Breeding Stock Sales or Deaths                                                                                            100               $0
         Raised Breeding Stock (sales value - base value - death loss)                                                               $0        100               $0                   $0.00
         Purchased Breeding Stock (sales - tax book value - death loss)                                                              $0        100               $0                   $0.00
         Miscellaneous Cash Income                                                                                                   $0          0               $0                   $0.00
         Other Cash Receipts                                                                                                         $0          0               $0                   $0.00
         Other Cash Receipts                                                                                                         $0          0               $0                   $0.00
         Accrual Revenue Adjustments                                                                                                 $0        100               $0                   $0.00
   Total Cow-Calf Revenue                                                                                                            $0                          $0                   $0.00
                                                                                                                                                                                                                   % of
   Expense Item and Amount Allocated to Cows                                                                                 Total                                                                               Total Cost
   IRS Code and Expense Items from Schedule F "Profit or Loss From Farming"
     12 Car and Truck Expense                                                                                                        $0        100               $0                   $0.00                               0.0
     13 Chemicals                                                                                                                    $0        100               $0                   $0.00                               0.0
     14 Conservation Expense                                                                                                         $0        100               $0                   $0.00                               0.0
     15 Custom Hire (machine work)                                                                                                   $0        100               $0                   $0.00                               0.0
     16 Depreciation (from Depreciation Schedule)
          Vehicles                                                                                                                   $0        100               $0                   $0.00                               0.0
          Machinery & Equipment                                                                                                      $0        100               $0                   $0.00                               0.0
          Buildings & Improvements                                                                                                   $0        100               $0                   $0.00                               0.0
          Purchased Breeding Stock                                                                                                   $0        100               $0                   $0.00                               0.0
     17 Employee Benefits Programs                                                                                                   $0        100               $0                   $0.00                               0.0
     18 Feed Purchase                                                                                                                $0        100               $0                   $0.00                               0.0
     19 Fertilizer & Lime                                                                                                            $0        100               $0                   $0.00                               0.0
     20 Freight & Trucking                                                                                                           $0        100               $0                   $0.00                               0.0
     21 Gasoline, Fuel, & Oil                                                                                                        $0        100               $0                   $0.00                               0.0
     22 Insurance                                                                                                                    $0        100               $0                   $0.00                               0.0
     23 Interest Expense
          Cash                                                                                                                       $0        100               $0                   $0.00
          Change in Accrued Interest                                                                                                 $0        100               $0                   $0.00
     24 Hired Labor & Management                                                                                                     $0        100               $0                   $0.00                               0.0
     25 Pension & Profit-Sharing Plans
     26 Rents or Leases
          Vehicles, Machinery & Equipment                                                                                            $0        100               $0                   $0.00                               0.0
          Land                                                                                                                       $0        100               $0                   $0.00                               0.0
     27 Repairs & Maintenance                                                                                                        $0        100               $0                   $0.00                               0.0
     28 Seed & Plants                                                                                                                $0        100               $0                   $0.00                               0.0
     29 Storage & Warehousing                                                                                                        $0        100               $0                   $0.00                               0.0
     30 Supplies Purchased                                                                                                           $0        100               $0                   $0.00                               0.0
     31 Property Taxes                                                                                                               $0        100               $0                   $0.00                               0.0
     32 Utilities                                                                                                                    $0        100               $0                   $0.00                               0.0
     33 Veterinary, Breeding & Medicine                                                                                              $0        100               $0                   $0.00                               0.0
     34 Other Cash Expenses Specify
          Professional Fees                                                                                                          $0        100               $0                   $0.00                               0.0
          Lodging                                                                                                                    $0        100               $0                   $0.00                               0.0
          Other Cash Expenses                                                                                                        $0        100               $0                   $0.00                               0.0
          Other Cash Expenses                                                                                                        $0        100               $0                   $0.00                               0.0
          Other Cash Expenses                                                                                                        $0        100               $0                   $0.00                               0.0

           Accrual Adjustment from Schedule (less change in Interest-line 23)                                                        $0        100               $0                   $0.00                               0.0
           Owner Operator Withdrawals - Labor and Management - Cash Withdrawal                                                       $0        100               $0                   $0.00                               0.0

   Total Enterprise Costs                                                                                                            $0                          $0                   $0.00                             0.00

   Net Pre-Tax Cow-Calf Enterprise Income (Loss) Accrual Adjusted                                                                   $0                            $0                  $0.00
   -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   Unit Cost of Weaned Calves
                                                                                      Calf Crop %              Head Ave. Wt./Hd. Per Cow                                           Pounds
           Total weight of all calves weaned (lb.)                                                 0                0 NA                           0                                        0
                                                                                                                                                                                     Total          $/Cwt.          $/Cow
           Total Enterprise Costs                                                                                                                                                         $0           $0.00              0.00
           Total Enterprise Non-calf Revenue                                                                                                                                              $0           $0.00              0.00
           Total Adjusted Enterprise Costs                                                                                                                                                $0           $0.00              0.00

   Cost of Weaned Calves ($/Cwt.)                                                                                                                                                     $0.00
   -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   Net Cash Income and Expenses
             Cash Revenue                                                                                                                                                                 $0
             Cash Value of Culled Breeding Cattle Sales                                                                                                                                   $0

            Total Cash Income                                                                                                                                                             $0

            Total Cash Enterprise Cash Expenses*                                                                                                                                          $0

   Net Pre-Tax Cash Income Minus Cash Expenses                                                                                                                                            $0
   -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   *Includes owner withdrawals if included. Does not include capital expenditures as they are not an operating cost.


Filename: a11829c0-7f1e-40aa-a031-39c94a751922.xls                                                  7/11/2011, 7:12 PM                                                                                         Reports Page 2 of 5
                                  Cow Cost by Major Cost Category
                                                                                       % of
         Cost Category                 Costs/Cow                     Costs/Cwt.        Total
                                                     Production of 0 Lb./Cow       0
         Cattle                              $0.00                         $0.00           0.0%
         Purchased Feed                      $0.00                         $0.00           0.0%
         Raised Feed                         $0.00                         $0.00           0.0%
         Grazing                             $0.00                         $0.00           0.0%
         Vehicles                            $0.00                         $0.00           0.0%
         Interest                            $0.00                         $0.00           0.0%
         Overhead                            $0.00                         $0.00           0.0%
         Accrual Adjustments                 $0.00                         $0.00           0.0%
         Owner Labor & Mgmt                  $0.00                         $0.00           0.0%
         Total Costs                         $0.00                         $0.00           0.0%
         Total Enterprise
          Non-calf Revenue                   $0.00                        $0.00
         Total Adjusted Cost                 $0.00                        $0.00


                                        Cow Cost by Major Cost Category

                  $350.00

                  $300.00

                  $250.00

                  $200.00

                  $150.00

                  $100.00

                   $50.00

                       $0.00




                                        Cow Cost Percent by Cost Category




                                                          Purchased
                                                         Owner Labor &
                                                            Accrual
                                                            Grazing
                                                             Mgmt
                                                             Feed
                                                           Overhead
                                                            Vehicles
                                                             Cattle
                                                            Interest
                                                          Raised Feed
                                                          Adjustments
                                                             0.0%
                                                             0.0%
                                                              0.0%
                                                             0.0%
                                                              0.0%




                                               7/11/2011, 7:12 PM
Filename: a11829c0-7f1e-40aa-a031-39c94a751922.xls                                        Reports Page 5 of 5
                              Ranch Property and Resource Description Worksheet*
               Fiscal Year For Analysis

               Date of Description Summary:                                Name of Analysis:

               Main Objectives of Ranch Ownership:




               Sources of Investment Capital and Non-ranch Income to Support the Ranch:




               Labor and Management - Who is Involved?




                                                            Used By Cow          Used By Cow
               Type of Pasture or Crop Land                  Grazing             Raised Feed   Total
                                                              Acres                 Acres      Acres
               Native Unimproved
               Native Improved
               Improved Perennial
               Annual Pasture or Forage Crop
               Woodland (Grazeable Forestland)
               Crop Aftermath

               Total Acres of Land:

               Water Facilities Description:




               Pasture and Grazing System Description:




               Wild Life and Livestock Enterprise Description:


               Ranch Resource Stewardship Objectives:


               Winter Feeding Program Description by Cattle Enterprise:




               Buildings Description:




               Residence Description:


               Livestock Handling Facilities and Equipment Description:




               Other Comments:




Filename: a11829c0-7f1e-40aa-a031-39c94a751922.xls        7/11/2011, 7:12 PM                           Worksheets Page 1 of 3
                        Summary of Cattle Production and Sales For Fiscal Year Worksheet

                                                                     Fiscal Year For Analysis

                     Number of Cows Exposed to Produce Calves Weaned                                                                  Hd.

                                                                                                                         Total                             Total Net
     Weaned Calves Production and Values                                                  Head                         Payweight                            Value $
                                                                                                                          Lb.
                     Bull Calves Weaned
                                Sold

                                      Retained

                     Subtotal Bull Calves*

                     Steer Calves Weaned
                                Sold

                                      Retained

                     Subtotal Steer Calves*

                     Heifer Calves Weaned
                                Sold

                                      Retained

                                                                                                                                                         Base Value
                                     Heifers Kept for Replacements

                     Subtotal Heifer Calves*

     Total Weaned Calves Production and Value
     of Sales, Retained or Kept for Replacements

     ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                                                                                                                           Total                           Total Net
     Cull or Breeding Cattle Sales                                                        Head                         Payweight                            Value $
                                                                                                                            Lb.
                     Aged Female Sales
                     Culls for Cows Slaughter Raised
                     Culls for Cows Slaughter Purchased

                     Culled Replacement Heifers Raised
                     Culled Replacement Heifers Purchased

                     For Breeding
                     Open & Pregnant Raised
                     Open & Pregnant Purchased

                     With Calves (pairs) Raised
                     With Calves (pairs) Purchased

                     Subtotal Aged Female Sales*

                     Aged Bull Sales
                     Culls for Slaughter Raised
                     Culls for Slaughter Purchased

                     Breeding Bulls Raised
                     Breeding Bulls Purchased

                     Subtotal Cull & Breeding Bulls*

     Total Cull or Breeding Cattle Sales*
     --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     *Totals are calculated by the software.

Filename: a11829c0-7f1e-40aa-a031-39c94a751922.xls                         7/11/2011, 7:12 PM                                                           Worksheets Page 3 of 3
                                                                                               Beef Cattle Inventory Data Worksheet
                                                   Ranch Name PFLUGER                                                                 Fiscal Year                       2004

                                              Period of Report                1/1/2004             To                12/31/2004

                      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                              CATEGORY/CLASS                             Purchased               Raised               Raised                Raised               Raised               Raised          Purchased                Purchased
                                                                          Breeding             Breeding                Repl.                  Bull               Heifer                Steer          Repl.                        Bulls
                                                                            Cows                  Cows                Heifers               Calves               Calves               Calves          Heifers

                      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                               Beginning Inventory                                      8                    8                    2                                          5                     7


                               Purchases                                                                                                                                                                                2


                      I        Transfers In or Births                                                                                                                        6                   11
                      N

                               Changes in Category                                                           2


                               Longs in Counts

                      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                                Total Beginning + Entries (A)                           8                   10                     0                                        11                   18
                      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                              Sales                                                     1                                                                                    5                     9


                              Transfers Out

                      O
                      U       Changes in Category                                                                                 2
                      T

                              Consumed


                              Deaths


                              Shorts in Counts
                      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                              Total Out (B)                                             1                                                                                     5                    9
                      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                              Ending Inventory (A-B)                                    7                   10                                                                6                    9                     2
                      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                              Written Comments:




Filename: a11829c0-7f1e-40aa-a031-39c94a751922.xls                                                                   7/11/2011, 7:12 PM                                                                                                               Worksheets Page 2 of 3

				
DOCUMENT INFO
Description: Profit Loss Statement Trucking document sample