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

Formwork Construction Business Plan

Concrete Fabricators

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
Single Family Housing 0% £8,320 £10,920 £12,480 £11,180 £12,610 £13,790 £11,700 £11,700 £12,455 £12,870 £13,260 £13,114
Other Residential Housing 0% £3,200 £4,200 £4,800 £4,300 £4,850 £5,304 £4,500 £4,500 £4,790 £4,950 £5,100 £5,044
Commercial Construction 0% £4,480 £5,880 £6,720 £6,020 £6,790 £7,426 £6,300 £6,300 £6,707 £6,930 £7,140 £7,062
Total Sales £16,000 £21,000 £24,000 £21,500 £24,250 £26,520 £22,500 £22,500 £23,952 £24,750 £25,500 £25,220
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Single Family Housing £433 £433 £433 £433 £433 £433 £433 £433 £433 £433 £433 £433
Other Residential Housing £167 £167 £167 £167 £167 £167 £167 £167 £167 £167 £167 £167
Commercial Construction £233 £233 £233 £233 £233 £233 £233 £233 £233 £233 £233 £233
Subtotal Direct Cost of Sales £833 £833 £833 £833 £833 £833 £833 £833 £833 £833 £833 £833
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Lloyd James 0% £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400
Anne James 0% £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500
Sam McDonald 0% £2,200 £2,200 £2,200 £2,200 £2,200 £2,200 £2,200 £2,200 £2,200 £2,200 £2,200 £2,200
Cement Layer No. 1 0% £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842
Cement Layer No. 2 0% £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842
Cement Layer No. 3 0% £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842
Part time Cement Layer No.4 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Part time Cement Layer No. 5 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 6 6 6 6 6 6 6 6 6 6 6 6
Total Payroll £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626
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 £16,000 £21,000 £24,000 £21,500 £24,250 £26,520 £22,500 £22,500 £23,952 £24,750 £25,500 £25,220
Direct Cost of Sales £833 £833 £833 £833 £833 £833 £833 £833 £833 £833 £833 £833
Other £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Total Cost of Sales £1,083 £1,083 £1,083 £1,083 £1,083 £1,083 £1,083 £1,083 £1,083 £1,083 £1,083 £1,083
Gross Margin £14,917 £19,917 £22,917 £20,417 £23,167 £25,437 £21,417 £21,417 £22,869 £23,667 £24,417 £24,137
Gross Margin % 93.23% 94.84% 95.49% 94.96% 95.53% 95.92% 95.19% 95.19% 95.48% 95.62% 95.75% 95.70%
Expenses
Payroll £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626
Sales and Marketing and Other Expenses £2,862 £2,862 £2,862 £2,862 £2,862 £2,862 £2,862 £2,862 £2,862 £2,862 £2,862 £2,862
Depreciation £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000
Rent/Mortgage £1,035 £1,035 £1,035 £1,035 £1,035 £1,035 £1,035 £1,035 £1,035 £1,035 £1,035 £1,035
Supplies and Equipment £827 £827 £827 £827 £827 £827 £827 £827 £827 £827 £827 £827
Insurance £1,205 £1,205 £1,205 £1,205 £1,205 £1,205 £1,205 £1,205 £1,205 £1,205 £1,205 £1,205
Services £236 £236 £236 £236 £236 £236 £236 £236 £236 £236 £236 £236
Payroll Taxes 15% £829 £829 £829 £829 £829 £829 £829 £829 £829 £829 £829 £829
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £22,620 £22,620 £22,620 £22,620 £22,620 £22,620 £22,620 £22,620 £22,620 £22,620 £22,620 £22,620
Profit Before Interest and Taxes (£7,703) (£2,703) £297 (£2,203) £547 £2,817 (£1,203) (£1,203) £249 £1,047 £1,797 £1,517
EBITDA (£3,703) £1,297 £4,297 £1,797 £4,547 £6,817 £2,797 £2,797 £4,249 £5,047 £5,797 £5,517
Interest Expense £161 £156 £151 £146 £141 £136 £131 £126 £121 £116 £111 £106
Taxes Incurred £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Net Profit (£7,864) (£2,859) £146 (£2,349) £406 £2,681 (£1,334) (£1,329) £128 £931 £1,686 £1,411
Net Profit/Sales -49.15% -13.61% 0.61% -10.92% 1.68% 10.11% -5.93% -5.91% 0.54% 3.76% 6.61% 5.60%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales £4,000 £5,250 £6,000 £5,375 £6,063 £6,630 £5,625 £5,625 £5,988 £6,188 £6,375 £6,305
Cash from Receivables £11,663 £12,063 £12,125 £15,825 £17,938 £16,194 £18,244 £19,790 £16,875 £16,911 £17,984 £18,581
Subtotal Cash from Operations £15,663 £17,313 £18,125 £21,200 £24,000 £22,824 £23,869 £25,415 £22,863 £23,099 £24,359 £24,886
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 £2,000 £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 £3,000 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Cash Received £20,663 £17,313 £18,125 £21,200 £24,000 £22,824 £23,869 £25,415 £22,863 £23,099 £24,359 £24,886
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626
Bill Payments £40,871 £8,238 £8,233 £8,228 £8,223 £8,218 £8,213 £8,208 £8,203 £8,198 £8,193 £8,188
Subtotal Spent on Operations £52,497 £19,864 £19,859 £19,854 £19,849 £19,844 £19,839 £19,834 £19,829 £19,824 £19,819 £19,814
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 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Other Liabilities Principal Repayment £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
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 £53,497 £20,964 £20,959 £20,954 £20,949 £20,944 £20,939 £20,934 £20,929 £20,924 £20,919 £20,914
Net Cash Flow (£32,834) (£3,651) (£2,834) £246 £3,051 £1,880 £2,931 £4,481 £1,934 £2,175 £3,440 £3,973
Cash Balance £12,474 £8,824 £5,990 £6,236 £9,287 £11,167 £14,098 £18,579 £20,513 £22,688 £26,128 £30,101
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash £45,308 £12,474 £8,824 £5,990 £6,236 £9,287 £11,167 £14,098 £18,579 £20,513 £22,688 £26,128 £30,101
Accounts Receivable £23,326 £23,663 £27,350 £33,225 £33,525 £33,775 £37,471 £36,102 £33,188 £34,277 £35,928 £37,069 £37,403
Other Current Assets £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830
Total Current Assets £77,464 £44,967 £45,004 £48,045 £48,591 £51,892 £57,469 £59,030 £60,596 £63,620 £67,446 £72,027 £76,333
Long-term Assets
Long-term Assets £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687
Accumulated Depreciation £45,691 £49,691 £53,691 £57,690 £61,690 £65,690 £69,690 £73,689 £77,689 £81,689 £85,689 £89,688 £93,688
Total Long-term Assets £461,996 £457,996 £453,997 £449,997 £445,997 £441,997 £437,998 £433,998 £429,998 £425,998 £421,999 £417,999 £413,999
Total Assets £539,460 £502,964 £499,000 £498,042 £494,588 £493,890 £495,466 £493,028 £490,594 £489,618 £489,444 £490,026 £490,332
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable £40,596 £7,963 £7,958 £7,954 £7,949 £7,944 £7,939 £7,934 £7,929 £7,925 £7,920 £7,915 £7,910
Current Borrowing £0 £2,000 £1,900 £1,800 £1,700 £1,600 £1,500 £1,400 £1,300 £1,200 £1,100 £1,000 £900
Other Current Liabilities £22,785 £22,285 £21,785 £21,285 £20,785 £20,285 £19,785 £19,285 £18,785 £18,285 £17,785 £17,285 £16,785
Subtotal Current Liabilities £63,381 £32,248 £31,643 £31,039 £30,434 £29,829 £29,224 £28,619 £28,014 £27,410 £26,805 £26,200 £25,595
Long-term Liabilities £17,766 £17,266 £16,766 £16,266 £15,766 £15,266 £14,766 £14,266 £13,766 £13,266 £12,766 £12,266 £11,766
Total Liabilities £81,147 £49,514 £48,409 £47,305 £46,200 £45,095 £43,990 £42,885 £41,780 £40,676 £39,571 £38,466 £37,361
Paid-in Capital £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
Retained Earnings £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313
Earnings £0 (£7,864) (£10,722) (£10,576) (£12,925) (£12,518) (£9,837) (£11,171) (£12,499) (£12,371) (£11,440) (£9,753) (£8,342)
Total Capital £458,313 £453,449 £450,591 £450,737 £448,388 £448,795 £451,476 £450,142 £448,814 £448,942 £449,873 £451,560 £452,971
Total Liabilities and Capital £539,460 £502,964 £499,000 £498,042 £494,588 £493,890 £495,466 £493,028 £490,594 £489,618 £489,444 £490,026 £490,332
Net Worth £458,313 £453,449 £450,591 £450,737 £448,388 £448,795 £451,476 £450,142 £448,814 £448,942 £449,874 £451,560 £452,971
previous
next
Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Single Family Housing 0% £8,320 £10,920 £12,480 £11,180 £12,610 £13,790 £11,700 £11,700 £12,455 £12,870 £13,260 £13,114
Other Residential Housing 0% £3,200 £4,200 £4,800 £4,300 £4,850 £5,304 £4,500 £4,500 £4,790 £4,950 £5,100 £5,044
Commercial Construction 0% £4,480 £5,880 £6,720 £6,020 £6,790 £7,426 £6,300 £6,300 £6,707 £6,930 £7,140 £7,062
Total Sales £16,000 £21,000 £24,000 £21,500 £24,250 £26,520 £22,500 £22,500 £23,952 £24,750 £25,500 £25,220
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Single Family Housing £433 £433 £433 £433 £433 £433 £433 £433 £433 £433 £433 £433
Other Residential Housing £167 £167 £167 £167 £167 £167 £167 £167 £167 £167 £167 £167
Commercial Construction £233 £233 £233 £233 £233 £233 £233 £233 £233 £233 £233 £233
Subtotal Direct Cost of Sales £833 £833 £833 £833 £833 £833 £833 £833 £833 £833 £833 £833
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Lloyd James 0% £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400 £2,400
Anne James 0% £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500
Sam McDonald 0% £2,200 £2,200 £2,200 £2,200 £2,200 £2,200 £2,200 £2,200 £2,200 £2,200 £2,200 £2,200
Cement Layer No. 1 0% £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842
Cement Layer No. 2 0% £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842
Cement Layer No. 3 0% £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842 £1,842
Part time Cement Layer No.4 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Part time Cement Layer No. 5 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 6 6 6 6 6 6 6 6 6 6 6 6
Total Payroll £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626
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 £16,000 £21,000 £24,000 £21,500 £24,250 £26,520 £22,500 £22,500 £23,952 £24,750 £25,500 £25,220
Direct Cost of Sales £833 £833 £833 £833 £833 £833 £833 £833 £833 £833 £833 £833
Other £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Total Cost of Sales £1,083 £1,083 £1,083 £1,083 £1,083 £1,083 £1,083 £1,083 £1,083 £1,083 £1,083 £1,083
Gross Margin £14,917 £19,917 £22,917 £20,417 £23,167 £25,437 £21,417 £21,417 £22,869 £23,667 £24,417 £24,137
Gross Margin % 93.23% 94.84% 95.49% 94.96% 95.53% 95.92% 95.19% 95.19% 95.48% 95.62% 95.75% 95.70%
Expenses
Payroll £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626
Sales and Marketing and Other Expenses £2,862 £2,862 £2,862 £2,862 £2,862 £2,862 £2,862 £2,862 £2,862 £2,862 £2,862 £2,862
Depreciation £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000
Rent/Mortgage £1,035 £1,035 £1,035 £1,035 £1,035 £1,035 £1,035 £1,035 £1,035 £1,035 £1,035 £1,035
Supplies and Equipment £827 £827 £827 £827 £827 £827 £827 £827 £827 £827 £827 £827
Insurance £1,205 £1,205 £1,205 £1,205 £1,205 £1,205 £1,205 £1,205 £1,205 £1,205 £1,205 £1,205
Services £236 £236 £236 £236 £236 £236 £236 £236 £236 £236 £236 £236
Payroll Taxes 15% £829 £829 £829 £829 £829 £829 £829 £829 £829 £829 £829 £829
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £22,620 £22,620 £22,620 £22,620 £22,620 £22,620 £22,620 £22,620 £22,620 £22,620 £22,620 £22,620
Profit Before Interest and Taxes (£7,703) (£2,703) £297 (£2,203) £547 £2,817 (£1,203) (£1,203) £249 £1,047 £1,797 £1,517
EBITDA (£3,703) £1,297 £4,297 £1,797 £4,547 £6,817 £2,797 £2,797 £4,249 £5,047 £5,797 £5,517
Interest Expense £161 £156 £151 £146 £141 £136 £131 £126 £121 £116 £111 £106
Taxes Incurred £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Net Profit (£7,864) (£2,859) £146 (£2,349) £406 £2,681 (£1,334) (£1,329) £128 £931 £1,686 £1,411
Net Profit/Sales -49.15% -13.61% 0.61% -10.92% 1.68% 10.11% -5.93% -5.91% 0.54% 3.76% 6.61% 5.60%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales £4,000 £5,250 £6,000 £5,375 £6,063 £6,630 £5,625 £5,625 £5,988 £6,188 £6,375 £6,305
Cash from Receivables £11,663 £12,063 £12,125 £15,825 £17,938 £16,194 £18,244 £19,790 £16,875 £16,911 £17,984 £18,581
Subtotal Cash from Operations £15,663 £17,313 £18,125 £21,200 £24,000 £22,824 £23,869 £25,415 £22,863 £23,099 £24,359 £24,886
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 £2,000 £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 £3,000 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Cash Received £20,663 £17,313 £18,125 £21,200 £24,000 £22,824 £23,869 £25,415 £22,863 £23,099 £24,359 £24,886
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626 £11,626
Bill Payments £40,871 £8,238 £8,233 £8,228 £8,223 £8,218 £8,213 £8,208 £8,203 £8,198 £8,193 £8,188
Subtotal Spent on Operations £52,497 £19,864 £19,859 £19,854 £19,849 £19,844 £19,839 £19,834 £19,829 £19,824 £19,819 £19,814
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 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Other Liabilities Principal Repayment £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
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 £53,497 £20,964 £20,959 £20,954 £20,949 £20,944 £20,939 £20,934 £20,929 £20,924 £20,919 £20,914
Net Cash Flow (£32,834) (£3,651) (£2,834) £246 £3,051 £1,880 £2,931 £4,481 £1,934 £2,175 £3,440 £3,973
Cash Balance £12,474 £8,824 £5,990 £6,236 £9,287 £11,167 £14,098 £18,579 £20,513 £22,688 £26,128 £30,101
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash £45,308 £12,474 £8,824 £5,990 £6,236 £9,287 £11,167 £14,098 £18,579 £20,513 £22,688 £26,128 £30,101
Accounts Receivable £23,326 £23,663 £27,350 £33,225 £33,525 £33,775 £37,471 £36,102 £33,188 £34,277 £35,928 £37,069 £37,403
Other Current Assets £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830 £8,830
Total Current Assets £77,464 £44,967 £45,004 £48,045 £48,591 £51,892 £57,469 £59,030 £60,596 £63,620 £67,446 £72,027 £76,333
Long-term Assets
Long-term Assets £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687 £507,687
Accumulated Depreciation £45,691 £49,691 £53,691 £57,690 £61,690 £65,690 £69,690 £73,689 £77,689 £81,689 £85,689 £89,688 £93,688
Total Long-term Assets £461,996 £457,996 £453,997 £449,997 £445,997 £441,997 £437,998 £433,998 £429,998 £425,998 £421,999 £417,999 £413,999
Total Assets £539,460 £502,964 £499,000 £498,042 £494,588 £493,890 £495,466 £493,028 £490,594 £489,618 £489,444 £490,026 £490,332
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable £40,596 £7,963 £7,958 £7,954 £7,949 £7,944 £7,939 £7,934 £7,929 £7,925 £7,920 £7,915 £7,910
Current Borrowing £0 £2,000 £1,900 £1,800 £1,700 £1,600 £1,500 £1,400 £1,300 £1,200 £1,100 £1,000 £900
Other Current Liabilities £22,785 £22,285 £21,785 £21,285 £20,785 £20,285 £19,785 £19,285 £18,785 £18,285 £17,785 £17,285 £16,785
Subtotal Current Liabilities £63,381 £32,248 £31,643 £31,039 £30,434 £29,829 £29,224 £28,619 £28,014 £27,410 £26,805 £26,200 £25,595
Long-term Liabilities £17,766 £17,266 £16,766 £16,266 £15,766 £15,266 £14,766 £14,266 £13,766 £13,266 £12,766 £12,266 £11,766
Total Liabilities £81,147 £49,514 £48,409 £47,305 £46,200 £45,095 £43,990 £42,885 £41,780 £40,676 £39,571 £38,466 £37,361
Paid-in Capital £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
Retained Earnings £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313 £458,313
Earnings £0 (£7,864) (£10,722) (£10,576) (£12,925) (£12,518) (£9,837) (£11,171) (£12,499) (£12,371) (£11,440) (£9,753) (£8,342)
Total Capital £458,313 £453,449 £450,591 £450,737 £448,388 £448,795 £451,476 £450,142 £448,814 £448,942 £449,873 £451,560 £452,971
Total Liabilities and Capital £539,460 £502,964 £499,000 £498,042 £494,588 £493,890 £495,466 £493,028 £490,594 £489,618 £489,444 £490,026 £490,332
Net Worth £458,313 £453,449 £450,591 £450,737 £448,388 £448,795 £451,476 £450,142 £448,814 £448,942 £449,874 £451,560 £452,971