Evergreen Life Memorial Center

Start your own business plan »

Funeral Home Business Plan

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Funeral Products & Services $5,884 $5,884 $5,884 $5,884 $11,768 $11,768 $11,768 $17,652 $17,682 $23,536 $23,535 $29,420
Direct Cremations $0 $0 $0 $1,775 $0 $1,775 $0 $1,775 $1,775 $1,775 $1,775 $1,775
Total Sales $5,884 $5,884 $5,884 $7,659 $11,768 $13,543 $11,768 $19,427 $19,457 $25,311 $25,310 $31,195
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Funeral Products & Services $2,059 $2,059 $2,059 $2,059 $4,119 $4,119 $4,119 $6,178 $6,189 $8,238 $8,237 $10,297
Direct Cremations $0 $0 $0 $621 $0 $621 $0 $621 $621 $621 $621 $621
Subtotal Direct Cost of Sales $2,059 $2,059 $2,059 $2,681 $4,119 $4,740 $4,119 $6,799 $6,810 $8,859 $8,859 $10,918
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Owner 3% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Salesperson 3% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Administrative Assistant 3% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Staff Member 3% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 1 1 1 1 1 1 1 1 1 1 1 1
Total Payroll $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $5,884 $5,884 $5,884 $7,659 $11,768 $13,543 $11,768 $19,427 $19,457 $25,311 $25,310 $31,195
Direct Cost of Sales $2,059 $2,059 $2,059 $2,681 $4,119 $4,740 $4,119 $6,799 $6,810 $8,859 $8,859 $10,918
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $2,059 $2,059 $2,059 $2,681 $4,119 $4,740 $4,119 $6,799 $6,810 $8,859 $8,859 $10,918
Gross Margin $3,825 $3,825 $3,825 $4,978 $7,649 $8,803 $7,649 $12,628 $12,647 $16,452 $16,452 $20,277
Gross Margin % 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00%
Expenses
Payroll $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Marketing/Promotion $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Depreciation $1,056 $1,056 $1,056 $1,056 $1,056 $1,056 $1,056 $1,056 $1,056 $1,056 $1,056 $1,056
Mortgage Payments $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Insurance $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Payroll Taxes 15% $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Auto Expenses 15% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Supplies $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Total Operating Expenses $13,606 $13,606 $13,606 $13,606 $13,606 $13,606 $13,606 $13,606 $13,606 $13,606 $13,606 $13,606
Profit Before Interest and Taxes ($9,781) ($9,781) ($9,781) ($8,628) ($5,957) ($4,803) ($5,957) ($978) ($959) $2,846 $2,846 $6,671
EBITDA ($8,725) ($8,725) ($8,725) ($7,572) ($4,901) ($3,747) ($4,901) $78 $97 $3,902 $3,902 $7,727
Interest Expense $1,477 $1,453 $1,430 $1,407 $1,383 $1,360 $1,337 $1,313 $1,290 $1,267 $1,243 $1,220
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($11,258) ($11,235) ($11,211) ($10,034) ($7,340) ($6,163) ($7,293) ($2,292) ($2,249) $1,579 $1,602 $5,451
Net Profit/Sales -191.33% -190.94% -190.54% -131.01% -62.37% -45.51% -61.98% -11.80% -11.56% 6.24% 6.33% 17.47%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $5,884 $5,884 $5,884 $7,659 $11,768 $13,543 $11,768 $19,427 $19,457 $25,311 $25,310 $31,195
Subtotal Cash from Operations $5,884 $5,884 $5,884 $7,659 $11,768 $13,543 $11,768 $19,427 $19,457 $25,311 $25,310 $31,195
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $5,884 $5,884 $5,884 $7,659 $11,768 $13,543 $11,768 $19,427 $19,457 $25,311 $25,310 $31,195
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $16,086 $16,063 $16,039 $16,637 $18,052 $18,650 $18,005 $20,663 $20,650 $22,676 $22,652 $24,688
Subtotal Spent on Operations $16,086 $16,063 $16,039 $16,637 $18,052 $18,650 $18,005 $20,663 $20,650 $22,676 $22,652 $24,688
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $19,586 $19,563 $19,539 $20,137 $21,552 $22,150 $21,505 $24,163 $24,150 $26,176 $26,152 $28,188
Net Cash Flow ($13,702) ($13,679) ($13,655) ($12,478) ($9,784) ($8,607) ($9,737) ($4,736) ($4,693) ($865) ($842) $3,007
Cash Balance $104,598 $90,919 $77,264 $64,785 $55,001 $46,394 $36,657 $31,921 $27,228 $26,364 $25,522 $28,529
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $118,300 $104,598 $90,919 $77,264 $64,785 $55,001 $46,394 $36,657 $31,921 $27,228 $26,364 $25,522 $28,529
Other Current Assets $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000
Total Current Assets $145,300 $131,598 $117,919 $104,264 $91,785 $82,001 $73,394 $63,657 $58,921 $54,228 $53,364 $52,522 $55,529
Long-term Assets
Long-term Assets $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000
Accumulated Depreciation $0 $1,056 $2,112 $3,168 $4,224 $5,280 $6,336 $7,392 $8,448 $9,504 $10,560 $11,616 $12,672
Total Long-term Assets $80,000 $78,944 $77,888 $76,832 $75,776 $74,720 $73,664 $72,608 $71,552 $70,496 $69,440 $68,384 $67,328
Total Assets $225,300 $210,542 $195,807 $181,096 $167,561 $156,721 $147,058 $136,265 $130,473 $124,724 $122,804 $120,906 $122,857
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Current Borrowing $225,000 $221,500 $218,000 $214,500 $211,000 $207,500 $204,000 $200,500 $197,000 $193,500 $190,000 $186,500 $183,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $225,000 $221,500 $218,000 $214,500 $211,000 $207,500 $204,000 $200,500 $197,000 $193,500 $190,000 $186,500 $183,000
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $225,000 $221,500 $218,000 $214,500 $211,000 $207,500 $204,000 $200,500 $197,000 $193,500 $190,000 $186,500 $183,000
Paid-in Capital $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Retained Earnings ($19,700) ($19,700) ($19,700) ($19,700) ($19,700) ($19,700) ($19,700) ($19,700) ($19,700) ($19,700) ($19,700) ($19,700) ($19,700)
Earnings $0 ($11,258) ($22,493) ($33,704) ($43,739) ($51,079) ($57,242) ($64,535) ($66,827) ($69,076) ($67,496) ($65,894) ($60,443)
Total Capital $300 ($10,958) ($22,193) ($33,404) ($43,439) ($50,779) ($56,942) ($64,235) ($66,527) ($68,776) ($67,196) ($65,594) ($60,143)
Total Liabilities and Capital $225,300 $210,542 $195,807 $181,096 $167,561 $156,721 $147,058 $136,265 $130,473 $124,724 $122,804 $120,906 $122,857
Net Worth $300 ($10,958) ($22,193) ($33,404) ($43,439) ($50,779) ($56,942) ($64,235) ($66,527) ($68,776) ($67,196) ($65,594) ($60,144)