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

Pizzeria Business Plan

Pizzeria del Causamali

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
Pizza 0% £7,200 £12,600 £11,160 £12,000 £11,460 £11,340 £11,820 £11,160 £11,320 £11,640 £10,560 £11,640
Breadsticks 0% £1,000 £1,750 £1,550 £1,667 £1,592 £1,575 £1,642 £1,550 £1,642 £1,617 £1,467 £1,617
Beer 0% £2,000 £3,500 £3,100 £3,333 £3,183 £3,150 £3,283 £3,100 £3,283 £3,233 £2,933 £3,233
Drinks 0% £2,720 £4,760 £4,216 £4,533 £4,329 £4,284 £4,465 £4,216 £4,465 £4,397 £3,989 £4,397
Total Sales £12,920 £22,610 £20,026 £21,533 £20,564 £20,349 £21,210 £20,026 £20,710 £20,887 £18,949 £20,887
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
Pizza 32% £2,304 £4,032 £3,571 £3,840 £3,667 £3,629 £3,782 £3,571 £3,622 £3,725 £3,379 £3,725
Breadsticks 20% £200 £350 £310 £333 £318 £315 £328 £310 £328 £323 £293 £323
Beer 20% £400 £700 £620 £667 £637 £630 £657 £620 £657 £647 £587 £647
Drinks 5% £136 £238 £211 £227 £216 £214 £223 £211 £223 £220 £199 £220
Subtotal Direct Cost of Sales £3,040 £5,320 £4,712 £5,067 £4,839 £4,788 £4,991 £4,712 £4,831 £4,915 £4,459 £4,915
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
Kitchen Leads 0% £2,340 £2,340 £2,340 £2,340 £2,340 £2,340 £2,340 £2,340 £2,340 £2,340 £2,340 £2,340
Kitchen/Wait 0% £3,120 £3,120 £3,120 £3,120 £3,120 £3,120 £3,120 £3,120 £3,120 £3,120 £3,120 £3,120
Dishwasher 0% £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300
Owner 0% £750 £750 £750 £750 £750 £750 £750 £750 £750 £750 £750 £750
Delivery 0% £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300
Total People 12 12 12 12 12 12 12 12 12 12 12 12
Total Payroll £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810
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 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Long-term Interest Rate 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 £12,920 £22,610 £20,026 £21,533 £20,564 £20,349 £21,210 £20,026 £20,710 £20,887 £18,949 £20,887
Direct Cost of Sales £3,040 £5,320 £4,712 £5,067 £4,839 £4,788 £4,991 £4,712 £4,831 £4,915 £4,459 £4,915
Other Costs of Goods £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £3,040 £5,320 £4,712 £5,067 £4,839 £4,788 £4,991 £4,712 £4,831 £4,915 £4,459 £4,915
Gross Margin £9,880 £17,290 £15,314 £16,467 £15,726 £15,561 £16,220 £15,314 £15,880 £15,973 £14,491 £15,973
Gross Margin % 76.47% 76.47% 76.47% 76.47% 76.47% 76.47% 76.47% 76.47% 76.68% 76.47% 76.47% 76.47%
Expenses
Payroll £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810
Sales and Marketing and Other Expenses £500 £750 £750 £750 £750 £750 £750 £750 £250 £250 £500 £500
Depreciation £170 £170 £170 £170 £170 £170 £170 £170 £170 £170 £170 £170
Rent £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200
Utilities £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600
Insurance £350 £350 £350 £350 £350 £350 £350 £350 £350 £350 £350 £350
Payroll Taxes 15% £670 £670 £670 £670 £670 £670 £670 £670 £670 £670 £670 £670
Website Hosting and Maintenance 15% £50 £50 £50 £50 £50 £50 £50 £50 £50 £50 £50 £50
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £12,350 £12,600 £12,600 £12,600 £12,600 £12,600 £12,600 £12,600 £12,100 £12,100 £12,350 £12,350
Profit Before Interest and Taxes (£2,470) £4,690 £2,714 £3,866 £3,125 £2,961 £3,619 £2,714 £3,779 £3,872 £2,140 £3,622
EBITDA (£2,300) £4,860 £2,884 £4,036 £3,295 £3,131 £3,789 £2,884 £3,949 £4,042 £2,310 £3,792
Interest Expense £102 £100 £98 £96 £94 £92 £90 £88 £85 £83 £81 £79
Taxes Incurred (£772) £1,377 £785 £1,131 £910 £861 £1,059 £788 £1,108 £1,137 £618 £1,063
Net Profit (£1,801) £3,213 £1,831 £2,639 £2,122 £2,008 £2,471 £1,838 £2,586 £2,652 £1,441 £2,480
Net Profit/Sales -13.94% 14.21% 9.14% 12.26% 10.32% 9.87% 11.65% 9.18% 12.49% 12.70% 7.61% 11.87%
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 £12,920 £22,610 £20,026 £21,533 £20,564 £20,349 £21,210 £20,026 £20,710 £20,887 £18,949 £20,887
Subtotal Cash from Operations £12,920 £22,610 £20,026 £21,533 £20,564 £20,349 £21,210 £20,026 £20,710 £20,887 £18,949 £20,887
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 £12,920 £22,610 £20,026 £21,533 £20,564 £20,349 £21,210 £20,026 £20,710 £20,887 £18,949 £20,887
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 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810
Bill Payments £9,590 £2,921 £9,309 £9,037 £10,016 £9,381 £9,359 £9,806 £9,113 £9,189 £9,254 £8,409
Subtotal Spent on Operations £18,400 £11,731 £18,119 £17,847 £18,826 £18,191 £18,169 £18,616 £17,923 £17,999 £18,064 £17,219
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 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
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 £18,900 £12,231 £18,619 £18,347 £19,326 £18,691 £18,669 £19,116 £18,423 £18,499 £18,564 £17,719
Net Cash Flow (£5,980) £10,379 £1,407 £3,187 £1,238 £1,658 £2,541 £910 £2,288 £2,388 £386 £3,168
Cash Balance £17,120 £27,499 £28,906 £32,093 £33,331 £34,989 £37,530 £38,440 £40,728 £43,116 £43,501 £46,670
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 £23,100 £17,120 £27,499 £28,906 £32,093 £33,331 £34,989 £37,530 £38,440 £40,728 £43,116 £43,501 £46,670
Inventory £6,000 £2,960 £1,862 £1,649 £1,773 £1,694 £1,676 £1,747 £1,649 £1,691 £1,720 £1,561 £1,720
Other Current Assets £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250
Total Current Assets £34,350 £25,330 £34,611 £35,805 £39,116 £40,275 £41,915 £44,527 £45,339 £47,669 £50,086 £50,312 £53,640
Long-term Assets
Long-term Assets £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300
Accumulated Depreciation £0 £170 £340 £510 £680 £850 £1,020 £1,190 £1,360 £1,530 £1,700 £1,870 £2,040
Total Long-term Assets £20,300 £20,130 £19,960 £19,790 £19,620 £19,450 £19,280 £19,110 £18,940 £18,770 £18,600 £18,430 £18,260
Total Assets £54,650 £45,460 £54,571 £55,595 £58,736 £59,725 £61,195 £63,637 £64,279 £66,439 £68,686 £68,742 £71,900
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 £9,500 £2,611 £9,008 £8,702 £9,703 £9,070 £9,031 £9,503 £8,806 £8,880 £8,975 £8,089 £9,267
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 £9,500 £2,611 £9,008 £8,702 £9,703 £9,070 £9,031 £9,503 £8,806 £8,880 £8,975 £8,089 £9,267
Long-term Liabilities £25,000 £24,500 £24,000 £23,500 £23,000 £22,500 £22,000 £21,500 £21,000 £20,500 £20,000 £19,500 £19,000
Total Liabilities £34,500 £27,111 £33,008 £32,202 £32,703 £31,570 £31,031 £31,003 £29,806 £29,380 £28,975 £27,589 £28,267
Paid-in Capital £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000
Retained Earnings (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850)
Earnings £0 (£1,801) £1,412 £3,243 £5,883 £8,005 £10,014 £12,484 £14,323 £16,909 £19,561 £21,003 £23,483
Total Capital £20,150 £18,349 £21,562 £23,393 £26,033 £28,155 £30,164 £32,634 £34,473 £37,059 £39,711 £41,153 £43,633
Total Liabilities and Capital £54,650 £45,460 £54,571 £55,595 £58,736 £59,725 £61,195 £63,637 £64,279 £66,439 £68,686 £68,742 £71,900
Net Worth £20,150 £18,349 £21,562 £23,393 £26,033 £28,155 £30,164 £32,634 £34,473 £37,059 £39,711 £41,153 £43,633
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
Pizza 0% £7,200 £12,600 £11,160 £12,000 £11,460 £11,340 £11,820 £11,160 £11,320 £11,640 £10,560 £11,640
Breadsticks 0% £1,000 £1,750 £1,550 £1,667 £1,592 £1,575 £1,642 £1,550 £1,642 £1,617 £1,467 £1,617
Beer 0% £2,000 £3,500 £3,100 £3,333 £3,183 £3,150 £3,283 £3,100 £3,283 £3,233 £2,933 £3,233
Drinks 0% £2,720 £4,760 £4,216 £4,533 £4,329 £4,284 £4,465 £4,216 £4,465 £4,397 £3,989 £4,397
Total Sales £12,920 £22,610 £20,026 £21,533 £20,564 £20,349 £21,210 £20,026 £20,710 £20,887 £18,949 £20,887
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
Pizza 32% £2,304 £4,032 £3,571 £3,840 £3,667 £3,629 £3,782 £3,571 £3,622 £3,725 £3,379 £3,725
Breadsticks 20% £200 £350 £310 £333 £318 £315 £328 £310 £328 £323 £293 £323
Beer 20% £400 £700 £620 £667 £637 £630 £657 £620 £657 £647 £587 £647
Drinks 5% £136 £238 £211 £227 £216 £214 £223 £211 £223 £220 £199 £220
Subtotal Direct Cost of Sales £3,040 £5,320 £4,712 £5,067 £4,839 £4,788 £4,991 £4,712 £4,831 £4,915 £4,459 £4,915
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
Kitchen Leads 0% £2,340 £2,340 £2,340 £2,340 £2,340 £2,340 £2,340 £2,340 £2,340 £2,340 £2,340 £2,340
Kitchen/Wait 0% £3,120 £3,120 £3,120 £3,120 £3,120 £3,120 £3,120 £3,120 £3,120 £3,120 £3,120 £3,120
Dishwasher 0% £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300
Owner 0% £750 £750 £750 £750 £750 £750 £750 £750 £750 £750 £750 £750
Delivery 0% £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300
Total People 12 12 12 12 12 12 12 12 12 12 12 12
Total Payroll £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810
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 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Long-term Interest Rate 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 £12,920 £22,610 £20,026 £21,533 £20,564 £20,349 £21,210 £20,026 £20,710 £20,887 £18,949 £20,887
Direct Cost of Sales £3,040 £5,320 £4,712 £5,067 £4,839 £4,788 £4,991 £4,712 £4,831 £4,915 £4,459 £4,915
Other Costs of Goods £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £3,040 £5,320 £4,712 £5,067 £4,839 £4,788 £4,991 £4,712 £4,831 £4,915 £4,459 £4,915
Gross Margin £9,880 £17,290 £15,314 £16,467 £15,726 £15,561 £16,220 £15,314 £15,880 £15,973 £14,491 £15,973
Gross Margin % 76.47% 76.47% 76.47% 76.47% 76.47% 76.47% 76.47% 76.47% 76.68% 76.47% 76.47% 76.47%
Expenses
Payroll £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810
Sales and Marketing and Other Expenses £500 £750 £750 £750 £750 £750 £750 £750 £250 £250 £500 £500
Depreciation £170 £170 £170 £170 £170 £170 £170 £170 £170 £170 £170 £170
Rent £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200
Utilities £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600
Insurance £350 £350 £350 £350 £350 £350 £350 £350 £350 £350 £350 £350
Payroll Taxes 15% £670 £670 £670 £670 £670 £670 £670 £670 £670 £670 £670 £670
Website Hosting and Maintenance 15% £50 £50 £50 £50 £50 £50 £50 £50 £50 £50 £50 £50
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £12,350 £12,600 £12,600 £12,600 £12,600 £12,600 £12,600 £12,600 £12,100 £12,100 £12,350 £12,350
Profit Before Interest and Taxes (£2,470) £4,690 £2,714 £3,866 £3,125 £2,961 £3,619 £2,714 £3,779 £3,872 £2,140 £3,622
EBITDA (£2,300) £4,860 £2,884 £4,036 £3,295 £3,131 £3,789 £2,884 £3,949 £4,042 £2,310 £3,792
Interest Expense £102 £100 £98 £96 £94 £92 £90 £88 £85 £83 £81 £79
Taxes Incurred (£772) £1,377 £785 £1,131 £910 £861 £1,059 £788 £1,108 £1,137 £618 £1,063
Net Profit (£1,801) £3,213 £1,831 £2,639 £2,122 £2,008 £2,471 £1,838 £2,586 £2,652 £1,441 £2,480
Net Profit/Sales -13.94% 14.21% 9.14% 12.26% 10.32% 9.87% 11.65% 9.18% 12.49% 12.70% 7.61% 11.87%
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 £12,920 £22,610 £20,026 £21,533 £20,564 £20,349 £21,210 £20,026 £20,710 £20,887 £18,949 £20,887
Subtotal Cash from Operations £12,920 £22,610 £20,026 £21,533 £20,564 £20,349 £21,210 £20,026 £20,710 £20,887 £18,949 £20,887
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 £12,920 £22,610 £20,026 £21,533 £20,564 £20,349 £21,210 £20,026 £20,710 £20,887 £18,949 £20,887
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 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810 £8,810
Bill Payments £9,590 £2,921 £9,309 £9,037 £10,016 £9,381 £9,359 £9,806 £9,113 £9,189 £9,254 £8,409
Subtotal Spent on Operations £18,400 £11,731 £18,119 £17,847 £18,826 £18,191 £18,169 £18,616 £17,923 £17,999 £18,064 £17,219
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 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
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 £18,900 £12,231 £18,619 £18,347 £19,326 £18,691 £18,669 £19,116 £18,423 £18,499 £18,564 £17,719
Net Cash Flow (£5,980) £10,379 £1,407 £3,187 £1,238 £1,658 £2,541 £910 £2,288 £2,388 £386 £3,168
Cash Balance £17,120 £27,499 £28,906 £32,093 £33,331 £34,989 £37,530 £38,440 £40,728 £43,116 £43,501 £46,670
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 £23,100 £17,120 £27,499 £28,906 £32,093 £33,331 £34,989 £37,530 £38,440 £40,728 £43,116 £43,501 £46,670
Inventory £6,000 £2,960 £1,862 £1,649 £1,773 £1,694 £1,676 £1,747 £1,649 £1,691 £1,720 £1,561 £1,720
Other Current Assets £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250 £5,250
Total Current Assets £34,350 £25,330 £34,611 £35,805 £39,116 £40,275 £41,915 £44,527 £45,339 £47,669 £50,086 £50,312 £53,640
Long-term Assets
Long-term Assets £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300 £20,300
Accumulated Depreciation £0 £170 £340 £510 £680 £850 £1,020 £1,190 £1,360 £1,530 £1,700 £1,870 £2,040
Total Long-term Assets £20,300 £20,130 £19,960 £19,790 £19,620 £19,450 £19,280 £19,110 £18,940 £18,770 £18,600 £18,430 £18,260
Total Assets £54,650 £45,460 £54,571 £55,595 £58,736 £59,725 £61,195 £63,637 £64,279 £66,439 £68,686 £68,742 £71,900
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 £9,500 £2,611 £9,008 £8,702 £9,703 £9,070 £9,031 £9,503 £8,806 £8,880 £8,975 £8,089 £9,267
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 £9,500 £2,611 £9,008 £8,702 £9,703 £9,070 £9,031 £9,503 £8,806 £8,880 £8,975 £8,089 £9,267
Long-term Liabilities £25,000 £24,500 £24,000 £23,500 £23,000 £22,500 £22,000 £21,500 £21,000 £20,500 £20,000 £19,500 £19,000
Total Liabilities £34,500 £27,111 £33,008 £32,202 £32,703 £31,570 £31,031 £31,003 £29,806 £29,380 £28,975 £27,589 £28,267
Paid-in Capital £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000 £46,000
Retained Earnings (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850) (£25,850)
Earnings £0 (£1,801) £1,412 £3,243 £5,883 £8,005 £10,014 £12,484 £14,323 £16,909 £19,561 £21,003 £23,483
Total Capital £20,150 £18,349 £21,562 £23,393 £26,033 £28,155 £30,164 £32,634 £34,473 £37,059 £39,711 £41,153 £43,633
Total Liabilities and Capital £54,650 £45,460 £54,571 £55,595 £58,736 £59,725 £61,195 £63,637 £64,279 £66,439 £68,686 £68,742 £71,900
Net Worth £20,150 £18,349 £21,562 £23,393 £26,033 £28,155 £30,164 £32,634 £34,473 £37,059 £39,711 £41,153 £43,633