San Francisco Limo
Appendix
Sales Forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | |||||||||||||
CATA | 0% | $5,475 | $3,016 | $2,434 | $3,080 | $3,080 | $3,080 | $3,080 | $3,080 | $3,080 | $3,080 | $3,080 | $3,080 |
Corporate Clients | 0% | $899 | $1,351 | $947 | $1,000 | $1,000 | $1,000 | $1,000 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 |
Transfers (Credit Cards) | 0% | $1,900 | $2,400 | $3,344 | $3,807 | $4,230 | $5,076 | $5,076 | $5,499 | $5,922 | $5,922 | $6,345 | $6,345 |
Hourly Hire | 0% | $0 | $0 | $1,617 | $0 | $1,080 | $1,440 | $1,800 | $2,160 | $2,880 | $3,240 | $3,600 | $2,880 |
Total Sales | $8,274 | $6,767 | $8,342 | $7,887 | $9,390 | $10,596 | $10,956 | $11,939 | $13,082 | $13,442 | $14,225 | $13,505 | |
Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
CATA | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Corporate Clients | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Transfers (Credit Cards) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Hourly Hire | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Personnel Plan | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Tim Politano | 0% | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $2,000 |
Peter Battinelli | 0% | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $2,000 |
Brian | 0% | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $1,440 | $1,440 | $1,440 | $1,440 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
Total Payroll | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,840 | $3,840 | $3,840 | $5,440 |
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 | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | |
Tax Rate | 30.00% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | |
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 | $8,274 | $6,767 | $8,342 | $7,887 | $9,390 | $10,596 | $10,956 | $11,939 | $13,082 | $13,442 | $14,225 | $13,505 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Gross Margin | $8,274 | $6,767 | $8,342 | $7,887 | $9,390 | $10,596 | $10,956 | $11,939 | $13,082 | $13,442 | $14,225 | $13,505 | |
Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
Expenses | |||||||||||||
Payroll | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,840 | $3,840 | $3,840 | $5,440 | |
Sales and Marketing and Other Expenses | $4,036 | $3,966 | $4,057 | $4,662 | $11,610 | $3,397 | $3,038 | $3,480 | $3,169 | $3,188 | $3,618 | $2,533 | |
Depreciation | $23 | $24 | $23 | $23 | $1,324 | $1,324 | $1,324 | $1,324 | $1,324 | $1,324 | $1,324 | $1,324 | |
Depreciation | $55 | $55 | $55 | $55 | $55 | $55 | $55 | $55 | $55 | $55 | $55 | $55 | |
Utilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Insurance | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Garage Rental | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Accounting | $170 | $170 | $170 | $170 | $170 | $170 | $170 | $170 | $170 | $170 | $170 | $170 | |
Payroll Taxes | 13% | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $486 | $486 | $486 | $688 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $8,701 | $8,632 | $8,722 | $9,327 | $17,576 | $9,363 | $9,004 | $9,446 | $9,744 | $9,763 | $10,193 | $10,910 | |
Profit Before Interest and Taxes | ($427) | ($1,865) | ($380) | ($1,440) | ($8,186) | $1,233 | $1,952 | $2,493 | $3,338 | $3,679 | $4,032 | $2,595 | |
EBITDA | ($404) | ($1,841) | ($357) | ($1,417) | ($6,862) | $2,557 | $3,276 | $3,817 | $4,662 | $5,003 | $5,356 | $3,919 | |
Interest Expense | $120 | $120 | $120 | $53 | $261 | $260 | $259 | $258 | $257 | $256 | $255 | $271 | |
Taxes Incurred | ($164) | ($486) | ($123) | ($366) | ($2,070) | $238 | $415 | $547 | $755 | $839 | $925 | $569 | |
Net Profit | ($383) | ($1,499) | ($378) | ($1,128) | ($6,378) | $734 | $1,278 | $1,687 | $2,326 | $2,584 | $2,851 | $1,755 | |
Net Profit/Sales | -4.63% | -22.15% | -4.53% | -14.30% | -67.92% | 6.93% | 11.66% | 14.13% | 17.78% | 19.23% | 20.05% | 12.99% |
Pro Forma Cash Flow | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $7,447 | $6,090 | $7,508 | $7,098 | $8,451 | $9,536 | $9,860 | $10,745 | $11,774 | $12,098 | $12,803 | $12,155 | |
Cash from Receivables | $2,000 | $2,028 | $822 | $682 | $833 | $794 | $943 | $1,061 | $1,099 | $1,198 | $1,309 | $1,347 | |
Subtotal Cash from Operations | $9,447 | $8,118 | $8,330 | $7,780 | $9,284 | $10,330 | $10,803 | $11,806 | $12,873 | $13,296 | $14,112 | $13,501 | |
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 | $21,000 | $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 | $43,529 | $0 | $0 | $0 | $0 | $0 | $0 | $20,570 | |
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 | $9,500 | $0 | $0 | $0 | $0 | $0 | $0 | $2,500 | $0 | |
New Investment Received | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $9,447 | $8,118 | $8,330 | $17,280 | $73,813 | $10,330 | $10,803 | $11,806 | $12,873 | $13,296 | $16,612 | $34,071 | |
Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Expenditures from Operations | |||||||||||||
Cash Spending | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,840 | $3,840 | $3,840 | $5,440 | |
Bill Payments | $178 | $5,321 | $4,957 | $5,407 | $5,873 | $10,947 | $5,232 | $5,073 | $5,627 | $5,595 | $5,711 | $6,169 | |
Subtotal Spent on Operations | $3,478 | $8,621 | $8,257 | $8,707 | $9,173 | $14,247 | $8,532 | $8,373 | $9,467 | $9,435 | $9,551 | $11,609 | |
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 | $8,000 | $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 | $1,194 | $1,194 | $1,194 | $1,194 | $1,194 | $1,194 | $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 | $54,410 | $0 | $0 | $0 | $0 | $0 | $0 | $27,205 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $3,478 | $8,621 | $8,257 | $16,707 | $63,583 | $15,441 | $9,726 | $9,567 | $10,661 | $10,629 | $10,745 | $38,814 | |
Net Cash Flow | $5,969 | ($503) | $73 | $574 | $10,229 | ($5,111) | $1,078 | $2,239 | $2,212 | $2,666 | $5,867 | ($4,742) | |
Cash Balance | $7,169 | $6,666 | $6,739 | $7,312 | $17,542 | $12,431 | $13,509 | $15,747 | $17,959 | $20,625 | $26,492 | $21,750 |
Pro Forma Balance Sheet | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $1,200 | $7,169 | $6,666 | $6,739 | $7,312 | $17,542 | $12,431 | $13,509 | $15,747 | $17,959 | $20,625 | $26,492 | $21,750 |
Accounts Receivable | $4,000 | $2,827 | $1,477 | $1,488 | $1,595 | $1,701 | $1,967 | $2,120 | $2,253 | $2,462 | $2,609 | $2,722 | $2,726 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $5,200 | $9,996 | $8,142 | $8,227 | $8,907 | $19,243 | $14,398 | $15,629 | $18,000 | $20,421 | $23,234 | $29,214 | $24,475 |
Long-term Assets | |||||||||||||
Long-term Assets | $14,000 | $14,000 | $14,000 | $14,000 | $4,500 | $58,910 | $58,910 | $58,910 | $58,910 | $58,910 | $58,910 | $56,410 | $83,615 |
Accumulated Depreciation | $0 | $23 | $47 | $70 | $93 | $1,417 | $2,741 | $4,065 | $5,389 | $6,713 | $8,037 | $9,361 | $10,685 |
Total Long-term Assets | $14,000 | $13,977 | $13,953 | $13,930 | $4,407 | $57,493 | $56,169 | $54,845 | $53,521 | $52,197 | $50,873 | $47,049 | $72,930 |
Total Assets | $19,200 | $23,973 | $22,095 | $22,157 | $13,314 | $76,736 | $70,567 | $70,474 | $71,521 | $72,618 | $74,107 | $76,263 | $97,405 |
Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Current Liabilities | |||||||||||||
Accounts Payable | $0 | $5,156 | $4,777 | $5,217 | $5,502 | $10,772 | $5,063 | $4,886 | $5,440 | $5,405 | $5,504 | $6,003 | $4,820 |
Current Borrowing | $12,000 | $12,000 | $12,000 | $12,000 | $4,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
Other Current Liabilities | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
Subtotal Current Liabilities | $15,500 | $20,656 | $20,277 | $20,717 | $13,002 | $39,272 | $33,563 | $33,386 | $33,940 | $33,905 | $34,004 | $34,503 | $33,320 |
Long-term Liabilities | $26,500 | $26,500 | $26,500 | $26,500 | $26,500 | $70,029 | $68,835 | $67,641 | $66,447 | $65,253 | $64,059 | $62,865 | $83,435 |
Total Liabilities | $42,000 | $47,156 | $46,777 | $47,217 | $39,502 | $109,301 | $102,398 | $101,027 | $100,387 | $99,158 | $98,063 | $97,368 | $116,755 |
Paid-in Capital | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 |
Retained Earnings | ($56,657) | ($22,900) | ($22,900) | ($22,900) | ($22,900) | ($22,900) | ($22,900) | ($22,900) | ($22,900) | ($22,900) | ($22,900) | ($22,900) | ($22,900) |
Earnings | $33,757 | ($383) | ($1,882) | ($2,260) | ($3,388) | ($9,765) | ($9,031) | ($7,753) | ($6,066) | ($3,740) | ($1,156) | $1,696 | $3,450 |
Total Capital | ($22,800) | ($23,183) | ($24,682) | ($25,060) | ($26,188) | ($32,565) | ($31,831) | ($30,553) | ($28,866) | ($26,540) | ($23,956) | ($21,104) | ($19,350) |
Total Liabilities and Capital | $19,200 | $23,973 | $22,095 | $22,157 | $13,314 | $76,736 | $70,567 | $70,474 | $71,521 | $72,618 | $74,107 | $76,263 | $97,405 |
Net Worth | ($22,800) | ($23,183) | ($24,682) | ($25,060) | ($26,188) | ($32,565) | ($31,831) | ($30,553) | ($28,866) | ($26,540) | ($23,956) | ($21,104) | ($19,350) |