Please fill all required fields
input sheet
results
Narrative
Free Breakeven Calculator
Step 1 Call Mix & Average Sale
How To Use This Calculator
Your Call Mix:
This is a simple way to calculate your break even in two ways: # of calls and $ in revenue. I recommend you start by entering your best guesses. The results will tell you if you are close. You can play some
"what / if"
games by changing the input on this sheet. For instance: What if you increased your burial prices by 5%? Try it and see what happens. Have fun! After you have learned how it works you can get serious by inputting actual data from your financial statements.
Burials
Cremations
Misc. Calls
Total Calls
Your Sales Averages:
Avg. Burial Sale
Avg. Cremation Sale
Miscellaneous Revenue
Step 2 Average Wholesale Cost
Step 4 Mdse Volume
Your Wholesale averages
Your Units Sold
Avg. Casket Cost
Caskets Sold
Avg. Vault Cost
Vaults Sold
Avg. Cremation Mdse
Cremation Mdse Sold
xxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxx
Step 3
Other Wholesale costs
Your Cost of Sales
Casket Wholesale
Other Wholesale Costs
Vault Wholesale
Urn Wholesale
Aggregate Miscellaneous Cost
Miscellaneous Cost
Step 5 Operating Ratios
Your P & L
Your Ratios
Standard Ratios
Total Revenue
100.00%
Cost of Sales
15-20%
Gross Margin
75-80%
Total Fixed Overhead
70+%
Net Profit /
(
Loss)
5+%
alancreedy.org • All Rights Reserved 2011
Free Breakeven Calculator
Key Results
Your Averages
Your Breakeven
Averages:
Avg. Sale
Calls Needed to Breakeven:
Avg. Burial Sale
Revenue Needed to Breakeven:
Avg. Cremation Sale
Your Margin of Safety
Your Cremation Rate
Your Current Call Volume:
Calls
Incremental Unit C
ontribution:
Your Current Margin of Safety:
Calls
Avg. Unit Margin
Your Margin of Safety Should Be:
Calls
Burial Margin
Your Margin of Safety Is:
Calls
Cremation Margin
xxxxxxxxxxxxx
xxxxxxxxxxxxxxxx
Disclaimer:
This tool is not intended to replace a thoroughly detailed analysis. It is for your use as a quick and easy way to assess your situation and try a few different scenarios. Certain items are not included which could materially affect results. These include things like conversions from guaranteed preneed contracts, certain competitive factors, revenue or expense from unrelated enterprises and payment to non contributing family members. Click on the button below to learn more.
alancreedy.org • All Rights Reserved 2011
Free Breakeven Calculator
Narrative
Results
AlanCreedy.org for specific recommendations on how to maximize your business performance.
Disclaimer:
This tool is not intended to replace a thoroughly detailed analysis. It is for your use as a quick and easy way to assess your situation and try a few different scenarios. Certain items are not included which could materially affect results. These include things like conversions from guaranteed preneed contracts, certain competitive factors, revenue or expense from unrelated enterprises and payment to non contributing family members. Click on the button below to learn more.
alancreedy.org • All Rights Reserved 2011
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.