Valley Airporter
Appendix
Sales Forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | |||||||||||||
Shuttle Tickets | 0% | $40,000 | $40,000 | $45,000 | $45,000 | $50,000 | $50,000 | $50,000 | $40,000 | $50,000 | $40,000 | $50,000 | $50,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $40,000 | $40,000 | $45,000 | $45,000 | $50,000 | $50,000 | $50,000 | $40,000 | $50,000 | $40,000 | $50,000 | $50,000 | |
Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Shuttle Tickets | $0 | $5,000 | $6,000 | $6,000 | $7,000 | $7,000 | $7,000 | $6,000 | $6,000 | $5,000 | $6,000 | $6,000 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $5,000 | $6,000 | $6,000 | $7,000 | $7,000 | $7,000 | $6,000 | $6,000 | $5,000 | $6,000 | $6,000 |
Personnel Plan | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Bob Wilson | 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 |
Mary Wilson | 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 |
Drivers | 0% | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 |
Office Staff/Sales | 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 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
Total Payroll | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 |
General Assumptions | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
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 | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | $40,000 | $40,000 | $45,000 | $45,000 | $50,000 | $50,000 | $50,000 | $40,000 | $50,000 | $40,000 | $50,000 | $50,000 | |
Direct Cost of Sales | $0 | $5,000 | $6,000 | $6,000 | $7,000 | $7,000 | $7,000 | $6,000 | $6,000 | $5,000 | $6,000 | $6,000 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $5,000 | $6,000 | $6,000 | $7,000 | $7,000 | $7,000 | $6,000 | $6,000 | $5,000 | $6,000 | $6,000 | |
Gross Margin | $40,000 | $35,000 | $39,000 | $39,000 | $43,000 | $43,000 | $43,000 | $34,000 | $44,000 | $35,000 | $44,000 | $44,000 | |
Gross Margin % | 100.00% | 87.50% | 86.67% | 86.67% | 86.00% | 86.00% | 86.00% | 85.00% | 88.00% | 87.50% | 88.00% | 88.00% | |
Expenses | |||||||||||||
Payroll | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | |
Sales and Marketing and Other Expenses | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Depreciation | $1,547 | $1,547 | $1,547 | $1,547 | $1,547 | $1,547 | $1,547 | $1,547 | $1,547 | $1,547 | $1,547 | $1,547 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Insurance | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Rent | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Payroll Taxes | 15% | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $36,147 | $36,147 | $36,147 | $36,147 | $36,147 | $36,147 | $36,147 | $36,147 | $36,147 | $36,147 | $36,147 | $36,147 | |
Profit Before Interest and Taxes | $3,853 | ($1,147) | $2,853 | $2,853 | $6,853 | $6,853 | $6,853 | ($2,147) | $7,853 | ($1,147) | $7,853 | $7,853 | |
EBITDA | $5,400 | $400 | $4,400 | $4,400 | $8,400 | $8,400 | $8,400 | ($600) | $9,400 | $400 | $9,400 | $9,400 | |
Interest Expense | $655 | $643 | $632 | $620 | $608 | $597 | $585 | $573 | $562 | $550 | $538 | $527 | |
Taxes Incurred | $959 | ($537) | $666 | $670 | $1,873 | $1,877 | $1,880 | ($816) | $2,187 | ($509) | $2,194 | $2,198 | |
Net Profit | $2,239 | ($1,253) | $1,555 | $1,563 | $4,371 | $4,379 | $4,388 | ($1,904) | $5,104 | ($1,188) | $5,120 | $5,128 | |
Net Profit/Sales | 5.60% | -3.13% | 3.46% | 3.47% | 8.74% | 8.76% | 8.78% | -4.76% | 10.21% | -2.97% | 10.24% | 10.26% |
Pro Forma Cash Flow | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $40,000 | $40,000 | $45,000 | $45,000 | $50,000 | $50,000 | $50,000 | $40,000 | $50,000 | $40,000 | $50,000 | $50,000 | |
Subtotal Cash from Operations | $40,000 | $40,000 | $45,000 | $45,000 | $50,000 | $50,000 | $50,000 | $40,000 | $50,000 | $40,000 | $50,000 | $50,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) | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
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 | $42,000 | $42,000 | $47,000 | $47,000 | $52,000 | $52,000 | $52,000 | $42,000 | $52,000 | $42,000 | $52,000 | $52,000 | |
Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Expenditures from Operations | |||||||||||||
Cash Spending | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | $24,000 | |
Bill Payments | $16,407 | $12,331 | $15,779 | $17,898 | $17,963 | $20,081 | $20,073 | $19,942 | $16,457 | $19,225 | $15,764 | $19,332 | |
Subtotal Spent on Operations | $40,407 | $36,331 | $39,779 | $41,898 | $41,963 | $44,081 | $44,073 | $43,942 | $40,457 | $43,225 | $39,764 | $43,332 | |
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,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | |
Purchase Other Current Assets | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Purchase Long-term Assets | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $45,807 | $41,731 | $45,179 | $47,298 | $47,363 | $49,481 | $49,473 | $49,342 | $45,857 | $48,625 | $45,164 | $48,732 | |
Net Cash Flow | ($3,807) | $269 | $1,821 | ($298) | $4,637 | $2,519 | $2,527 | ($7,342) | $6,143 | ($6,625) | $6,836 | $3,268 | |
Cash Balance | $46,193 | $46,462 | $48,283 | $47,985 | $52,622 | $55,141 | $57,667 | $50,325 | $56,468 | $49,843 | $56,679 | $59,947 |
Pro Forma Balance Sheet | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $50,000 | $46,193 | $46,462 | $48,283 | $47,985 | $52,622 | $55,141 | $57,667 | $50,325 | $56,468 | $49,843 | $56,679 | $59,947 |
Other Current Assets | $0 | $2,000 | $4,000 | $6,000 | $8,000 | $10,000 | $12,000 | $14,000 | $16,000 | $18,000 | $20,000 | $22,000 | $24,000 |
Total Current Assets | $50,000 | $48,193 | $50,462 | $54,283 | $55,985 | $62,622 | $67,141 | $71,667 | $66,325 | $74,468 | $69,843 | $78,679 | $83,947 |
Long-term Assets | |||||||||||||
Long-term Assets | $130,000 | $132,000 | $134,000 | $136,000 | $138,000 | $140,000 | $142,000 | $144,000 | $146,000 | $148,000 | $150,000 | $152,000 | $154,000 |
Accumulated Depreciation | $24,000 | $25,547 | $27,094 | $28,641 | $30,188 | $31,735 | $33,282 | $34,829 | $36,376 | $37,923 | $39,470 | $41,017 | $42,564 |
Total Long-term Assets | $106,000 | $106,453 | $106,906 | $107,359 | $107,812 | $108,265 | $108,718 | $109,171 | $109,624 | $110,077 | $110,530 | $110,983 | $111,436 |
Total Assets | $156,000 | $154,646 | $157,368 | $161,642 | $163,797 | $170,887 | $175,859 | $180,838 | $175,949 | $184,545 | $180,373 | $189,662 | $195,383 |
Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Current Liabilities | |||||||||||||
Accounts Payable | $16,000 | $11,807 | $15,183 | $17,301 | $17,294 | $19,412 | $19,404 | $19,397 | $15,812 | $18,704 | $15,120 | $18,688 | $18,680 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $2,000 | $4,000 | $6,000 | $8,000 | $10,000 | $12,000 | $14,000 | $16,000 | $18,000 | $20,000 | $22,000 | $24,000 |
Subtotal Current Liabilities | $16,000 | $13,807 | $19,183 | $23,301 | $25,294 | $29,412 | $31,404 | $33,397 | $31,812 | $36,704 | $35,120 | $40,688 | $42,680 |
Long-term Liabilities | $80,000 | $78,600 | $77,200 | $75,800 | $74,400 | $73,000 | $71,600 | $70,200 | $68,800 | $67,400 | $66,000 | $64,600 | $63,200 |
Total Liabilities | $96,000 | $92,407 | $96,383 | $99,101 | $99,694 | $102,412 | $103,004 | $103,597 | $100,612 | $104,104 | $101,120 | $105,288 | $105,880 |
Paid-in Capital | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Retained Earnings | $45,500 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 |
Earnings | $14,500 | $2,239 | $985 | $2,540 | $4,103 | $8,475 | $12,854 | $17,242 | $15,337 | $20,441 | $19,253 | $24,374 | $29,502 |
Total Capital | $60,000 | $62,239 | $60,985 | $62,540 | $64,103 | $68,475 | $72,854 | $77,242 | $75,337 | $80,441 | $79,254 | $84,374 | $89,502 |
Total Liabilities and Capital | $156,000 | $154,646 | $157,368 | $161,642 | $163,797 | $170,887 | $175,859 | $180,838 | $175,949 | $184,545 | $180,373 | $189,662 | $195,383 |
Net Worth | $60,000 | $62,239 | $60,985 | $62,540 | $64,103 | $68,475 | $72,854 | $77,242 | $75,337 | $80,441 | $79,254 | $84,374 | $89,502 |