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 |