Amerihall
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 | |||||||||||||
Established Realtors | 0% | 200 | 300 | 600 | 800 | 1,050 | 1,500 | 1,800 | 1,900 | 2,150 | 2,350 | 2,550 | 2,800 |
New Realtors | 0% | 50 | 90 | 100 | 100 | 100 | 150 | 200 | 200 | 200 | 200 | 200 | 200 |
Old Timers | 0% | 0 | 0 | 6 | 10 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 |
Total Unit Sales | 250 | 390 | 706 | 910 | 1,170 | 1,670 | 2,020 | 2,120 | 2,370 | 2,570 | 2,770 | 3,020 | |
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 | |
Established Realtors | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | |
New Realtors | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | |
Old Timers | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | |
Sales | |||||||||||||
Established Realtors | $80,000 | $120,000 | $240,000 | $320,000 | $420,000 | $600,000 | $720,000 | $760,000 | $860,000 | $940,000 | $1,020,000 | $1,120,000 | |
New Realtors | $15,000 | $27,000 | $30,000 | $30,000 | $30,000 | $45,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | |
Old Timers | $0 | $0 | $1,500 | $2,500 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Total Sales | $95,000 | $147,000 | $271,500 | $352,500 | $455,000 | $650,000 | $785,000 | $825,000 | $925,000 | $1,005,000 | $1,085,000 | $1,185,000 | |
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 | |
Established Realtors | 0.00% | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 | $65.00 |
New Realtors | 0.00% | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 |
Old Timers | 0.00% | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 |
Direct Cost of Sales | |||||||||||||
Established Realtors | $13,000 | $19,500 | $39,000 | $52,000 | $68,250 | $97,500 | $117,000 | $123,500 | $139,750 | $152,750 | $165,750 | $182,000 | |
New Realtors | $3,000 | $5,400 | $6,000 | $6,000 | $6,000 | $9,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | |
Old Timers | $0 | $0 | $360 | $600 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | |
Subtotal Direct Cost of Sales | $16,000 | $24,900 | $45,360 | $58,600 | $75,450 | $107,700 | $130,200 | $136,700 | $152,950 | $165,950 | $178,950 | $195,200 |
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 | ||
Secretary Corporate | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Director of Conventions/Sales | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $3,750 | $3,750 | $3,750 |
National Convention Staff | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,500 | $5,000 | $5,000 |
Online Help | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Director of Realest® Relations | 0% | $5,409 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 |
Clerical Secretary | 0% | $0 | $0 | $0 | $0 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 |
Managing Director | 0% | $5,833 | $5,833 | $5,833 | $5,833 | $5,833 | $5,833 | $5,833 | $5,833 | $5,833 | $5,833 | $5,833 | $5,833 |
Regional Sales Administrator | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Managing Broker | 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 |
Total People | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 7 | 7 | 7 | |
Total Payroll | $16,242 | $16,250 | $16,250 | $16,250 | $17,917 | $17,917 | $17,917 | $17,917 | $17,917 | $24,167 | $26,667 | $26,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% | 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 | $95,000 | $147,000 | $271,500 | $352,500 | $455,000 | $650,000 | $785,000 | $825,000 | $925,000 | $1,005,000 | $1,085,000 | $1,185,000 | |
Direct Cost of Sales | $16,000 | $24,900 | $45,360 | $58,600 | $75,450 | $107,700 | $130,200 | $136,700 | $152,950 | $165,950 | $178,950 | $195,200 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $16,000 | $24,900 | $45,360 | $58,600 | $75,450 | $107,700 | $130,200 | $136,700 | $152,950 | $165,950 | $178,950 | $195,200 | |
Gross Margin | $79,000 | $122,100 | $226,140 | $293,900 | $379,550 | $542,300 | $654,800 | $688,300 | $772,050 | $839,050 | $906,050 | $989,800 | |
Gross Margin % | 83.16% | 83.06% | 83.29% | 83.38% | 83.42% | 83.43% | 83.41% | 83.43% | 83.46% | 83.49% | 83.51% | 83.53% | |
Expenses | |||||||||||||
Payroll | $16,242 | $16,250 | $16,250 | $16,250 | $17,917 | $17,917 | $17,917 | $17,917 | $17,917 | $24,167 | $26,667 | $26,667 | |
Sales and Marketing and Other Expenses | $3,420 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 | |
Depreciation | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Website | $15,000 | $15,000 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Utilities | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
Insurance | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Rent | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Payroll Taxes | 15% | $2,436 | $2,438 | $2,438 | $2,438 | $2,688 | $2,688 | $2,688 | $2,688 | $2,688 | $3,625 | $4,000 | $4,000 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $41,198 | $44,108 | $31,608 | $31,608 | $33,525 | $33,525 | $33,525 | $33,525 | $33,525 | $40,712 | $43,587 | $43,587 | |
Profit Before Interest and Taxes | $37,802 | $77,993 | $194,533 | $262,293 | $346,025 | $508,775 | $621,275 | $654,775 | $738,525 | $798,338 | $862,463 | $946,213 | |
EBITDA | $38,002 | $78,193 | $194,733 | $262,493 | $346,225 | $508,975 | $621,475 | $654,975 | $738,725 | $798,538 | $862,663 | $946,413 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | $11,341 | $19,498 | $48,633 | $65,573 | $86,506 | $127,194 | $155,319 | $163,694 | $184,631 | $199,584 | $215,616 | $236,553 | |
Net Profit | $26,461 | $58,494 | $145,899 | $196,719 | $259,519 | $381,582 | $465,957 | $491,082 | $553,894 | $598,753 | $646,847 | $709,660 | |
Net Profit/Sales | 27.85% | 39.79% | 53.74% | 55.81% | 57.04% | 58.70% | 59.36% | 59.53% | 59.88% | 59.58% | 59.62% | 59.89% |
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 | $95,000 | $147,000 | $271,500 | $352,500 | $455,000 | $650,000 | $785,000 | $825,000 | $925,000 | $1,005,000 | $1,085,000 | $1,185,000 | |
Subtotal Cash from Operations | $95,000 | $147,000 | $271,500 | $352,500 | $455,000 | $650,000 | $785,000 | $825,000 | $925,000 | $1,005,000 | $1,085,000 | $1,185,000 | |
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 | $95,000 | $147,000 | $271,500 | $352,500 | $455,000 | $650,000 | $785,000 | $825,000 | $925,000 | $1,005,000 | $1,085,000 | $1,185,000 | |
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 | $16,242 | $16,250 | $16,250 | $16,250 | $17,917 | $17,917 | $17,917 | $17,917 | $17,917 | $24,167 | $26,667 | $26,667 | |
Bill Payments | $1,737 | $52,762 | $73,292 | $110,157 | $140,598 | $179,795 | $251,989 | $301,422 | $317,041 | $353,952 | $382,860 | $412,525 | |
Subtotal Spent on Operations | $17,979 | $69,012 | $89,542 | $126,407 | $158,515 | $197,712 | $269,906 | $319,339 | $334,958 | $378,119 | $409,527 | $439,192 | |
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 | $5,000 | $5,000 | $5,000 | $5,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $22,979 | $74,012 | $94,542 | $131,407 | $168,515 | $207,712 | $279,906 | $329,339 | $344,958 | $388,119 | $419,527 | $449,192 | |
Net Cash Flow | $72,021 | $72,988 | $176,958 | $221,093 | $286,485 | $442,288 | $505,094 | $495,661 | $580,042 | $616,881 | $665,473 | $735,808 | |
Cash Balance | $137,021 | $210,009 | $386,967 | $608,061 | $894,545 | $1,336,833 | $1,841,927 | $2,337,588 | $2,917,630 | $3,534,511 | $4,199,984 | $4,935,792 |
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 | $65,000 | $137,021 | $210,009 | $386,967 | $608,061 | $894,545 | $1,336,833 | $1,841,927 | $2,337,588 | $2,917,630 | $3,534,511 | $4,199,984 | $4,935,792 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $65,000 | $137,021 | $210,009 | $386,967 | $608,061 | $894,545 | $1,336,833 | $1,841,927 | $2,337,588 | $2,917,630 | $3,534,511 | $4,199,984 | $4,935,792 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $5,000 | $10,000 | $15,000 | $20,000 | $30,000 | $40,000 | $50,000 | $60,000 | $70,000 | $80,000 | $90,000 | $100,000 |
Accumulated Depreciation | $0 | $200 | $400 | $600 | $800 | $1,000 | $1,200 | $1,400 | $1,600 | $1,800 | $2,000 | $2,200 | $2,400 |
Total Long-term Assets | $0 | $4,800 | $9,600 | $14,400 | $19,200 | $29,000 | $38,800 | $48,600 | $58,400 | $68,200 | $78,000 | $87,800 | $97,600 |
Total Assets | $65,000 | $141,821 | $219,609 | $401,367 | $627,261 | $923,545 | $1,375,633 | $1,890,527 | $2,395,988 | $2,985,830 | $3,612,511 | $4,287,784 | $5,033,392 |
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 | $50,360 | $69,654 | $105,512 | $134,686 | $171,452 | $241,958 | $290,896 | $305,275 | $341,223 | $369,150 | $397,576 | $433,524 |
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 | $50,360 | $69,654 | $105,512 | $134,686 | $171,452 | $241,958 | $290,896 | $305,275 | $341,223 | $369,150 | $397,576 | $433,524 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $50,360 | $69,654 | $105,512 | $134,686 | $171,452 | $241,958 | $290,896 | $305,275 | $341,223 | $369,150 | $397,576 | $433,524 |
Paid-in Capital | $125,050 | $125,050 | $125,050 | $125,050 | $125,050 | $125,050 | $125,050 | $125,050 | $125,050 | $125,050 | $125,050 | $125,050 | $125,050 |
Retained Earnings | ($60,050) | ($60,050) | ($60,050) | ($60,050) | ($60,050) | ($60,050) | ($60,050) | ($60,050) | ($60,050) | ($60,050) | ($60,050) | ($60,050) | ($60,050) |
Earnings | $0 | $26,461 | $84,956 | $230,855 | $427,574 | $687,093 | $1,068,675 | $1,534,632 | $2,025,713 | $2,579,607 | $3,178,361 | $3,825,208 | $4,534,868 |
Total Capital | $65,000 | $91,461 | $149,956 | $295,855 | $492,574 | $752,093 | $1,133,675 | $1,599,632 | $2,090,713 | $2,644,607 | $3,243,361 | $3,890,208 | $4,599,868 |
Total Liabilities and Capital | $65,000 | $141,821 | $219,609 | $401,367 | $627,261 | $923,545 | $1,375,633 | $1,890,527 | $2,395,988 | $2,985,830 | $3,612,511 | $4,287,784 | $5,033,392 |
Net Worth | $65,000 | $91,461 | $149,956 | $295,855 | $492,574 | $752,093 | $1,133,675 | $1,599,632 | $2,090,713 | $2,644,607 | $3,243,361 | $3,890,208 | $4,599,868 |