Manufacturing Financial Model & Feasibility Study in Excel (NPV, IRR, DCF, EVA)

What this model does

Four product categories each carry their own volume, growth and cost per unit. Production cost is built from raw materials, labour, conversion cost and an overhead percentage; a markup turns cost into price; direct factory salaries rise with annual inflation. Operating expenses, six classes of fixed assets — from buildings and machinery to vehicles and computers — and a loan with its own schedule complete the picture.

Seven sensitivity cases — budget, three optimistic and three pessimistic (±10%, ±25%, ±50%) — flex units, costs and markup from one selector, and the whole model follows. The valuation sheet walks through each method step by step: project free cash flows, the cost of capital, terminal value and discounting, then Economic Value Added with return on capital employed. A dashboard charts the results.

Use it for

• A feasibility study for a new plant, product line or capacity expansion
• Investor and lender packs that need NPV, IRR and a DCF value side by side
• Understanding how volume, unit cost and markup each move the valuation

Inside the workbook

1. findi360 · MAIN MENU — The cover, then a menu linking every sheet.
2. Summery · DB Visuals — Year-one overview, the sensitivity selector, and charts of NPV, IRR, DCF and EVA.
3. INPUTS — Only the yellow cells change: volumes, unit costs, markup, salaries, inflation, assets and loan.
4. IS · BS · CFS — Income statement to EPS and appropriation, balance sheet with a difference check, cash flow statement.
5. FA · Loan — Six fixed-asset classes with depreciation and a WDV check; the loan schedule.
6. VALUATION — NPV, IRR, DCF and EVA, each worked step by step with notes.

Who this model is for

• Manufacturers and project sponsors preparing a feasibility study or capex case
• Bankers and investors who want to see the cost build-up behind a valuation
• Finance professionals learning NPV, IRR, DCF and EVA on one consistent model

Frequently asked questions

Keep going on findi360

• DATA DARE Production Output and Plant Efficiency DD-MFG-001 · L1 — XLSX / ~10,000 rows Work Orders, Materials and Production Variance DD-MFG-002 · L2 — CSV / ~30,000 rows Manufacturing Cost, Quality and Supply Chain Performance DD-MFG-003 · L3 — Parquet / ~500,000 rows
• DATA DRILL Test yourself — Power BI practice questions One question at a time, or a 50-question timed simulation.
• COURSE Courses and free recordings Power BI, Python and finance courses for finance professionals.

Related models

• Hospital Financial Model & Feasibility Study

  A private hospital projected from its real revenue drivers — consultations, surgeries, beds and occupancy by ward, diagnostic tests — with a sensitivity dashboard and NPV, IRR and DCF.

• Restaurant Financial Model with Valuation

  A fast-food outlet projected month by month for five years — four products, three sales scenarios, the three financial statements, a loan and an NPV with terminal value.