Ereidi Farm

Start your own business plan »

Horse Training Business Plan

Appendix

Sales Forecast
May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
Sales
Training 0% $0 $0 $0 $0 $7,200 $12,000 $18,000 $24,000 $24,000 $24,000 $24,000 $24,000
Broodmare w/foal 0% $0 $660 $660 $1,320 $2,880 $5,760 $7,200 $8,640 $8,640 $8,640 $8,640 $8,640
Boarding other 0% $1,070 $650 $1,050 $1,050 $1,050 $1,050 $1,050 $600 $1,800 $6,000 $6,000 $6,000
Home-grown sales 0% $2,000 $0 $0 $0 $6,000 $0 $0 $10,000 $0 $0 $0 $0
Total Sales $3,070 $1,310 $1,710 $2,370 $17,130 $18,810 $26,250 $43,240 $34,440 $38,640 $38,640 $38,640
Direct Cost of Sales May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
Training $0 $0 $0 $0 $600 $1,000 $1,500 $2,000 $2,000 $2,000 $2,000 $2,000
Broodmare w/foal $0 $100 $100 $100 $400 $800 $1,000 $1,200 $1,200 $1,200 $1,200 $1,200
Boarding other $300 $200 $300 $300 $300 $300 $300 $100 $300 $1,000 $1,000 $1,000
Home-grown sales $0 $8,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $300 $8,300 $400 $400 $1,300 $2,100 $2,800 $3,300 $3,500 $4,200 $4,200 $4,200
Personnel Plan
May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
Owner 0% $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Head Trainer 0% $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Groom 1 0% $0 $0 $0 $0 $0 $0 $1,203 $1,203 $1,203 $1,203 $1,203 $1,203
Groom 2 0% $0 $0 $0 $0 $0 $0 $0 $0 $1,203 $1,203 $1,203 $1,203
Total People 0 0 0 0 0 2 3 3 4 4 4 4
Total Payroll $0 $0 $0 $0 $0 $4,000 $5,203 $5,203 $6,406 $6,406 $6,406 $6,406
General Assumptions
May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 5.50% 5.50% 5.50% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Long-term Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Tax Rate 30.00% 23.00% 23.00% 23.00% 23.00% 23.00% 23.00% 23.00% 23.00% 23.00% 23.00% 23.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
Sales $3,070 $1,310 $1,710 $2,370 $17,130 $18,810 $26,250 $43,240 $34,440 $38,640 $38,640 $38,640
Direct Cost of Sales $300 $8,300 $400 $400 $1,300 $2,100 $2,800 $3,300 $3,500 $4,200 $4,200 $4,200
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $300 $8,300 $400 $400 $1,300 $2,100 $2,800 $3,300 $3,500 $4,200 $4,200 $4,200
Gross Margin $2,770 ($6,990) $1,310 $1,970 $15,830 $16,710 $23,450 $39,940 $30,940 $34,440 $34,440 $34,440
Gross Margin % 90.23% -533.59% 76.61% 83.12% 92.41% 88.84% 89.33% 92.37% 89.84% 89.13% 89.13% 89.13%
Expenses
Payroll $0 $0 $0 $0 $0 $4,000 $5,203 $5,203 $6,406 $6,406 $6,406 $6,406
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Rent $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 15% $0 $0 $0 $0 $0 $600 $780 $780 $961 $961 $961 $961
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $200 $200 $200 $200 $200 $4,800 $6,183 $6,183 $7,567 $7,567 $7,567 $7,567
Profit Before Interest and Taxes $2,570 ($7,190) $1,110 $1,770 $15,630 $11,910 $17,267 $33,757 $23,373 $26,873 $26,873 $26,873
EBITDA $2,770 ($6,990) $1,310 $1,970 $15,830 $12,110 $17,467 $33,957 $23,573 $27,073 $27,073 $27,073
Interest Expense $1,185 $1,185 $1,185 $1,191 $1,191 $1,191 $1,191 $1,191 $1,191 $1,191 $1,191 $1,191
Taxes Incurred $415 ($1,926) ($17) $133 $3,321 $2,465 $3,697 $7,490 $5,102 $5,907 $5,907 $5,907
Net Profit $969 ($6,449) ($58) $446 $11,118 $8,254 $12,378 $25,076 $17,080 $19,775 $19,775 $19,775
Net Profit/Sales 31.57% -492.30% -3.40% 18.82% 64.90% 43.88% 47.16% 57.99% 49.59% 51.18% 51.18% 51.18%
Pro Forma Cash Flow
May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
Cash Received
Cash from Operations
Cash Sales $2,610 $1,114 $1,454 $2,015 $14,561 $15,989 $22,313 $36,754 $29,274 $32,844 $32,844 $32,844
Cash from Receivables $6,469 $6,484 $452 $199 $260 $429 $2,578 $2,859 $4,022 $6,442 $5,187 $5,796
Subtotal Cash from Operations $9,078 $7,597 $1,905 $2,213 $14,820 $16,418 $24,890 $39,613 $33,296 $39,286 $38,031 $38,640
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 $9,078 $7,597 $1,905 $2,213 $14,820 $16,418 $24,890 $39,613 $33,296 $39,286 $38,031 $38,640
Expenditures May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
Expenditures from Operations
Cash Spending $0 $0 $0 $0 $0 $4,000 $5,203 $5,203 $6,406 $6,406 $6,406 $6,406
Bill Payments $63 $2,089 $7,359 $1,573 $1,860 $5,830 $6,427 $8,612 $12,694 $10,804 $12,259 $12,259
Subtotal Spent on Operations $63 $2,089 $7,359 $1,573 $1,860 $9,830 $11,630 $13,815 $19,100 $17,210 $18,665 $18,665
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 $63 $2,089 $7,359 $1,573 $1,860 $9,830 $11,630 $13,815 $19,100 $17,210 $18,665 $18,665
Net Cash Flow $9,015 $5,508 ($5,454) $640 $12,960 $6,588 $13,261 $25,798 $14,196 $22,076 $19,366 $19,975
Cash Balance $12,297 $17,805 $12,350 $12,990 $25,950 $32,538 $45,799 $71,597 $85,793 $107,869 $127,235 $147,210
Pro Forma Balance Sheet
May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
Assets Starting Balances
Current Assets
Cash $3,282 $12,297 $17,805 $12,350 $12,990 $25,950 $32,538 $45,799 $71,597 $85,793 $107,869 $127,235 $147,210
Accounts Receivable $12,937 $6,929 $642 $446 $603 $2,913 $5,305 $6,665 $10,292 $11,436 $10,790 $11,399 $11,399
Other Current Assets $87,684 $87,684 $87,684 $87,684 $87,684 $87,684 $87,684 $87,684 $87,684 $87,684 $87,684 $87,684 $87,684
Total Current Assets $103,903 $106,910 $106,130 $100,481 $101,278 $116,547 $125,527 $140,148 $169,573 $184,912 $206,343 $226,318 $246,293
Long-term Assets
Long-term Assets $490,000 $490,000 $490,000 $490,000 $490,000 $490,000 $490,000 $490,000 $490,000 $490,000 $490,000 $490,000 $490,000
Accumulated Depreciation $2,800 $3,000 $3,200 $3,400 $3,600 $3,800 $4,000 $4,200 $4,400 $4,600 $4,800 $5,000 $5,200
Total Long-term Assets $487,200 $487,000 $486,800 $486,600 $486,400 $486,200 $486,000 $485,800 $485,600 $485,400 $485,200 $485,000 $484,800
Total Assets $591,103 $593,910 $592,930 $587,081 $587,678 $602,747 $611,527 $625,948 $655,173 $670,312 $691,543 $711,318 $731,093
Liabilities and Capital May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
Current Liabilities
Accounts Payable $0 $1,837 $7,307 $1,516 $1,667 $5,618 $6,144 $8,186 $12,336 $10,395 $11,850 $11,850 $11,850
Current Borrowing $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $13,000 $14,837 $20,307 $14,516 $14,667 $18,618 $19,144 $21,186 $25,336 $23,395 $24,850 $24,850 $24,850
Long-term Liabilities $193,000 $193,000 $193,000 $193,000 $193,000 $193,000 $193,000 $193,000 $193,000 $193,000 $193,000 $193,000 $193,000
Total Liabilities $206,000 $207,837 $213,307 $207,516 $207,667 $211,618 $212,144 $214,186 $218,336 $216,395 $217,850 $217,850 $217,850
Paid-in Capital $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retained Earnings $385,103 $385,103 $385,103 $385,103 $385,103 $385,103 $385,103 $385,103 $385,103 $385,103 $385,103 $385,103 $385,103
Earnings $0 $969 ($5,480) ($5,538) ($5,092) $6,026 $14,280 $26,658 $51,734 $68,814 $88,590 $108,365 $128,140
Total Capital $385,103 $386,072 $379,623 $379,565 $380,011 $391,129 $399,383 $411,761 $436,837 $453,917 $473,693 $493,468 $513,243
Total Liabilities and Capital $591,103 $593,910 $592,930 $587,081 $587,678 $602,747 $611,527 $625,948 $655,173 $670,312 $691,543 $711,318 $731,093
Net Worth $385,103 $386,072 $379,623 $379,565 $380,011 $391,129 $399,383 $411,761 $436,837 $453,917 $473,693 $493,468 $513,243