RJ Wagner and Assoc. Realty
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 | |||||||||||||
Agent Sales – 25% To Company | 0% | $0 | $2,375 | $8,125 | $11,250 | $4,500 | $4,500 | $4,500 | $3,375 | $3,375 | $12,375 | $14,625 | $14,625 |
Broker Sales – 100% To Company | 0% | $3,389 | $3,731 | $6,750 | $0 | $3,375 | $3,375 | $3,375 | $0 | $0 | $4,500 | $7,875 | $7,875 |
Photo Service – 100% To Company | 0% | $0 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 |
Referrals – 25% Agent/25% Company | 0% | $187 | $187 | $187 | $187 | $187 | $187 | $187 | $187 | $187 | $187 | $187 | $187 |
Total Sales | $3,576 | $6,773 | $15,542 | $11,917 | $8,542 | $8,542 | $8,542 | $4,042 | $4,042 | $17,542 | $23,167 | $23,167 | |
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 | |
Agent Sales – 25% To Company | $0 | $238 | $813 | $1,125 | $450 | $450 | $450 | $338 | $338 | $1,238 | $1,463 | $1,463 | |
Broker Sales – 100% To Company | $339 | $373 | $675 | $1,350 | $675 | $1,350 | $675 | $1,350 | $1,350 | $1,350 | $675 | $675 | |
Photo Service – 100% To Company | $0 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | |
Referrals – 25% Agent/25% Company | $0 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | |
Subtotal Direct Cost of Sales | $339 | $681 | $1,558 | $2,545 | $1,195 | $1,870 | $1,195 | $1,758 | $1,758 | $2,658 | $2,208 | $2,208 |
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 | ||
Wagner | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | $3,576 | $6,773 | $15,542 | $11,917 | $8,542 | $8,542 | $8,542 | $4,042 | $4,042 | $17,542 | $23,167 | $23,167 | |
Direct Cost of Sales | $339 | $681 | $1,558 | $2,545 | $1,195 | $1,870 | $1,195 | $1,758 | $1,758 | $2,658 | $2,208 | $2,208 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $339 | $681 | $1,558 | $2,545 | $1,195 | $1,870 | $1,195 | $1,758 | $1,758 | $2,658 | $2,208 | $2,208 | |
Gross Margin | $3,237 | $6,093 | $13,985 | $9,372 | $7,347 | $6,672 | $7,347 | $2,285 | $2,285 | $14,885 | $20,960 | $20,960 | |
Gross Margin % | 90.52% | 89.95% | 89.98% | 78.64% | 86.01% | 78.11% | 86.01% | 56.52% | 56.52% | 84.85% | 90.47% | 90.47% | |
Expenses | |||||||||||||
Payroll | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Marketing/Promotion | $200 | $200 | $600 | $700 | $1,000 | $700 | $700 | $900 | $700 | $700 | $1,000 | $700 | |
Depreciation | $150 | $150 | $150 | $150 | $125 | $90 | $75 | $75 | $75 | $75 | $75 | $80 | |
Utilities | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Rent | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | |
Insurance | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Office Supplies | $100 | $100 | $200 | $200 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Business Software | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,000 | |
Leased Equipment | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
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 | $5,300 | $5,300 | $5,800 | $5,900 | $6,275 | $5,940 | $5,925 | $6,125 | $5,925 | $5,925 | $6,225 | $6,930 | |
Profit Before Interest and Taxes | ($2,063) | $793 | $8,185 | $3,472 | $1,072 | $732 | $1,422 | ($3,841) | ($3,641) | $8,960 | $14,735 | $14,030 | |
EBITDA | ($1,913) | $943 | $8,335 | $3,622 | $1,197 | $822 | $1,497 | ($3,766) | ($3,566) | $9,035 | $14,810 | $14,110 | |
Interest Expense | $4 | $8 | $13 | $17 | $21 | $25 | $29 | $33 | $38 | $42 | $46 | $50 | |
Taxes Incurred | ($620) | $196 | $2,043 | $864 | $263 | $177 | $348 | ($968) | ($920) | $2,229 | $3,672 | $3,495 | |
Net Profit | ($1,447) | $588 | $6,129 | $2,592 | $788 | $530 | $1,045 | ($2,905) | ($2,759) | $6,688 | $11,017 | $10,485 | |
Net Profit/Sales | -40.46% | 8.68% | 39.44% | 21.75% | 9.23% | 6.21% | 12.23% | -71.88% | -68.25% | 38.13% | 47.55% | 45.26% |
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 | $3,218 | $6,096 | $13,988 | $10,725 | $7,688 | $7,688 | $7,688 | $3,638 | $3,638 | $15,788 | $20,850 | $20,850 | |
Cash from Receivables | $0 | $12 | $368 | $707 | $1,542 | $1,180 | $854 | $854 | $839 | $404 | $449 | $1,773 | |
Subtotal Cash from Operations | $3,218 | $6,108 | $14,356 | $11,432 | $9,230 | $8,868 | $8,542 | $4,492 | $4,477 | $16,192 | $21,300 | $22,623 | |
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 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
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 | $3,718 | $6,608 | $14,856 | $11,932 | $9,730 | $9,368 | $9,042 | $4,992 | $4,977 | $16,692 | $21,800 | $23,123 | |
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 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Bill Payments | $10,062 | $1,912 | $3,142 | $6,260 | $6,124 | $4,638 | $4,905 | $4,404 | $3,867 | $3,861 | $7,822 | $9,093 | |
Subtotal Spent on Operations | $13,062 | $4,912 | $6,142 | $9,260 | $9,124 | $7,638 | $7,905 | $7,404 | $6,867 | $6,861 | $10,822 | $12,093 | |
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 | $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 | $13,062 | $4,912 | $6,142 | $9,260 | $9,124 | $7,638 | $7,905 | $7,404 | $6,867 | $6,861 | $10,822 | $12,093 | |
Net Cash Flow | ($9,344) | $1,696 | $8,714 | $2,672 | $606 | $1,730 | $1,137 | ($2,412) | ($1,890) | $9,831 | $10,978 | $11,030 | |
Cash Balance | $412 | $2,108 | $10,821 | $13,493 | $14,099 | $15,829 | $16,966 | $14,554 | $12,663 | $22,495 | $33,472 | $44,503 |
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 | $9,756 | $412 | $2,108 | $10,821 | $13,493 | $14,099 | $15,829 | $16,966 | $14,554 | $12,663 | $22,495 | $33,472 | $44,503 |
Accounts Receivable | $0 | $358 | $1,023 | $2,209 | $2,694 | $2,006 | $1,680 | $1,680 | $1,230 | $795 | $2,145 | $4,012 | $4,556 |
Other Current Assets | $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 |
Total Current Assets | $29,756 | $20,770 | $23,131 | $33,030 | $36,187 | $36,105 | $37,509 | $38,646 | $35,784 | $33,458 | $44,640 | $57,485 | $69,059 |
Long-term Assets | |||||||||||||
Long-term Assets | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 |
Accumulated Depreciation | $0 | $150 | $300 | $450 | $600 | $725 | $815 | $890 | $965 | $1,040 | $1,115 | $1,190 | $1,270 |
Total Long-term Assets | $7,000 | $6,850 | $6,700 | $6,550 | $6,400 | $6,275 | $6,185 | $6,110 | $6,035 | $5,960 | $5,885 | $5,810 | $5,730 |
Total Assets | $36,756 | $27,620 | $29,831 | $39,580 | $42,587 | $42,380 | $43,694 | $44,756 | $41,819 | $39,418 | $50,525 | $63,295 | $74,789 |
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 | $10,000 | $1,811 | $2,934 | $6,054 | $5,970 | $4,474 | $4,758 | $4,275 | $3,743 | $3,601 | $7,519 | $8,773 | $9,282 |
Current Borrowing | $0 | $500 | $1,000 | $1,500 | $2,000 | $2,500 | $3,000 | $3,500 | $4,000 | $4,500 | $5,000 | $5,500 | $6,000 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $10,000 | $2,311 | $3,934 | $7,554 | $7,970 | $6,974 | $7,758 | $7,775 | $7,743 | $8,101 | $12,519 | $14,273 | $15,282 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $10,000 | $2,311 | $3,934 | $7,554 | $7,970 | $6,974 | $7,758 | $7,775 | $7,743 | $8,101 | $12,519 | $14,273 | $15,282 |
Paid-in Capital | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 |
Retained Earnings | ($23,244) | ($23,244) | ($23,244) | ($23,244) | ($23,244) | ($23,244) | ($23,244) | ($23,244) | ($23,244) | ($23,244) | ($23,244) | ($23,244) | ($23,244) |
Earnings | $0 | ($1,447) | ($859) | $5,270 | $7,862 | $8,650 | $9,180 | $10,225 | $7,319 | $4,561 | $11,249 | $22,266 | $32,750 |
Total Capital | $26,756 | $25,309 | $25,897 | $32,026 | $34,618 | $35,406 | $35,936 | $36,981 | $34,075 | $31,317 | $38,005 | $49,022 | $59,506 |
Total Liabilities and Capital | $36,756 | $27,620 | $29,831 | $39,580 | $42,587 | $42,380 | $43,694 | $44,756 | $41,819 | $39,418 | $50,525 | $63,295 | $74,789 |
Net Worth | $26,756 | $25,309 | $25,897 | $32,026 | $34,618 | $35,406 | $35,936 | $36,981 | $34,075 | $31,317 | $38,005 | $49,022 | $59,506 |