Orchard (Apple or Otherwise) Excel Financial Model

Bottom-up financial projections for an orchard (apple or otherwise). Includes 3-statement model.

by Jason Varner
smarthelping.com - Financial Modeling for EveryoneFollow 167

1 review991 views|2 comments|Bookmark Add to cart - $45.00

Description
Latest Upgrades: Added financial statements that are linked to the base assumptions, a capex schedule for trees and equipment that produce depreciation (including the off-set rules for how trees can be depreciated), Executive Summary, DCF Analysis / NPV, and improved general overal global assumptions.


The value in this template is in the detail of the assumptions. Advanced logic has been applied to the specific types of costs and revenue factors that drive the operation of an Apple orchard.

Assumptions Include:
Schedule Defining...
-Amount of Acres
-Trees per Acre
-Bushel yield per Acre
-Weight per bushel (lbs)
-Cost per harvest (bearing years)

Specific Variable Inputs For:
-Harvest per year
-First harvest year
-Acres in use over time
-Initial Acres bought
-Provision
-Starting year for each job type
-Up to 5 job types (laborers) and a head count of each with estimated hours / annual costs.
-Fencing costs
-Costs related to bearing years
-Packaging
-Equipment
-Fuel

Revenue
-Up to 6 types of fruit
-% of Orchard each type represents
-Sale price per lb per type
-Expected % sold of sellable yield
-% of total yield that is sellable

Financing Assumptions

The model will then give you projections for up to 50 years as defined by your assumptions. IRR, ROI, and annualized ROI figures populate as well as a running cash flow position.

The point of this tool is to allow one to figure out what kind of conditions are required in order to start making a profit as well as testing various assumptions out to see what may not be feasible based on expected cash flows.

This Best Practice includes
1 Excel template and 1 tutorial video