Agriculture, Feed, Financial Model

10-year Financial Projections, Break-Even, Budget, Budgeting, Business Valuation, Cash Flow Analysis, Cash Flow Projections, Cash on Cash Yield, Debt Schedule, Debt Security, Debt Service Coverage, Discount Rate, Dividends, Excel, Financial Analysis, Financial Debt, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Ratios, Financial Reporting, Financial Statements, Forecast, Forecasting, Income Statement, Investment Multiple, Investor Cash Flows, Investors, IRR (Internal Rate of Return), KPIs (Key Performance Indicators), NPV (Net Present Value), Profitability Analysis, Return on Invested Capital (ROIC), Return on Investment (ROI), Sensitivity Analysis, Terminal Value, Three Statement Model | Three Financial Statements, Uses and Sources of Funds, Valuation

This financial model excel template prepares a business plan for oilseeds crushing plant production by implementing a bottom-up approach. It begins by determining up to 5 crushing lines and their capacities, with the total resulting in the oilseeds production capacity. Users then determine the percentage allocation to distribute the annual oilseed production target after identifying up to five different types of oilseeds.

The most common oilseed outputs are oilseed meal and oil. The financial model calculates the output for every ton of oilseed based on the conversion assumptions for each type of identified oilseed. Other key assumptions include the start year of operations, price assumptions, cost and expenses, total capital expenditures, uses and sources of funds, and assumptions related to the use of debt financing.

By translating these assumptions into a thorough 30-year financial plan, the business owners and investors can comprehend how the company should perform financially over the following years.

Additionally, the model enables the determination of the oilseeds crushing plant’s break-even volume and price, as well as the key relevant financial ratios and financial metrics like the oilseeds crushing plant profit margin, IRR, and NPV that are necessary for banks and investors to comprehend the oilseed crushing plant project.

Oilseeds Crushing Plant Spreadsheet Template Structure

This Excel template has instructions and formulas that are simple and easy to follow, which allows users to run simulations by varying the input assumptions. The elements of this financial model template are enumerated below:

Instructions and Terms contain the cell color codes and the terms and abbreviations used.

Executive Summary and Detailed Summary include charts for a better understanding of your Oilseeds Crushing Plant project reports’ financial prospects and to provide answers to the following questions:

• How much does it cost to set up an oilseed crushing plant?
• Is oilseed crushing profitable?
• What are the different types of oilseeds and their respective conversion to oilseed meal and oil?
• What is the loss in volume from crushing oilseeds?

These spreadsheets include a 10-year summary of the following:

• Projected Financial Statements overview– Income Statement, Balance Sheet, and Cash Flows Statement.
• Levered and Unlevered Free Cash Flows calculating key financial feasibility metrics such as the Internal Rate of Return (IRR), Payback Period, Net Present Value (NPV)
• Investor Summary
• Uses and Sources of Funds, and Debt Financing
• Operational Key Performance Indicators – Profit per ton of Oilseed
• Oilseeds Crushing Plant Production Summary
• Output for every ton of Oilseed and Loss in Conversion
• Lifetime Profit Distribution and Cash Flows
• Break-Even Analysis Summary
• Sensitivity Analysis Summary

Assumptions that are necessary and applicable in the business plan of an Oilseed Crushing Plant Financial Model are presented in this worksheet.

• General Settings
  • Currency
  • Project Timeline – Oilseeds Production Operation Years
  • Income Tax Rate
  • Net Working Capital
  • Inflation and Price Escalation
• Oilseeds Crushing Plant Assumptions
  • Product Input and Output Units
  • Line Capacities and Production Target
  • Conversion Ratios – Output for every Input of Oilseeds
  • Oil Conversion from Gallon to Ton
  • Oilseeds Prices
  • Prices of Oilseed Output Products
  • Direct Costs
  • Operating Expenses
  • Capital Expenditures, CAPEX Schedule and Maintenance per year

It could take up to three years to completely set up an oilseed crushing plant. By spreading out the amount of capital across the first three years, the CAPEX schedule of this model enables customers to plan this circumstance flexibly and realistically.

• Uses and Sources of Funds
  • Cash Reserve and Net Working Capital
  • Loan Amounts and Interest Rates
• Investors – Funding and Equity Stake
• Exit and Valuation Assumptions
• Dividend Policy Assumptions – Cash Sweep or Profit Distribution

Operating Model contains detailed calculations of the annual 30-year operational forecasts of the oilseed crushing production process.

• Oilseeds and Oilseed Meal and Oil Volume
• Loss in Conversion Summary
• Price and Cost Inflation Rates
• Revenue Breakdown of Oilseeds Meal and Oil
• Direct Costs
• Operating Expenses
• Fixed Assets Schedule – Initial CAPEX, Spending allocation, Maintenance, and Depreciation

The special features of this worksheet include:

• Annual Oilseeds input volume should not exceed the Oilseeds Crushing Plant’s Production Capacity.
• Percentage of the Plant Capacity Utilization
• Oilseeds Meal and Oil volume are calculated depending on the assumption of the project timeline.
• Operating Expenses will also only start upon the first year of production.

Monthly Budget is prepared to have a detailed assessment of the financial feasibility of the oilseeds crushing plant. This five-year monthly budget is formulated to start calculation from the selected first target year and operating month of the oilseed crushing production process. Using the monthly budget, users may distribute, using percentages, the monthly production target, annual revenue, and costs for the months that occurred. Also presented in this spreadsheet are the calculations of minimum funding required, suggested net working capital, and presentation of Monthly Free Cash Flows (Unlevered and Levered) and Projected Cash Balance.

Financials worksheet contains a comprehensive and detailed 30-year forecast of:

• Financial Statements – Income Statement, Balance Sheet, Cash Flow Statement
• Projected Enterprise Value
• Unlevered and Levered Free Cash Flow
• Financial Metrics, and
• Equity Funding and Divided Policy Schedule
• Financial Ratios
• Standardized Income Statement
• Oilseeds Profit per Ton analysis

The financial worksheet also shows calculations of Profit Margins in the production of Oilseeds, such as Gross Profit, EBITDA, EBIT, EBT, and Net Income/Loss Margin.

Debt Schedule is specially prepared for funding purposes to be presented to banks and investors. It contains financial ratios the banks and investors want to see when evaluating a project’s feasibility. The debt schedule comes with two debt facility options and adjustments for drawdowns and repayments.

Break-Even Analysis calculates the required oilseed production volume and average cost price for oilseeds of chosen year to break even at an EBIT level. This sheet also shows a break-even sensitivity analysis.

Shareholders Cash Flow is prepared to show the calculations of the Equity Multiple and Investors’ IRR, which helps determine if their funding and equity stake percentages would result to profit on their end.

Sensitivity Analysis determines how variables such as prices, expenses, and conversion ratios affect the IRR of a chosen parameter. Users may select Unlevered or Leveled IRRs, and Investors.

Crush your own Mix of Oilseeds now!

This Oilseeds Crushing Plant Excel worksheet template offers users helpful features that help them decide whether crushing oilseeds is financially viable by analyzing the effects of various scenarios on the feasibility of your project. Users will be able to determine whether to invest in oilseed crushing production with the aid of financial analysis and significant KPIs.

This financial model template comes pre-filled with an example forecast of an Oilseed Crushing Plant. The forecast can be readily changed by altering the assumptions indicated in blue.

The models, current version at 1.1, are available in two fully editable Excel versions:

• Excel Version
• Null Version – No values in the assumption sheet.
• PDF Version – Outlines the details of the model structure.

File types:
.xlsx (MS Excel)
.pdf (Adobe Acrobat Reader)