Evergreen Life Memorial Center
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) |