Spreadsheet: 681784d1591741268-xlsx-file-generating-error-name-052220-biz-plan-from-tm-multi-acre
Sheet: FHF - assumptions dashboard & P

 |  |  |  | FULL HARVEST FARM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FARM ASSUMPTIONS DASHBOARD
 |  |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
GH1 YEAR
GH1 MONTH HARVESTING |  |  |  | 0.42 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1
GH1 MONTH OPERATING EXP KICK IN |  |  |  | 0.67 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1
GH2 YEAR
GH2 MONTH HARVEST |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  | 1
GH2 MONTH OPERATING EXP KICK IN |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  | 1
GH3 YEAR
GH3 MONTH HARVESTING
GH3 MONTH OPERATING EXP KICK IN
 | GH1 | GH2 | GH3 | Year 1 | GH1 | GH2 | GH3 | Year 2 | GH1 | GH2 | GH3 | Year 3 | GH1 | GH2 | GH3 | Year 4 | GH1 | GH2 | GH3 | Year 5
Grow Math: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.1 | selling px per head of lettuce |  |  |  |  | KEY:
Unit Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998000 | heads / year | 5148000 | heads / year (2.5 acre) |  |  | assumptions
Unit Price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Turas Mara questions
Total Revenue (0% loss) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02 | inflation |  | corp tax rate: |  |  | calculations
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 | crop insurance increase |  | 0.09 |  |  | AmHydro comments |  | incentives:
Loss Rate Built In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AmHydro to do / answer |  | let them see how they're doing, put them in the driver's seat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for greenhouse workers, give them quarterly bonus as well
Total Revenue (inc. loss rate) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COGS per head of lettuce |  |  |  |  |  |  |  | could be $500 / quarter if they meet a certain loss ratio
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | Distribution |  | "extra" baked in
COGS Math: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.036 | Seedlings & Growing Med |  | 0.05
Distribution |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03 | Fertilizer, Nutrients, & Minerals
Seedlings & Growing Med |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.08 | Packaging
Fertilizer, Nutrients, & Minerals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totak
Packaging |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Greenhouse construction
Total COGS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BEGINS YEAR | BEGINS MONTH | DURATION
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Greenhouse 1 | 1 | 4 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Greenhouses 2 | 1 | 7 | 14
P&L
Income
Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Greenhouse online (producing) |  | MONTH | MONTH | MONTH
Services |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | year | seedling planted | harvest | opex kicks in
Total Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Greenhouse 1 | 1 | 6
Cost of Goods Sold |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Greenhouse 2 | 2 | 4
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Greenhouse 3 | 3 | 4
Total Cost of Goods Sold |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ^ toggle these to play with when things get up & running
GROSS PROFIT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Corporate Phones |  |  | A/R Cycle time
gross margin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per line per month | 50 |  | 60 | days
Expenses
AmHydro Farm Management Fee
Amortization
Consultants
Food safety consultant
Sales, Marketing, Branding
Dues & Subscriptions
Insurance
Office Expenses
Operating Lease (with TM)
Legal & Accounting
Miscellaneous
Repairs & Maintenance
Shipping and Delivery
Greenhouse Supplies
Taxes & Licenses
Travel
Utilities
Electricity
Water
Phone
Internet
Gas
Utilities Total
Payroll
Wages
Taxes
Healthcare
Payroll Total
Total Expenses
Pretax income
Interest Expense / Income
Tax Provision
NET INCOME
net margin
 |  |  |  | GREENHOUSE 1  0.5 acre |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GREENHOUSE 2 2.5 acres |  |  |  |  |  | GREENHOUSE 3  2.5 acre
years denote life of greenhouse, not FHF > |  |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Grow Math:
Unit Sales
Unit Price
Total Revenue (0% loss)
Loss Rate Built In |  |  |  | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
Total Revenue (inc. loss rate)
COGS Math:
Distribution
Seedlings & Growing Med
Fertilizer, Nutrients, & Minerals
Packaging
Total COGS
P&L
 |  |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Income
Sales
Services |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Total Income
Cost of Goods Sold
[NAME]
Total Cost of Goods Sold
GROSS PROFIT
gross margin
Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Questions for AmHydro:
AmHydro Farm Management Fee |  |  |  | 50000 |  |  |  | 50000 |  |  |  | 50000 |  |  |  | 50000 |  |  |  | 50000 |  | 50000 |  |  |  |  |  | 50000
Amortization
Consultants
Food safety consultant |  |  |  | 40000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
Sales, Marketing, Branding |  |  |  | 5000 |  |  |  | 5000 |  |  |  | 5000 |  |  |  | 5000 |  |  |  | 5000 |  | 48000
Dues & Subscriptions |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | < are there any organizations / greenhouse growers associations FHF management should be apart of? conferences to attend? There is a severe shortage of continuing ed for head growers. A revenue stream we have considered in the past...
Insurance |  |  |  | 12000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42000 |  |  |  |  |  | 42000
Office Expenses |  |  |  | 5000 |  |  |  | 5000 |  |  |  | 5000 |  |  |  | 5000 |  |  |  | 5000 |  | 10000 | 10000 | 10000 | 10000 | 10000
Operating Lease (with TM)
Legal & Accounting |  |  |  | 7500 |  |  |  | 7500 |  |  |  | 7500 |  |  |  | 7500 |  |  |  | 7500 |  | 60000 | 30000
Miscellaneous |  |  |  | 5000 |  |  |  | 5000 |  |  |  | 5000 |  |  |  | 5000 |  |  |  | 5000 |  | 25000
Repairs & Maintenance |  |  |  | 10000 |  |  |  | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15000 | 7500 | 7500 | 7500 | 7500 |  | 15000 | 5000 | 5000 | 5000 | 5000
Shipping and Delivery |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Greenhouse Supplies |  |  |  | 6000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20000
Taxes & Licenses |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | going to attempt to have wholesaler / customer to pick up that cost (re: becoming [NAME])
Travel |  |  |  | 5000 |  |  |  | 5000 |  |  |  | 5000 |  |  |  | 5000 |  |  |  | 5000 |  | 5000 | 5000 | 5000 | 5000 | 5000 |  | 5000 | 5000 | 5000 | 5000 | 5000 |  | tax landscape in NJ? [NAME]'s accountant looking into it
Utilities
Electricity |  |  |  | 12000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50000 |  |  |  |  |  | 50000
Water |  |  |  | 12000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35000 |  |  |  |  |  | 35000
Phone
Internet |  |  |  | 1500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500 |  |  |  |  |  | 0 | 0 | 0
Gas |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70000 |  |  |  |  |  | 70000
Utilities Total
Payroll software |  |  |  | 2500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Payroll
Wages
Taxes
Healthcare
Payroll Total
Total Expenses
Pretax Income
Interest Expense / Income
Tax Provision
NET INCOME
net margin