This financial model sits at the intersection of manufacturing and renewable energy, focused on the fast‑growing need for battery recycling as electrification accelerates. It translates the operational flow—from feedstock intake to black mass (BM) and optional downstream metal refining—into a clear, decision‑ready set of financials. Built for both operators and investors, the workbook spans up to 10 years and integrates the full 3‑statement model with a DCF, IRR, ROI, equity multiple, and minimum‑cash outputs. Detailed monthly pro formas roll up into annual views and an Executive Summary that goes from high‑level metrics down to cash flow, supported by 21 charts and graphs. All assumptions are dynamic; the model is fully editable and unlocked for complete transparency.
Revenue is modeled the way plants actually run: configure up to four feedstock intake channels with inbound tonnes per month and choose among tolled, gated, and recycler bidding acquisition modes. Decide whether to stop at BM or refine further into metals, then set forward pricing per tonne for all products and by‑products. You can define BM yields and value per tonne by category and adjust product and metal pricing over time to reflect market dynamics. A dedicated Accounts Receivable configuration lets you specify the percentage of revenue collected at sale and schedule the remaining collections across up to three months after the sale, ensuring cash receipts, AR balances, and liquidity planning match real customer terms.
Costs are broken out with equal fidelity. Indirect fixed costs (lighting, non‑direct utilities, supervisors, and more) are separated from direct labor, which can be configured by work center (shifts, headcount, salaries). Feedstock costs can be set per tonne at the total intake level and by inbound channel, while processing and selling costs are specified for BM and refined product outputs. The model visualizes average total revenue, cost, and profit per tonne so you can see per‑tonne economics by pathway and channel at a glance.
Beyond operating performance, the template handles the full build‑out and financing picture. It includes a construction and equipment cost schedule with depreciation, SG&A sections, a construction loan plus two operating loan configurations, and a Sources & Uses summary. Because collections timing flows through the integrated statements, the model naturally captures working‑capital needs, borrowing draws, and minimum cash. Under the hood, the logic has been engineered to track the permutations of feedstock mix, yield, and pricing across the refining cycle—detailed enough to model realistic scenarios for a battery recycling plant, yet streamlined enough for most teams to use for pricing/cost analysis and overall feasibility.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Renewable Energy, Integrated Financial Model Excel: Battery Recycling Plant: Startup Financial Feasibility Template Excel (XLSX) Spreadsheet, Jason Varner | SmartHelping
Integrated Financial Model Real Estate Loans Mining Industry Franchising Activity Based Costing
|
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. |