Trusted by 25,000+ startup founders, investors and CPAs
Clear Investor Roadmap
Megan Carter, NY
This template turned a fuzzy idea into a model I could explain line by line, so investor questions felt much easier to answer. It gave me the structure I needed and saved a full day of guesswork.
Blank Spreadsheet, Instant Direction
Ryan Mitchell, TX
Starting from scratch felt impossible, but this model gave me a clean place to begin and cut my setup time by hours. I had a working forecast the same afternoon instead of staring at an empty sheet.
Easy Excel For Nonexperts
Laura Bennett, FL
I don't live in Excel, so the prebuilt formulas and clean layout made the model far less technical than I expected. I was able to update assumptions without breaking anything and send the numbers to my team the same day.
MODEL OVERVIEW
What Is Used Oil Recycling System Financial Model?
This is an editable Excel and Google Sheets workbook for planning five-years around recurring revenue from services, scenario analysis and integrated financial statements.
Use the model to combine sales acquisition of customers from retained service cohorts, monthly fee levels, operating costs, cash flow and financial statements.
You can edit start time, start customers, annual marketing budget, monthly seasonality, CAC, level allocation, customer duration or chorn convention, and monthly fees.
Built around regular customersThe acquisition of customers, the allocation of tiers, the retention of cohorts and monthly fees are affected by fixed revenues from services and integrated financial results.
ENGINE OF RECURRENT REVENUE FROM SERVICES
How Is the Model Service of Used Oil Recycling Calculates Revenue?
The model converts marketing spending into retained customer cohorts and then multiplys active customers by a corresponding monthly fee to calculate fixed revenues from services.
01
Buy Clients
Calculates new customers from marketing expenses divided by CAC, using the monthly schedule of seasonal marketing.
02
Horizontal
Where no other system exists under this scheme, the standard method shall be used.
03
Stop the Cohorts
Keep each cohort of the customer for the duration of its validity or in accordance with the collective convention of the workbook.
04
Active Number
Add initial customers to all non-exhaustive cohorts of customers to determine active customers by level.
05
Calculate Income
We multiply active customers by matching the monthly fee and sum up constant revenues in different levels and months.
FORM OF CORRECTIONRevenue = Active customers × Monthly fee for active customers
01 / REVENUE
How Are the Re-Applications for Revenue Arranged?
The income worksheet combines marketing budgets, CAC, level allocation, customer duration, active customers and monthly fees with cyclical revenues from services.
REVENUE
The revenue outlook shows acquisition, allocation of levels, customer lifetime, active customers and monthly service fees.
02 / COGS & OPEX
How Recycling Services Costs Are Planned?
The COGS & OPEX worksheet organises the costs of recycling related to revenue, variable marketing costs and fleet costs, as well as the fixed operating assumptions and their timetables.
COGS & OPEX
View COGS & OPEX shows the recycling of COGS, fleet variable costs, marketing and fixed operating costs.
03 / SCENARIOS
How Can we Compare Low, Basic and High Matters?
The Scenarios compared low, base and high revenue paths, gross margin, premium margin and EBITDA in the five-year forecast.
SCENARIOS
The scenario view shows low, basic and high paths to four key financial results.
04 / DASHBOARD
What Does the Distribution Board Have in Common?
The table contains global settings, financing and control of working capital, results of scenarios, revenue mix, profitability, cash flow, reimbursement and key financial indicators.
DASHBOARD
The table summarises the assumptions, scenarios, revenue mix, profitability, cash flow and return on investment.
FIT OF PRODUCTS
Is the Oil Recycling System Used Suitable for You?
It is consistent with service companies of a recurring nature, using marketing-driven customer cohorts, defined life periods or lifetimes, allocation of tiers and monthly fees; significant economic differences may require non-standard modelling.
MODEL BY MADA READY
Good Example
You get customers from marketing expenses and the cost of buying customers.
You assign new customers at different service levels with certain periods of customer life or churns.
You expect recurring revenue from active customers and monthly fees at a level.
You want low, base and high issues related to integrated financial statements.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your basic income depends on the amount of oil collected, the resale of goods or other mechanics without subscription.
To directly push income, you must have a route, vehicle, storage or processing capacity restriction.
You need detailed schedules for collecting, processing, removing or stocking goods outside the structure.
You need reporting structures or consolidation at the level of an entity that are significantly different from the workbook contained in it.
The template is the starting point of planning, not a guarantee of performance.
FINANCIAL MODEL SERVICE
Do You Need a Model Built Around Your Requirements?
The Financial Models Laboratory can build or adjust a model when you need a different logic of recycling revenue, operational schedules or financial reporting.
You will receive an instant, fully editable Excel and Google Sheets workbook with five-year projections, analysis of Low/Base/High scenarios and integrated financial reports.
01
Editable workbook
Updating acquisition, customer viability or churn, level of accuracy, cost, staff, capital expenditure and financial outlays.
02
Five-year forecast
Review of the five-year financial projections with monthly and annual cash flow.
03
Analysis of scenarios
Compare low, base and high cases for revenues, margins, EBITDA and other results.
04
Financial statements
Preview income account, cash flow, balance sheet, dashboard, summary and analytical reports.
BEFORE BUYING IMPORTANT INFORMATION
Secondhand Oil Recycling System Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the model calculate the revenue from the recycling services of the oil used for recycling?
It calculates new customers from expenditure marketing and CAC, allocates them according to the level, retains active cohorts, and then multiplys active customers with monthly fees and sums up revenue at different levels and months.
02
What are the assumptions I can change?
You can edit launch date, customer start, annual marketing budget, monthly marketing seasonality, CAC, allocation of new clients, customer lifetime or churn convention, and monthly fees by level.
03
What can I compare in Low, Base and High scenarios?
You can compare alternative paths for revenue, gross margin, premium premium and EBITDA over five years of forecast.
04
What financial results are taken into account?
Product Presents Income Statement, Cash Flow Statement, Balance Sheet, Distribution Board, Summary, Screenplays, Valuation, Break-even, ROIC, Charts, KPIs, Coefficients, Supreme Revenue, Supreme Expenditure, Sources and Use and Views of DuPont.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. Financial Models Lab offers custom financial modelling for buyers who need different revenue logic, operating schedules or reporting structures.
06
Is the workbook a forecast or a guarantee?
This is a planning forecast based on assumptions entered in the workbook, not a guarantee of financial results. Actual results may differ from modeled results.
What Does the Used Oil Recycling Service Financial Model Contain?
This downloadable financial model for waste oil management provides everything you need to build a comprehensive financial forecast for your used motor oil collection service, from initial startup costs to long-term profitability analysis.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
REVENUE
COGS & OPEX
SCENARIOS
DASHBOARD
