RA Concepts
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 | |||||||||||||
D Putter | 0% | $0 | $9,552 | $10,507 | $8,358 | $9,154 | $10,029 | $11,064 | $12,178 | $7,960 | $8,756 | $9,631 | $10,586 |
V Putter | 0% | $0 | $0 | $0 | $3,980 | $4,378 | $4,776 | $5,174 | $5,572 | $3,980 | $4,378 | $5,174 | $5,572 |
W Putter | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $3,980 | $4,378 | $4,776 | $5,174 |
Scorpion | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $3,980 | $4,378 |
Total Sales | $0 | $9,552 | $10,507 | $12,338 | $13,532 | $14,805 | $16,238 | $17,750 | $15,920 | $17,512 | $23,561 | $25,710 | |
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 | |
Putter Cost | $0 | $2,712 | $2,983 | $3,503 | $3,842 | $4,204 | $4,610 | $5,039 | $4,520 | $4,972 | $6,576 | $7,073 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $2,712 | $2,983 | $3,503 | $3,842 | $4,204 | $4,610 | $5,039 | $4,520 | $4,972 | $6,576 | $7,073 |
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 | ||
Randy Comstock | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Alan Comstock | 0% | $500 | $500 | $500 | $747 | $771 | $796 | $825 | $855 | $818 | $850 | $971 | $1,014 |
Van Russell | 0% | $900 | $1,378 | $1,425 | $1,517 | $1,577 | $1,640 | $1,712 | $1,788 | $1,696 | $1,776 | $2,078 | $2,186 |
Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
Total Payroll | $3,900 | $4,378 | $4,425 | $4,764 | $4,847 | $4,936 | $5,037 | $5,143 | $5,014 | $5,126 | $5,549 | $5,700 |
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 | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | $0 | $9,552 | $10,507 | $12,338 | $13,532 | $14,805 | $16,238 | $17,750 | $15,920 | $17,512 | $23,561 | $25,710 | |
Direct Cost of Sales | $0 | $2,712 | $2,983 | $3,503 | $3,842 | $4,204 | $4,610 | $5,039 | $4,520 | $4,972 | $6,576 | $7,073 | |
Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $2,712 | $2,983 | $3,503 | $3,842 | $4,204 | $4,610 | $5,039 | $4,520 | $4,972 | $6,576 | $7,073 | |
Gross Margin | $0 | $6,840 | $7,524 | $8,835 | $9,690 | $10,601 | $11,628 | $12,711 | $11,400 | $12,540 | $16,985 | $18,637 | |
Gross Margin % | 0.00% | 71.61% | 71.61% | 71.61% | 71.61% | 71.60% | 71.61% | 71.61% | 71.61% | 71.61% | 72.09% | 72.49% | |
Expenses | |||||||||||||
Payroll | $3,900 | $4,378 | $4,425 | $4,764 | $4,847 | $4,936 | $5,037 | $5,143 | $5,014 | $5,126 | $5,549 | $5,700 | |
Sales and Marketing and Other Expenses | $900 | $900 | $900 | $1,300 | $1,200 | $1,200 | $1,200 | $1,200 | $2,600 | $2,100 | $2,200 | $2,200 | |
Depreciation | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Rent | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | |
Research and Development | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $0 | $0 | $0 | $0 | |
Equipment Maintenance and Repair | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $365 | $365 | $365 | $365 | $365 | $365 | $365 | $365 | $365 | $365 | $365 | $365 | |
Insurance | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | |
Total Operating Expenses | $7,090 | $7,568 | $7,615 | $8,354 | $8,337 | $8,426 | $8,527 | $8,633 | $9,404 | $9,016 | $9,539 | $9,690 | |
Profit Before Interest and Taxes | ($7,090) | ($728) | ($91) | $481 | $1,353 | $2,175 | $3,101 | $4,079 | $1,996 | $3,524 | $7,446 | $8,947 | |
EBITDA | ($6,990) | ($628) | $9 | $581 | $1,453 | $2,275 | $3,201 | $4,179 | $2,096 | $3,624 | $7,546 | $9,047 | |
Interest Expense | $574 | $568 | $562 | $556 | $550 | $544 | $538 | $532 | $526 | $520 | $514 | $508 | |
Taxes Incurred | ($2,299) | ($389) | ($196) | ($22) | $241 | $489 | $769 | $1,064 | $441 | $901 | $2,080 | $2,532 | |
Net Profit | ($5,365) | ($907) | ($457) | ($52) | $562 | $1,142 | $1,795 | $2,483 | $1,029 | $2,103 | $4,853 | $5,908 | |
Net Profit/Sales | 0.00% | -9.49% | -4.35% | -0.42% | 4.15% | 7.71% | 11.05% | 13.99% | 6.46% | 12.01% | 20.60% | 22.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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Cash from Receivables | $0 | $0 | $318 | $9,584 | $10,568 | $12,378 | $13,574 | $14,853 | $16,288 | $17,689 | $15,973 | $17,714 | |
Subtotal Cash from Operations | $0 | $0 | $318 | $9,584 | $10,568 | $12,378 | $13,574 | $14,853 | $16,288 | $17,689 | $15,973 | $17,714 | |
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 | $0 | $0 | $318 | $9,584 | $10,568 | $12,378 | $13,574 | $14,853 | $16,288 | $17,689 | $15,973 | $17,714 | |
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,900 | $4,378 | $4,425 | $4,764 | $4,847 | $4,936 | $5,037 | $5,143 | $5,014 | $5,126 | $5,549 | $5,700 | |
Bill Payments | $45 | $1,428 | $3,275 | $3,475 | $4,029 | $4,189 | $4,490 | $6,558 | $10,454 | $9,255 | $10,818 | $14,814 | |
Subtotal Spent on Operations | $3,945 | $5,806 | $7,701 | $8,238 | $8,876 | $9,125 | $9,526 | $11,700 | $15,468 | $14,381 | $16,368 | $20,514 | |
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 | $1,208 | $1,208 | $1,208 | $1,208 | $1,208 | $1,208 | $1,208 | $1,208 | $1,208 | $1,208 | $1,208 | $1,208 | |
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 | $5,154 | $7,014 | $8,909 | $9,447 | $10,084 | $10,333 | $10,735 | $12,908 | $16,676 | $15,589 | $17,576 | $21,722 | |
Net Cash Flow | ($5,154) | ($7,014) | ($8,591) | $137 | $484 | $2,044 | $2,840 | $1,944 | ($388) | $2,100 | ($1,603) | ($4,009) | |
Cash Balance | $18,336 | $11,322 | $2,731 | $2,868 | $3,352 | $5,396 | $8,236 | $10,180 | $9,793 | $11,893 | $10,290 | $6,281 |
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 | $23,490 | $18,336 | $11,322 | $2,731 | $2,868 | $3,352 | $5,396 | $8,236 | $10,180 | $9,793 | $11,893 | $10,290 | $6,281 |
Accounts Receivable | $0 | $0 | $9,552 | $19,741 | $22,495 | $25,459 | $27,886 | $30,549 | $33,447 | $33,078 | $32,901 | $40,489 | $48,486 |
Inventory | $25,200 | $25,200 | $22,488 | $19,505 | $16,002 | $12,160 | $7,956 | $5,071 | $5,543 | $4,972 | $5,469 | $7,234 | $7,780 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $48,690 | $43,536 | $43,362 | $41,977 | $41,365 | $40,971 | $41,238 | $43,857 | $49,170 | $47,843 | $50,263 | $58,013 | $62,547 |
Long-term Assets | |||||||||||||
Long-term Assets | $62,160 | $62,160 | $62,160 | $62,160 | $62,160 | $62,160 | $62,160 | $62,160 | $62,160 | $62,160 | $62,160 | $62,160 | $62,160 |
Accumulated Depreciation | $0 | $100 | $200 | $300 | $400 | $500 | $600 | $700 | $800 | $900 | $1,000 | $1,100 | $1,200 |
Total Long-term Assets | $62,160 | $62,060 | $61,960 | $61,860 | $61,760 | $61,660 | $61,560 | $61,460 | $61,360 | $61,260 | $61,160 | $61,060 | $60,960 |
Total Assets | $110,850 | $105,596 | $105,322 | $103,837 | $103,125 | $102,631 | $102,798 | $105,317 | $110,530 | $109,103 | $111,423 | $119,073 | $123,507 |
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 | $1,319 | $3,160 | $3,341 | $3,889 | $4,041 | $4,276 | $6,208 | $10,147 | $8,899 | $10,324 | $14,329 | $14,064 |
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 | $1,319 | $3,160 | $3,341 | $3,889 | $4,041 | $4,276 | $6,208 | $10,147 | $8,899 | $10,324 | $14,329 | $14,064 |
Long-term Liabilities | $116,000 | $114,792 | $113,583 | $112,375 | $111,167 | $109,958 | $108,750 | $107,542 | $106,333 | $105,125 | $103,917 | $102,708 | $101,500 |
Total Liabilities | $116,000 | $116,111 | $116,744 | $115,716 | $115,056 | $114,000 | $113,026 | $113,749 | $116,480 | $114,024 | $114,241 | $117,038 | $115,564 |
Paid-in Capital | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
Retained Earnings | ($15,150) | ($15,150) | ($15,150) | ($15,150) | ($15,150) | ($15,150) | ($15,150) | ($15,150) | ($15,150) | ($15,150) | ($15,150) | ($15,150) | ($15,150) |
Earnings | $0 | ($5,365) | ($6,272) | ($6,729) | ($6,781) | ($6,219) | ($5,077) | ($3,283) | ($800) | $229 | $2,332 | $7,185 | $13,093 |
Total Capital | ($5,150) | ($10,515) | ($11,422) | ($11,879) | ($11,931) | ($11,369) | ($10,227) | ($8,433) | ($5,950) | ($4,921) | ($2,818) | $2,035 | $7,943 |
Total Liabilities and Capital | $110,850 | $105,596 | $105,322 | $103,837 | $103,125 | $102,631 | $102,798 | $105,317 | $110,530 | $109,103 | $111,423 | $119,073 | $123,507 |
Net Worth | ($5,150) | ($10,515) | ($11,422) | ($11,879) | ($11,931) | ($11,369) | ($10,227) | ($8,433) | ($5,950) | ($4,921) | ($2,818) | $2,035 | $7,943 |