Flash Commercial Photography
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 | |||||||||||||
Photo Shoots | $15,383 | $15,691 | $16,005 | $16,325 | $16,652 | $16,985 | $17,325 | $17,672 | $18,025 | $18,386 | $18,754 | $19,129 | |
Photo Editing | $3,683 | $3,831 | $3,984 | $4,143 | $4,309 | $4,481 | $4,661 | $4,847 | $5,041 | $5,243 | $5,452 | $5,670 | |
Printing and Framing | $1,739 | $1,774 | $1,809 | $1,845 | $1,882 | $1,920 | $1,958 | $1,997 | $2,037 | $2,078 | $2,120 | $2,162 | |
Studio Rental | $1,023 | $5,027 | $6,163 | $6,651 | $7,075 | $7,162 | $7,436 | $7,494 | $7,162 | $6,344 | $5,705 | $4,396 | |
Total Sales | $21,828 | $26,323 | $27,961 | $28,964 | $29,918 | $30,548 | $31,380 | $32,010 | $32,265 | $32,051 | $32,031 | $31,357 | |
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 | |
Printing and Framing Cost | $1,304 | $1,331 | $1,357 | $1,384 | $1,412 | $1,440 | $1,469 | $1,498 | $1,528 | $1,559 | $1,590 | $1,622 | |
Other Cost of Sales | $3,274 | $3,948 | $4,194 | $4,345 | $4,488 | $4,582 | $4,707 | $4,802 | $4,840 | $4,808 | $4,805 | $4,704 | |
Subtotal Direct Cost of Sales | $4,578 | $5,279 | $5,551 | $5,728 | $5,899 | $6,022 | $6,176 | $6,299 | $6,368 | $6,366 | $6,395 | $6,325 |
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 | ||
CEO | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Assistant Photographer | $2,000 | $2,120 | $2,247 | $2,382 | $2,525 | $2,676 | $2,837 | $3,007 | $3,187 | $3,378 | $3,581 | $3,796 | |
Administrative Assistant | $1,500 | $1,515 | $1,530 | $1,545 | $1,560 | $1,576 | $1,592 | $1,608 | $1,624 | $1,640 | $1,656 | $1,673 | |
Assistant Photographer 2 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Assistant Photographer 3 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Assistant Photographer 4 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total People | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
Total Payroll | $8,500 | $8,635 | $8,777 | $8,927 | $9,085 | $9,252 | $9,429 | $9,615 | $9,811 | $10,018 | $10,237 | $10,469 |
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 | $21,828 | $26,323 | $27,961 | $28,964 | $29,918 | $30,548 | $31,380 | $32,010 | $32,265 | $32,051 | $32,031 | $31,357 | |
Direct Cost of Sales | $4,578 | $5,279 | $5,551 | $5,728 | $5,899 | $6,022 | $6,176 | $6,299 | $6,368 | $6,366 | $6,395 | $6,325 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $4,578 | $5,279 | $5,551 | $5,728 | $5,899 | $6,022 | $6,176 | $6,299 | $6,368 | $6,366 | $6,395 | $6,325 | |
Gross Margin | $17,250 | $21,044 | $22,410 | $23,236 | $24,019 | $24,526 | $25,205 | $25,711 | $25,898 | $25,685 | $25,636 | $25,032 | |
Gross Margin % | 79.02% | 79.95% | 80.15% | 80.22% | 80.28% | 80.29% | 80.32% | 80.32% | 80.26% | 80.14% | 80.04% | 79.83% | |
Expenses | |||||||||||||
Payroll | $8,500 | $8,635 | $8,777 | $8,927 | $9,085 | $9,252 | $9,429 | $9,615 | $9,811 | $10,018 | $10,237 | $10,469 | |
Marketing/Promotion | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Depreciation | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Rent | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Utilities | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Insurance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Payroll Taxes | 15% | $1,275 | $1,313 | $1,352 | $1,393 | $1,435 | $1,478 | $1,522 | $1,568 | $1,615 | $1,663 | $1,713 | $1,764 |
Other | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Total Operating Expenses | $16,675 | $16,848 | $17,029 | $17,220 | $17,420 | $17,630 | $17,851 | $18,083 | $18,326 | $18,581 | $18,850 | $19,133 | |
Profit Before Interest and Taxes | $575 | $4,196 | $5,381 | $6,016 | $6,599 | $6,896 | $7,354 | $7,628 | $7,572 | $7,104 | $6,786 | $5,899 | |
EBITDA | $1,075 | $4,696 | $5,881 | $6,516 | $7,099 | $7,396 | $7,854 | $8,128 | $8,072 | $7,604 | $7,286 | $6,399 | |
Interest Expense | $76 | $69 | $63 | $56 | $49 | $42 | $35 | $28 | $21 | $14 | $7 | $0 | |
Taxes Incurred | $149 | $1,238 | $1,596 | $1,788 | $1,965 | $2,056 | $2,196 | $2,280 | $2,265 | $2,127 | $2,034 | $1,770 | |
Net Profit | $349 | $2,889 | $3,723 | $4,172 | $4,585 | $4,798 | $5,123 | $5,320 | $5,285 | $4,963 | $4,746 | $4,129 | |
Net Profit/Sales | 1.60% | 10.97% | 13.32% | 14.40% | 15.33% | 15.71% | 16.33% | 16.62% | 16.38% | 15.48% | 14.82% | 13.17% |
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 | $4,366 | $5,265 | $5,592 | $5,793 | $5,984 | $6,110 | $6,276 | $6,402 | $6,453 | $6,410 | $6,406 | $6,271 | |
Cash from Receivables | $582 | $17,582 | $21,102 | $22,396 | $23,197 | $23,951 | $24,461 | $25,121 | $25,615 | $25,806 | $25,640 | $25,607 | |
Subtotal Cash from Operations | $4,948 | $22,847 | $26,694 | $28,188 | $29,180 | $30,061 | $30,737 | $31,523 | $32,068 | $32,216 | $32,046 | $31,878 | |
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 | $4,948 | $22,847 | $26,694 | $28,188 | $29,180 | $30,061 | $30,737 | $31,523 | $32,068 | $32,216 | $32,046 | $31,878 | |
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,500 | $8,635 | $8,777 | $8,927 | $9,085 | $9,252 | $9,429 | $9,615 | $9,811 | $10,018 | $10,237 | $10,469 | |
Bill Payments | $2,916 | $12,540 | $14,321 | $14,974 | $15,378 | $15,756 | $16,009 | $16,336 | $16,578 | $16,665 | $16,569 | $16,539 | |
Subtotal Spent on Operations | $11,416 | $21,175 | $23,098 | $23,901 | $24,463 | $25,008 | $25,438 | $25,951 | $26,389 | $26,683 | $26,806 | $27,008 | |
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 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | |
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 | $12,249 | $22,008 | $23,932 | $24,735 | $25,296 | $25,842 | $26,271 | $26,784 | $27,222 | $27,517 | $27,640 | $27,841 | |
Net Cash Flow | ($7,302) | $839 | $2,763 | $3,454 | $3,884 | $4,219 | $4,465 | $4,738 | $4,845 | $4,700 | $4,407 | $4,037 | |
Cash Balance | $7,698 | $8,537 | $11,299 | $14,753 | $18,637 | $22,856 | $27,322 | $32,060 | $36,905 | $41,605 | $46,012 | $50,049 |
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 | $15,000 | $7,698 | $8,537 | $11,299 | $14,753 | $18,637 | $22,856 | $27,322 | $32,060 | $36,905 | $41,605 | $46,012 | $50,049 |
Accounts Receivable | $0 | $16,880 | $20,356 | $21,623 | $22,399 | $23,137 | $23,624 | $24,267 | $24,754 | $24,952 | $24,786 | $24,771 | $24,249 |
Other Current Assets | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Total Current Assets | $16,000 | $25,579 | $29,893 | $33,923 | $38,152 | $42,774 | $47,480 | $52,589 | $57,814 | $62,857 | $67,391 | $71,783 | $75,299 |
Long-term Assets | |||||||||||||
Long-term Assets | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 |
Accumulated Depreciation | $0 | $500 | $1,000 | $1,500 | $2,000 | $2,500 | $3,000 | $3,500 | $4,000 | $4,500 | $5,000 | $5,500 | $6,000 |
Total Long-term Assets | $30,000 | $29,500 | $29,000 | $28,500 | $28,000 | $27,500 | $27,000 | $26,500 | $26,000 | $25,500 | $25,000 | $24,500 | $24,000 |
Total Assets | $46,000 | $55,079 | $58,893 | $62,423 | $66,152 | $70,274 | $74,480 | $79,089 | $83,814 | $88,357 | $92,391 | $96,283 | $99,299 |
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 | $2,500 | $12,063 | $13,823 | $14,462 | $14,853 | $15,223 | $15,465 | $15,784 | $16,023 | $16,113 | $16,018 | $15,997 | $15,717 |
Current Borrowing | $5,000 | $4,583 | $4,167 | $3,750 | $3,333 | $2,917 | $2,500 | $2,083 | $1,667 | $1,250 | $833 | $417 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $7,500 | $16,647 | $17,989 | $18,212 | $18,186 | $18,140 | $17,965 | $17,867 | $17,689 | $17,363 | $16,851 | $16,413 | $15,717 |
Long-term Liabilities | $5,000 | $4,583 | $4,167 | $3,750 | $3,333 | $2,917 | $2,500 | $2,083 | $1,667 | $1,250 | $833 | $417 | $0 |
Total Liabilities | $12,500 | $21,230 | $22,156 | $21,962 | $21,519 | $21,056 | $20,465 | $19,950 | $19,356 | $18,613 | $17,684 | $16,830 | $15,717 |
Paid-in Capital | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 |
Retained Earnings | ($24,500) | ($24,500) | ($24,500) | ($24,500) | ($24,500) | ($24,500) | ($24,500) | ($24,500) | ($24,500) | ($24,500) | ($24,500) | ($24,500) | ($24,500) |
Earnings | $0 | $349 | $3,237 | $6,960 | $11,132 | $15,718 | $20,515 | $25,639 | $30,959 | $36,244 | $41,207 | $45,953 | $50,082 |
Total Capital | $33,500 | $33,849 | $36,737 | $40,460 | $44,632 | $49,218 | $54,015 | $59,139 | $64,459 | $69,744 | $74,707 | $79,453 | $83,582 |
Total Liabilities and Capital | $46,000 | $55,079 | $58,893 | $62,423 | $66,152 | $70,274 | $74,480 | $79,089 | $83,814 | $88,357 | $92,391 | $96,283 | $99,299 |
Net Worth | $33,500 | $33,849 | $36,737 | $40,460 | $44,632 | $49,218 | $54,015 | $59,139 | $64,459 | $69,744 | $74,707 | $79,453 | $83,582 |