GFX: Gravestat Farm eXchange
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 | ||
Unit Sales | |||||||||||||
Riding Horses | 0% | 4 | 6 | 12 | 12 | 12 | 12 | 10 | 12 | 8 | 8 | 12 | 16 |
Major Tack & Equipment | 0% | 2 | 6 | 10 | 15 | 20 | 20 | 25 | 35 | 25 | 25 | 35 | 50 |
Minor Tack & Supplies | 0% | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 60 | 75 |
GFX Manufactured Products | 0% | 0 | 2 | 5 | 10 | 15 | 20 | 15 | 20 | 15 | 15 | 20 | 25 |
Total Unit Sales | 11 | 24 | 42 | 57 | 72 | 82 | 85 | 107 | 93 | 98 | 127 | 166 | |
Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Riding Horses | $1,600.00 | $1,600.00 | $1,600.00 | $1,600.00 | $1,600.00 | $1,600.00 | $1,600.00 | $1,600.00 | $1,600.00 | $1,600.00 | $1,600.00 | $1,600.00 | |
Major Tack & Equipment | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | |
Minor Tack & Supplies | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | |
GFX Manufactured Products | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | |
Sales | |||||||||||||
Riding Horses | $6,400 | $9,600 | $19,200 | $19,200 | $19,200 | $19,200 | $16,000 | $19,200 | $12,800 | $12,800 | $19,200 | $25,600 | |
Major Tack & Equipment | $600 | $1,800 | $3,000 | $4,500 | $6,000 | $6,000 | $7,500 | $10,500 | $7,500 | $7,500 | $10,500 | $15,000 | |
Minor Tack & Supplies | $50 | $100 | $150 | $200 | $250 | $300 | $350 | $400 | $450 | $500 | $600 | $750 | |
GFX Manufactured Products | $0 | $200 | $500 | $1,000 | $1,500 | $2,000 | $1,500 | $2,000 | $1,500 | $1,500 | $2,000 | $2,500 | |
Total Sales | $7,050 | $11,700 | $22,850 | $24,900 | $26,950 | $27,500 | $25,350 | $32,100 | $22,250 | $22,300 | $32,300 | $43,850 | |
Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Riding Horses | 0.00% | $1,120.00 | $1,120.00 | $1,120.00 | $1,120.00 | $1,120.00 | $1,120.00 | $1,120.00 | $1,120.00 | $1,120.00 | $1,120.00 | $1,120.00 | $1,120.00 |
Major Tack & Equipment | 0.00% | $210.00 | $210.00 | $210.00 | $210.00 | $210.00 | $210.00 | $210.00 | $210.00 | $210.00 | $210.00 | $210.00 | $210.00 |
Minor Tack & Supplies | 0.00% | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 |
GFX Manufactured Products | 0.00% | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 |
Direct Cost of Sales | |||||||||||||
Riding Horses | $4,480 | $6,720 | $13,440 | $13,440 | $13,440 | $13,440 | $11,200 | $13,440 | $8,960 | $8,960 | $13,440 | $17,920 | |
Major Tack & Equipment | $420 | $1,260 | $2,100 | $3,150 | $4,200 | $4,200 | $5,250 | $7,350 | $5,250 | $5,250 | $7,350 | $10,500 | |
Minor Tack & Supplies | $35 | $70 | $105 | $140 | $175 | $210 | $245 | $280 | $315 | $350 | $420 | $525 | |
GFX Manufactured Products | $0 | $50 | $125 | $250 | $375 | $500 | $375 | $500 | $375 | $375 | $500 | $625 | |
Subtotal Direct Cost of Sales | $4,935 | $8,100 | $15,770 | $16,980 | $18,190 | $18,350 | $17,070 | $21,570 | $14,900 | $14,935 | $21,710 | $29,570 |
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 | $7,050 | $11,700 | $22,850 | $24,900 | $26,950 | $27,500 | $25,350 | $32,100 | $22,250 | $22,300 | $32,300 | $43,850 | |
Direct Cost of Sales | $4,935 | $8,100 | $15,770 | $16,980 | $18,190 | $18,350 | $17,070 | $21,570 | $14,900 | $14,935 | $21,710 | $29,570 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $4,935 | $8,100 | $15,770 | $16,980 | $18,190 | $18,350 | $17,070 | $21,570 | $14,900 | $14,935 | $21,710 | $29,570 | |
Gross Margin | $2,115 | $3,600 | $7,080 | $7,920 | $8,760 | $9,150 | $8,280 | $10,530 | $7,350 | $7,365 | $10,590 | $14,280 | |
Gross Margin % | 30.00% | 30.77% | 30.98% | 31.81% | 32.50% | 33.27% | 32.66% | 32.80% | 33.03% | 33.03% | 32.79% | 32.57% | |
Expenses | |||||||||||||
Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales and Marketing and Other Expenses | $5,868 | $5,868 | $5,868 | $5,868 | $5,868 | $5,868 | $5,868 | $5,868 | $5,868 | $5,868 | $5,868 | $5,868 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Leased Equipment | $85 | $85 | $85 | $85 | $85 | $85 | $85 | $85 | $85 | $85 | $85 | $85 | |
Utilities | $460 | $460 | $460 | $460 | $460 | $460 | $460 | $460 | $460 | $460 | $460 | $460 | |
Insurance | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
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 | $6,913 | $6,913 | $6,913 | $6,913 | $6,913 | $6,913 | $6,913 | $6,913 | $6,913 | $6,913 | $6,913 | $6,913 | |
Profit Before Interest and Taxes | ($4,798) | ($3,313) | $167 | $1,007 | $1,847 | $2,237 | $1,367 | $3,617 | $437 | $452 | $3,677 | $7,367 | |
EBITDA | ($4,798) | ($3,313) | $167 | $1,007 | $1,847 | $2,237 | $1,367 | $3,617 | $437 | $452 | $3,677 | $7,367 | |
Interest Expense | $1,034 | $1,026 | $1,019 | $1,011 | $1,003 | $996 | $988 | $981 | $973 | $965 | $958 | $950 | |
Taxes Incurred | ($1,750) | ($1,085) | ($213) | ($1) | $211 | $310 | $95 | $659 | ($134) | ($128) | $680 | $1,604 | |
Net Profit | ($4,082) | ($3,255) | ($639) | ($3) | $633 | $931 | $284 | $1,977 | ($402) | ($385) | $2,040 | $4,813 | |
Net Profit/Sales | -57.91% | -27.82% | -2.80% | -0.01% | 2.35% | 3.38% | 1.12% | 6.16% | -1.81% | -1.73% | 6.31% | 10.98% |
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 | $7,050 | $11,700 | $22,850 | $24,900 | $26,950 | $27,500 | $25,350 | $32,100 | $22,250 | $22,300 | $32,300 | $43,850 | |
Subtotal Cash from Operations | $7,050 | $11,700 | $22,850 | $24,900 | $26,950 | $27,500 | $25,350 | $32,100 | $22,250 | $22,300 | $32,300 | $43,850 | |
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 | $7,050 | $11,700 | $22,850 | $24,900 | $26,950 | $27,500 | $25,350 | $32,100 | $22,250 | $22,300 | $32,300 | $43,850 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Bill Payments | $207 | $6,467 | $14,887 | $31,736 | $26,281 | $27,618 | $26,642 | $24,038 | $34,414 | $15,562 | $23,223 | $38,045 | |
Subtotal Spent on Operations | $207 | $6,467 | $14,887 | $31,736 | $26,281 | $27,618 | $26,642 | $24,038 | $34,414 | $15,562 | $23,223 | $38,045 | |
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 | $917 | $917 | $917 | $917 | $917 | $917 | $917 | $917 | $917 | $917 | $917 | $917 | |
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 | $1,123 | $7,384 | $15,804 | $32,653 | $27,198 | $28,535 | $27,559 | $24,955 | $35,331 | $16,479 | $24,140 | $38,962 | |
Net Cash Flow | $5,927 | $4,316 | $7,046 | ($7,753) | ($248) | ($1,035) | ($2,209) | $7,145 | ($13,081) | $5,821 | $8,160 | $4,888 | |
Cash Balance | $47,927 | $52,243 | $59,289 | $51,536 | $51,288 | $50,253 | $48,044 | $55,189 | $42,109 | $47,930 | $56,090 | $60,978 |
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 | $42,000 | $47,927 | $52,243 | $59,289 | $51,536 | $51,288 | $50,253 | $48,044 | $55,189 | $42,109 | $47,930 | $56,090 | $60,978 |
Inventory | $14,500 | $9,565 | $8,910 | $17,347 | $18,678 | $20,009 | $20,185 | $18,777 | $23,727 | $16,390 | $16,429 | $23,881 | $32,527 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $56,500 | $57,492 | $61,153 | $76,636 | $70,214 | $71,297 | $70,438 | $66,821 | $78,916 | $58,499 | $64,359 | $79,971 | $93,505 |
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 | $56,500 | $57,492 | $61,153 | $76,636 | $70,214 | $71,297 | $70,438 | $66,821 | $78,916 | $58,499 | $64,359 | $79,971 | $93,505 |
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 | $5,991 | $13,823 | $30,862 | $25,360 | $26,727 | $25,854 | $22,869 | $33,904 | $14,804 | $21,966 | $36,456 | $46,094 |
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 | $5,991 | $13,823 | $30,862 | $25,360 | $26,727 | $25,854 | $22,869 | $33,904 | $14,804 | $21,966 | $36,456 | $46,094 |
Long-term Liabilities | $125,000 | $124,083 | $123,167 | $122,250 | $121,333 | $120,417 | $119,500 | $118,583 | $117,667 | $116,750 | $115,833 | $114,917 | $114,000 |
Total Liabilities | $125,000 | $130,074 | $136,990 | $153,112 | $146,693 | $147,143 | $145,354 | $141,453 | $151,570 | $131,554 | $137,799 | $151,373 | $160,094 |
Paid-in Capital | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Retained Earnings | ($68,500) | ($68,500) | ($68,500) | ($68,500) | ($68,500) | ($68,500) | ($68,500) | ($68,500) | ($68,500) | ($68,500) | ($68,500) | ($68,500) | ($68,500) |
Earnings | $0 | ($4,082) | ($7,337) | ($7,976) | ($7,979) | ($7,346) | ($6,415) | ($6,131) | ($4,154) | ($4,556) | ($4,941) | ($2,901) | $1,911 |
Total Capital | ($68,500) | ($72,582) | ($75,837) | ($76,476) | ($76,479) | ($75,846) | ($74,915) | ($74,631) | ($72,654) | ($73,056) | ($73,441) | ($71,401) | ($66,589) |
Total Liabilities and Capital | $56,500 | $57,492 | $61,153 | $76,636 | $70,214 | $71,297 | $70,438 | $66,821 | $78,916 | $58,499 | $64,359 | $79,971 | $93,505 |
Net Worth | ($68,500) | ($72,582) | ($75,837) | ($76,476) | ($76,479) | ($75,846) | ($74,915) | ($74,631) | ($72,654) | ($73,056) | ($73,441) | ($71,401) | ($66,589) |