Trusted by 25,000+ startup founders, investors and CPAs
From Blank Sheet To Plan
Megan Turner, NC
I didn’t have to start from scratch, which saved me a full day of spreadsheet work. The template gave me a clean starting point for the candle business model and made the assumptions easier to explain.
Clear Cash Flow Visibility
Daniel Foster, TX
The cash flow forecast made it much easier to see where the runway could tighten up. I was able to spot a shortfall early and adjust my plan before my next lender meeting.
Reporting In One Place
Priya Shah, IL
Having the statements and charts together cut out the usual file hunting. I pulled one clean report for my review meeting in under an hour.
Model review
What is included in the financial model of Candle Manufacturing?
The Financial model for the production of candles is an editable five-year workbook combining product line units and price assumptions with monthly and annual reports, scenarios and navigation desks.
Use the workbook to plan products from candles, units, prices, costs, staff, equipment expenditure, financing and the resulting financial results.
The editable operational assumptions flow through monthly model calculations in the five-year forecast, scenario comparisons, financial statements and management reports.
Built to plan the product lineRevenue is derived from unit prices and corresponding prices for each updated product line with candles, taking into account seasonality and revenue auxiliaries when used.
Engine revenue from the production of candles
How does financial model calculate the revenue from a business called Candle Manufacturing?
The model calculates each product line from units sold or sold multiplied by the corresponding sales price and then combines the enabling lines and additional revenue.
01
Product definition
Set the names of the product lines produced and the start-up date when the start-up dates are used in the schedule.
02
Introduction of units
Units manufactured, marketed or sold using sales conventions or workbook stocks.
03
Set the price
An appropriate sales price per unit of each product line included should be assigned.
04
Use seasonality
Where annual sources are reported in monthly reports, the production line revenue should be allocated once per season.
05
Calculation of revenue
The amount of revenue as part of the updated product lines and the addition of any additional revenue entered separately.
Basic formularevenue = product line units × matched price + additional revenue
01 / Revenue
What can you edit on the Worksheet entry?
The revenue view organizes the candle product lines, unit volume, sales prices, launch time and monthly seasonality that provide the forecast revenue product line.
Revenue
The revenue view displays product lines, unit assumptions, prices, seasonality and the resulting forecast.
02 / COGS
How does the structure of the COGS sheet lead to direct costs?
According to COGS, the direct costs of producing candles are separated by product, basis of calculation, year of forecast and monthly schedule, so the cost assumptions are followed by the operating volume.
COGS
The COGS view shows the categories of direct costs, the basis for the calculation, the annual assumptions and the monthly calculations of expenditure.
03 / Scenarios
What can you compare the scenarios to?
The scenario compares the Low, Base, and High levels for revenue, gross margin, contribution margin and EBITDA over the forecast period of five years.
Scenarios
The scenarios shall show charts of Low, Base, and High performance for key financial instruments over five years.
04 / Dashboard
What Does the Dashboard Bring Together?
You can use dashboard to review model configurations, scenario checks, key indicators, basic financial performance, mix of revenue, profitability, cash flow and return on investment charts in one place.
Dashboard
The Dashboard presents configuration controls, scenario results, basic financial data and management charts in one view.
Product adjustment
Is the financial model candle manufacturing right for you?
The ready-made model fits into the production economy of the production line built around units and prices; structurally different revenue logics or operating schedules may require custom modelling.
Model ready
It fits perfectly
Your revenue is driven by manufactured product line units and matching sales prices.
You want an editable launch, volume, prices, seasonality and extra revenue.
You plan direct costs, operating expenses, payroll and capital expenditure in combined schedules.
You need Low, Base, and High scenarios, basic financial statements and management reports in one workbook.
Order structure
Think about the model
Your revenue depends on formulas that differ significantly from product line units multiplied by prices.
You need operational schedules structured differently than a revenue, cost, salary or capital vision model.
Reporting structures significantly different from the financial statements, scenarios and results of the Dashboard model are required.
You need a specialized structure to recognize sales or inventory outside of the existing workbook convention.
The indicator is the starting point for planning, not a guarantee of performance.
Financial modelling service for orders
Do you need a pattern that meets your requirements?
Financial Models Lab can build or customize a model when your business needs a different revenue logic, operating schedule or financial reporting.
After purchasing, you'll receive an instantly downloadable Excel financial model containing five-year forecast, monthly and annual forecast, scenarios and financial statements.
01
Editable workbook
Change the operational and financial assumptions of the model directly to workbook in Excel.
02
5 - Annual Forecast
An overview of the five years forecast with monthly and annual financial details.
03
Analysis of scenarios
Compare the Low, Base, and High cases in each key financial instrument.
04
Financial statements
Use your projected income statement, cash flow, balance sheet, summary and dashboard results.
Before purchase
Candle Making Financial Models FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the financial model calculate the production of Candle revenue?
It shall calculate each updated product line from units sold or sold multiplied by the corresponding sales price and then add up any additional revenue entered separately.
02
What assumptions about the production of candles can be changed?
You can edit product line names, start time when used, unit volume, sales prices, sales conventions or inventories in the workbook, seasonality and additional revenue started.
03
What can I compare low, base, and high scenarios to?
They allow the comparison of alternative five-year results in terms of revenue, gross margin, contribution margin and EBITDA.
04
What financial results are included in the workbook?
In workbook there is income statement, a report from cash flow, a balance sheet, a summary, dashboard and management reports based on charts.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab offers individual financial modelling when you need different revenue logic, operational timetable or reporting structures.
06
Is this workbook a prediction or a guarantee?
This is a planning forecast based on the assumptions contained in the workbook, not a guarantee of business results or financial results.
What Does the Candle Manufacturing Financial Model Contain?
This is a complete financial operating model designed to help you launch and scale a candle manufacturing business.
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
Scenarios
Dashboard
