Mad Keen Motors

Start your own business plan »

Automotive Repair - Sales - Valet Business Plan

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