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

Sports Bar Business Plan

Take Five Sports Bar and Grill

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

previous
next

Appendix

Sales Forecast
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Sales
Food 0% £32,130 £64,260 £67,473 £77,112 £80,325 £53,633 £80,450 £89,388 £107,266 £116,205 £125,000 £133,000
Drinks 0% £30,870 £61,740 £64,827 £74,088 £77,175 £52,749 £79,124 £87,915 £105,498 £114,290 £120,000 £130,000
Retail 0% £0 £1,000 £1,000 £1,200 £1,500 £720 £1,556 £1,729 £2,074 £2,247 £2,400 £2,500
Franchise Fees 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Sales £63,000 £127,000 £133,300 £152,400 £159,000 £107,102 £161,130 £179,032 £214,838 £232,742 £247,400 £265,500
Direct Cost of Sales Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Food £10,924 £21,848 £23,033 £26,218 £27,310 £18,235 £27,353 £30,392 £36,470 £39,510 £42,500 £45,220
Drinks £6,791 £13,523 £14,262 £16,299 £16,979 £11,605 £17,407 £19,341 £23,210 £25,144 £26,400 £28,600
Retail £0 £500 £600 £600 £750 £360 £778 £865 £1,037 £1,124 £1,200 £1,250
Franchise Fees £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Direct Cost of Sales £17,715 £35,871 £37,895 £43,117 £45,039 £30,200 £45,538 £50,598 £60,717 £65,778 £70,100 £75,070
Personnel Plan
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Total Payroll 0% £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400
Name or Title or Group 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 12 12 12 12 12 12 12 12 12 12 12 12
Total Payroll £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400
Pro Forma Profit and Loss
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Sales £63,000 £127,000 £133,300 £152,400 £159,000 £107,102 £161,130 £179,032 £214,838 £232,742 £247,400 £265,500
Direct Cost of Sales £17,715 £35,871 £37,895 £43,117 £45,039 £30,200 £45,538 £50,598 £60,717 £65,778 £70,100 £75,070
Other Costs of Sales £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £17,715 £35,871 £37,895 £43,117 £45,039 £30,200 £45,538 £50,598 £60,717 £65,778 £70,100 £75,070
Gross Margin £45,285 £91,129 £95,405 £109,283 £113,961 £76,902 £115,592 £128,434 £154,121 £166,964 £177,300 £190,430
Gross Margin % 71.88% 71.76% 71.57% 71.71% 71.67% 71.80% 71.74% 71.74% 71.74% 71.74% 71.67% 71.73%
Expenses
Payroll £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400
Marketing/Promotion £7,000 £4,500 £5,000 £4,500 £6,000 £5,500 £5,500 £6,000 £6,000 £6,500 £6,500 £6,500
Depreciation £5,833 £5,833 £5,833 £5,833 £5,833 £5,833 £5,833 £5,833 £5,833 £5,833 £5,833 £5,833
Rent £4,400 £4,400 £4,400 £4,400 £4,400 £4,400 £4,400 £4,400 £4,400 £4,400 £4,400 £4,400
Utilities £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400
Insurance £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Payroll Taxes 12% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £63,033 £60,533 £61,033 £60,533 £62,033 £61,533 £61,533 £62,033 £62,033 £62,533 £62,533 £62,533
Profit Before Interest and Taxes (£17,748) £30,596 £34,372 £48,750 £51,928 £15,369 £54,059 £66,401 £92,088 £104,431 £114,767 £127,897
EBITDA (£11,915) £36,429 £40,205 £54,583 £57,761 £21,202 £59,892 £72,234 £97,921 £110,264 £120,600 £133,730
Interest Expense £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Taxes Incurred (£5,857) £10,097 £11,343 £16,088 £17,136 £5,072 £17,839 £21,912 £30,389 £34,462 £37,873 £42,206
Net Profit (£11,891) £20,499 £23,029 £32,663 £34,792 £10,297 £36,220 £44,489 £61,699 £69,969 £76,894 £85,691
Net Profit/Sales -18.87% 16.14% 17.28% 21.43% 21.88% 9.61% 22.48% 24.85% 28.72% 30.06% 31.08% 32.28%
Pro Forma Cash Flow
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Cash Received
Cash from Operations
Cash Sales £63,000 £127,000 £133,300 £152,400 £159,000 £107,102 £161,130 £179,032 £214,838 £232,742 £247,400 £265,500
Subtotal Cash from Operations £63,000 £127,000 £133,300 £152,400 £159,000 £107,102 £161,130 £179,032 £214,838 £232,742 £247,400 £265,500
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 £625,000 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Cash Received £688,000 £127,000 £133,300 £152,400 £159,000 £107,102 £161,130 £179,032 £214,838 £232,742 £247,400 £265,500
Expenditures Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Expenditures from Operations
Cash Spending £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400
Bill Payments £21,138 £34,524 £79,773 £66,697 £79,277 £78,561 £36,292 £95,494 £94,682 £118,173 £122,338 £129,361
Subtotal Spent on Operations £61,538 £74,924 £120,173 £107,097 £119,677 £118,961 £76,692 £135,894 £135,082 £158,573 £162,738 £169,761
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 £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 £600,000 £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 £661,538 £74,924 £120,173 £107,097 £119,677 £118,961 £76,692 £135,894 £135,082 £158,573 £162,738 £169,761
Net Cash Flow £26,462 £52,076 £13,127 £45,303 £39,323 (£11,859) £84,438 £43,138 £79,756 £74,169 £84,662 £95,739
Cash Balance £93,598 £145,674 £158,800 £204,103 £243,427 £231,567 £316,005 £359,143 £438,900 £513,069 £597,731 £693,470
Pro Forma Balance Sheet
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Assets Starting Balances
Current Assets
Cash £67,136 £93,598 £145,674 £158,800 £204,103 £243,427 £231,567 £316,005 £359,143 £438,900 £513,069 £597,731 £693,470
Inventory £15,197 £19,487 £39,458 £41,685 £47,429 £49,543 £33,220 £50,092 £55,658 £66,789 £72,356 £77,110 £82,577
Other Current Assets £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310
Total Current Assets £99,643 £130,394 £202,442 £217,795 £268,842 £310,279 £282,097 £383,407 £432,111 £522,998 £602,735 £692,151 £793,357
Long-term Assets
Long-term Assets £475,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495
Accumulated Depreciation £29,713 £35,546 £41,379 £47,212 £53,045 £58,878 £64,711 £70,544 £76,377 £82,210 £88,043 £93,876 £99,709
Total Long-term Assets £445,782 £1,039,949 £1,034,116 £1,028,283 £1,022,450 £1,016,617 £1,010,784 £1,004,951 £999,118 £993,285 £987,452 £981,619 £975,786
Total Assets £545,425 £1,170,343 £1,236,558 £1,246,078 £1,291,292 £1,326,896 £1,292,881 £1,388,358 £1,431,229 £1,516,283 £1,590,187 £1,673,770 £1,769,143
Liabilities and Capital Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Current Liabilities
Accounts Payable £20,040 £31,849 £77,565 £64,055 £76,607 £77,420 £33,107 £92,364 £90,747 £114,102 £118,037 £124,726 £134,408
Current Borrowing £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Current Liabilities £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826
Subtotal Current Liabilities £60,866 £72,675 £118,391 £104,881 £117,433 £118,246 £73,933 £133,190 £131,573 £154,928 £158,863 £165,552 £175,234
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Liabilities £60,866 £72,675 £118,391 £104,881 £117,433 £118,246 £73,933 £133,190 £131,573 £154,928 £158,863 £165,552 £175,234
Paid-in Capital £625,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
Retained Earnings (£218,401) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441)
Earnings £77,960 (£11,891) £8,608 £31,637 £64,300 £99,092 £109,389 £145,608 £190,097 £251,796 £321,765 £398,659 £484,350
Total Capital £484,559 £1,097,668 £1,118,167 £1,141,196 £1,173,859 £1,208,651 £1,218,948 £1,255,167 £1,299,656 £1,361,355 £1,431,324 £1,508,218 £1,593,909
Total Liabilities and Capital £545,425 £1,170,343 £1,236,558 £1,246,078 £1,291,292 £1,326,896 £1,292,881 £1,388,358 £1,431,229 £1,516,283 £1,590,187 £1,673,770 £1,769,143
Net Worth £484,559 £1,097,668 £1,118,167 £1,141,196 £1,173,859 £1,208,651 £1,218,948 £1,255,167 £1,299,656 £1,361,355 £1,431,324 £1,508,218 £1,593,909
General Assumptions
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
previous
next
Sales Forecast
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Sales
Food 0% £32,130 £64,260 £67,473 £77,112 £80,325 £53,633 £80,450 £89,388 £107,266 £116,205 £125,000 £133,000
Drinks 0% £30,870 £61,740 £64,827 £74,088 £77,175 £52,749 £79,124 £87,915 £105,498 £114,290 £120,000 £130,000
Retail 0% £0 £1,000 £1,000 £1,200 £1,500 £720 £1,556 £1,729 £2,074 £2,247 £2,400 £2,500
Franchise Fees 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Sales £63,000 £127,000 £133,300 £152,400 £159,000 £107,102 £161,130 £179,032 £214,838 £232,742 £247,400 £265,500
Direct Cost of Sales Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Food £10,924 £21,848 £23,033 £26,218 £27,310 £18,235 £27,353 £30,392 £36,470 £39,510 £42,500 £45,220
Drinks £6,791 £13,523 £14,262 £16,299 £16,979 £11,605 £17,407 £19,341 £23,210 £25,144 £26,400 £28,600
Retail £0 £500 £600 £600 £750 £360 £778 £865 £1,037 £1,124 £1,200 £1,250
Franchise Fees £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Direct Cost of Sales £17,715 £35,871 £37,895 £43,117 £45,039 £30,200 £45,538 £50,598 £60,717 £65,778 £70,100 £75,070
Personnel Plan
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Total Payroll 0% £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400
Name or Title or Group 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 12 12 12 12 12 12 12 12 12 12 12 12
Total Payroll £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400
Pro Forma Profit and Loss
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Sales £63,000 £127,000 £133,300 £152,400 £159,000 £107,102 £161,130 £179,032 £214,838 £232,742 £247,400 £265,500
Direct Cost of Sales £17,715 £35,871 £37,895 £43,117 £45,039 £30,200 £45,538 £50,598 £60,717 £65,778 £70,100 £75,070
Other Costs of Sales £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £17,715 £35,871 £37,895 £43,117 £45,039 £30,200 £45,538 £50,598 £60,717 £65,778 £70,100 £75,070
Gross Margin £45,285 £91,129 £95,405 £109,283 £113,961 £76,902 £115,592 £128,434 £154,121 £166,964 £177,300 £190,430
Gross Margin % 71.88% 71.76% 71.57% 71.71% 71.67% 71.80% 71.74% 71.74% 71.74% 71.74% 71.67% 71.73%
Expenses
Payroll £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400
Marketing/Promotion £7,000 £4,500 £5,000 £4,500 £6,000 £5,500 £5,500 £6,000 £6,000 £6,500 £6,500 £6,500
Depreciation £5,833 £5,833 £5,833 £5,833 £5,833 £5,833 £5,833 £5,833 £5,833 £5,833 £5,833 £5,833
Rent £4,400 £4,400 £4,400 £4,400 £4,400 £4,400 £4,400 £4,400 £4,400 £4,400 £4,400 £4,400
Utilities £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400
Insurance £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Payroll Taxes 12% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £63,033 £60,533 £61,033 £60,533 £62,033 £61,533 £61,533 £62,033 £62,033 £62,533 £62,533 £62,533
Profit Before Interest and Taxes (£17,748) £30,596 £34,372 £48,750 £51,928 £15,369 £54,059 £66,401 £92,088 £104,431 £114,767 £127,897
EBITDA (£11,915) £36,429 £40,205 £54,583 £57,761 £21,202 £59,892 £72,234 £97,921 £110,264 £120,600 £133,730
Interest Expense £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Taxes Incurred (£5,857) £10,097 £11,343 £16,088 £17,136 £5,072 £17,839 £21,912 £30,389 £34,462 £37,873 £42,206
Net Profit (£11,891) £20,499 £23,029 £32,663 £34,792 £10,297 £36,220 £44,489 £61,699 £69,969 £76,894 £85,691
Net Profit/Sales -18.87% 16.14% 17.28% 21.43% 21.88% 9.61% 22.48% 24.85% 28.72% 30.06% 31.08% 32.28%
Pro Forma Cash Flow
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Cash Received
Cash from Operations
Cash Sales £63,000 £127,000 £133,300 £152,400 £159,000 £107,102 £161,130 £179,032 £214,838 £232,742 £247,400 £265,500
Subtotal Cash from Operations £63,000 £127,000 £133,300 £152,400 £159,000 £107,102 £161,130 £179,032 £214,838 £232,742 £247,400 £265,500
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 £625,000 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Cash Received £688,000 £127,000 £133,300 £152,400 £159,000 £107,102 £161,130 £179,032 £214,838 £232,742 £247,400 £265,500
Expenditures Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Expenditures from Operations
Cash Spending £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400 £40,400
Bill Payments £21,138 £34,524 £79,773 £66,697 £79,277 £78,561 £36,292 £95,494 £94,682 £118,173 £122,338 £129,361
Subtotal Spent on Operations £61,538 £74,924 £120,173 £107,097 £119,677 £118,961 £76,692 £135,894 £135,082 £158,573 £162,738 £169,761
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 £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 £600,000 £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 £661,538 £74,924 £120,173 £107,097 £119,677 £118,961 £76,692 £135,894 £135,082 £158,573 £162,738 £169,761
Net Cash Flow £26,462 £52,076 £13,127 £45,303 £39,323 (£11,859) £84,438 £43,138 £79,756 £74,169 £84,662 £95,739
Cash Balance £93,598 £145,674 £158,800 £204,103 £243,427 £231,567 £316,005 £359,143 £438,900 £513,069 £597,731 £693,470
Pro Forma Balance Sheet
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Assets Starting Balances
Current Assets
Cash £67,136 £93,598 £145,674 £158,800 £204,103 £243,427 £231,567 £316,005 £359,143 £438,900 £513,069 £597,731 £693,470
Inventory £15,197 £19,487 £39,458 £41,685 £47,429 £49,543 £33,220 £50,092 £55,658 £66,789 £72,356 £77,110 £82,577
Other Current Assets £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310 £17,310
Total Current Assets £99,643 £130,394 £202,442 £217,795 £268,842 £310,279 £282,097 £383,407 £432,111 £522,998 £602,735 £692,151 £793,357
Long-term Assets
Long-term Assets £475,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495 £1,075,495
Accumulated Depreciation £29,713 £35,546 £41,379 £47,212 £53,045 £58,878 £64,711 £70,544 £76,377 £82,210 £88,043 £93,876 £99,709
Total Long-term Assets £445,782 £1,039,949 £1,034,116 £1,028,283 £1,022,450 £1,016,617 £1,010,784 £1,004,951 £999,118 £993,285 £987,452 £981,619 £975,786
Total Assets £545,425 £1,170,343 £1,236,558 £1,246,078 £1,291,292 £1,326,896 £1,292,881 £1,388,358 £1,431,229 £1,516,283 £1,590,187 £1,673,770 £1,769,143
Liabilities and Capital Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Current Liabilities
Accounts Payable £20,040 £31,849 £77,565 £64,055 £76,607 £77,420 £33,107 £92,364 £90,747 £114,102 £118,037 £124,726 £134,408
Current Borrowing £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Current Liabilities £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826 £40,826
Subtotal Current Liabilities £60,866 £72,675 £118,391 £104,881 £117,433 £118,246 £73,933 £133,190 £131,573 £154,928 £158,863 £165,552 £175,234
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Liabilities £60,866 £72,675 £118,391 £104,881 £117,433 £118,246 £73,933 £133,190 £131,573 £154,928 £158,863 £165,552 £175,234
Paid-in Capital £625,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
Retained Earnings (£218,401) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441) (£140,441)
Earnings £77,960 (£11,891) £8,608 £31,637 £64,300 £99,092 £109,389 £145,608 £190,097 £251,796 £321,765 £398,659 £484,350
Total Capital £484,559 £1,097,668 £1,118,167 £1,141,196 £1,173,859 £1,208,651 £1,218,948 £1,255,167 £1,299,656 £1,361,355 £1,431,324 £1,508,218 £1,593,909
Total Liabilities and Capital £545,425 £1,170,343 £1,236,558 £1,246,078 £1,291,292 £1,326,896 £1,292,881 £1,388,358 £1,431,229 £1,516,283 £1,590,187 £1,673,770 £1,769,143
Net Worth £484,559 £1,097,668 £1,118,167 £1,141,196 £1,173,859 £1,208,651 £1,218,948 £1,255,167 £1,299,656 £1,361,355 £1,431,324 £1,508,218 £1,593,909
General Assumptions
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0