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

Real Estate Brokerage Business Plan

RJ Wagner and Assoc. Realty

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
Agent Sales - 25% To Company 0% £0 £2,375 £8,125 £11,250 £4,500 £4,500 £4,500 £3,375 £3,375 £12,375 £14,625 £14,625
Broker Sales - 100% To Company 0% £3,389 £3,731 £6,750 £0 £3,375 £3,375 £3,375 £0 £0 £4,500 £7,875 £7,875
Photo Service - 100% To Company 0% £0 £480 £480 £480 £480 £480 £480 £480 £480 £480 £480 £480
Referrals - 25% Agent/25% Company 0% £187 £187 £187 £187 £187 £187 £187 £187 £187 £187 £187 £187
Total Sales £3,576 £6,773 £15,542 £11,917 £8,542 £8,542 £8,542 £4,042 £4,042 £17,542 £23,167 £23,167
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
Agent Sales - 25% To Company £0 £238 £813 £1,125 £450 £450 £450 £338 £338 £1,238 £1,463 £1,463
Broker Sales - 100% To Company £339 £373 £675 £1,350 £675 £1,350 £675 £1,350 £1,350 £1,350 £675 £675
Photo Service - 100% To Company £0 £40 £40 £40 £40 £40 £40 £40 £40 £40 £40 £40
Referrals - 25% Agent/25% Company £0 £30 £30 £30 £30 £30 £30 £30 £30 £30 £30 £30
Subtotal Direct Cost of Sales £339 £681 £1,558 £2,545 £1,195 £1,870 £1,195 £1,758 £1,758 £2,658 £2,208 £2,208
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
Wagner 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
Other 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,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 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
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 £3,576 £6,773 £15,542 £11,917 £8,542 £8,542 £8,542 £4,042 £4,042 £17,542 £23,167 £23,167
Direct Cost of Sales £339 £681 £1,558 £2,545 £1,195 £1,870 £1,195 £1,758 £1,758 £2,658 £2,208 £2,208
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £339 £681 £1,558 £2,545 £1,195 £1,870 £1,195 £1,758 £1,758 £2,658 £2,208 £2,208
Gross Margin £3,237 £6,093 £13,985 £9,372 £7,347 £6,672 £7,347 £2,285 £2,285 £14,885 £20,960 £20,960
Gross Margin % 90.52% 89.95% 89.98% 78.64% 86.01% 78.11% 86.01% 56.52% 56.52% 84.85% 90.47% 90.47%
Expenses
Payroll £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Marketing/Promotion £200 £200 £600 £700 £1,000 £700 £700 £900 £700 £700 £1,000 £700
Depreciation £150 £150 £150 £150 £125 £90 £75 £75 £75 £75 £75 £80
Utilities £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150
Rent £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300
Insurance £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150
Office Supplies £100 £100 £200 £200 £300 £300 £300 £300 £300 £300 £300 £300
Business Software £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £1,000
Leased Equipment £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Payroll Taxes 15% £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 £5,300 £5,300 £5,800 £5,900 £6,275 £5,940 £5,925 £6,125 £5,925 £5,925 £6,225 £6,930
Profit Before Interest and Taxes (£2,063) £793 £8,185 £3,472 £1,072 £732 £1,422 (£3,841) (£3,641) £8,960 £14,735 £14,030
EBITDA (£1,913) £943 £8,335 £3,622 £1,197 £822 £1,497 (£3,766) (£3,566) £9,035 £14,810 £14,110
Interest Expense £4 £8 £13 £17 £21 £25 £29 £33 £38 £42 £46 £50
Taxes Incurred (£620) £196 £2,043 £864 £263 £177 £348 (£968) (£920) £2,229 £3,672 £3,495
Net Profit (£1,447) £588 £6,129 £2,592 £788 £530 £1,045 (£2,905) (£2,759) £6,688 £11,017 £10,485
Net Profit/Sales -40.46% 8.68% 39.44% 21.75% 9.23% 6.21% 12.23% -71.88% -68.25% 38.13% 47.55% 45.26%
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 £3,218 £6,096 £13,988 £10,725 £7,688 £7,688 £7,688 £3,638 £3,638 £15,788 £20,850 £20,850
Cash from Receivables £0 £12 £368 £707 £1,542 £1,180 £854 £854 £839 £404 £449 £1,773
Subtotal Cash from Operations £3,218 £6,108 £14,356 £11,432 £9,230 £8,868 £8,542 £4,492 £4,477 £16,192 £21,300 £22,623
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 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
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 £3,718 £6,608 £14,856 £11,932 £9,730 £9,368 £9,042 £4,992 £4,977 £16,692 £21,800 £23,123
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 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Bill Payments £10,062 £1,912 £3,142 £6,260 £6,124 £4,638 £4,905 £4,404 £3,867 £3,861 £7,822 £9,093
Subtotal Spent on Operations £13,062 £4,912 £6,142 £9,260 £9,124 £7,638 £7,905 £7,404 £6,867 £6,861 £10,822 £12,093
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 £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 £13,062 £4,912 £6,142 £9,260 £9,124 £7,638 £7,905 £7,404 £6,867 £6,861 £10,822 £12,093
Net Cash Flow (£9,344) £1,696 £8,714 £2,672 £606 £1,730 £1,137 (£2,412) (£1,890) £9,831 £10,978 £11,030
Cash Balance £412 £2,108 £10,821 £13,493 £14,099 £15,829 £16,966 £14,554 £12,663 £22,495 £33,472 £44,503
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 £9,756 £412 £2,108 £10,821 £13,493 £14,099 £15,829 £16,966 £14,554 £12,663 £22,495 £33,472 £44,503
Accounts Receivable £0 £358 £1,023 £2,209 £2,694 £2,006 £1,680 £1,680 £1,230 £795 £2,145 £4,012 £4,556
Other Current Assets £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000
Total Current Assets £29,756 £20,770 £23,131 £33,030 £36,187 £36,105 £37,509 £38,646 £35,784 £33,458 £44,640 £57,485 £69,059
Long-term Assets
Long-term Assets £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000
Accumulated Depreciation £0 £150 £300 £450 £600 £725 £815 £890 £965 £1,040 £1,115 £1,190 £1,270
Total Long-term Assets £7,000 £6,850 £6,700 £6,550 £6,400 £6,275 £6,185 £6,110 £6,035 £5,960 £5,885 £5,810 £5,730
Total Assets £36,756 £27,620 £29,831 £39,580 £42,587 £42,380 £43,694 £44,756 £41,819 £39,418 £50,525 £63,295 £74,789
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 £10,000 £1,811 £2,934 £6,054 £5,970 £4,474 £4,758 £4,275 £3,743 £3,601 £7,519 £8,773 £9,282
Current Borrowing £0 £500 £1,000 £1,500 £2,000 £2,500 £3,000 £3,500 £4,000 £4,500 £5,000 £5,500 £6,000
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £10,000 £2,311 £3,934 £7,554 £7,970 £6,974 £7,758 £7,775 £7,743 £8,101 £12,519 £14,273 £15,282
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Liabilities £10,000 £2,311 £3,934 £7,554 £7,970 £6,974 £7,758 £7,775 £7,743 £8,101 £12,519 £14,273 £15,282
Paid-in Capital £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000
Retained Earnings (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244)
Earnings £0 (£1,447) (£859) £5,270 £7,862 £8,650 £9,180 £10,225 £7,319 £4,561 £11,249 £22,266 £32,750
Total Capital £26,756 £25,309 £25,897 £32,026 £34,618 £35,406 £35,936 £36,981 £34,075 £31,317 £38,005 £49,022 £59,506
Total Liabilities and Capital £36,756 £27,620 £29,831 £39,580 £42,587 £42,380 £43,694 £44,756 £41,819 £39,418 £50,525 £63,295 £74,789
Net Worth £26,756 £25,309 £25,897 £32,026 £34,618 £35,406 £35,936 £36,981 £34,075 £31,317 £38,005 £49,022 £59,506
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
Agent Sales - 25% To Company 0% £0 £2,375 £8,125 £11,250 £4,500 £4,500 £4,500 £3,375 £3,375 £12,375 £14,625 £14,625
Broker Sales - 100% To Company 0% £3,389 £3,731 £6,750 £0 £3,375 £3,375 £3,375 £0 £0 £4,500 £7,875 £7,875
Photo Service - 100% To Company 0% £0 £480 £480 £480 £480 £480 £480 £480 £480 £480 £480 £480
Referrals - 25% Agent/25% Company 0% £187 £187 £187 £187 £187 £187 £187 £187 £187 £187 £187 £187
Total Sales £3,576 £6,773 £15,542 £11,917 £8,542 £8,542 £8,542 £4,042 £4,042 £17,542 £23,167 £23,167
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
Agent Sales - 25% To Company £0 £238 £813 £1,125 £450 £450 £450 £338 £338 £1,238 £1,463 £1,463
Broker Sales - 100% To Company £339 £373 £675 £1,350 £675 £1,350 £675 £1,350 £1,350 £1,350 £675 £675
Photo Service - 100% To Company £0 £40 £40 £40 £40 £40 £40 £40 £40 £40 £40 £40
Referrals - 25% Agent/25% Company £0 £30 £30 £30 £30 £30 £30 £30 £30 £30 £30 £30
Subtotal Direct Cost of Sales £339 £681 £1,558 £2,545 £1,195 £1,870 £1,195 £1,758 £1,758 £2,658 £2,208 £2,208
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
Wagner 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
Other 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,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 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
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 £3,576 £6,773 £15,542 £11,917 £8,542 £8,542 £8,542 £4,042 £4,042 £17,542 £23,167 £23,167
Direct Cost of Sales £339 £681 £1,558 £2,545 £1,195 £1,870 £1,195 £1,758 £1,758 £2,658 £2,208 £2,208
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £339 £681 £1,558 £2,545 £1,195 £1,870 £1,195 £1,758 £1,758 £2,658 £2,208 £2,208
Gross Margin £3,237 £6,093 £13,985 £9,372 £7,347 £6,672 £7,347 £2,285 £2,285 £14,885 £20,960 £20,960
Gross Margin % 90.52% 89.95% 89.98% 78.64% 86.01% 78.11% 86.01% 56.52% 56.52% 84.85% 90.47% 90.47%
Expenses
Payroll £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Marketing/Promotion £200 £200 £600 £700 £1,000 £700 £700 £900 £700 £700 £1,000 £700
Depreciation £150 £150 £150 £150 £125 £90 £75 £75 £75 £75 £75 £80
Utilities £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150
Rent £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300 £1,300
Insurance £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150
Office Supplies £100 £100 £200 £200 £300 £300 £300 £300 £300 £300 £300 £300
Business Software £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £1,000
Leased Equipment £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Payroll Taxes 15% £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 £5,300 £5,300 £5,800 £5,900 £6,275 £5,940 £5,925 £6,125 £5,925 £5,925 £6,225 £6,930
Profit Before Interest and Taxes (£2,063) £793 £8,185 £3,472 £1,072 £732 £1,422 (£3,841) (£3,641) £8,960 £14,735 £14,030
EBITDA (£1,913) £943 £8,335 £3,622 £1,197 £822 £1,497 (£3,766) (£3,566) £9,035 £14,810 £14,110
Interest Expense £4 £8 £13 £17 £21 £25 £29 £33 £38 £42 £46 £50
Taxes Incurred (£620) £196 £2,043 £864 £263 £177 £348 (£968) (£920) £2,229 £3,672 £3,495
Net Profit (£1,447) £588 £6,129 £2,592 £788 £530 £1,045 (£2,905) (£2,759) £6,688 £11,017 £10,485
Net Profit/Sales -40.46% 8.68% 39.44% 21.75% 9.23% 6.21% 12.23% -71.88% -68.25% 38.13% 47.55% 45.26%
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 £3,218 £6,096 £13,988 £10,725 £7,688 £7,688 £7,688 £3,638 £3,638 £15,788 £20,850 £20,850
Cash from Receivables £0 £12 £368 £707 £1,542 £1,180 £854 £854 £839 £404 £449 £1,773
Subtotal Cash from Operations £3,218 £6,108 £14,356 £11,432 £9,230 £8,868 £8,542 £4,492 £4,477 £16,192 £21,300 £22,623
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 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
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 £3,718 £6,608 £14,856 £11,932 £9,730 £9,368 £9,042 £4,992 £4,977 £16,692 £21,800 £23,123
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 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Bill Payments £10,062 £1,912 £3,142 £6,260 £6,124 £4,638 £4,905 £4,404 £3,867 £3,861 £7,822 £9,093
Subtotal Spent on Operations £13,062 £4,912 £6,142 £9,260 £9,124 £7,638 £7,905 £7,404 £6,867 £6,861 £10,822 £12,093
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 £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 £13,062 £4,912 £6,142 £9,260 £9,124 £7,638 £7,905 £7,404 £6,867 £6,861 £10,822 £12,093
Net Cash Flow (£9,344) £1,696 £8,714 £2,672 £606 £1,730 £1,137 (£2,412) (£1,890) £9,831 £10,978 £11,030
Cash Balance £412 £2,108 £10,821 £13,493 £14,099 £15,829 £16,966 £14,554 £12,663 £22,495 £33,472 £44,503
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 £9,756 £412 £2,108 £10,821 £13,493 £14,099 £15,829 £16,966 £14,554 £12,663 £22,495 £33,472 £44,503
Accounts Receivable £0 £358 £1,023 £2,209 £2,694 £2,006 £1,680 £1,680 £1,230 £795 £2,145 £4,012 £4,556
Other Current Assets £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000
Total Current Assets £29,756 £20,770 £23,131 £33,030 £36,187 £36,105 £37,509 £38,646 £35,784 £33,458 £44,640 £57,485 £69,059
Long-term Assets
Long-term Assets £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000 £7,000
Accumulated Depreciation £0 £150 £300 £450 £600 £725 £815 £890 £965 £1,040 £1,115 £1,190 £1,270
Total Long-term Assets £7,000 £6,850 £6,700 £6,550 £6,400 £6,275 £6,185 £6,110 £6,035 £5,960 £5,885 £5,810 £5,730
Total Assets £36,756 £27,620 £29,831 £39,580 £42,587 £42,380 £43,694 £44,756 £41,819 £39,418 £50,525 £63,295 £74,789
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 £10,000 £1,811 £2,934 £6,054 £5,970 £4,474 £4,758 £4,275 £3,743 £3,601 £7,519 £8,773 £9,282
Current Borrowing £0 £500 £1,000 £1,500 £2,000 £2,500 £3,000 £3,500 £4,000 £4,500 £5,000 £5,500 £6,000
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £10,000 £2,311 £3,934 £7,554 £7,970 £6,974 £7,758 £7,775 £7,743 £8,101 £12,519 £14,273 £15,282
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Liabilities £10,000 £2,311 £3,934 £7,554 £7,970 £6,974 £7,758 £7,775 £7,743 £8,101 £12,519 £14,273 £15,282
Paid-in Capital £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000 £50,000
Retained Earnings (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244) (£23,244)
Earnings £0 (£1,447) (£859) £5,270 £7,862 £8,650 £9,180 £10,225 £7,319 £4,561 £11,249 £22,266 £32,750
Total Capital £26,756 £25,309 £25,897 £32,026 £34,618 £35,406 £35,936 £36,981 £34,075 £31,317 £38,005 £49,022 £59,506
Total Liabilities and Capital £36,756 £27,620 £29,831 £39,580 £42,587 £42,380 £43,694 £44,756 £41,819 £39,418 £50,525 £63,295 £74,789
Net Worth £26,756 £25,309 £25,897 £32,026 £34,618 £35,406 £35,936 £36,981 £34,075 £31,317 £38,005 £49,022 £59,506