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

ISP Business Plan

Web Solutions, Inc.

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

previous
next

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Dialup Internet Access 0% £98,250 £98,500 £97,250 £98,250 £96,250 £96,250 £96,250 £96,250 £96,250 £96,250 £93,000 £92,250
High-bandwidth Internet Access 0% £9,250 £9,750 £9,500 £9,250 £8,750 £8,750 £8,750 £8,750 £8,750 £8,750 £7,750 £7,000
Website and Virtual Domain Hosting 0% £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750
Network Services 0% £8,000 £8,000 £7,000 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £5,000 £3,250
Server Colocation 0% £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250
Other 0% £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750
Total Sales £129,250 £130,000 £127,500 £127,500 £125,000 £125,000 £125,000 £125,000 £125,000 £125,000 £119,500 £116,250
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Dialup Internet Access £3,333 £3,333 £3,333 £3,333 £3,333 £3,333 £3,333 £3,333 £3,333 £3,333 £3,333 £3,333
High-bandwidth Internet Access £0 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000
Website and Virtual Domain Hosting £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400
Network Services £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
Server Colocation £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Other £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Subtotal Direct Cost of Sales £4,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Donald Williams 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
Amy Williams 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
Geena James 0% £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Dialup Services Manager 0% £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750
R & D Manager 0% £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
R & D Researcher 0% £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
Technical Support Personnel 0% £2,600 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600
Technical Support Personnel 0% £0 £0 £0 £0 £0 £0 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600
Total People 8 8 8 8 8 8 8 8 8 8 8 8
Total Payroll £24,350 £24,350 £24,350 £24,350 £24,350 £24,350 £26,950 £26,950 £26,950 £26,950 £26,950 £26,950
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current 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%
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 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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales £129,250 £130,000 £127,500 £127,500 £125,000 £125,000 £125,000 £125,000 £125,000 £125,000 £119,500 £116,250
Direct Cost of Sales £4,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £4,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633
Gross Margin £124,617 £123,367 £120,867 £120,867 £118,367 £118,367 £118,367 £118,367 £118,367 £118,367 £112,867 £109,617
Gross Margin % 96.42% 94.90% 94.80% 94.80% 94.69% 94.69% 94.69% 94.69% 94.69% 94.69% 94.45% 94.29%
Expenses
Payroll £24,350 £24,350 £24,350 £24,350 £24,350 £24,350 £26,950 £26,950 £26,950 £26,950 £26,950 £26,950
Sales and Marketing and Other Expenses £3,456 £3,456 £3,456 £3,456 £3,456 £3,456 £3,456 £3,456 £3,456 £3,456 £3,456 £3,456
Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Legal Fees £25 £25 £25 £25 £25 £25 £25 £25 £25 £25 £25 £25
Utilities £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300
Insurance £350 £350 £350 £350 £350 £350 £350 £350 £350 £350 £350 £350
Mortgage £5,600 £5,600 £5,600 £5,600 £5,600 £5,600 £5,600 £5,600 £5,600 £5,600 £5,600 £5,600
Payroll Taxes 15% £3,653 £3,653 £3,653 £3,653 £3,653 £3,653 £4,043 £4,043 £4,043 £4,043 £4,043 £4,043
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £37,733 £37,733 £37,733 £37,733 £37,733 £37,733 £40,723 £40,723 £40,723 £40,723 £40,723 £40,723
Profit Before Interest and Taxes £86,884 £85,634 £83,134 £83,134 £80,634 £80,634 £77,644 £77,644 £77,644 £77,644 £72,144 £68,894
EBITDA £86,884 £85,634 £83,134 £83,134 £80,634 £80,634 £77,644 £77,644 £77,644 £77,644 £72,144 £68,894
Interest Expense £5,990 £5,844 £5,698 £5,553 £5,407 £5,261 £5,115 £4,969 £4,823 £4,678 £4,532 £4,386
Taxes Incurred £24,268 £19,947 £19,359 £19,395 £18,807 £18,843 £18,132 £18,169 £18,205 £18,242 £16,903 £16,127
Net Profit £56,626 £59,842 £58,077 £58,186 £56,420 £56,530 £54,397 £54,506 £54,615 £54,725 £50,709 £48,381
Net Profit/Sales 43.81% 46.03% 45.55% 45.64% 45.14% 45.22% 43.52% 43.60% 43.69% 43.78% 42.43% 41.62%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales £109,863 £110,500 £108,375 £108,375 £106,250 £106,250 £106,250 £106,250 £106,250 £106,250 £101,575 £98,813
Cash from Receivables £11,750 £12,396 £19,391 £19,488 £19,125 £19,113 £18,750 £18,750 £18,750 £18,750 £18,750 £18,723
Subtotal Cash from Operations £121,613 £122,896 £127,766 £127,863 £125,375 £125,363 £125,000 £125,000 £125,000 £125,000 £120,325 £117,535
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 £121,613 £122,896 £127,766 £127,863 £125,375 £125,363 £125,000 £125,000 £125,000 £125,000 £120,325 £117,535
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending £24,350 £24,350 £24,350 £24,350 £24,350 £24,350 £26,950 £26,950 £26,950 £26,950 £26,950 £26,950
Bill Payments £72,297 £48,192 £45,783 £45,070 £44,940 £44,226 £44,105 £43,650 £43,540 £43,431 £43,276 £41,810
Subtotal Spent on Operations £96,647 £72,542 £70,133 £69,420 £69,290 £68,576 £71,055 £70,600 £70,490 £70,381 £70,226 £68,760
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 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
Other Liabilities Principal Repayment £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Long-term Liabilities Principal Repayment £12,500 £12,500 £12,500 £12,500 £12,500 £12,500 £12,500 £12,500 £12,500 £12,500 £12,500 £12,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 £114,147 £90,042 £87,633 £86,920 £86,790 £86,076 £88,555 £88,100 £87,990 £87,881 £87,726 £86,260
Net Cash Flow £7,466 £32,854 £40,133 £40,943 £38,585 £39,286 £36,445 £36,900 £37,010 £37,119 £32,599 £31,275
Cash Balance £120,078 £152,932 £193,065 £234,008 £272,593 £311,880 £348,325 £385,225 £422,235 £459,354 £491,953 £523,228
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash £112,613 £120,078 £152,932 £193,065 £234,008 £272,593 £311,880 £348,325 £385,225 £422,235 £459,354 £491,953 £523,228
Accounts Receivable £23,500 £31,138 £38,241 £37,975 £37,613 £37,238 £36,875 £36,875 £36,875 £36,875 £36,875 £36,050 £34,765
Other Current Assets £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650
Total Current Assets £170,763 £185,866 £225,824 £265,690 £306,271 £344,481 £383,405 £419,850 £456,750 £493,760 £530,879 £562,653 £592,643
Long-term Assets
Long-term Assets £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650
Accumulated Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Long-term Assets £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650
Total Assets £502,413 £517,516 £557,474 £597,340 £637,921 £676,131 £715,055 £751,500 £788,400 £825,410 £862,529 £894,303 £924,293
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable £70,688 £46,665 £44,281 £43,571 £43,465 £42,755 £42,650 £42,198 £42,093 £41,987 £41,881 £40,446 £39,555
Current Borrowing £90,337 £85,337 £80,337 £75,337 £70,337 £65,337 £60,337 £55,337 £50,337 £45,337 £40,337 £35,337 £30,337
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £161,025 £132,002 £124,618 £118,908 £113,802 £108,092 £102,987 £97,535 £92,430 £87,324 £82,218 £75,783 £69,892
Long-term Liabilities £645,975 £633,475 £620,975 £608,475 £595,975 £583,475 £570,975 £558,475 £545,975 £533,475 £520,975 £508,475 £495,975
Total Liabilities £807,000 £765,477 £745,593 £727,383 £709,777 £691,567 £673,962 £656,010 £638,405 £620,799 £603,193 £584,258 £565,867
Paid-in Capital £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Retained Earnings (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587)
Earnings £0 £56,626 £116,468 £174,544 £232,730 £289,151 £345,680 £400,077 £454,583 £509,198 £563,923 £614,632 £663,013
Total Capital (£304,587) (£247,961) (£188,119) (£130,043) (£71,857) (£15,436) £41,093 £95,490 £149,996 £204,611 £259,336 £310,045 £358,426
Total Liabilities and Capital £502,413 £517,516 £557,474 £597,340 £637,921 £676,131 £715,055 £751,500 £788,400 £825,410 £862,529 £894,303 £924,293
Net Worth (£304,587) (£247,961) (£188,119) (£130,043) (£71,857) (£15,436) £41,093 £95,490 £149,996 £204,611 £259,336 £310,045 £358,426
previous
next
Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Dialup Internet Access 0% £98,250 £98,500 £97,250 £98,250 £96,250 £96,250 £96,250 £96,250 £96,250 £96,250 £93,000 £92,250
High-bandwidth Internet Access 0% £9,250 £9,750 £9,500 £9,250 £8,750 £8,750 £8,750 £8,750 £8,750 £8,750 £7,750 £7,000
Website and Virtual Domain Hosting 0% £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750
Network Services 0% £8,000 £8,000 £7,000 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £5,000 £3,250
Server Colocation 0% £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250
Other 0% £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750
Total Sales £129,250 £130,000 £127,500 £127,500 £125,000 £125,000 £125,000 £125,000 £125,000 £125,000 £119,500 £116,250
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Dialup Internet Access £3,333 £3,333 £3,333 £3,333 £3,333 £3,333 £3,333 £3,333 £3,333 £3,333 £3,333 £3,333
High-bandwidth Internet Access £0 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000
Website and Virtual Domain Hosting £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400
Network Services £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
Server Colocation £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Other £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Subtotal Direct Cost of Sales £4,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Donald Williams 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
Amy Williams 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
Geena James 0% £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Dialup Services Manager 0% £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750 £3,750
R & D Manager 0% £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
R & D Researcher 0% £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
Technical Support Personnel 0% £2,600 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600
Technical Support Personnel 0% £0 £0 £0 £0 £0 £0 £2,600 £2,600 £2,600 £2,600 £2,600 £2,600
Total People 8 8 8 8 8 8 8 8 8 8 8 8
Total Payroll £24,350 £24,350 £24,350 £24,350 £24,350 £24,350 £26,950 £26,950 £26,950 £26,950 £26,950 £26,950
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current 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%
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 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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales £129,250 £130,000 £127,500 £127,500 £125,000 £125,000 £125,000 £125,000 £125,000 £125,000 £119,500 £116,250
Direct Cost of Sales £4,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £4,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633 £6,633
Gross Margin £124,617 £123,367 £120,867 £120,867 £118,367 £118,367 £118,367 £118,367 £118,367 £118,367 £112,867 £109,617
Gross Margin % 96.42% 94.90% 94.80% 94.80% 94.69% 94.69% 94.69% 94.69% 94.69% 94.69% 94.45% 94.29%
Expenses
Payroll £24,350 £24,350 £24,350 £24,350 £24,350 £24,350 £26,950 £26,950 £26,950 £26,950 £26,950 £26,950
Sales and Marketing and Other Expenses £3,456 £3,456 £3,456 £3,456 £3,456 £3,456 £3,456 £3,456 £3,456 £3,456 £3,456 £3,456
Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Legal Fees £25 £25 £25 £25 £25 £25 £25 £25 £25 £25 £25 £25
Utilities £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300
Insurance £350 £350 £350 £350 £350 £350 £350 £350 £350 £350 £350 £350
Mortgage £5,600 £5,600 £5,600 £5,600 £5,600 £5,600 £5,600 £5,600 £5,600 £5,600 £5,600 £5,600
Payroll Taxes 15% £3,653 £3,653 £3,653 £3,653 £3,653 £3,653 £4,043 £4,043 £4,043 £4,043 £4,043 £4,043
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £37,733 £37,733 £37,733 £37,733 £37,733 £37,733 £40,723 £40,723 £40,723 £40,723 £40,723 £40,723
Profit Before Interest and Taxes £86,884 £85,634 £83,134 £83,134 £80,634 £80,634 £77,644 £77,644 £77,644 £77,644 £72,144 £68,894
EBITDA £86,884 £85,634 £83,134 £83,134 £80,634 £80,634 £77,644 £77,644 £77,644 £77,644 £72,144 £68,894
Interest Expense £5,990 £5,844 £5,698 £5,553 £5,407 £5,261 £5,115 £4,969 £4,823 £4,678 £4,532 £4,386
Taxes Incurred £24,268 £19,947 £19,359 £19,395 £18,807 £18,843 £18,132 £18,169 £18,205 £18,242 £16,903 £16,127
Net Profit £56,626 £59,842 £58,077 £58,186 £56,420 £56,530 £54,397 £54,506 £54,615 £54,725 £50,709 £48,381
Net Profit/Sales 43.81% 46.03% 45.55% 45.64% 45.14% 45.22% 43.52% 43.60% 43.69% 43.78% 42.43% 41.62%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales £109,863 £110,500 £108,375 £108,375 £106,250 £106,250 £106,250 £106,250 £106,250 £106,250 £101,575 £98,813
Cash from Receivables £11,750 £12,396 £19,391 £19,488 £19,125 £19,113 £18,750 £18,750 £18,750 £18,750 £18,750 £18,723
Subtotal Cash from Operations £121,613 £122,896 £127,766 £127,863 £125,375 £125,363 £125,000 £125,000 £125,000 £125,000 £120,325 £117,535
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 £121,613 £122,896 £127,766 £127,863 £125,375 £125,363 £125,000 £125,000 £125,000 £125,000 £120,325 £117,535
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending £24,350 £24,350 £24,350 £24,350 £24,350 £24,350 £26,950 £26,950 £26,950 £26,950 £26,950 £26,950
Bill Payments £72,297 £48,192 £45,783 £45,070 £44,940 £44,226 £44,105 £43,650 £43,540 £43,431 £43,276 £41,810
Subtotal Spent on Operations £96,647 £72,542 £70,133 £69,420 £69,290 £68,576 £71,055 £70,600 £70,490 £70,381 £70,226 £68,760
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 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
Other Liabilities Principal Repayment £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Long-term Liabilities Principal Repayment £12,500 £12,500 £12,500 £12,500 £12,500 £12,500 £12,500 £12,500 £12,500 £12,500 £12,500 £12,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 £114,147 £90,042 £87,633 £86,920 £86,790 £86,076 £88,555 £88,100 £87,990 £87,881 £87,726 £86,260
Net Cash Flow £7,466 £32,854 £40,133 £40,943 £38,585 £39,286 £36,445 £36,900 £37,010 £37,119 £32,599 £31,275
Cash Balance £120,078 £152,932 £193,065 £234,008 £272,593 £311,880 £348,325 £385,225 £422,235 £459,354 £491,953 £523,228
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash £112,613 £120,078 £152,932 £193,065 £234,008 £272,593 £311,880 £348,325 £385,225 £422,235 £459,354 £491,953 £523,228
Accounts Receivable £23,500 £31,138 £38,241 £37,975 £37,613 £37,238 £36,875 £36,875 £36,875 £36,875 £36,875 £36,050 £34,765
Other Current Assets £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650 £34,650
Total Current Assets £170,763 £185,866 £225,824 £265,690 £306,271 £344,481 £383,405 £419,850 £456,750 £493,760 £530,879 £562,653 £592,643
Long-term Assets
Long-term Assets £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650
Accumulated Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Long-term Assets £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650 £331,650
Total Assets £502,413 £517,516 £557,474 £597,340 £637,921 £676,131 £715,055 £751,500 £788,400 £825,410 £862,529 £894,303 £924,293
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable £70,688 £46,665 £44,281 £43,571 £43,465 £42,755 £42,650 £42,198 £42,093 £41,987 £41,881 £40,446 £39,555
Current Borrowing £90,337 £85,337 £80,337 £75,337 £70,337 £65,337 £60,337 £55,337 £50,337 £45,337 £40,337 £35,337 £30,337
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £161,025 £132,002 £124,618 £118,908 £113,802 £108,092 £102,987 £97,535 £92,430 £87,324 £82,218 £75,783 £69,892
Long-term Liabilities £645,975 £633,475 £620,975 £608,475 £595,975 £583,475 £570,975 £558,475 £545,975 £533,475 £520,975 £508,475 £495,975
Total Liabilities £807,000 £765,477 £745,593 £727,383 £709,777 £691,567 £673,962 £656,010 £638,405 £620,799 £603,193 £584,258 £565,867
Paid-in Capital £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Retained Earnings (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587) (£304,587)
Earnings £0 £56,626 £116,468 £174,544 £232,730 £289,151 £345,680 £400,077 £454,583 £509,198 £563,923 £614,632 £663,013
Total Capital (£304,587) (£247,961) (£188,119) (£130,043) (£71,857) (£15,436) £41,093 £95,490 £149,996 £204,611 £259,336 £310,045 £358,426
Total Liabilities and Capital £502,413 £517,516 £557,474 £597,340 £637,921 £676,131 £715,055 £751,500 £788,400 £825,410 £862,529 £894,303 £924,293
Net Worth (£304,587) (£247,961) (£188,119) (£130,043) (£71,857) (£15,436) £41,093 £95,490 £149,996 £204,611 £259,336 £310,045 £358,426