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

Car Wash Self-service Business Plan

Auto Paradise

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
Laser Car Wash Sales 0% £11,596 £11,596 £19,961 £19,961 £19,961 £19,961 £19,961 £19,961 £19,961 £19,961 £19,961 £19,961
Self-Serve Revenue 0% £3,000 £3,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000
Vacuum / Vending Sales 0% £730 £730 £1,298 £1,298 £1,298 £1,298 £1,298 £1,298 £1,298 £1,298 £1,298 £1,298
ATM Revenue 0% £50 £50 £100 £100 £100 £100 £100 £100 £100 £100 £96 £100
RO Water Sales 0% £500 £500 £750 £750 £750 £750 £750 £750 £750 £750 £750 £750
Total Sales £15,876 £15,876 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,105 £28,109
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
Laser Car Wash Sales £2,609 £2,609 £4,491 £4,491 £4,491 £4,491 £4,491 £4,491 £4,491 £4,491 £4,491 £4,491
Self-Serve Revenue £333 £333 £667 £667 £667 £667 £667 £667 £667 £667 £667 £667
Vacuum / Vending Sales £146 £146 £260 £260 £260 £206 £260 £260 £260 £260 £260 £260
ATM Revenue £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
RO Water Sales £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Direct Cost of Sales £3,088 £3,088 £5,417 £5,417 £5,417 £5,364 £5,417 £5,417 £5,417 £5,417 £5,417 £5,417
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
2 Attendants, 1st site 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
Manager, 1st site (Owner) 0% £0 £0 £0 £0 £0 £0 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
2 Attentants, 2nd site 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Manager, 2nd site (Owner) 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
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 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50%
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% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.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 £15,876 £15,876 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,105 £28,109
Direct Cost of Sales £3,088 £3,088 £5,417 £5,417 £5,417 £5,364 £5,417 £5,417 £5,417 £5,417 £5,417 £5,417
Other Production Expenses £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £3,088 £3,088 £5,417 £5,417 £5,417 £5,364 £5,417 £5,417 £5,417 £5,417 £5,417 £5,417
Gross Margin £12,787 £12,787 £22,692 £22,692 £22,692 £22,745 £22,692 £22,692 £22,692 £22,692 £22,688 £22,692
Gross Margin % 80.55% 80.55% 80.73% 80.73% 80.73% 80.92% 80.73% 80.73% 80.73% 80.73% 80.72% 80.73%
Expenses
Payroll £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
Sales and Marketing and Other Expenses £1,450 £1,450 £1,450 £1,450 £1,450 £1,450 £1,450 £1,450 £1,450 £1,450 £1,450 £1,450
Depreciation £6,264 £6,264 £6,264 £6,264 £6,264 £6,264 £6,264 £6,264 £6,264 £6,264 £6,264 £6,264
Accounting / Legal £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Dumpster / Telephone / Pager £125 £125 £125 £125 £125 £125 £125 £125 £125 £125 £125 £125
Insurance £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150
Repairs / Maintenance £850 £850 £850 £850 £850 £850 £850 £850 £850 £850 £850 £850
Payroll Taxes 15% £300 £300 £300 £300 £300 £300 £750 £750 £750 £750 £750 £750
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £11,239 £11,239 £11,239 £11,239 £11,239 £11,239 £14,689 £14,689 £14,689 £14,689 £14,689 £14,689
Profit Before Interest and Taxes £1,548 £1,548 £11,453 £11,453 £11,453 £11,506 £8,003 £8,003 £8,003 £8,003 £7,999 £8,003
EBITDA £7,812 £7,812 £17,717 £17,717 £17,717 £17,770 £14,267 £14,267 £14,267 £14,267 £14,263 £14,267
Interest Expense £4,662 £4,656 £4,651 £4,646 £4,641 £4,636 £4,631 £4,626 £4,621 £4,616 £4,611 £4,606
Taxes Incurred (£934) (£622) £1,360 £1,361 £1,362 £1,374 £674 £675 £676 £677 £678 £679
Net Profit (£2,179) (£2,486) £5,441 £5,445 £5,449 £5,496 £2,697 £2,701 £2,705 £2,710 £2,710 £2,718
Net Profit/Sales -13.73% -15.66% 19.36% 19.37% 19.39% 19.55% 9.60% 9.61% 9.62% 9.64% 9.64% 9.67%
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 £15,876 £15,876 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,105 £28,109
Subtotal Cash from Operations £15,876 £15,876 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,105 £28,109
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 £15,876 £15,876 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,105 £28,109
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 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
Bill Payments £326 £9,801 £10,242 £14,404 £14,400 £14,394 £14,342 £14,148 £14,144 £14,139 £14,135 £14,131
Subtotal Spent on Operations £2,326 £11,801 £12,242 £16,404 £16,400 £16,394 £19,342 £19,148 £19,144 £19,139 £19,135 £19,131
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 £764 £764 £764 £764 £764 £764 £764 £764 £764 £764 £764 £764
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 £65,000
Subtotal Cash Spent £3,090 £12,565 £13,006 £17,168 £17,164 £17,158 £20,106 £19,912 £19,908 £19,903 £19,899 £84,895
Net Cash Flow £12,785 £3,311 £15,103 £10,941 £10,945 £10,951 £8,003 £8,197 £8,201 £8,206 £8,206 (£56,786)
Cash Balance £107,285 £110,596 £125,699 £136,640 £147,586 £158,536 £166,539 £174,737 £182,938 £191,144 £199,349 £142,564
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 £94,500 £107,285 £110,596 £125,699 £136,640 £147,586 £158,536 £166,539 £174,737 £182,938 £191,144 £199,349 £142,564
Other Current Assets £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Current Assets £94,500 £107,285 £110,596 £125,699 £136,640 £147,586 £158,536 £166,539 £174,737 £182,938 £191,144 £199,349 £142,564
Long-term Assets
Long-term Assets £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000
Accumulated Depreciation £0 £6,264 £12,528 £18,792 £25,056 £31,320 £37,584 £43,848 £50,112 £56,376 £62,640 £68,904 £75,168
Total Long-term Assets £799,000 £792,736 £786,472 £780,208 £773,944 £767,680 £761,416 £755,152 £748,888 £742,624 £736,360 £730,096 £723,832
Total Assets £893,500 £900,021 £897,068 £905,907 £910,584 £915,266 £919,952 £921,691 £923,625 £925,562 £927,504 £929,445 £866,396
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 £9,465 £9,762 £13,924 £13,920 £13,916 £13,871 £13,676 £13,672 £13,668 £13,664 £13,660 £13,656
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 £0 £9,465 £9,762 £13,924 £13,920 £13,916 £13,871 £13,676 £13,672 £13,668 £13,664 £13,660 £13,656
Long-term Liabilities £700,000 £699,236 £698,472 £697,708 £696,944 £696,180 £695,416 £694,652 £693,888 £693,124 £692,360 £691,596 £690,832
Total Liabilities £700,000 £708,701 £708,234 £711,632 £710,864 £710,096 £709,287 £708,328 £707,560 £706,792 £706,024 £705,256 £704,488
Paid-in Capital £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000
Retained Earnings (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£105,500)
Earnings £0 (£2,179) (£4,666) £775 £6,220 £11,670 £17,166 £19,863 £22,564 £25,270 £27,979 £30,690 £33,407
Total Capital £193,500 £191,321 £188,834 £194,275 £199,720 £205,170 £210,666 £213,363 £216,064 £218,770 £221,479 £224,190 £161,907
Total Liabilities and Capital £893,500 £900,021 £897,068 £905,907 £910,584 £915,266 £919,952 £921,691 £923,625 £925,562 £927,504 £929,445 £866,396
Net Worth £193,500 £191,321 £188,834 £194,275 £199,720 £205,170 £210,666 £213,363 £216,064 £218,770 £221,479 £224,190 £161,907
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
Laser Car Wash Sales 0% £11,596 £11,596 £19,961 £19,961 £19,961 £19,961 £19,961 £19,961 £19,961 £19,961 £19,961 £19,961
Self-Serve Revenue 0% £3,000 £3,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000
Vacuum / Vending Sales 0% £730 £730 £1,298 £1,298 £1,298 £1,298 £1,298 £1,298 £1,298 £1,298 £1,298 £1,298
ATM Revenue 0% £50 £50 £100 £100 £100 £100 £100 £100 £100 £100 £96 £100
RO Water Sales 0% £500 £500 £750 £750 £750 £750 £750 £750 £750 £750 £750 £750
Total Sales £15,876 £15,876 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,105 £28,109
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
Laser Car Wash Sales £2,609 £2,609 £4,491 £4,491 £4,491 £4,491 £4,491 £4,491 £4,491 £4,491 £4,491 £4,491
Self-Serve Revenue £333 £333 £667 £667 £667 £667 £667 £667 £667 £667 £667 £667
Vacuum / Vending Sales £146 £146 £260 £260 £260 £206 £260 £260 £260 £260 £260 £260
ATM Revenue £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
RO Water Sales £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Direct Cost of Sales £3,088 £3,088 £5,417 £5,417 £5,417 £5,364 £5,417 £5,417 £5,417 £5,417 £5,417 £5,417
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
2 Attendants, 1st site 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
Manager, 1st site (Owner) 0% £0 £0 £0 £0 £0 £0 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
2 Attentants, 2nd site 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Manager, 2nd site (Owner) 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
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 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50%
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% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.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 £15,876 £15,876 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,105 £28,109
Direct Cost of Sales £3,088 £3,088 £5,417 £5,417 £5,417 £5,364 £5,417 £5,417 £5,417 £5,417 £5,417 £5,417
Other Production Expenses £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £3,088 £3,088 £5,417 £5,417 £5,417 £5,364 £5,417 £5,417 £5,417 £5,417 £5,417 £5,417
Gross Margin £12,787 £12,787 £22,692 £22,692 £22,692 £22,745 £22,692 £22,692 £22,692 £22,692 £22,688 £22,692
Gross Margin % 80.55% 80.55% 80.73% 80.73% 80.73% 80.92% 80.73% 80.73% 80.73% 80.73% 80.72% 80.73%
Expenses
Payroll £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
Sales and Marketing and Other Expenses £1,450 £1,450 £1,450 £1,450 £1,450 £1,450 £1,450 £1,450 £1,450 £1,450 £1,450 £1,450
Depreciation £6,264 £6,264 £6,264 £6,264 £6,264 £6,264 £6,264 £6,264 £6,264 £6,264 £6,264 £6,264
Accounting / Legal £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Dumpster / Telephone / Pager £125 £125 £125 £125 £125 £125 £125 £125 £125 £125 £125 £125
Insurance £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150
Repairs / Maintenance £850 £850 £850 £850 £850 £850 £850 £850 £850 £850 £850 £850
Payroll Taxes 15% £300 £300 £300 £300 £300 £300 £750 £750 £750 £750 £750 £750
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £11,239 £11,239 £11,239 £11,239 £11,239 £11,239 £14,689 £14,689 £14,689 £14,689 £14,689 £14,689
Profit Before Interest and Taxes £1,548 £1,548 £11,453 £11,453 £11,453 £11,506 £8,003 £8,003 £8,003 £8,003 £7,999 £8,003
EBITDA £7,812 £7,812 £17,717 £17,717 £17,717 £17,770 £14,267 £14,267 £14,267 £14,267 £14,263 £14,267
Interest Expense £4,662 £4,656 £4,651 £4,646 £4,641 £4,636 £4,631 £4,626 £4,621 £4,616 £4,611 £4,606
Taxes Incurred (£934) (£622) £1,360 £1,361 £1,362 £1,374 £674 £675 £676 £677 £678 £679
Net Profit (£2,179) (£2,486) £5,441 £5,445 £5,449 £5,496 £2,697 £2,701 £2,705 £2,710 £2,710 £2,718
Net Profit/Sales -13.73% -15.66% 19.36% 19.37% 19.39% 19.55% 9.60% 9.61% 9.62% 9.64% 9.64% 9.67%
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 £15,876 £15,876 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,105 £28,109
Subtotal Cash from Operations £15,876 £15,876 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,105 £28,109
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 £15,876 £15,876 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,109 £28,105 £28,109
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 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
Bill Payments £326 £9,801 £10,242 £14,404 £14,400 £14,394 £14,342 £14,148 £14,144 £14,139 £14,135 £14,131
Subtotal Spent on Operations £2,326 £11,801 £12,242 £16,404 £16,400 £16,394 £19,342 £19,148 £19,144 £19,139 £19,135 £19,131
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 £764 £764 £764 £764 £764 £764 £764 £764 £764 £764 £764 £764
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 £65,000
Subtotal Cash Spent £3,090 £12,565 £13,006 £17,168 £17,164 £17,158 £20,106 £19,912 £19,908 £19,903 £19,899 £84,895
Net Cash Flow £12,785 £3,311 £15,103 £10,941 £10,945 £10,951 £8,003 £8,197 £8,201 £8,206 £8,206 (£56,786)
Cash Balance £107,285 £110,596 £125,699 £136,640 £147,586 £158,536 £166,539 £174,737 £182,938 £191,144 £199,349 £142,564
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 £94,500 £107,285 £110,596 £125,699 £136,640 £147,586 £158,536 £166,539 £174,737 £182,938 £191,144 £199,349 £142,564
Other Current Assets £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Current Assets £94,500 £107,285 £110,596 £125,699 £136,640 £147,586 £158,536 £166,539 £174,737 £182,938 £191,144 £199,349 £142,564
Long-term Assets
Long-term Assets £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000 £799,000
Accumulated Depreciation £0 £6,264 £12,528 £18,792 £25,056 £31,320 £37,584 £43,848 £50,112 £56,376 £62,640 £68,904 £75,168
Total Long-term Assets £799,000 £792,736 £786,472 £780,208 £773,944 £767,680 £761,416 £755,152 £748,888 £742,624 £736,360 £730,096 £723,832
Total Assets £893,500 £900,021 £897,068 £905,907 £910,584 £915,266 £919,952 £921,691 £923,625 £925,562 £927,504 £929,445 £866,396
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 £9,465 £9,762 £13,924 £13,920 £13,916 £13,871 £13,676 £13,672 £13,668 £13,664 £13,660 £13,656
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 £0 £9,465 £9,762 £13,924 £13,920 £13,916 £13,871 £13,676 £13,672 £13,668 £13,664 £13,660 £13,656
Long-term Liabilities £700,000 £699,236 £698,472 £697,708 £696,944 £696,180 £695,416 £694,652 £693,888 £693,124 £692,360 £691,596 £690,832
Total Liabilities £700,000 £708,701 £708,234 £711,632 £710,864 £710,096 £709,287 £708,328 £707,560 £706,792 £706,024 £705,256 £704,488
Paid-in Capital £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000 £234,000
Retained Earnings (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£40,500) (£105,500)
Earnings £0 (£2,179) (£4,666) £775 £6,220 £11,670 £17,166 £19,863 £22,564 £25,270 £27,979 £30,690 £33,407
Total Capital £193,500 £191,321 £188,834 £194,275 £199,720 £205,170 £210,666 £213,363 £216,064 £218,770 £221,479 £224,190 £161,907
Total Liabilities and Capital £893,500 £900,021 £897,068 £905,907 £910,584 £915,266 £919,952 £921,691 £923,625 £925,562 £927,504 £929,445 £866,396
Net Worth £193,500 £191,321 £188,834 £194,275 £199,720 £205,170 £210,666 £213,363 £216,064 £218,770 £221,479 £224,190 £161,907