Mad Keen Motors
Appendix
| Sales Forecast | |||||||||||||
| Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | ||
| Sales | |||||||||||||
| Revenue from all Standard Streams | £67,000 | £67,000 | £67,000 | £67,000 | £67,000 | £67,000 | £67,000 | £67,000 | £67,000 | £67,000 | £67,000 | £67,000 | |
| Increased Sales through website | £660 | £1,000 | £1,400 | £1,700 | £1,350 | £1,350 | £1,350 | £1,700 | £2,050 | £2,400 | £1,700 | £1,700 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £67,660 | £68,000 | £68,400 | £68,700 | £68,350 | £68,350 | £68,350 | £68,700 | £69,050 | £69,400 | £68,700 | £68,700 | |
| Direct Cost of Sales | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | |
| Direct Costs | £2,706 | £2,720 | £2,736 | £2,748 | £2,734 | £2,734 | £2,734 | £2,748 | £2,762 | £2,776 | £2,748 | £2,748 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £2,706 | £2,720 | £2,736 | £2,748 | £2,734 | £2,734 | £2,734 | £2,748 | £2,762 | £2,776 | £2,748 | £2,748 | |
| Personnel Plan | |||||||||||||
| Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | ||
| Mark Keen, Co-Owner | 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 |
| Barry Keen, Co-Owner | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Mechanics | 0% | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Other Staff | 0% | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 |
| Elisabeth Keen, Admin | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Total People | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | |
| Total Payroll | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | |
| Pro Forma Profit and Loss | |||||||||||||
| Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | ||
| Sales | £67,660 | £68,000 | £68,400 | £68,700 | £68,350 | £68,350 | £68,350 | £68,700 | £69,050 | £69,400 | £68,700 | £68,700 | |
| Direct Cost of Sales | £2,706 | £2,720 | £2,736 | £2,748 | £2,734 | £2,734 | £2,734 | £2,748 | £2,762 | £2,776 | £2,748 | £2,748 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,706 | £2,720 | £2,736 | £2,748 | £2,734 | £2,734 | £2,734 | £2,748 | £2,762 | £2,776 | £2,748 | £2,748 | |
| Gross Margin | £64,954 | £65,280 | £65,664 | £65,952 | £65,616 | £65,616 | £65,616 | £65,952 | £66,288 | £66,624 | £65,952 | £65,952 | |
| Gross Margin % | 96.00% | 96.00% | 96.00% | 96.00% | 96.00% | 96.00% | 96.00% | 96.00% | 96.00% | 96.00% | 96.00% | 96.00% | |
| Expenses | |||||||||||||
| Payroll | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | |
| Other Expense Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Standard Operating Expenses | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | |
| Website Infrastructure | £0 | £0 | £0 | £350 | £350 | £350 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Website Development | £600 | £600 | £600 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Website Maintenance | £0 | £0 | £0 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Expensed Equipment | £2,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes (National Insurance, etc.) | 15% | £5,025 | £5,025 | £5,025 | £5,025 | £5,025 | £5,025 | £5,025 | £5,025 | £5,025 | £5,025 | £5,025 | £5,025 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £38,925 | £38,925 | £38,925 | £38,925 | £38,925 | £38,925 | £38,925 | £38,925 | £38,925 | £38,925 | £38,925 | £38,925 | |
| Profit Before Interest and Taxes | £26,029 | £26,355 | £26,739 | £27,027 | £26,691 | £26,691 | £26,691 | £27,027 | £27,363 | £27,699 | £27,027 | £27,027 | |
| EBITDA | £26,429 | £26,755 | £27,139 | £27,427 | £27,091 | £27,091 | £27,091 | £27,427 | £27,763 | £28,099 | £27,427 | £27,427 | |
| Interest Expense | £6,233 | £6,233 | £6,233 | £6,233 | £6,233 | £6,233 | £6,233 | £6,233 | £6,233 | £6,233 | £6,233 | £6,233 | |
| Taxes Incurred | £5,939 | £6,037 | £6,152 | £6,238 | £6,137 | £6,137 | £6,137 | £6,238 | £6,339 | £6,440 | £6,238 | £6,238 | |
| Net Profit | £13,857 | £14,085 | £14,354 | £14,556 | £14,320 | £14,320 | £14,320 | £14,556 | £14,791 | £15,026 | £14,556 | £14,556 | |
| Net Profit/Sales | 20.48% | 20.71% | 20.99% | 21.19% | 20.95% | 20.95% | 20.95% | 21.19% | 21.42% | 21.65% | 21.19% | 21.19% | |
| Pro Forma Cash Flow | |||||||||||||
| Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £67,660 | £68,000 | £68,400 | £68,700 | £68,350 | £68,350 | £68,350 | £68,700 | £69,050 | £69,400 | £68,700 | £68,700 | |
| Subtotal Cash from Operations | £67,660 | £68,000 | £68,400 | £68,700 | £68,350 | £68,350 | £68,350 | £68,700 | £69,050 | £69,400 | £68,700 | £68,700 | |
| 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 | £67,660 | £68,000 | £68,400 | £68,700 | £68,350 | £68,350 | £68,350 | £68,700 | £69,050 | £69,400 | £68,700 | £68,700 | |
| Expenditures | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | |
| Bill Payments | £20,573 | £17,200 | £17,299 | £17,467 | £19,148 | £20,116 | £20,130 | £20,134 | £20,262 | £20,377 | £20,479 | £20,217 | |
| Subtotal Spent on Operations | £54,073 | £50,700 | £50,799 | £50,967 | £52,648 | £53,616 | £53,630 | £53,634 | £53,762 | £53,877 | £53,979 | £53,717 | |
| 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 | £2,000 | £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 | £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 | £56,073 | £50,700 | £50,799 | £50,967 | £52,648 | £53,616 | £53,630 | £53,634 | £53,762 | £53,877 | £53,979 | £53,717 | |
| Net Cash Flow | £11,587 | £17,300 | £17,601 | £17,733 | £15,702 | £14,734 | £14,720 | £15,066 | £15,288 | £15,523 | £14,721 | £14,983 | |
| Cash Balance | £215,075 | £232,375 | £249,976 | £267,709 | £283,411 | £298,145 | £312,865 | £327,931 | £343,219 | £358,742 | £373,463 | £388,446 | |
| Pro Forma Balance Sheet | |||||||||||||
| Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £203,488 | £215,075 | £232,375 | £249,976 | £267,709 | £283,411 | £298,145 | £312,865 | £327,931 | £343,219 | £358,742 | £373,463 | £388,446 |
| Inventory | £12,040 | £9,334 | £6,614 | £3,878 | £2,748 | £2,734 | £2,734 | £2,734 | £2,748 | £2,762 | £2,776 | £2,748 | £2,748 |
| Other Current Assets | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 |
| Total Current Assets | £285,528 | £294,408 | £308,988 | £323,854 | £340,457 | £356,145 | £370,879 | £385,599 | £400,679 | £415,981 | £431,518 | £446,211 | £461,194 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 |
| Accumulated Depreciation | £15,000 | £15,400 | £15,800 | £16,200 | £16,600 | £17,000 | £17,400 | £17,800 | £18,200 | £18,600 | £19,000 | £19,400 | £19,800 |
| Total Long-term Assets | £1,235,000 | £1,234,600 | £1,234,200 | £1,233,800 | £1,233,400 | £1,233,000 | £1,232,600 | £1,232,200 | £1,231,800 | £1,231,400 | £1,231,000 | £1,230,600 | £1,230,200 |
| Total Assets | £1,520,528 | £1,529,008 | £1,543,188 | £1,557,654 | £1,573,857 | £1,589,145 | £1,603,479 | £1,617,799 | £1,632,479 | £1,647,381 | £1,662,518 | £1,676,811 | £1,691,394 |
| Liabilities and Capital | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £20,000 | £16,624 | £16,718 | £16,830 | £18,478 | £19,445 | £19,459 | £19,459 | £19,583 | £19,694 | £19,805 | £19,543 | £19,570 |
| 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 | £20,000 | £16,624 | £16,718 | £16,830 | £18,478 | £19,445 | £19,459 | £19,459 | £19,583 | £19,694 | £19,805 | £19,543 | £19,570 |
| Long-term Liabilities | £750,000 | £748,000 | £748,000 | £748,000 | £748,000 | £748,000 | £748,000 | £748,000 | £748,000 | £748,000 | £748,000 | £748,000 | £748,000 |
| Total Liabilities | £770,000 | £764,624 | £764,718 | £764,830 | £766,478 | £767,445 | £767,459 | £767,459 | £767,583 | £767,694 | £767,805 | £767,543 | £767,570 |
| Paid-in Capital | £400,000 | £400,000 | £400,000 | £400,000 | £400,000 | £400,000 | £400,000 | £400,000 | £400,000 | £400,000 | £400,000 | £400,000 | £400,000 |
| Retained Earnings | £314,488 | £350,528 | £350,528 | £350,528 | £350,528 | £350,528 | £350,528 | £350,528 | £350,528 | £350,528 | £350,528 | £350,528 | £350,528 |
| Earnings | £36,040 | £13,857 | £27,942 | £42,296 | £56,851 | £71,172 | £85,492 | £99,812 | £114,368 | £129,159 | £144,185 | £158,740 | £173,296 |
| Total Capital | £750,528 | £764,385 | £778,470 | £792,824 | £807,379 | £821,700 | £836,020 | £850,340 | £864,896 | £879,687 | £894,713 | £909,268 | £923,824 |
| Total Liabilities and Capital | £1,520,528 | £1,529,008 | £1,543,188 | £1,557,654 | £1,573,857 | £1,589,145 | £1,603,479 | £1,617,799 | £1,632,479 | £1,647,381 | £1,662,518 | £1,676,811 | £1,691,394 |
| Net Worth | £750,528 | £764,385 | £778,470 | £792,824 | £807,379 | £821,700 | £836,020 | £850,340 | £864,896 | £879,687 | £894,713 | £909,268 | £923,824 |
By 
