R and R Printing
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 | |||||||||||||
Rob Scott’s Sales | 0% | $30,000 | $40,000 | $50,000 | $55,000 | $60,000 | $65,000 | $70,000 | $72,000 | $75,000 | $75,000 | $78,000 | $80,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $30,000 | $40,000 | $50,000 | $55,000 | $60,000 | $65,000 | $70,000 | $72,000 | $75,000 | $75,000 | $78,000 | $80,000 | |
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 | |
Rob Scott’s Sales | $24,000 | $32,000 | $40,000 | $44,000 | $45,000 | $48,750 | $52,500 | $54,000 | $56,250 | $52,500 | $54,600 | $56,000 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $24,000 | $32,000 | $40,000 | $44,000 | $45,000 | $48,750 | $52,500 | $54,000 | $56,250 | $52,500 | $54,600 | $56,000 |
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 | ||
Rob Scott | 0% | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 |
Other | 0% | $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 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 |
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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
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 | $30,000 | $40,000 | $50,000 | $55,000 | $60,000 | $65,000 | $70,000 | $72,000 | $75,000 | $75,000 | $78,000 | $80,000 | |
Direct Cost of Sales | $24,000 | $32,000 | $40,000 | $44,000 | $45,000 | $48,750 | $52,500 | $54,000 | $56,250 | $52,500 | $54,600 | $56,000 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $24,000 | $32,000 | $40,000 | $44,000 | $45,000 | $48,750 | $52,500 | $54,000 | $56,250 | $52,500 | $54,600 | $56,000 | |
Gross Margin | $6,000 | $8,000 | $10,000 | $11,000 | $15,000 | $16,250 | $17,500 | $18,000 | $18,750 | $22,500 | $23,400 | $24,000 | |
Gross Margin % | 20.00% | 20.00% | 20.00% | 20.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 30.00% | 30.00% | 30.00% | |
Expenses | |||||||||||||
Payroll | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | |
Marketing/Promotion | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
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 | |
Insurance | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $2,567 | $2,567 | $2,567 | $2,567 | $2,567 | $2,567 | $2,567 | $2,567 | $2,567 | $2,567 | $2,567 | $2,567 | |
Profit Before Interest and Taxes | $3,433 | $5,433 | $7,433 | $8,433 | $12,433 | $13,683 | $14,933 | $15,433 | $16,183 | $19,933 | $20,833 | $21,433 | |
EBITDA | $3,433 | $5,433 | $7,433 | $8,433 | $12,433 | $13,683 | $14,933 | $15,433 | $16,183 | $19,933 | $20,833 | $21,433 | |
Interest Expense | $417 | $417 | $408 | $400 | $391 | $383 | $374 | $366 | $357 | $349 | $340 | $332 | |
Taxes Incurred | $905 | $1,505 | $2,107 | $2,410 | $3,613 | $3,990 | $4,368 | $4,520 | $4,748 | $5,875 | $6,148 | $6,330 | |
Net Profit | $2,111 | $3,511 | $4,917 | $5,623 | $8,429 | $9,310 | $10,191 | $10,547 | $11,078 | $13,709 | $14,345 | $14,771 | |
Net Profit/Sales | 7.04% | 8.78% | 9.83% | 10.22% | 14.05% | 14.32% | 14.56% | 14.65% | 14.77% | 18.28% | 18.39% | 18.46% |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Cash from Receivables | $0 | $1,000 | $30,333 | $40,333 | $50,167 | $55,167 | $60,167 | $65,167 | $70,067 | $72,100 | $75,000 | $75,100 | |
Subtotal Cash from Operations | $0 | $1,000 | $30,333 | $40,333 | $50,167 | $55,167 | $60,167 | $65,167 | $70,067 | $72,100 | $75,000 | $75,100 | |
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 | $37,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $0 | $38,000 | $30,333 | $40,333 | $50,167 | $55,167 | $60,167 | $65,167 | $70,067 | $72,100 | $75,000 | $75,100 | |
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 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | |
Bill Payments | $874 | $26,508 | $35,108 | $43,559 | $47,783 | $50,041 | $54,160 | $58,197 | $59,868 | $62,167 | $59,703 | $62,040 | |
Subtotal Spent on Operations | $2,541 | $28,175 | $36,775 | $45,226 | $49,450 | $51,708 | $55,827 | $59,864 | $61,535 | $63,834 | $61,370 | $63,707 | |
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 | $0 | $0 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | |
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 | $2,541 | $28,175 | $37,795 | $46,246 | $50,470 | $52,728 | $56,847 | $60,884 | $62,555 | $64,854 | $62,390 | $64,727 | |
Net Cash Flow | ($2,541) | $9,825 | ($7,462) | ($5,912) | ($303) | $2,439 | $3,320 | $4,283 | $7,511 | $7,246 | $12,610 | $10,373 | |
Cash Balance | $47,459 | $57,284 | $49,822 | $43,910 | $43,606 | $46,045 | $49,365 | $53,648 | $61,159 | $68,405 | $81,015 | $91,388 |
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 | $50,000 | $47,459 | $57,284 | $49,822 | $43,910 | $43,606 | $46,045 | $49,365 | $53,648 | $61,159 | $68,405 | $81,015 | $91,388 |
Accounts Receivable | $0 | $30,000 | $69,000 | $88,667 | $103,333 | $113,167 | $123,000 | $132,833 | $139,667 | $144,600 | $147,500 | $150,500 | $155,400 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $50,000 | $77,459 | $126,284 | $138,489 | $147,243 | $156,773 | $169,045 | $182,198 | $193,314 | $205,759 | $215,905 | $231,515 | $246,788 |
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 | $50,000 | $77,459 | $126,284 | $138,489 | $147,243 | $156,773 | $169,045 | $182,198 | $193,314 | $205,759 | $215,905 | $231,515 | $246,788 |
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 | $25,348 | $33,661 | $41,968 | $46,119 | $48,240 | $52,222 | $56,204 | $57,793 | $60,180 | $57,637 | $59,922 | $61,443 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $0 | $25,348 | $33,661 | $41,968 | $46,119 | $48,240 | $52,222 | $56,204 | $57,793 | $60,180 | $57,637 | $59,922 | $61,443 |
Long-term Liabilities | $50,000 | $50,000 | $50,000 | $48,980 | $47,960 | $46,940 | $45,920 | $44,900 | $43,880 | $42,860 | $41,840 | $40,820 | $39,800 |
Total Liabilities | $50,000 | $75,348 | $83,661 | $90,948 | $94,079 | $95,180 | $98,142 | $101,104 | $101,673 | $103,040 | $99,477 | $100,742 | $101,243 |
Paid-in Capital | $15,000 | $15,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 |
Retained Earnings | ($15,000) | ($15,000) | ($15,000) | ($15,000) | ($15,000) | ($15,000) | ($15,000) | ($15,000) | ($15,000) | ($15,000) | ($15,000) | ($15,000) | ($15,000) |
Earnings | $0 | $2,111 | $5,623 | $10,540 | $16,164 | $24,593 | $33,903 | $44,094 | $54,641 | $65,720 | $79,429 | $93,774 | $108,544 |
Total Capital | $0 | $2,111 | $42,623 | $47,540 | $53,164 | $61,593 | $70,903 | $81,094 | $91,641 | $102,720 | $116,429 | $130,774 | $145,544 |
Total Liabilities and Capital | $50,000 | $77,459 | $126,284 | $138,489 | $147,243 | $156,773 | $169,045 | $182,198 | $193,314 | $205,759 | $215,905 | $231,515 | $246,788 |
Net Worth | $0 | $2,111 | $42,623 | $47,540 | $53,164 | $61,593 | $70,903 | $81,094 | $91,641 | $102,720 | $116,429 | $130,774 | $145,544 |