20% Discount on Business Plan Pro Premier Edition
Click here to buy now or call 0845 351 9924
 

Coffee Distribution Business Plan

The Coffee Warehouse

This sample business plan can be edited directly in Business Plan Pro software.

previous
next

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Espresso Syrups 0% £14,322 £16,470 £18,941 £21,782 £25,049 £28,807 £33,128 £38,097 £43,811 £50,383 £57,940 £66,632
Chocolate & Caramel Sauces 0% £10,465 £12,034 £13,839 £15,915 £18,303 £21,048 £21,048 £24,205 £27,836 £32,011 £36,813 £42,335
Specialty Beverage Mixes 0% £8,626 £6,363 £3,759 £4,006 £4,242 £4,732 £7,887 £10,498 £21,167 £30,347 £34,899 £40,134
Energy Drinks 0% £1,530 £1,760 £2,023 £2,327 £2,676 £3,077 £3,539 £4,070 £4,680 £5,382 £6,190 £7,118
Concentrated Milk 0% £1,530 £2,924 £3,520 £4,245 £5,128 £6,360 £7,914 £9,882 £12,379 £15,556 £19,604 £24,774
Paper Supplies 0% £51,400 £47,414 £43,114 £45,849 £51,378 £58,075 £68,506 £85,766 £123,777 £177,815 £202,120 £230,071
Marketing 0% £700 £805 £910 £1,015 £1,155 £1,295 £1,470 £1,680 £1,890 £2,170 £2,450 £2,765
Total Sales £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Espresso Syrups £11,908 £13,694 £15,748 £18,110 £20,827 £23,951 £27,544 £31,675 £36,426 £41,890 £48,174 £55,400
Chocolate & Caramel Sauces £8,441 £9,707 £11,163 £12,837 £14,763 £16,977 £19,524 £22,453 £25,821 £29,694 £34,148 £39,270
Specialty Beverage Mixes £6,496 £4,866 £2,981 £3,192 £3,401 £3,802 £6,168 £8,145 £16,035 £22,852 £26,280 £30,222
Energy Drinks £1,260 £1,449 £1,666 £1,916 £2,204 £2,534 £2,914 £3,352 £3,854 £4,433 £5,097 £5,862
Concentrated Milk £1,308 £2,509 £3,022 £3,646 £4,405 £5,465 £6,804 £8,499 £10,651 £13,389 £16,880 £21,339
Paper Supplies £38,550 £35,560 £32,335 £34,387 £38,534 £43,556 £51,379 £64,325 £92,833 £133,361 £151,590 £172,554
Marketing £250 £288 £325 £363 £413 £463 £525 £600 £675 £775 £875 £988
Subtotal Direct Cost of Sales £68,213 £68,073 £67,240 £74,451 £84,546 £96,749 £114,858 £139,049 £186,297 £246,395 £283,045 £325,635
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Jennifer Smith 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
Sales/Delivery (Salary) 0% £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700
Sales/Delivery (Commission) 0% £170 £192 £216 £240 £268 £300 £336 £379 £429 £493 £565 £649
Delivery/Warehouse Personnel 0% £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700
Administration 0% £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560
Total People 4 4 4 4 4 4 4 4 4 4 4 4
Total Payroll £7,630 £7,652 £7,676 £7,700 £7,728 £7,760 £7,796 £7,839 £7,889 £7,953 £8,025 £8,109
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00%
Long-term Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00%
Tax Rate 30.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Direct Cost of Sales £68,213 £68,073 £67,240 £74,451 £84,546 £96,749 £114,858 £139,049 £186,297 £246,395 £283,045 £325,635
Hidden Row £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £68,213 £68,073 £67,240 £74,451 £84,546 £96,749 £114,858 £139,049 £186,297 £246,395 £283,045 £325,635
Gross Margin £20,360 £19,697 £18,866 £20,688 £23,385 £26,645 £28,634 £35,149 £49,243 £67,269 £76,971 £88,194
Gross Margin % 22.99% 22.44% 21.91% 21.74% 21.67% 21.59% 19.96% 20.18% 20.91% 21.45% 21.38% 21.31%
Expenses
Payroll £7,630 £7,652 £7,676 £7,700 £7,728 £7,760 £7,796 £7,839 £7,889 £7,953 £8,025 £8,109
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Rent £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758
Utilities and Phone £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600
Insurance £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
Payroll Burden 15% £1,145 £1,148 £1,151 £1,155 £1,159 £1,164 £1,169 £1,176 £1,183 £1,193 £1,204 £1,216
Leased Equipment (Delivery Vehicles) £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000
Leased Equipment (Warehouse) £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Leased Equipment (Other) £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Fuel (delivery) £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000
Advertising / Promotion £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300
Professional Services 15% £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Miscellaneous (office supplies, etc) £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Total Operating Expenses £15,783 £15,808 £15,835 £15,863 £15,895 £15,932 £15,973 £16,023 £16,080 £16,154 £16,237 £16,333
Profit Before Interest and Taxes £4,578 £3,889 £3,030 £4,825 £7,490 £10,713 £12,661 £19,126 £33,163 £51,116 £60,735 £71,861
EBITDA £4,578 £3,889 £3,030 £4,825 £7,490 £10,713 £12,661 £19,126 £33,163 £51,116 £60,735 £71,861
Interest Expense £620 £607 £593 £580 £567 £553 £540 £527 £513 £500 £487 £473
Taxes Incurred £1,187 £821 £609 £1,061 £1,731 £2,540 £3,030 £4,650 £8,162 £12,654 £15,062 £17,847
Other Income
Interest Income £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Income Account Name £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Other Income £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Expense
Account Name £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Expense Account Name £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Other Expense £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Net Other Income £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Net Profit £2,770 £2,462 £1,828 £3,184 £5,192 £7,620 £9,090 £13,950 £24,487 £37,962 £45,186 £53,541
Net Profit/Sales 3.13% 2.80% 2.12% 3.35% 4.81% 6.18% 6.34% 8.01% 10.40% 12.10% 12.55% 12.94%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Subtotal Cash from Operations £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Additional Cash Received
Non Operating (Other) Income £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
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 £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending £7,630 £7,652 £7,676 £7,700 £7,728 £7,760 £7,796 £7,839 £7,889 £7,953 £8,025 £8,109
Bill Payments £2,607 £78,184 £77,442 £76,236 £92,651 £106,626 £122,274 £147,608 £181,556 £257,760 £334,299 £348,850
Subtotal Spent on Operations £10,237 £85,836 £85,118 £83,936 £100,379 £114,386 £130,070 £155,447 £189,445 £265,713 £342,324 £356,959
Additional Cash Spent
Non Operating (Other) Expense £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Sales Tax, VAT, HST/GST Paid Out £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Principal Repayment of Current Borrowing £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000
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 £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 £12,237 £87,836 £87,118 £85,936 £102,379 £116,386 £132,070 £157,447 £191,445 £267,713 £344,324 £358,959
Net Cash Flow £76,336 (£66) (£1,012) £9,203 £5,552 £7,008 £11,422 £16,751 £44,095 £45,951 £15,692 £54,870
Cash Balance £86,136 £86,071 £85,059 £94,262 £99,813 £106,821 £118,243 £134,994 £179,089 £225,039 £240,731 £295,601
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash £9,800 £86,136 £86,071 £85,059 £94,262 £99,813 £106,821 £118,243 £134,994 £179,089 £225,039 £240,731 £295,601
Inventory £75,000 £75,034 £74,880 £73,964 £81,896 £93,001 £106,424 £126,344 £152,954 £204,926 £271,034 £311,349 £358,198
Other Current Assets £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750
Total Current Assets £103,550 £179,920 £179,701 £177,773 £194,908 £211,564 £231,995 £263,337 £306,698 £402,765 £514,823 £570,830 £672,549
Long-term Assets
Long-term Assets £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Accumulated Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Long-term Assets £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Assets £103,550 £179,920 £179,701 £177,773 £194,908 £211,564 £231,995 £263,337 £306,698 £402,765 £514,823 £570,830 £672,549
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable £0 £75,600 £74,919 £73,163 £89,114 £102,578 £117,390 £141,641 £173,052 £246,632 £322,728 £335,549 £385,728
Current Borrowing £95,000 £93,000 £91,000 £89,000 £87,000 £85,000 £83,000 £81,000 £79,000 £77,000 £75,000 £73,000 £71,000
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £95,000 £168,600 £165,919 £162,163 £176,114 £187,578 £200,390 £222,641 £252,052 £323,632 £397,728 £408,549 £456,728
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Liabilities £95,000 £168,600 £165,919 £162,163 £176,114 £187,578 £200,390 £222,641 £252,052 £323,632 £397,728 £408,549 £456,728
Paid-in Capital £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000
Retained Earnings (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450)
Earnings £0 £2,770 £5,232 £7,060 £10,244 £15,436 £23,056 £32,146 £46,096 £70,583 £108,545 £153,731 £207,271
Total Capital £8,550 £11,320 £13,782 £15,610 £18,794 £23,986 £31,606 £40,696 £54,646 £79,133 £117,095 £162,281 £215,821
Total Liabilities and Capital £103,550 £179,920 £179,701 £177,773 £194,908 £211,564 £231,995 £263,337 £306,698 £402,765 £514,823 £570,830 £672,549
Net Worth £8,550 £11,320 £13,782 £15,610 £18,794 £23,986 £31,606 £40,696 £54,646 £79,133 £117,095 £162,281 £215,821
previous
next
Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Espresso Syrups 0% £14,322 £16,470 £18,941 £21,782 £25,049 £28,807 £33,128 £38,097 £43,811 £50,383 £57,940 £66,632
Chocolate & Caramel Sauces 0% £10,465 £12,034 £13,839 £15,915 £18,303 £21,048 £21,048 £24,205 £27,836 £32,011 £36,813 £42,335
Specialty Beverage Mixes 0% £8,626 £6,363 £3,759 £4,006 £4,242 £4,732 £7,887 £10,498 £21,167 £30,347 £34,899 £40,134
Energy Drinks 0% £1,530 £1,760 £2,023 £2,327 £2,676 £3,077 £3,539 £4,070 £4,680 £5,382 £6,190 £7,118
Concentrated Milk 0% £1,530 £2,924 £3,520 £4,245 £5,128 £6,360 £7,914 £9,882 £12,379 £15,556 £19,604 £24,774
Paper Supplies 0% £51,400 £47,414 £43,114 £45,849 £51,378 £58,075 £68,506 £85,766 £123,777 £177,815 £202,120 £230,071
Marketing 0% £700 £805 £910 £1,015 £1,155 £1,295 £1,470 £1,680 £1,890 £2,170 £2,450 £2,765
Total Sales £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Espresso Syrups £11,908 £13,694 £15,748 £18,110 £20,827 £23,951 £27,544 £31,675 £36,426 £41,890 £48,174 £55,400
Chocolate & Caramel Sauces £8,441 £9,707 £11,163 £12,837 £14,763 £16,977 £19,524 £22,453 £25,821 £29,694 £34,148 £39,270
Specialty Beverage Mixes £6,496 £4,866 £2,981 £3,192 £3,401 £3,802 £6,168 £8,145 £16,035 £22,852 £26,280 £30,222
Energy Drinks £1,260 £1,449 £1,666 £1,916 £2,204 £2,534 £2,914 £3,352 £3,854 £4,433 £5,097 £5,862
Concentrated Milk £1,308 £2,509 £3,022 £3,646 £4,405 £5,465 £6,804 £8,499 £10,651 £13,389 £16,880 £21,339
Paper Supplies £38,550 £35,560 £32,335 £34,387 £38,534 £43,556 £51,379 £64,325 £92,833 £133,361 £151,590 £172,554
Marketing £250 £288 £325 £363 £413 £463 £525 £600 £675 £775 £875 £988
Subtotal Direct Cost of Sales £68,213 £68,073 £67,240 £74,451 £84,546 £96,749 £114,858 £139,049 £186,297 £246,395 £283,045 £325,635
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Jennifer Smith 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
Sales/Delivery (Salary) 0% £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700
Sales/Delivery (Commission) 0% £170 £192 £216 £240 £268 £300 £336 £379 £429 £493 £565 £649
Delivery/Warehouse Personnel 0% £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700
Administration 0% £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560
Total People 4 4 4 4 4 4 4 4 4 4 4 4
Total Payroll £7,630 £7,652 £7,676 £7,700 £7,728 £7,760 £7,796 £7,839 £7,889 £7,953 £8,025 £8,109
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00%
Long-term Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00%
Tax Rate 30.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Direct Cost of Sales £68,213 £68,073 £67,240 £74,451 £84,546 £96,749 £114,858 £139,049 £186,297 £246,395 £283,045 £325,635
Hidden Row £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £68,213 £68,073 £67,240 £74,451 £84,546 £96,749 £114,858 £139,049 £186,297 £246,395 £283,045 £325,635
Gross Margin £20,360 £19,697 £18,866 £20,688 £23,385 £26,645 £28,634 £35,149 £49,243 £67,269 £76,971 £88,194
Gross Margin % 22.99% 22.44% 21.91% 21.74% 21.67% 21.59% 19.96% 20.18% 20.91% 21.45% 21.38% 21.31%
Expenses
Payroll £7,630 £7,652 £7,676 £7,700 £7,728 £7,760 £7,796 £7,839 £7,889 £7,953 £8,025 £8,109
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Rent £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758
Utilities and Phone £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600
Insurance £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
Payroll Burden 15% £1,145 £1,148 £1,151 £1,155 £1,159 £1,164 £1,169 £1,176 £1,183 £1,193 £1,204 £1,216
Leased Equipment (Delivery Vehicles) £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000
Leased Equipment (Warehouse) £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Leased Equipment (Other) £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Fuel (delivery) £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000
Advertising / Promotion £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300
Professional Services 15% £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Miscellaneous (office supplies, etc) £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Total Operating Expenses £15,783 £15,808 £15,835 £15,863 £15,895 £15,932 £15,973 £16,023 £16,080 £16,154 £16,237 £16,333
Profit Before Interest and Taxes £4,578 £3,889 £3,030 £4,825 £7,490 £10,713 £12,661 £19,126 £33,163 £51,116 £60,735 £71,861
EBITDA £4,578 £3,889 £3,030 £4,825 £7,490 £10,713 £12,661 £19,126 £33,163 £51,116 £60,735 £71,861
Interest Expense £620 £607 £593 £580 £567 £553 £540 £527 £513 £500 £487 £473
Taxes Incurred £1,187 £821 £609 £1,061 £1,731 £2,540 £3,030 £4,650 £8,162 £12,654 £15,062 £17,847
Other Income
Interest Income £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Income Account Name £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Other Income £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Expense
Account Name £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Expense Account Name £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Other Expense £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Net Other Income £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Net Profit £2,770 £2,462 £1,828 £3,184 £5,192 £7,620 £9,090 £13,950 £24,487 £37,962 £45,186 £53,541
Net Profit/Sales 3.13% 2.80% 2.12% 3.35% 4.81% 6.18% 6.34% 8.01% 10.40% 12.10% 12.55% 12.94%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Subtotal Cash from Operations £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Additional Cash Received
Non Operating (Other) Income £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
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 £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending £7,630 £7,652 £7,676 £7,700 £7,728 £7,760 £7,796 £7,839 £7,889 £7,953 £8,025 £8,109
Bill Payments £2,607 £78,184 £77,442 £76,236 £92,651 £106,626 £122,274 £147,608 £181,556 £257,760 £334,299 £348,850
Subtotal Spent on Operations £10,237 £85,836 £85,118 £83,936 £100,379 £114,386 £130,070 £155,447 £189,445 £265,713 £342,324 £356,959
Additional Cash Spent
Non Operating (Other) Expense £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Sales Tax, VAT, HST/GST Paid Out £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Principal Repayment of Current Borrowing £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000
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 £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 £12,237 £87,836 £87,118 £85,936 £102,379 £116,386 £132,070 £157,447 £191,445 £267,713 £344,324 £358,959
Net Cash Flow £76,336 (£66) (£1,012) £9,203 £5,552 £7,008 £11,422 £16,751 £44,095 £45,951 £15,692 £54,870
Cash Balance £86,136 £86,071 £85,059 £94,262 £99,813 £106,821 £118,243 £134,994 £179,089 £225,039 £240,731 £295,601
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash £9,800 £86,136 £86,071 £85,059 £94,262 £99,813 £106,821 £118,243 £134,994 £179,089 £225,039 £240,731 £295,601
Inventory £75,000 £75,034 £74,880 £73,964 £81,896 £93,001 £106,424 £126,344 £152,954 £204,926 £271,034 £311,349 £358,198
Other Current Assets £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750
Total Current Assets £103,550 £179,920 £179,701 £177,773 £194,908 £211,564 £231,995 £263,337 £306,698 £402,765 £514,823 £570,830 £672,549
Long-term Assets
Long-term Assets £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Accumulated Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Long-term Assets £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Assets £103,550 £179,920 £179,701 £177,773 £194,908 £211,564 £231,995 £263,337 £306,698 £402,765 £514,823 £570,830 £672,549
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable £0 £75,600 £74,919 £73,163 £89,114 £102,578 £117,390 £141,641 £173,052 £246,632 £322,728 £335,549 £385,728
Current Borrowing £95,000 £93,000 £91,000 £89,000 £87,000 £85,000 £83,000 £81,000 £79,000 £77,000 £75,000 £73,000 £71,000
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £95,000 £168,600 £165,919 £162,163 £176,114 £187,578 £200,390 £222,641 £252,052 £323,632 £397,728 £408,549 £456,728
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Liabilities £95,000 £168,600 £165,919 £162,163 £176,114 £187,578 £200,390 £222,641 £252,052 £323,632 £397,728 £408,549 £456,728
Paid-in Capital £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000 £25,000
Retained Earnings (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450) (£16,450)
Earnings £0 £2,770 £5,232 £7,060 £10,244 £15,436 £23,056 £32,146 £46,096 £70,583 £108,545 £153,731 £207,271
Total Capital £8,550 £11,320 £13,782 £15,610 £18,794 £23,986 £31,606 £40,696 £54,646 £79,133 £117,095 £162,281 £215,821
Total Liabilities and Capital £103,550 £179,920 £179,701 £177,773 £194,908 £211,564 £231,995 £263,337 £306,698 £402,765 £514,823 £570,830 £672,549
Net Worth £8,550 £11,320 £13,782 £15,610 £18,794 £23,986 £31,606 £40,696 £54,646 £79,133 £117,095 £162,281 £215,821