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

Driving School Business Plan

Markam Driving School

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
Adult drivers 0% £14,000 £14,000 £14,000 £14,000 £14,000 £20,000 £20,000 £20,000 £24,000 £25,000 £21,000 £23,000
Beginner drivers 0% £18,000 £18,000 £18,000 £18,000 £18,000 £24,000 £24,000 £24,000 £28,000 £26,000 £33,000 £36,000
Drivers under court order 0% £11,500 £11,500 £11,500 £11,500 £11,500 £14,000 £14,000 £14,000 £17,000 £18,000 £18,888 £18,000
High schools 0% £20,850 £20,850 £20,850 £20,850 £20,850 £25,000 £25,000 £25,000 £41,700 £41,700 £31,000 £31,000
Commercial drivers 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Sales £64,350 £64,350 £64,350 £64,350 £64,350 £83,000 £83,000 £83,000 £110,700 £110,700 £103,888 £108,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Adult drivers £5,600 £5,600 £5,600 £5,600 £5,600 £8,000 £8,000 £8,000 £9,600 £10,000 £8,400 £9,200
Beginner drivers £7,200 £7,200 £7,200 £7,200 £7,200 £9,600 £9,600 £9,600 £11,200 £10,400 £13,200 £14,400
Drivers under court order £4,600 £4,600 £4,600 £4,600 £4,600 £5,600 £5,600 £5,600 £6,800 £7,200 £7,555 £7,200
High schools £8,340 £8,340 £8,340 £8,340 £8,340 £10,000 £10,000 £10,000 £16,680 £16,680 £12,400 £12,400
Commercial drivers £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Direct Cost of Sales £25,740 £25,740 £25,740 £25,740 £25,740 £33,200 £33,200 £33,200 £44,280 £44,280 £41,555 £43,200
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
President and General Manager 0% £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000
Controller 0% £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000
Education Planner 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
Education Coordinator 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
Facilities Mangers 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Office Manager 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
Marketing Executive (Contract work) 0% £1,250 £1,250 £1,250 £1,250 £1,250 £1,250 £1,250 £1,250 £1,250 £1,250 £1,250 £1,250
Educators 0% £7,500 £7,500 £7,500 £7,500 £7,500 £13,000 £13,000 £13,000 £13,000 £13,000 £13,000 £13,000
Total People 11 11 11 11 11 15 15 15 15 15 15 15
Total Payroll £24,750 £24,750 £24,750 £24,750 £24,750 £30,250 £30,250 £30,250 £30,250 £30,250 £30,250 £30,250
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% 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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales £64,350 £64,350 £64,350 £64,350 £64,350 £83,000 £83,000 £83,000 £110,700 £110,700 £103,888 £108,000
Direct Cost of Sales £25,740 £25,740 £25,740 £25,740 £25,740 £33,200 £33,200 £33,200 £44,280 £44,280 £41,555 £43,200
Other Production Expenses £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £25,740 £25,740 £25,740 £25,740 £25,740 £33,200 £33,200 £33,200 £44,280 £44,280 £41,555 £43,200
Gross Margin £38,610 £38,610 £38,610 £38,610 £38,610 £49,800 £49,800 £49,800 £66,420 £66,420 £62,333 £64,800
Gross Margin % 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00%
Expenses
Payroll £24,750 £24,750 £24,750 £24,750 £24,750 £30,250 £30,250 £30,250 £30,250 £30,250 £30,250 £30,250
Sales and Marketing and Other Expenses £2,900 £2,900 £2,900 £2,900 £2,900 £4,500 £4,500 £4,500 £6,000 £6,000 £6,000 £6,000
Depreciation £200 £200 £200 £200 £200 £200 £200 £200 £400 £400 £400 £400
Leased Equipment £0 £0 £0 £0 £0 £2,000 £2,000 £2,000 £4,000 £4,000 £4,000 £4,000
Utilities £200 £200 £200 £200 £200 £400 £400 £400 £600 £600 £600 £600
Insurance £600 £600 £600 £600 £600 £1,200 £1,200 £1,200 £1,800 £1,800 £1,800 £1,800
Rent £2,000 £2,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £6,000 £6,000 £6,000 £6,000
Payroll Taxes 15% £3,713 £3,713 £3,713 £3,713 £3,713 £4,538 £4,538 £4,538 £4,538 £4,538 £4,538 £4,538
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £34,363 £34,363 £36,363 £36,363 £36,363 £47,088 £47,088 £47,088 £53,588 £53,588 £53,588 £53,588
Profit Before Interest and Taxes £4,248 £4,248 £2,248 £2,248 £2,248 £2,713 £2,713 £2,713 £12,833 £12,833 £8,745 £11,213
EBITDA £4,448 £4,448 £2,448 £2,448 £2,448 £2,913 £2,913 £2,913 £13,233 £13,233 £9,145 £11,613
Interest Expense £188 £183 £179 £175 £171 £167 £163 £158 £154 £150 £146 £142
Taxes Incurred £1,218 £1,219 £621 £622 £623 £764 £765 £766 £3,804 £3,805 £2,580 £3,321
Net Profit £2,842 £2,845 £1,448 £1,451 £1,454 £1,782 £1,785 £1,788 £8,875 £8,878 £6,020 £7,750
Net Profit/Sales 4.42% 4.42% 2.25% 2.25% 2.26% 2.15% 2.15% 2.15% 8.02% 8.02% 5.79% 7.18%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales £64,350 £64,350 £64,350 £64,350 £64,350 £83,000 £83,000 £83,000 £110,700 £110,700 £103,888 £108,000
Subtotal Cash from Operations £64,350 £64,350 £64,350 £64,350 £64,350 £83,000 £83,000 £83,000 £110,700 £110,700 £103,888 £108,000
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 £64,350 £64,350 £64,350 £64,350 £64,350 £83,000 £83,000 £83,000 £110,700 £110,700 £103,888 £108,000
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending £24,750 £24,750 £24,750 £24,750 £24,750 £30,250 £30,250 £30,250 £30,250 £30,250 £30,250 £30,250
Bill Payments £4,935 £36,558 £36,602 £37,952 £37,949 £38,374 £50,768 £50,765 £51,443 £71,175 £71,040 £67,298
Subtotal Spent on Operations £29,685 £61,308 £61,352 £62,702 £62,699 £68,624 £81,018 £81,015 £81,693 £101,425 £101,290 £97,548
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 £30,185 £61,808 £61,852 £63,202 £63,199 £69,124 £81,518 £81,515 £82,193 £101,925 £101,790 £98,048
Net Cash Flow £34,165 £2,542 £2,498 £1,148 £1,151 £13,876 £1,482 £1,485 £28,507 £8,775 £2,098 £9,952
Cash Balance £47,103 £49,645 £52,144 £53,292 £54,443 £68,319 £69,801 £71,286 £99,794 £108,569 £110,666 £120,618
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash £12,938 £47,103 £49,645 £52,144 £53,292 £54,443 £68,319 £69,801 £71,286 £99,794 £108,569 £110,666 £120,618
Other Current Assets £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000
Total Current Assets £14,938 £49,103 £51,645 £54,144 £55,292 £56,443 £70,319 £71,801 £73,286 £101,794 £110,569 £112,666 £122,618
Long-term Assets
Long-term Assets £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000
Accumulated Depreciation £12,000 £12,200 £12,400 £12,600 £12,800 £13,000 £13,200 £13,400 £13,600 £14,000 £14,400 £14,800 £15,200
Total Long-term Assets £62,000 £61,800 £61,600 £61,400 £61,200 £61,000 £60,800 £60,600 £60,400 £60,000 £59,600 £59,200 £58,800
Total Assets £76,938 £110,903 £113,245 £115,544 £116,492 £117,443 £131,119 £132,401 £133,686 £161,794 £170,169 £171,866 £181,418
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable £3,716 £35,339 £35,337 £36,687 £36,684 £36,681 £49,076 £49,073 £49,070 £68,803 £68,800 £64,978 £67,280
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 £3,716 £35,339 £35,337 £36,687 £36,684 £36,681 £49,076 £49,073 £49,070 £68,803 £68,800 £64,978 £67,280
Long-term Liabilities £23,000 £22,500 £22,000 £21,500 £21,000 £20,500 £20,000 £19,500 £19,000 £18,500 £18,000 £17,500 £17,000
Total Liabilities £26,716 £57,839 £57,337 £58,187 £57,684 £57,181 £69,076 £68,573 £68,070 £87,303 £86,800 £82,478 £84,280
Paid-in Capital £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000
Retained Earnings £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222
Earnings £0 £2,842 £5,687 £7,135 £8,586 £10,039 £11,821 £13,606 £15,394 £24,269 £33,147 £39,166 £46,916
Total Capital £50,222 £53,064 £55,909 £57,357 £58,808 £60,261 £62,043 £63,828 £65,616 £74,491 £83,369 £89,388 £97,138
Total Liabilities and Capital £76,938 £110,903 £113,245 £115,544 £116,492 £117,443 £131,119 £132,401 £133,686 £161,794 £170,169 £171,866 £181,418
Net Worth £50,222 £53,064 £55,909 £57,357 £58,808 £60,261 £62,043 £63,828 £65,616 £74,491 £83,369 £89,388 £97,138
previous
next
Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Adult drivers 0% £14,000 £14,000 £14,000 £14,000 £14,000 £20,000 £20,000 £20,000 £24,000 £25,000 £21,000 £23,000
Beginner drivers 0% £18,000 £18,000 £18,000 £18,000 £18,000 £24,000 £24,000 £24,000 £28,000 £26,000 £33,000 £36,000
Drivers under court order 0% £11,500 £11,500 £11,500 £11,500 £11,500 £14,000 £14,000 £14,000 £17,000 £18,000 £18,888 £18,000
High schools 0% £20,850 £20,850 £20,850 £20,850 £20,850 £25,000 £25,000 £25,000 £41,700 £41,700 £31,000 £31,000
Commercial drivers 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Sales £64,350 £64,350 £64,350 £64,350 £64,350 £83,000 £83,000 £83,000 £110,700 £110,700 £103,888 £108,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Adult drivers £5,600 £5,600 £5,600 £5,600 £5,600 £8,000 £8,000 £8,000 £9,600 £10,000 £8,400 £9,200
Beginner drivers £7,200 £7,200 £7,200 £7,200 £7,200 £9,600 £9,600 £9,600 £11,200 £10,400 £13,200 £14,400
Drivers under court order £4,600 £4,600 £4,600 £4,600 £4,600 £5,600 £5,600 £5,600 £6,800 £7,200 £7,555 £7,200
High schools £8,340 £8,340 £8,340 £8,340 £8,340 £10,000 £10,000 £10,000 £16,680 £16,680 £12,400 £12,400
Commercial drivers £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Direct Cost of Sales £25,740 £25,740 £25,740 £25,740 £25,740 £33,200 £33,200 £33,200 £44,280 £44,280 £41,555 £43,200
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
President and General Manager 0% £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000
Controller 0% £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000
Education Planner 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
Education Coordinator 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
Facilities Mangers 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Office Manager 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
Marketing Executive (Contract work) 0% £1,250 £1,250 £1,250 £1,250 £1,250 £1,250 £1,250 £1,250 £1,250 £1,250 £1,250 £1,250
Educators 0% £7,500 £7,500 £7,500 £7,500 £7,500 £13,000 £13,000 £13,000 £13,000 £13,000 £13,000 £13,000
Total People 11 11 11 11 11 15 15 15 15 15 15 15
Total Payroll £24,750 £24,750 £24,750 £24,750 £24,750 £30,250 £30,250 £30,250 £30,250 £30,250 £30,250 £30,250
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% 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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales £64,350 £64,350 £64,350 £64,350 £64,350 £83,000 £83,000 £83,000 £110,700 £110,700 £103,888 £108,000
Direct Cost of Sales £25,740 £25,740 £25,740 £25,740 £25,740 £33,200 £33,200 £33,200 £44,280 £44,280 £41,555 £43,200
Other Production Expenses £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £25,740 £25,740 £25,740 £25,740 £25,740 £33,200 £33,200 £33,200 £44,280 £44,280 £41,555 £43,200
Gross Margin £38,610 £38,610 £38,610 £38,610 £38,610 £49,800 £49,800 £49,800 £66,420 £66,420 £62,333 £64,800
Gross Margin % 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00%
Expenses
Payroll £24,750 £24,750 £24,750 £24,750 £24,750 £30,250 £30,250 £30,250 £30,250 £30,250 £30,250 £30,250
Sales and Marketing and Other Expenses £2,900 £2,900 £2,900 £2,900 £2,900 £4,500 £4,500 £4,500 £6,000 £6,000 £6,000 £6,000
Depreciation £200 £200 £200 £200 £200 £200 £200 £200 £400 £400 £400 £400
Leased Equipment £0 £0 £0 £0 £0 £2,000 £2,000 £2,000 £4,000 £4,000 £4,000 £4,000
Utilities £200 £200 £200 £200 £200 £400 £400 £400 £600 £600 £600 £600
Insurance £600 £600 £600 £600 £600 £1,200 £1,200 £1,200 £1,800 £1,800 £1,800 £1,800
Rent £2,000 £2,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £6,000 £6,000 £6,000 £6,000
Payroll Taxes 15% £3,713 £3,713 £3,713 £3,713 £3,713 £4,538 £4,538 £4,538 £4,538 £4,538 £4,538 £4,538
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £34,363 £34,363 £36,363 £36,363 £36,363 £47,088 £47,088 £47,088 £53,588 £53,588 £53,588 £53,588
Profit Before Interest and Taxes £4,248 £4,248 £2,248 £2,248 £2,248 £2,713 £2,713 £2,713 £12,833 £12,833 £8,745 £11,213
EBITDA £4,448 £4,448 £2,448 £2,448 £2,448 £2,913 £2,913 £2,913 £13,233 £13,233 £9,145 £11,613
Interest Expense £188 £183 £179 £175 £171 £167 £163 £158 £154 £150 £146 £142
Taxes Incurred £1,218 £1,219 £621 £622 £623 £764 £765 £766 £3,804 £3,805 £2,580 £3,321
Net Profit £2,842 £2,845 £1,448 £1,451 £1,454 £1,782 £1,785 £1,788 £8,875 £8,878 £6,020 £7,750
Net Profit/Sales 4.42% 4.42% 2.25% 2.25% 2.26% 2.15% 2.15% 2.15% 8.02% 8.02% 5.79% 7.18%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales £64,350 £64,350 £64,350 £64,350 £64,350 £83,000 £83,000 £83,000 £110,700 £110,700 £103,888 £108,000
Subtotal Cash from Operations £64,350 £64,350 £64,350 £64,350 £64,350 £83,000 £83,000 £83,000 £110,700 £110,700 £103,888 £108,000
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 £64,350 £64,350 £64,350 £64,350 £64,350 £83,000 £83,000 £83,000 £110,700 £110,700 £103,888 £108,000
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending £24,750 £24,750 £24,750 £24,750 £24,750 £30,250 £30,250 £30,250 £30,250 £30,250 £30,250 £30,250
Bill Payments £4,935 £36,558 £36,602 £37,952 £37,949 £38,374 £50,768 £50,765 £51,443 £71,175 £71,040 £67,298
Subtotal Spent on Operations £29,685 £61,308 £61,352 £62,702 £62,699 £68,624 £81,018 £81,015 £81,693 £101,425 £101,290 £97,548
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 £30,185 £61,808 £61,852 £63,202 £63,199 £69,124 £81,518 £81,515 £82,193 £101,925 £101,790 £98,048
Net Cash Flow £34,165 £2,542 £2,498 £1,148 £1,151 £13,876 £1,482 £1,485 £28,507 £8,775 £2,098 £9,952
Cash Balance £47,103 £49,645 £52,144 £53,292 £54,443 £68,319 £69,801 £71,286 £99,794 £108,569 £110,666 £120,618
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash £12,938 £47,103 £49,645 £52,144 £53,292 £54,443 £68,319 £69,801 £71,286 £99,794 £108,569 £110,666 £120,618
Other Current Assets £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000
Total Current Assets £14,938 £49,103 £51,645 £54,144 £55,292 £56,443 £70,319 £71,801 £73,286 £101,794 £110,569 £112,666 £122,618
Long-term Assets
Long-term Assets £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000 £74,000
Accumulated Depreciation £12,000 £12,200 £12,400 £12,600 £12,800 £13,000 £13,200 £13,400 £13,600 £14,000 £14,400 £14,800 £15,200
Total Long-term Assets £62,000 £61,800 £61,600 £61,400 £61,200 £61,000 £60,800 £60,600 £60,400 £60,000 £59,600 £59,200 £58,800
Total Assets £76,938 £110,903 £113,245 £115,544 £116,492 £117,443 £131,119 £132,401 £133,686 £161,794 £170,169 £171,866 £181,418
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable £3,716 £35,339 £35,337 £36,687 £36,684 £36,681 £49,076 £49,073 £49,070 £68,803 £68,800 £64,978 £67,280
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 £3,716 £35,339 £35,337 £36,687 £36,684 £36,681 £49,076 £49,073 £49,070 £68,803 £68,800 £64,978 £67,280
Long-term Liabilities £23,000 £22,500 £22,000 £21,500 £21,000 £20,500 £20,000 £19,500 £19,000 £18,500 £18,000 £17,500 £17,000
Total Liabilities £26,716 £57,839 £57,337 £58,187 £57,684 £57,181 £69,076 £68,573 £68,070 £87,303 £86,800 £82,478 £84,280
Paid-in Capital £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000 £30,000
Retained Earnings £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222 £20,222
Earnings £0 £2,842 £5,687 £7,135 £8,586 £10,039 £11,821 £13,606 £15,394 £24,269 £33,147 £39,166 £46,916
Total Capital £50,222 £53,064 £55,909 £57,357 £58,808 £60,261 £62,043 £63,828 £65,616 £74,491 £83,369 £89,388 £97,138
Total Liabilities and Capital £76,938 £110,903 £113,245 £115,544 £116,492 £117,443 £131,119 £132,401 £133,686 £161,794 £170,169 £171,866 £181,418
Net Worth £50,222 £53,064 £55,909 £57,357 £58,808 £60,261 £62,043 £63,828 £65,616 £74,491 £83,369 £89,388 £97,138