Key Takeaways
- Edible oil refinery financial projections must be built around sustainable refining margin per tonne, realistic working capital investment, disciplined DSCR modelling and bankability-not headline turnover numbers that merely reflect high crude oil prices.
- Crude oil (soybean, sunflower, mustard, palm oil, rice bran and others) typically constitutes 85–90% of total operating cost, so even a small shift in procurement price, yield loss or refining spread can sharply alter profitability, cash flow and debt service coverage ratio.
- A bankable detailed project report for an edible oil refinery must integrate projected profit and loss, balance sheet, cash flow, working capital assessment, CMA Data and term loan DSCR into one internally consistent financial model where every number reconciles.
- Working capital for crude oil inventory, chemicals and finished refined edible oils is usually substantial-especially for 300–1,000 TPD refineries-and often determines whether an otherwise viable edible oil business becomes truly profitable or cash-stressed from day one.
- Project Report Bank, led by CA Manish Gugliya, FCA, DISA (ICAI), prepares customised, India-specific DPRs and financial projections for edible oil refinery projects rather than selling generic templates.
Introduction – Why Financial Projections Matter for Edible Oil Refinery Projects
Edible oil refining operates in a high-volume, commodity-driven market where India imports approximately 56.25% of its edible oil needs. With increasing consumption-rural households consuming 10.58 kg per person and urban households 11.78 kg per person annually as of 2022-23-and the global vegetable oil market projected to reach USD 448.70 billion by 2034, the demand for refined cooking oils continues to grow. This market expansion, driven by rising population and packaged food demand, attracts significant investment into refinery projects across India.
However, for any edible oil refinery-whether 100, 300, 500 or 1,000 TPD-technical feasibility alone is insufficient. Edible oil refineries require substantial capital expenditure for setup and equipment, and refineries range from 3 to 5,000 TPD capacity. Banks and investors look beyond plant capacity and machinery specifications. They examine refined oil margins, projected cash flow, DSCR and the working capital cycle before committing funds.
Projects with modern essential equipment and a sound edible oil manufacturing process can still face financial stress if crude oil inventory is under-financed, capacity utilisation falls below projections, or term loan repayment begins before cash flows stabilise. A DPR that includes financial projections, outlines market analysis and project costs, and helps secure bank financing and government incentives must therefore tell a coherent financial story-not simply present large revenue numbers.
This article covers the analytical blocks that constitute serious edible oil refinery financial projections: projected profit and loss, balance sheet and cash flow statements, working capital assessment, CMA Data preparation, DSCR calculation, break-even analysis, IRR, NPV, sensitivity analysis and common projection mistakes. The guidance is written for serious project promoters in India planning mid- to large-scale refineries, from the perspective of a practising Chartered Accountant specialising in DPRs and project finance.
Key Assumptions for Edible Oil Refinery Financial Projections
Clearly documented assumptions are the backbone of any edible oil refinery financial model. Banks scrutinise these before accepting projections because the assumptions determine whether revenue, cost and cash flow figures are defensible or speculative.
This section describes typical assumption blocks for 100, 300, 500 and 1,000 TPD refineries in India. All numbers are illustrative for explanation only and must be validated with actual quotations and market data for any live project.
Capacity and Utilisation. Installed crude oil refining capacity (TPD) multiplied by operating days per year (typically 300–330) gives maximum annual throughput. However, capacity utilisation rates should be forecasted carefully during new refinery establishment phases. Very few plants achieve full utilisation in Year 1.
| Parameter | 100 TPD | 300 TPD | 500 TPD | 1,000 TPD |
|---|---|---|---|---|
| Operating Days / Year | 300 | 320 | 320 | 330 |
| Year 1 Utilisation | 60% | 60% | 60% | 55% |
| Year 2 Utilisation | 75% | 80% | 80% | 75% |
| Year 3 Utilisation | 85% | 85% | 90% | 85% |
| Year 5 Utilisation | 90% | 90% | 90% | 90% |
| Max Annual Crude (MT at 90%) | 27,000 | 86,400 | 1,44,000 | 2,97,000 |
For detailed guidance on why these capacities are commonly evaluated and how economies of scale must be balanced with market reach and working capital capacity, refer to the article on Edible Oil Refinery Capacity Planning.
Yield and Process Losses. The refining process-comprising degumming (which removes gums and impurities from crude oil), neutralisation (which eliminates free fatty acids using caustic soda), bleaching (which removes pigments and impurities), deodorisation (which removes odour and volatile compounds) and, for certain oils, winterisation (which improves clarity by removing waxes)-generates process losses. Typical yield losses range from 1.5–2% for sunflower and rice bran oil to 2.5–3.5% for palm oil, depending on crude quality and refining process flow. Promoters must not confuse oilseed crushing capacity with refining capacity; crude oil input TPD and refined oil output MT per day differ by the normalised yield loss.
Cost Assumptions. Key cost heads include:
- Crude edible oil procurement price per MT (illustrative soybean, sunflower, palm blends-varies daily)
- Chemicals and consumables: phosphoric acid, caustic lye, bleaching earth, filter aids
- Utilities: steam, power, water and fuel per MT crude processed-detailed norms are covered in Edible Oil Refinery Utility Requirements
- Packaging cost per kg of refined oil
- Repairs and maintenance (typically 1.5–3% of plant and machinery value annually)
- Manpower, selling and administrative overheads
A medium-sized refinery requires 1–3 acres of land. Land costs typically account for 10–20% of total investment, while machinery and equipment can constitute 35–50% of total investment. For reference, a 12 MT per day refinery costs approximately ₹759 lakh, though costs scale non-linearly for larger capacities. The actual capital investment and capacity choice should be aligned with the detailed discussion in Edible Oil Refinery Project Cost and Investment.
Finance and Tax. Assumptions include interest rate on term loan and working capital, loan tenure (typically 7–10 years), moratorium period, depreciation rates as per the Companies Act, and effective corporate tax rate. Real projects must use current tax law and lender-specific term sheets rather than assumed rates.
Standalone vs Integrated Projects. Refined oil plants may be standalone refineries or integrated with soybean or multi-oilseed solvent extraction. Integrated projects have different capital structures, yield economics and by-product revenue streams. For integrated project assumptions, refer to the Soybean Crushing, Oil Extraction and Refining Plant DPR and the Industrial Solvent Extraction and Multi-Oilseed Processing Plant DPR.
DPRs typically include a five-year financial projection at minimum, though lenders for larger refineries usually expect 7–10 year projections aligned with term loan tenure.
Revenue Projections and Refining Margin Analysis
Headline turnover for an edible oil business can look very large because crude oil itself is high-value. A 300 TPD refinery processing ₹1.30 lakh per MT crude will show annual sales exceeding several hundred crore. But real financial strength lies in the processing margin per tonne, not in big sales numbers. Edible oil price inflation can inflate revenue projections without significantly improving EBITDA if the processing margin per kg does not widen.
Revenue Computation Steps:
- Crude oil processed (MT) = Capacity × Utilisation × Operating Days
- Refined oil output (MT) = Crude processed × Net recovery percentage
- By-product recovery: acid oil, soap stock, fatty acid distillates, spent bleaching earth
- Total revenue = (Refined oil MT × Net selling price) + By-product revenue
Refining Margin per MT = (Realisation from Refined Oil + By-Product Revenue) − (Crude Oil Cost + Variable Processing Cost)
Refining margin is essentially the price differential between crude oil and refined oil, adjusted for processing cost and by-product recovery. Refining yields depend on crude oil quality and refining efficiency, and margins vary by crude type and refining route. The choice between physical vs chemical refining of edible oils directly affects chemical consumption, yield losses and therefore margin per tonne.
Illustrative Example – 300 TPD Refinery (Year 2, 80% Utilisation)
| Parameter | Value |
|---|---|
| Crude Oil Processed | 300 × 320 × 80% = 76,800 MT |
| Refined Oil Recovery (97.5%) | 74,880 MT |
| Average Refined Oil Realisation | ₹1,38,000 / MT |
| By-Product Revenue (per MT crude) | ₹800 / MT |
| Total Revenue | ₹1,034 crore + ₹6.14 crore = ₹1,040 crore (approx.) |
| Crude Oil Cost (₹1,30,000/MT) | ₹999 crore |
| Variable Processing Cost (₹3,000/MT crude) | ₹23 crore |
| Contribution | ₹18 crore |
| Contribution per MT Crude | ~₹2,350 |
By-products from refining-including fatty acid distillates and acid oils-can significantly enhance overall profitability when properly valued and marketed. The recovery of refining margins and processing costs directly affects whether the project generates sufficient cash for debt service.
It is important to distinguish between refining or processing margin (earned for converting crude to refined edible oil) and trading margin (holding crude or refined oil inventory and benefiting from price movement). DPRs and bank appraisals focus primarily on sustainable refining margin.
Projected Profit and Loss Statement for an Edible Oil Refinery
Lenders normally expect a 7–10 year projected profit and loss statement for medium- to large-scale edible oil refineries, aligned with term loan tenure and the stabilisation period. A thorough financial model typically includes cash flow, P&L, and balance sheet forecasts.
Illustrative Stabilised Year P&L – 300 TPD Refinery (Year 3, 85% Utilisation)
| Head | ₹ Crore (Approx.) |
|---|---|
| Net Sales (Refined Oil + By-Products) | 1,105 |
| Raw Material Consumption | 1,062 |
| Utilities (Steam, Power, Water, Fuel) | 8.5 |
| Chemicals & Consumables | 4.2 |
| Packing Material | 5.8 |
| Repairs & Maintenance | 2.0 |
| Employee Cost | 3.5 |
| Admin & Selling Expenses | 3.0 |
| EBITDA | 16.0 |
| Depreciation | 5.5 |
| Interest (Term Loan + WC) | 6.0 |
| Profit Before Tax | 4.5 |
| Tax (approx. 25%) | 1.1 |
| Profit After Tax | 3.4 |
Raw materials account for 85–90% of operating expenses in edible oil refining-a PACRA sector study places raw materials at approximately 87% of COGS. The operating cost structure must include both fixed and variable expenses for accurate financial analysis. High energy consumption is a major expense in the refining process, and operating costs include utilities, maintenance, and raw materials.
Gross profit margins for vegetable oil processing typically range from 10–15%, while profit margins in edible oil refining are typically thin and fluctuate due to market conditions. The edible oil refining business offers initial returns of 5–10%, though premium oils such as rice bran oil or high quality edible oil blends of sunflower and groundnut can provide returns around 25% of revenue. A 12 MT per day refinery can earn a 17% return on investment by Year 3 under favourable conditions.
Cash profit (PAT + Depreciation) is more relevant for DSCR and term loan servicing than accounting PAT alone. In the example above, cash profit is approximately ₹8.9 crore (₹3.4 + ₹5.5), which is the figure available for debt service. Operational efficiency is essential to maximise profitability, and capacity utilisation is critical-once fixed costs are covered, incremental utilisation significantly improves both EBITDA and PAT through operating leverage.
Edible Oil Refinery Working Capital Requirement
Working capital is one of the most critical issues for edible oil refineries. Crude oil, refined edible oils and packing material inventories are high-value. Working capital management is crucial due to the need for significant liquidity in oil procurement. Under-funding can halt operations entirely despite projected profitability.
Working capital requirements typically range from 10–20% of total capital investment, but for larger refineries processing imported crude, the absolute requirement can be enormous. High crude oil prices directly increase working capital requirements for refiners.
Major Working Capital Elements:
- Crude oil inventory (typically 25–30 days of consumption for domestic; up to 45–60 days for import-dependent refineries)
- Chemicals and consumables inventory (7–15 days)
- Finished goods inventory of refined oils (7–10 days)
- Trade receivables from distributors and wholesalers (15–30 days)
- Less: Trade payables to crude suppliers (10–15 days)
- Minimum cash balance for operating expenses
Inventory management is critical in maintaining sufficient operational cash flow within a refinery.
Illustrative Working Capital – 500 TPD Refinery (Stabilised Year)
| Component | Days | Daily Value (₹ Lakh) | Total (₹ Crore) |
|---|---|---|---|
| Crude Oil Inventory | 30 | 650 | 195 |
| Chemicals & Consumables | 10 | 8 | 0.8 |
| Finished Goods | 8 | 680 | 54 |
| Trade Receivables | 20 | 700 | 140 |
| Gross Current Assets | ~390 | ||
| Less: Trade Payables | 12 | 650 | 78 |
| Working Capital Gap | ~312 |
Simple formulas: Inventory Days = Average Inventory ÷ Daily Cost of Goods Consumed. Debtor Days = Average Receivables ÷ Daily Sales. Creditor Days = Average Payables ÷ Daily Purchases.
The assessed working capital requirement is distinct from the sanctioned cash credit or overdraft limit. Drawing power depends on monthly stock statements, margin requirements (typically 25% for inventory, 25–40% for receivables) and the value of hypothecated inventory and receivables. Banks in India use methods such as the operating cycle method or turnover method for MSMEs, while larger edible oil refineries undergo detailed working capital assessment based on projected balance sheets and CMA Data.
Do not apply a single uniform percentage of sales as working capital across all capacities. A 1,000 TPD refinery importing palm oil in large vessel parcels may require disproportionately higher absolute working capital because crude oil inventory is lumpy and import-linked. Promoters should plan working capital alongside term loan from inception. Insufficient working capital is a common reason technically sound edible oil businesses struggle.
CMA Data Preparation for Edible Oil Refinery Bank Finance
Credit Monitoring Arrangement (CMA) Data is a standard banking format in India used for both term loan and working capital appraisal. For a capital-intensive edible oil refinery, accurate CMA preparation is mandatory for any serious bank finance proposal.
Key Statements in CMA Data:
- Past performance (audited actuals for 2–3 years, where available)
- Current year estimates
- Future projections for 4–5 years
- Projected profit and loss and balance sheet
- Fund flow statement
- Details of existing and proposed credit facilities
- Current assets and current liabilities breakdown
- Key financial ratios: current ratio, debt-equity ratio, interest coverage ratio, DSCR
The edible oil refinery CMA figures must reconcile exactly with the DPR and main financial model. Sales, raw material consumption, term loan drawdown, interest costs and depreciation should not differ between documents. Common inconsistencies in weak proposals include different capacity utilisation assumptions in DPR versus CMA, mismatched debt-equity ratio, interest calculated on full term loan even before disbursement, or ignoring margin money contribution in working capital.
Exact CMA format and scrutiny level differ between public sector banks, private banks and financial institutions. A professional adviser can customise the structure while maintaining RBI and internal bank policy norms.
Edible Oil Refinery DSCR Calculation and Term Loan Repayment Capacity
The debt service coverage ratio measures how comfortably a refinery’s cash accruals can service term loan principal plus interest. The average DSCR is a key metric in DPRs for lenders evaluating industrial projects.
DSCR Formula (Project Finance Convention):
DSCR = Cash Available for Debt Service ÷ Total Debt Service (Interest + Principal)
Where Cash Available typically = PAT + Depreciation + Interest on Term Loan (with variations across institutions).
Illustrative DSCR – 300 TPD Refinery (₹60 Crore Term Loan, 8-Year Tenure, 1-Year Moratorium)
| Year | EBITDA (₹ Cr) | Interest TL (₹ Cr) | PAT (₹ Cr) | Cash Accrual (₹ Cr) | Principal Due (₹ Cr) | Total Debt Service (₹ Cr) | DSCR |
|---|---|---|---|---|---|---|---|
| 1 | 10.0 | 5.4 | 0.8 | 6.3 | 0.0 | 5.4 | 1.17 |
| 2 | 14.5 | 5.0 | 2.8 | 8.3 | 7.5 | 12.5 | 1.06* |
| 3 | 16.0 | 4.3 | 3.4 | 8.9 | 7.5 | 11.8 | 1.37 |
| 4 | 16.5 | 3.6 | 4.0 | 9.5 | 7.5 | 11.1 | 1.53 |
| 5 | 17.0 | 2.9 | 4.6 | 10.1 | 7.5 | 10.4 | 1.65 |
| Average DSCR | ~1.36 |
*Note: Year 2 DSCR is tight because ramp-up is still underway while full principal repayment begins. This is where moratorium planning matters.
Financial projections need to consider commodity price volatility. DSCR in an edible oil refinery is particularly sensitive to changes in refining margin per tonne and capacity utilisation. A ₹500 per MT drop in contribution on a refinery processing approximately 81,600 MT per year reduces annual contribution by roughly ₹4.1 crore-potentially dropping DSCR from 1.4 to below 1.1 in marginal years.
Many lenders informally prefer average DSCR comfortably above 1.3–1.4 for industrial projects, though no universal minimum applies across all institutions. The term loan repayment schedule-tenure, moratorium, ballooning versus equated instalments-should be crafted after running DSCR scenarios in the financial model rather than applying a standard template without analysis.
Projected Balance Sheet and Cash Flow Statement
The projected profit and loss alone does not tell the full story. Promoters and lenders also need projected balance sheet and cash flow statement to judge net worth build-up, working capital position and loan repayment capacity.
Major Balance Sheet Heads (Annual Projection):
- Gross block of fixed assets: land, building, plant and machinery, utilities, laboratory equipment, storage tanks
- Accumulated depreciation and net fixed assets
- Current assets: inventories, receivables, cash and bank balances
- Current liabilities: creditors, working capital loans, other current liabilities
- Term loan outstanding (must reconcile to repayment schedule)
- Share capital plus reserves
Cash Flow Categories:
- Operating activities: EBITDA adjusted for tax, working capital movement
- Investing activities: capital expenditure, future expansion
- Financing activities: drawdown and repayment of loans, equity infusion
An edible oil refinery can show accounting profits but face a cash crunch if large increases in crude oil stock or receivables consume cash. For example, if crude price rises 10% and the refinery maintains 30-day inventory, working capital investment increases by several crore-absorbing cash that accounting profits suggest is available. A good financial model allows monthly or quarterly cash flow analysis during the first 2–3 years to identify periods where cash flows fall short of interest and instalments.
Break-Even Analysis, Project IRR, Equity IRR, NPV and Payback Period
A break-even analysis is important for understanding capacity utilisation needs and cost coverage. Financial metrics like ROI and payback period are crucial for evaluating refinery viability.
| Metric | What It Measures | Edible Oil Refinery Context |
|---|---|---|
| Break-Even Point | Capacity utilisation or sales at which total costs are covered | Fixed Costs ÷ Contribution Margin %. Tells the promoter the minimum throughput needed to avoid losses. |
| Project IRR | Return on total capital employed | Tests overall financial feasibility; should exceed weighted cost of capital. |
| Equity IRR | Return to equity investors after debt service | Reflects promoter reward after leveraging with term loans. |
| NPV | Present value of future cash flows minus initial investment | Positive NPV at 12–15% discount rate indicates value creation. |
| Payback Period | Time to recover initial investment from net cash flows | Shorter payback reduces risk exposure. |
Project IRR and equity IRR should be evaluated alongside DSCR. Very high projected IRR based on optimistic refining margins will not be persuasive to bankers if sensitivity analysis shows DSCR collapsing under modest adverse changes.
Financial Feasibility Comparison – 100, 300, 500 and 1,000 TPD Refineries
Promoters often ask which capacity is best. The answer depends on capital investment, market reach, logistics, crude sourcing capability, working capital strength and risk appetite rather than a single formula.
| Parameter | 100 TPD | 300 TPD | 500 TPD | 1,000 TPD |
|---|---|---|---|---|
| Annual Crude (85% util.) | ~25,500 MT | ~81,600 MT | ~1,36,000 MT | ~2,80,500 MT |
| Capital Investment Range | ₹20–30 Cr | ₹50–80 Cr | ₹80–150 Cr | ₹150–300 Cr |
| Working Capital Intensity | Medium | High | Very High | Very High |
| Break-Even Utilisation | 50–60% | 45–55% | 40–50% | 40–50% |
| DSCR Sensitivity | Moderate | Moderate-High | High | High |
| Key Consideration | Market limited; higher per-MT cost | Good balance of scale and manageability | Requires strong procurement and distribution | Requires port proximity, large WC lines, robust market |
Larger plant capacity does not guarantee better profitability if the promoter’s distribution network, crude sourcing ability, or working capital lines cannot support the throughput. The detailed cost structure is discussed in Edible Oil Refinery Project Cost and Investment. For integrated crushing, extraction and refining complexes, financial modelling requires separate treatment of extraction yields and refining margins.
Sensitivity Analysis and Financial Risk Assessment
Edible oil refining operates on thin yet volatile margins. Regulatory costs and compliance also impact financial projections. A serious financial model must test how DSCR, IRR and cash flows respond to adverse movements.
Key Risk Variables:
- Crude edible oil procurement price increase
- Refined oil selling price reduction or lag in price pass-through
- Lower capacity utilisation
- Higher fuel and power cost
- Longer inventory holding due to import delays or location disadvantage (transportation costs)
- Slower collections and higher debtor days
- Higher interest rates or delayed commissioning
Illustrative Sensitivity Scenarios (300 TPD Refinery)
| Scenario | EBITDA Impact | Cash Accrual Impact | DSCR Movement |
|---|---|---|---|
| Base Case | ₹16.0 Cr | ₹8.9 Cr | 1.37 |
| Crude Price +5% | −₹3.5 Cr | −₹2.6 Cr | ~1.15 |
| Utilisation −10% | −₹2.0 Cr | −₹1.5 Cr | ~1.20 |
| Interest Rate +2% | −₹1.2 Cr | −₹0.9 Cr | ~1.25 |
| Combined Adverse | −₹6.0 Cr | −₹4.5 Cr | ~0.90 |
A project that remains above minimum DSCR and break-even even in modestly adverse scenarios is viewed more favourably by banks and investors. Promoters should test combined shocks-simultaneous crude increase and lower utilisation-not only one variable at a time.
Common Financial Projection Mistakes in Edible Oil Refinery DPRs
In my experience as a project finance adviser, many edible oil project reports fail not because the business idea is poor but because the financial projections are unrealistic or internally inconsistent.
- Assuming 85–90% utilisation in Year 1 without commissioning and market build-up allowance. Correction: use phased utilisation starting at 55–65%.
- Confusing high turnover with profitability by ignoring per-tonne refining margin. Correction: always present contribution per MT alongside revenue.
- Under-estimating crude and finished goods inventory and related working capital. Correction: model at least 25–30 days crude, 7–10 days finished goods.
- Ignoring refining losses (gums, soap stock, spent bleaching earth, transit losses) and overstating saleable quantity. Correction: validate yield assumptions with process equipment suppliers-see Edible Oil Refinery Machinery, Technology and EPC Selection for realistic automation level and efficiency benchmarks.
- Using flat crude and refined oil prices for 10 years without sensitivity analysis.
- Miscalculating interest (charging full-year interest before disbursement or during moratorium).
- Preparing CMA Data that does not tally with the DPR financial model.
- Neglecting repairs, maintenance, shutdown days and food safety compliance costs.
- Omitting DSCR analysis or showing unrealistically smooth DSCR despite volatile margins.
Documents Required for Edible Oil Refinery Financial Modelling and CMA Preparation
Promoters who want to engage a professional to prepare a DPR, financial projections and CMA Data should collect the following before modelling begins:
- Proposed refining capacity (TPD) and any future expansion plans
- Type and mix of crude oils: palm oil, soybean, sunflower, mustard, rice bran, groundnut, cottonseed or others
- Detailed quotations for plant and machinery, production equipment, utilities, storage tanks and automation from shortlisted vendors
- Land and building cost estimates including tank farm and civil work
- Refining process route (physical, chemical refining, or combination) and yield/loss data from the technical supplier
- Specific utility requirements and consumption norms
- Expected crude oil sourcing pattern (import versus domestic), payment terms and likely inventory days
- Target market, location, expected selling prices, credit terms, packing mix (pouches, jars, tins, bulk), and sales distribution plan
- Promoter’s net worth, proposed equity contribution and any unsecured loans planned
- Indicative term loan structure (tenure, moratorium), and proposed working capital facilities (cash credit, LC, buyers’ credit)
- Last 3 years’ audited financials of the promoter entity or group companies, where available
- Details of existing banking relationships and limits
- Project implementation schedule and any government schemes or subsidies targeted
- FSSAI licence (mandatory for edible oil refineries), Pollution Control Board consent (required for every refinery), Factory Act compliance for licensing, Legal Metrology registration (needed for packed oil), and state boiler inspectorate registration (required for steam boilers under vacuum deodorisation and other process stages)
Professional Edible Oil Refinery DPR, CMA Data and Financial Projection Services
Over more than 20 years of professional practice, I have worked extensively on project finance, DPR preparation and financial feasibility for manufacturing and processing projects across India. Project Report Bank is a professional advisory platform-not a generic document marketplace.
For edible oil refinery projects, the core service deliverables include:
- Plant-specific detailed project report covering technical and financial aspects
- Customised 7–10 year financial projections including projected profit and loss, balance sheet and cash flow
- Refinery-specific working capital assessment and bank finance structuring (term loan and working capital)
- CMA Data preparation tailored to the chosen lender’s format
- DSCR analysis and term loan repayment schedule modelling, including moratorium planning
- Break-even, IRR, NPV and payback computations, along with sensitivity and scenario analysis
- Support in understanding bank queries on viability, DSCR and security coverage
- Investor-ready DPR and pitch presentation where equity funding is being considered
- Integration of capacity planning, technology choice and utility planning with financial projections
If you are planning a 100–1,000 TPD edible oil refinery and require a properly structured DPR, financial model or CMA Data for bank finance or investment discussions, I invite you to share your basic project details for an initial discussion. No loan sanction or financial returns can be guaranteed-but a professionally prepared financial model significantly improves the quality of your investment decision and your conversations with lenders and investors.
CA Manish Gugliya, FCA, DISA (ICAI) Practising Chartered Accountant | Project Finance, DPR, CMA Data & Financial Feasibility Advisory ProjectReportBank.com
Frequently Asked Questions
The following addresses common queries from edible oil refinery promoters about financial projections, DSCR, CMA and working capital in the Indian context.
How are financial projections prepared for an edible oil refinery?
Financial projections begin with installed capacity and utilisation assumptions, then define crude oil and refined oil prices and yields. Detailed operating cost blocks-utilities, chemicals, packing, manpower, maintenance-are built next. Capital investment, funding mix, interest, depreciation and tax are structured to generate 7–10 year projected profit and loss, balance sheet, cash flow and DSCR schedules. Every assumption should be documented and internally consistent.
How much working capital is required for a 500 TPD edible oil refinery?
The exact figure depends on crude oil price, inventory days, debtor and creditor terms and the mix of oils processed. Crude oil inventory alone-at 25–30 days of consumption-can require ₹150–200 crore or more at current price levels. A formal assessment models crude inventory days, finished goods, receivables and payables to arrive at the working capital gap and the bank limit with appropriate promoter margin.
What is CMA Data for edible oil refinery bank finance?
CMA Data is a set of linked statements-past performance, projected profit and loss, balance sheet, fund flow, current assets and current liabilities, and existing and proposed credit limits-prepared in the banker’s prescribed format. It enables the bank to assess working capital requirement, DSCR and overall viability of the refinery project as part of the credit appraisal process.
How is DSCR calculated for an edible oil refinery?
DSCR equals cash accruals available for debt service divided by term loan principal repayment plus interest for each year. Cash accruals typically include PAT plus depreciation plus interest on term loan. The ratio is calculated year-wise across the loan tenure. In edible oil projects, small changes in refining margin or utilisation can significantly move DSCR because operating margins are narrow relative to turnover.
What financial statements should a bankable edible oil refinery DPR contain?
A bankable DPR should include 7–10 year projected profit and loss, balance sheet, cash flow statement, detailed working capital assessment, term loan repayment schedule, DSCR working, break-even analysis and IRR/NPV computation-all reconciled with the technical configuration and capital investment detailed in the project report.
Over how many years should refinery projections normally be prepared?
For bank finance proposals involving term loans, projections should cover the full loan tenure plus 1–2 years. For a typical 7–8 year term loan with 1 year moratorium, this means 9–10 year projections. Some lenders and investors may accept 5-year projections for smaller projects, but medium- to large-scale refineries generally require longer projection periods.
Why is working capital especially critical in edible oil refining compared to some other manufacturing sectors?
Because raw materials alone account for 85–90% of operating expenses, and crude edible oil is a globally traded commodity with daily price fluctuations. Even modest changes in crude price or inventory holding period can shift working capital requirements by several crore. Unlike sectors where raw material cost is a smaller proportion of sales, edible oil refineries face disproportionate cash flow pressure from inventory and receivable management.