Jonpaul's
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 | |||||||||||||
Barber Shop Hair Only Revenue | 0% | $40,040 | $41,440 | $42,840 | $44,240 | $45,640 | $47,040 | $48,440 | $49,840 | $51,240 | $52,640 | $54,040 | $55,440 |
Misc. Service i.e. Shave, Shine, Color etc. | 0% | $10,417 | $10,833 | $11,267 | $11,717 | $12,186 | $12,673 | $13,180 | $13,708 | $14,256 | $14,826 | $15,419 | $16,036 |
Product | 0% | $5,200 | $5,304 | $5,410 | $5,518 | $5,628 | $5,728 | $5,856 | $5,973 | $6,092 | $6,214 | $6,338 | $6,465 |
Total Sales | $55,657 | $57,577 | $59,517 | $61,475 | $63,454 | $65,441 | $67,476 | $69,521 | $71,588 | $73,680 | $75,797 | $77,941 | |
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 | |
Barber Shop Hair Only Revenue | $16,016 | $18,648 | $19,278 | $19,908 | $20,538 | $21,168 | $21,798 | $22,428 | $23,058 | $23,688 | $24,318 | $24,948 | |
Misc. Service i.e. Shave, Shine, Color etc. | $4,687 | $4,875 | $5,070 | $5,272 | $5,483 | $5,703 | $5,931 | $6,168 | $6,415 | $6,671 | $6,938 | $7,216 | |
Product | $2,600 | $2,652 | $2,705 | $2,759 | $2,814 | $2,870 | $2,928 | $2,986 | $3,046 | $3,107 | $3,169 | $3,232 | |
Subtotal Direct Cost of Sales | $23,303 | $26,175 | $27,053 | $27,939 | $28,835 | $29,741 | $30,657 | $31,582 | $32,519 | $33,466 | $34,425 | $35,396 |
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 | ||
Cathy Leskie | 0% | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
100% Commissioned Employees | 0% | $10 | $10 | $13 | $13 | $13 | $13 | $13 | $13 | $13 | $13 | $13 | $13 |
Assistant | 0% | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 |
Receptionist | 0% | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 |
Total People | 11 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | |
Total Payroll | $8,570 | $8,570 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 |
General Assumptions | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Long-term Interest Rate | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | |
Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
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 | $55,657 | $57,577 | $59,517 | $61,475 | $63,454 | $65,441 | $67,476 | $69,521 | $71,588 | $73,680 | $75,797 | $77,941 | |
Direct Cost of Sales | $23,303 | $26,175 | $27,053 | $27,939 | $28,835 | $29,741 | $30,657 | $31,582 | $32,519 | $33,466 | $34,425 | $35,396 | |
Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $23,303 | $26,175 | $27,053 | $27,939 | $28,835 | $29,741 | $30,657 | $31,582 | $32,519 | $33,466 | $34,425 | $35,396 | |
Gross Margin | $32,354 | $31,402 | $32,464 | $33,536 | $34,619 | $35,700 | $36,819 | $37,939 | $39,069 | $40,214 | $41,372 | $42,545 | |
Gross Margin % | 58.13% | 54.54% | 54.55% | 54.55% | 54.56% | 54.55% | 54.57% | 54.57% | 54.57% | 54.58% | 54.58% | 54.59% | |
Expenses | |||||||||||||
Payroll | $8,570 | $8,570 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | |
Sales and Marketing and Other Expenses | $4,000 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $3,000 | $1,300 | $1,300 | $1,300 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
Insurance | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Rent | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | |
Payroll Taxes | 15% | $1,286 | $1,286 | $1,286 | $1,286 | $1,286 | $1,286 | $1,286 | $1,286 | $1,286 | $1,286 | $1,286 | $1,286 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $22,606 | $19,906 | $19,909 | $19,909 | $19,909 | $19,909 | $19,909 | $19,909 | $21,609 | $19,909 | $19,909 | $19,909 | |
Profit Before Interest and Taxes | $9,749 | $11,497 | $12,555 | $13,627 | $14,710 | $15,791 | $16,910 | $18,030 | $17,460 | $20,305 | $21,463 | $22,636 | |
EBITDA | $9,749 | $11,497 | $12,555 | $13,627 | $14,710 | $15,791 | $16,910 | $18,030 | $17,460 | $20,305 | $21,463 | $22,636 | |
Interest Expense | $1,585 | $1,577 | $1,568 | $1,560 | $1,551 | $1,543 | $1,534 | $1,526 | $1,518 | $1,509 | $1,501 | $1,492 | |
Taxes Incurred | $2,449 | $2,976 | $3,296 | $3,620 | $3,948 | $4,274 | $4,613 | $4,951 | $4,783 | $5,639 | $5,989 | $6,343 | |
Net Profit | $5,714 | $6,944 | $7,691 | $8,447 | $9,211 | $9,974 | $10,763 | $11,553 | $11,160 | $13,157 | $13,974 | $14,801 | |
Net Profit/Sales | 10.27% | 12.06% | 12.92% | 13.74% | 14.52% | 15.24% | 15.95% | 16.62% | 15.59% | 17.86% | 18.44% | 18.99% |
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 | $55,657 | $57,577 | $59,517 | $61,475 | $63,454 | $65,441 | $67,476 | $69,521 | $71,588 | $73,680 | $75,797 | $77,941 | |
Subtotal Cash from Operations | $55,657 | $57,577 | $59,517 | $61,475 | $63,454 | $65,441 | $67,476 | $69,521 | $71,588 | $73,680 | $75,797 | $77,941 | |
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 | $10,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $55,657 | $67,577 | $59,517 | $61,475 | $63,454 | $65,441 | $67,476 | $69,521 | $71,588 | $73,680 | $75,797 | $77,941 | |
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 | $8,570 | $8,570 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | $8,573 | |
Bill Payments | $1,900 | $56,613 | $45,189 | $44,259 | $45,470 | $46,697 | $47,933 | $49,190 | $50,495 | $52,889 | $53,035 | $54,350 | |
Subtotal Spent on Operations | $10,470 | $65,183 | $53,762 | $52,832 | $54,043 | $55,270 | $56,506 | $57,763 | $59,068 | $61,462 | $61,608 | $62,923 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $1,196 | $1,196 | $1,196 | $1,196 | $1,196 | $1,196 | $1,196 | $1,196 | $1,196 | $1,196 | $1,196 | $1,196 | |
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 | $11,666 | $66,379 | $54,958 | $54,028 | $55,239 | $56,466 | $57,702 | $58,959 | $60,264 | $62,658 | $62,804 | $64,118 | |
Net Cash Flow | $43,991 | $1,198 | $4,559 | $7,447 | $8,215 | $8,975 | $9,774 | $10,562 | $11,324 | $11,022 | $12,993 | $13,823 | |
Cash Balance | $83,991 | $85,189 | $89,748 | $97,194 | $105,409 | $114,384 | $124,159 | $134,721 | $146,045 | $157,066 | $170,059 | $183,882 |
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 | $40,000 | $83,991 | $85,189 | $89,748 | $97,194 | $105,409 | $114,384 | $124,159 | $134,721 | $146,045 | $157,066 | $170,059 | $183,882 |
Inventory | $10,000 | $25,633 | $28,793 | $29,758 | $30,733 | $31,719 | $32,715 | $33,723 | $34,740 | $35,771 | $36,813 | $37,868 | $38,936 |
Other Current Assets | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 |
Total Current Assets | $88,000 | $147,624 | $151,981 | $157,506 | $165,927 | $175,128 | $185,099 | $195,881 | $207,461 | $219,816 | $231,879 | $245,927 | $260,817 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Assets | $88,000 | $147,624 | $151,981 | $157,506 | $165,927 | $175,128 | $185,099 | $195,881 | $207,461 | $219,816 | $231,879 | $245,927 | $260,817 |
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 | |||||||||||||
Accounts Payable | $0 | $55,106 | $43,715 | $42,745 | $43,915 | $45,100 | $46,295 | $47,509 | $48,732 | $51,123 | $51,225 | $52,495 | $53,781 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $25,500 | $25,500 | $25,500 | $25,500 | $25,500 | $25,500 | $25,500 | $25,500 | $25,500 | $25,500 | $25,500 | $25,500 | $25,500 |
Subtotal Current Liabilities | $25,500 | $80,606 | $69,215 | $68,245 | $69,415 | $70,600 | $71,795 | $73,009 | $74,232 | $76,623 | $76,725 | $77,995 | $79,281 |
Long-term Liabilities | $225,000 | $223,804 | $222,608 | $221,412 | $220,216 | $219,020 | $217,824 | $216,628 | $215,433 | $214,237 | $213,041 | $211,845 | $210,649 |
Total Liabilities | $250,500 | $304,410 | $291,823 | $289,657 | $289,632 | $289,621 | $289,619 | $289,638 | $289,665 | $290,860 | $289,766 | $289,840 | $289,930 |
Paid-in Capital | $0 | $0 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
Retained Earnings | ($162,500) | ($162,500) | ($162,500) | ($162,500) | ($162,500) | ($162,500) | ($162,500) | ($162,500) | ($162,500) | ($162,500) | ($162,500) | ($162,500) | ($162,500) |
Earnings | $0 | $5,714 | $12,658 | $20,349 | $28,796 | $38,007 | $47,981 | $58,743 | $70,296 | $81,456 | $94,613 | $108,587 | $123,388 |
Total Capital | ($162,500) | ($156,786) | ($139,842) | ($132,151) | ($123,704) | ($114,493) | ($104,519) | ($93,757) | ($82,204) | ($71,044) | ($57,887) | ($43,913) | ($29,112) |
Total Liabilities and Capital | $88,000 | $147,624 | $151,981 | $157,506 | $165,927 | $175,128 | $185,099 | $195,881 | $207,461 | $219,816 | $231,879 | $245,927 | $260,817 |
Net Worth | ($162,500) | ($156,786) | ($139,842) | ($132,151) | ($123,704) | ($114,493) | ($104,519) | ($93,757) | ($82,204) | ($71,044) | ($57,887) | ($43,913) | ($29,112) |