Aztec Food Imports
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 | |||||||||||||
Supermarkets | 0% | $14,000 | $14,000 | $14,000 | $16,000 | $16,000 | $17,500 | $18,000 | $18,000 | $20,000 | $20,000 | $20,000 | $22,000 |
Neighborhood Markets | 0% | $5,000 | $5,000 | $6,000 | $6,000 | $8,000 | $10,000 | $12,000 | $12,000 | $13,000 | $14,000 | $16,000 | $17,000 |
Total Sales | $19,000 | $19,000 | $20,000 | $22,000 | $24,000 | $27,500 | $30,000 | $30,000 | $33,000 | $34,000 | $36,000 | $39,000 | |
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 | |
Supermarkets | $4,000 | $4,000 | $4,000 | $4,400 | $6,000 | $6,300 | $8,000 | $8,200 | $9,000 | $10,000 | $10,000 | $12,000 | |
Neighborhood Markets | $1,000 | $1,000 | $1,000 | $1,080 | $1,200 | $1,280 | $1,700 | $1,740 | $1,800 | $2,000 | $2,000 | $2,500 | |
Subtotal Direct Cost of Sales | $5,000 | $5,000 | $5,000 | $5,480 | $7,200 | $7,580 | $9,700 | $9,940 | $10,800 | $12,000 | $12,000 | $14,500 |
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 | ||
Raymond Garcia | 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 |
Jose Arroyo | 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 |
Delivery Persons | 0% | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Office Manager | 0% | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
Total Payroll | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 |
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% | 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 | $19,000 | $19,000 | $20,000 | $22,000 | $24,000 | $27,500 | $30,000 | $30,000 | $33,000 | $34,000 | $36,000 | $39,000 | |
Direct Cost of Sales | $5,000 | $5,000 | $5,000 | $5,480 | $7,200 | $7,580 | $9,700 | $9,940 | $10,800 | $12,000 | $12,000 | $14,500 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $5,000 | $5,000 | $5,000 | $5,480 | $7,200 | $7,580 | $9,700 | $9,940 | $10,800 | $12,000 | $12,000 | $14,500 | |
Gross Margin | $14,000 | $14,000 | $15,000 | $16,520 | $16,800 | $19,920 | $20,300 | $20,060 | $22,200 | $22,000 | $24,000 | $24,500 | |
Gross Margin % | 73.68% | 73.68% | 75.00% | 75.09% | 70.00% | 72.44% | 67.67% | 66.87% | 67.27% | 64.71% | 66.67% | 62.82% | |
Expenses | |||||||||||||
Payroll | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | |
Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $240 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
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% | $1,890 | $1,890 | $1,890 | $1,890 | $1,890 | $1,890 | $1,890 | $1,890 | $1,890 | $1,890 | $1,890 | $1,890 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $18,230 | $18,230 | $18,230 | $18,230 | $18,230 | $18,230 | $18,230 | $18,230 | $18,230 | $18,230 | $18,230 | $18,230 | |
Profit Before Interest and Taxes | ($4,230) | ($4,230) | ($3,230) | ($1,710) | ($1,430) | $1,690 | $2,070 | $1,830 | $3,970 | $3,770 | $5,770 | $6,270 | |
EBITDA | ($3,990) | ($3,990) | ($2,990) | ($1,470) | ($1,190) | $1,930 | $2,310 | $2,070 | $4,210 | $4,010 | $6,010 | $6,510 | |
Interest Expense | $824 | $814 | $804 | $794 | $784 | $774 | $765 | $755 | $745 | $735 | $725 | $715 | |
Taxes Incurred | ($1,516) | ($1,513) | ($1,210) | ($751) | ($664) | $275 | $392 | $323 | $968 | $911 | $1,513 | $1,666 | |
Net Profit | ($3,537) | ($3,531) | ($2,824) | ($1,753) | ($1,550) | $641 | $914 | $753 | $2,258 | $2,125 | $3,531 | $3,888 | |
Net Profit/Sales | -18.62% | -18.58% | -14.12% | -7.97% | -6.46% | 2.33% | 3.05% | 2.51% | 6.84% | 6.25% | 9.81% | 9.97% |
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,750 | $4,750 | $5,000 | $5,500 | $6,000 | $6,875 | $7,500 | $7,500 | $8,250 | $8,500 | $9,000 | $9,750 | |
Cash from Receivables | $0 | $475 | $14,250 | $14,275 | $15,050 | $16,550 | $18,088 | $20,688 | $22,500 | $22,575 | $24,775 | $25,550 | |
Subtotal Cash from Operations | $4,750 | $5,225 | $19,250 | $19,775 | $21,050 | $23,425 | $25,588 | $28,188 | $30,750 | $31,075 | $33,775 | $35,300 | |
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,750 | $5,225 | $19,250 | $19,775 | $21,050 | $23,425 | $25,588 | $28,188 | $30,750 | $31,075 | $33,775 | $35,300 | |
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 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | |
Bill Payments | $157 | $4,697 | $4,700 | $4,999 | $5,435 | $5,541 | $6,443 | $6,738 | $12,520 | $18,899 | $20,331 | $19,808 | |
Subtotal Spent on Operations | $12,757 | $17,297 | $17,300 | $17,599 | $18,035 | $18,141 | $19,043 | $19,338 | $25,120 | $31,499 | $32,931 | $32,408 | |
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,180 | $1,180 | $1,180 | $1,180 | $1,180 | $1,180 | $1,180 | $1,180 | $1,180 | $1,180 | $1,180 | $1,180 | |
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 | $13,937 | $18,477 | $18,480 | $18,779 | $19,215 | $19,321 | $20,223 | $20,518 | $26,300 | $32,679 | $34,111 | $33,588 | |
Net Cash Flow | ($9,187) | ($13,252) | $770 | $996 | $1,835 | $4,104 | $5,365 | $7,670 | $4,450 | ($1,604) | ($336) | $1,712 | |
Cash Balance | $95,513 | $82,261 | $83,031 | $84,027 | $85,862 | $89,966 | $95,331 | $103,000 | $107,451 | $105,847 | $105,511 | $107,223 |
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 | $104,700 | $95,513 | $82,261 | $83,031 | $84,027 | $85,862 | $89,966 | $95,331 | $103,000 | $107,451 | $105,847 | $105,511 | $107,223 |
Accounts Receivable | $0 | $14,250 | $28,025 | $28,775 | $31,000 | $33,950 | $38,025 | $42,438 | $44,250 | $46,500 | $49,425 | $51,650 | $55,350 |
Inventory | $60,000 | $55,000 | $50,000 | $45,000 | $39,520 | $32,320 | $24,740 | $15,040 | $10,934 | $11,880 | $13,200 | $13,200 | $15,950 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $164,700 | $164,763 | $160,286 | $156,806 | $154,547 | $152,132 | $152,731 | $152,808 | $158,184 | $165,831 | $168,472 | $170,361 | $178,523 |
Long-term Assets | |||||||||||||
Long-term Assets | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
Accumulated Depreciation | $0 | $240 | $480 | $720 | $960 | $1,200 | $1,440 | $1,680 | $1,920 | $2,160 | $2,400 | $2,640 | $2,880 |
Total Long-term Assets | $20,000 | $19,760 | $19,520 | $19,280 | $19,040 | $18,800 | $18,560 | $18,320 | $18,080 | $17,840 | $17,600 | $17,360 | $17,120 |
Total Assets | $184,700 | $184,523 | $179,806 | $176,086 | $173,587 | $170,932 | $171,291 | $171,128 | $176,264 | $183,671 | $186,072 | $187,721 | $195,643 |
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 | $4,541 | $4,534 | $4,818 | $5,252 | $5,326 | $6,224 | $6,328 | $11,891 | $18,220 | $19,677 | $18,974 | $24,188 |
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 | $4,541 | $4,534 | $4,818 | $5,252 | $5,326 | $6,224 | $6,328 | $11,891 | $18,220 | $19,677 | $18,974 | $24,188 |
Long-term Liabilities | $100,000 | $98,820 | $97,640 | $96,460 | $95,280 | $94,100 | $92,920 | $91,740 | $90,560 | $89,380 | $88,200 | $87,020 | $85,840 |
Total Liabilities | $100,000 | $103,361 | $102,174 | $101,278 | $100,532 | $99,426 | $99,144 | $98,068 | $102,451 | $107,600 | $107,877 | $105,994 | $110,028 |
Paid-in Capital | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 |
Retained Earnings | ($15,300) | ($15,300) | ($15,300) | ($15,300) | ($15,300) | ($15,300) | ($15,300) | ($15,300) | ($15,300) | ($15,300) | ($15,300) | ($15,300) | ($15,300) |
Earnings | $0 | ($3,537) | ($7,068) | ($9,892) | ($11,645) | ($13,194) | ($12,553) | ($11,640) | ($10,887) | ($8,629) | ($6,505) | ($2,973) | $915 |
Total Capital | $84,700 | $81,163 | $77,632 | $74,808 | $73,056 | $71,506 | $72,147 | $73,060 | $73,813 | $76,071 | $78,195 | $81,727 | $85,615 |
Total Liabilities and Capital | $184,700 | $184,523 | $179,806 | $176,086 | $173,587 | $170,932 | $171,291 | $171,128 | $176,264 | $183,671 | $186,072 | $187,721 | $195,643 |
Net Worth | $84,700 | $81,163 | $77,632 | $74,808 | $73,056 | $71,506 | $72,147 | $73,060 | $73,813 | $76,071 | $78,195 | $81,727 | $85,615 |