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

Residential Remodeling Business Plan

by Business Networks

Anywhere Remodeling

This sample business plan was written by Business Networks of . This sample business plan can be edited directly in Business Plan Pro software.

previous
next
Page 1   2   3   4   5   6   7   8   9  

Appendix

Sales Forecast
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Sales
Commercial £3,237 £3,699 £5,780 £11,098 £16,416 £20,116 £19,884 £16,647 £12,486 £9,249 £6,705 £6,474
Residential £73,410 £76,879 £77,746 £89,884 £96,243 £101,156 £99,711 £109,827 £111,850 £119,075 £116,301 £116,532
Other £151 £151 £151 £151 £151 £151 £151 £151 £2,900 £3,587 £151 £151
Total Sales £76,798 £80,729 £83,677 £101,133 £112,810 £121,423 £119,746 £126,625 £127,236 £131,911 £123,157 £123,157
Direct Cost of Sales Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Materials £13,056 £13,724 £14,225 £17,193 £19,178 £20,642 £20,357 £21,526 £21,630 £22,425 £20,937 £20,937
Sub Contractor Costs £26,879 £28,255 £29,287 £35,397 £39,484 £42,498 £41,911 £44,319 £44,533 £46,169 £43,105 £43,105
Permits & Licensing £282 £282 £282 £282 £282 £282 £282 £282 £282 £282 £282 £282
Sales Costs w/commision £484 £509 £527 £637 £711 £765 £754 £798 £802 £831 £776 £776
Warranties £377 £385 £393 £401 £409 £417 £425 £434 £443 £452 £461 £470
Trash £530 £530 £530 £530 £530 £530 £530 £530 £530 £530 £530 £530
Other £161 £161 £161 £161 £161 £161 £161 £161 £161 £161 £161 £161
Subtotal Direct Cost of Sales £41,769 £43,846 £45,406 £54,601 £60,754 £65,295 £64,421 £68,050 £68,381 £70,850 £66,252 £66,261
Personnel Plan
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Labor £14,986 £14,986 £14,986 £14,986 £14,986 £14,986 £14,986 £14,986 £14,986 £14,985 £14,985 £14,985
Prod. Manager £3,153 £3,153 £3,153 £3,153 £3,153 £3,153 £3,153 £3,153 £3,153 £3,154 £3,154 £3,154
Design £887 £887 £887 £887 £887 £887 £887 £888 £888 £888 £888 £888
Prod Mgr (office) £773 £773 £773 £773 £773 £773 £773 £773 £773 £773 £773 £773
Sales (salaried/draw) £712 £713 £713 £713 £713 £713 £713 £713 £713 £713 £713 £713
Office £3,555 £3,555 £3,555 £3,555 £3,555 £3,555 £3,555 £3,555 £3,555 £3,555 £3,555 £3,555
Owners £6,500 £6,500 £6,500 £6,500 £6,500 £6,500 £6,500 £6,500 £6,500 £6,500 £6,500 £6,500
Total People 12 12 12 12 1 12 12 12 12 12 12 12
Total Payroll £30,566 £30,567 £30,567 £30,567 £30,567 £30,567 £30,567 £30,568 £30,568 £30,568 £30,568 £30,568
General Assumptions
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.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 25.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
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Sales £76,798 £80,729 £83,677 £101,133 £112,810 £121,423 £119,746 £126,625 £127,236 £131,911 £123,157 £123,157
Direct Cost of Sales £41,769 £43,846 £45,406 £54,601 £60,754 £65,295 £64,421 £68,050 £68,381 £70,850 £66,252 £66,261
Other Costs of Goods £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £41,769 £43,846 £45,406 £54,601 £60,754 £65,295 £64,421 £68,050 £68,381 £70,850 £66,252 £66,261
Gross Margin £35,029 £36,883 £38,271 £46,532 £52,056 £56,128 £55,325 £58,575 £58,855 £61,061 £56,905 £56,896
Gross Margin % 45.61% 45.69% 45.74% 46.01% 46.14% 46.22% 46.20% 46.26% 46.26% 46.29% 46.21% 46.20%
Expenses
Payroll £30,566 £30,567 £30,567 £30,567 £30,567 £30,567 £30,567 £30,568 £30,568 £30,568 £30,568 £30,568
Advertising £556 £612 £673 £740 £814 £895 £985 £1,084 £1,192 £1,311 £1,442 £1,586
Depreciation £738 £738 £738 £738 £738 £738 £738 £738 £738 £738 £738 £738
Marketing £643 £707 £778 £856 £942 £1,036 £1,140 £1,254 £1,379 £1,517 £1,669 £1,836
Bad Debts £187 £187 £187 £187 £187 £187 £187 £187 £187 £187 £187 £187
Donations £197 £197 £197 £197 £197 £197 £197 £197 £197 £197 £197 £197
Entertainment 50% £175 £175 £175 £175 £175 £175 £175 £175 £175 £175 £175 £175
Employee Benefits £4,129 £4,335 £4,552 £4,780 £5,019 £5,270 £5,534 £5,811 £6,102 £6,407 £6,727 £7,063
Equipment Buy/Rental £244 £256 £269 £282 £296 £311 £327 £343 £360 £378 £397 £417
Interest/Bank Charges (£17) (£17) (£17) (£17) (£17) (£17) (£17) (£17) (£17) (£17) (£17) (£17)
Tool Repair/Replacement £230 £230 £230 £230 £230 £230 £230 £230 £230 £230 £230 £230
Computer/Hardware/Software Consultants £541 £568 £596 £626 £657 £690 £724 £760 £798 £838 £880 £924
Dues/Sub/Licenses/Royalties/Trade Assoc £237 £237 £237 £237 £237 £237 £237 £237 £237 £237 £237 £237
Corp & Business Taxes £175 £175 £175 £175 £175 £175 £175 £175 £175 £175 £175 £175
Legal Expenses £109 £109 £109 £109 £109 £109 £109 £109 £109 £109 £109 £109
Accounting Expenses £194 £194 £194 £194 £194 £194 £194 £194 £194 £194 £194 £194
Rent of Office/Warehouse Space £1,210 £1,210 £1,210 £1,210 £1,210 £1,210 £1,210 £1,210 £1,210 £1,210 £1,210 £1,210
Repairs/Maintenance £95 £95 £95 £95 £95 £95 £95 £95 £95 £95 £95 £95
Communications £780 £780 £780 £780 £780 £780 £780 £780 £780 £780 £780 £780
Utilities £77 £77 £77 £77 £77 £77 £77 £77 £77 £77 £77 £77
Office Expenses £701 £701 £701 £701 £701 £701 £701 £701 £701 £701 £701 £701
Miscellaneous/Other £382 £382 £382 £382 £382 £382 £382 £382 £382 £382 £382 £382
Liability Insurance £626 £626 £626 £626 £626 £626 £626 £626 £626 £626 £626 £626
Vehicle Expenses & Insurance £866 £866 £866 £866 £866 £866 £866 £866 £866 £866 £866 £866
Liability Insurance for employees £42 £42 £42 £42 £42 £42 £42 £42 £42 £42 £42 £42
Vehicle Expenses & Insurance £337 £337 £337 £337 £337 £337 £337 £337 £337 £337 £337 £337
Insurance - General (#43) 15% £85 £85 £85 £85 £85 £85 £85 £85 £85 £85 £85 £85
Payroll Taxes 18% £5,471 £5,472 £5,472 £5,472 £5,472 £5,472 £5,472 £5,472 £5,472 £5,472 £5,472 £5,472
Total Operating Expenses £49,578 £49,944 £50,334 £50,750 £51,194 £51,668 £52,176 £52,719 £53,298 £53,918 £54,582 £55,293
Profit Before Interest and Taxes (£14,549) (£13,061) (£12,062) (£4,217) £862 £4,460 £3,150 £5,856 £5,557 £7,143 £2,323 £1,603
EBITDA (£13,811) (£12,323) (£11,324) (£3,479) £1,600 £5,198 £3,888 £6,594 £6,295 £7,881 £3,061 £2,341
Interest Expense £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Taxes Incurred £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Net Profit (£14,549) (£13,061) (£12,062) (£4,217) £862 £4,460 £3,150 £5,856 £5,557 £7,143 £2,323 £1,603
Net Profit/Sales -18.94% -16.18% -14.42% -4.17% 0.76% 3.67% 2.63% 4.62% 4.37% 5.42% 1.89% 1.30%
Pro Forma Cash Flow
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Cash Received
Cash from Operations
Cash Sales £19,200 £20,182 £20,919 £25,283 £28,203 £30,356 £29,937 £31,656 £31,809 £32,978 £30,789 £30,789
Cash from Receivables £294,000 £294,000 £177,719 £59,171 £61,726 £69,740 £80,521 £88,053 £90,396 £92,561 £95,213 £97,297
Subtotal Cash from Operations £313,200 £314,182 £198,638 £84,454 £89,928 £100,096 £110,457 £119,709 £122,205 £125,539 £126,002 £128,086
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 £313,200 £314,182 £198,638 £84,454 £89,928 £100,096 £110,457 £119,709 £122,205 £125,539 £126,002 £128,086
Expenditures Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Expenditures from Operations
Cash Spending £30,566 £30,567 £30,567 £30,567 £30,567 £30,567 £30,567 £30,568 £30,568 £30,568 £30,568 £30,568
Bill Payments £71,721 £60,124 £62,550 £64,755 £74,265 £80,810 £85,646 £85,430 £89,493 £90,475 £93,331 £89,552
Subtotal Spent on Operations £102,288 £90,691 £93,117 £95,322 £104,832 £111,377 £116,213 £115,998 £120,061 £121,044 £123,899 £120,120
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 £102,288 £90,691 £93,117 £95,322 £104,832 £111,377 £116,213 £115,998 £120,061 £121,044 £123,899 £120,120
Net Cash Flow £210,912 £223,491 £105,522 (£10,868) (£14,904) (£11,281) (£5,756) £3,710 £2,144 £4,495 £2,103 £7,967
Cash Balance £394,340 £617,831 £723,353 £712,485 £697,581 £686,300 £680,544 £684,255 £686,399 £690,894 £692,997 £700,964
Pro Forma Balance Sheet
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Assets Starting Balances
Current Assets
Cash £183,428 £394,340 £617,831 £723,353 £712,485 £697,581 £686,300 £680,544 £684,255 £686,399 £690,894 £692,997 £700,964
Accounts Receivable £735,000 £498,599 £265,145 £150,184 £166,863 £189,744 £211,071 £220,360 £227,276 £232,307 £238,679 £235,834 £230,904
Other Current Assets £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380
Total Current Assets £949,808 £924,318 £914,356 £904,916 £910,728 £918,705 £928,751 £932,284 £942,911 £950,086 £960,953 £960,211 £963,249
Long-term Assets
Long-term Assets £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879
Accumulated Depreciation £56,879 £57,617 £58,355 £59,093 £59,831 £60,569 £61,307 £62,045 £62,783 £63,521 £64,259 £64,997 £65,735
Total Long-term Assets £89,000 £88,262 £87,524 £86,786 £86,048 £85,310 £84,572 £83,834 £83,096 £82,358 £81,620 £80,882 £80,144
Total Assets £1,038,808 £1,012,580 £1,001,880 £991,702 £996,776 £1,004,015 £1,013,323 £1,016,118 £1,026,007 £1,032,444 £1,042,573 £1,041,093 £1,043,393
Liabilities and Capital Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Current Liabilities
Accounts Payable £69,720 £58,041 £60,402 £62,286 £71,577 £77,955 £82,803 £82,448 £86,481 £87,360 £90,347 £86,543 £87,239
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 £69,720 £58,041 £60,402 £62,286 £71,577 £77,955 £82,803 £82,448 £86,481 £87,360 £90,347 £86,543 £87,239
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Liabilities £69,720 £58,041 £60,402 £62,286 £71,577 £77,955 £82,803 £82,448 £86,481 £87,360 £90,347 £86,543 £87,239
Paid-in Capital £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
Retained Earnings £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088
Earnings £0 (£14,549) (£27,610) (£39,672) (£43,889) (£43,027) (£38,567) (£35,418) (£29,562) (£24,004) (£16,861) (£14,538) (£12,935)
Total Capital £969,088 £954,539 £941,478 £929,416 £925,199 £926,061 £930,521 £933,670 £939,526 £945,084 £952,227 £954,550 £956,153
Total Liabilities and Capital £1,038,808 £1,012,580 £1,001,880 £991,702 £996,776 £1,004,015 £1,013,323 £1,016,118 £1,026,007 £1,032,444 £1,042,573 £1,041,093 £1,043,393
Net Worth £969,088 £954,539 £941,478 £929,416 £925,199 £926,061 £930,521 £933,670 £939,526 £945,084 £952,227 £954,550 £956,153
Long-term
FY 2009 FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018
Sales £1,328,403 £1,496,903 £1,666,998 £1,822,098 £1,982,202 £1,995,000 £2,024,925 £2,055,299 £2,086,128 £2,117,420
Cost of Sales £715,885 £805,135 £895,541 £978,094 £1,063,327 £1,057,350 £1,073,210 £1,089,308 £1,105,648 £1,122,233
Gross Margin £612,517 £691,768 £771,457 £844,004 £918,875 £937,650 £951,715 £965,990 £980,480 £995,188
Gross Margin % 46.11% 46.21% 46.28% 46.32% 46.36% 47.00% 47.00% 47.00% 47.00% 47.00%
Operating Expenses £625,452 £668,161 £703,328 £740,345 £779,309 £778,050 £789,721 £801,567 £813,590 £825,794
Operating Income (£12,935) £23,607 £68,129 £103,658 £139,566 £159,600 £161,994 £164,424 £166,890 £169,394
Net Income (£12,935) £17,705 £51,097 £77,744 £104,675 £1,321,466 £1,453,613 £1,598,974 £1,758,872 £1,934,759
Current Assets £963,249 £989,191 £1,059,473 £1,156,141 £1,280,569 £1,283,130 £1,285,696 £1,288,267 £1,290,844 £1,293,426
Long-term Assets £80,144 £70,822 £61,009 £50,680 £39,807 £36,031 £39,634 £43,598 £47,958 £52,753
Current Liabilities £87,239 £86,155 £95,527 £104,122 £113,002 £92,950 £102,245 £112,470 £123,716 £136,088
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Equity £956,153 £973,858 £1,024,955 £1,102,699 £1,207,374 £1,226,211 £1,223,085 £1,219,396 £1,215,085 £1,210,091
previous
next
Sales Forecast
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Sales
Commercial £3,237 £3,699 £5,780 £11,098 £16,416 £20,116 £19,884 £16,647 £12,486 £9,249 £6,705 £6,474
Residential £73,410 £76,879 £77,746 £89,884 £96,243 £101,156 £99,711 £109,827 £111,850 £119,075 £116,301 £116,532
Other £151 £151 £151 £151 £151 £151 £151 £151 £2,900 £3,587 £151 £151
Total Sales £76,798 £80,729 £83,677 £101,133 £112,810 £121,423 £119,746 £126,625 £127,236 £131,911 £123,157 £123,157
Direct Cost of Sales Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Materials £13,056 £13,724 £14,225 £17,193 £19,178 £20,642 £20,357 £21,526 £21,630 £22,425 £20,937 £20,937
Sub Contractor Costs £26,879 £28,255 £29,287 £35,397 £39,484 £42,498 £41,911 £44,319 £44,533 £46,169 £43,105 £43,105
Permits & Licensing £282 £282 £282 £282 £282 £282 £282 £282 £282 £282 £282 £282
Sales Costs w/commision £484 £509 £527 £637 £711 £765 £754 £798 £802 £831 £776 £776
Warranties £377 £385 £393 £401 £409 £417 £425 £434 £443 £452 £461 £470
Trash £530 £530 £530 £530 £530 £530 £530 £530 £530 £530 £530 £530
Other £161 £161 £161 £161 £161 £161 £161 £161 £161 £161 £161 £161
Subtotal Direct Cost of Sales £41,769 £43,846 £45,406 £54,601 £60,754 £65,295 £64,421 £68,050 £68,381 £70,850 £66,252 £66,261
Personnel Plan
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Labor £14,986 £14,986 £14,986 £14,986 £14,986 £14,986 £14,986 £14,986 £14,986 £14,985 £14,985 £14,985
Prod. Manager £3,153 £3,153 £3,153 £3,153 £3,153 £3,153 £3,153 £3,153 £3,153 £3,154 £3,154 £3,154
Design £887 £887 £887 £887 £887 £887 £887 £888 £888 £888 £888 £888
Prod Mgr (office) £773 £773 £773 £773 £773 £773 £773 £773 £773 £773 £773 £773
Sales (salaried/draw) £712 £713 £713 £713 £713 £713 £713 £713 £713 £713 £713 £713
Office £3,555 £3,555 £3,555 £3,555 £3,555 £3,555 £3,555 £3,555 £3,555 £3,555 £3,555 £3,555
Owners £6,500 £6,500 £6,500 £6,500 £6,500 £6,500 £6,500 £6,500 £6,500 £6,500 £6,500 £6,500
Total People 12 12 12 12 1 12 12 12 12 12 12 12
Total Payroll £30,566 £30,567 £30,567 £30,567 £30,567 £30,567 £30,567 £30,568 £30,568 £30,568 £30,568 £30,568
General Assumptions
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.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 25.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
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Sales £76,798 £80,729 £83,677 £101,133 £112,810 £121,423 £119,746 £126,625 £127,236 £131,911 £123,157 £123,157
Direct Cost of Sales £41,769 £43,846 £45,406 £54,601 £60,754 £65,295 £64,421 £68,050 £68,381 £70,850 £66,252 £66,261
Other Costs of Goods £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £41,769 £43,846 £45,406 £54,601 £60,754 £65,295 £64,421 £68,050 £68,381 £70,850 £66,252 £66,261
Gross Margin £35,029 £36,883 £38,271 £46,532 £52,056 £56,128 £55,325 £58,575 £58,855 £61,061 £56,905 £56,896
Gross Margin % 45.61% 45.69% 45.74% 46.01% 46.14% 46.22% 46.20% 46.26% 46.26% 46.29% 46.21% 46.20%
Expenses
Payroll £30,566 £30,567 £30,567 £30,567 £30,567 £30,567 £30,567 £30,568 £30,568 £30,568 £30,568 £30,568
Advertising £556 £612 £673 £740 £814 £895 £985 £1,084 £1,192 £1,311 £1,442 £1,586
Depreciation £738 £738 £738 £738 £738 £738 £738 £738 £738 £738 £738 £738
Marketing £643 £707 £778 £856 £942 £1,036 £1,140 £1,254 £1,379 £1,517 £1,669 £1,836
Bad Debts £187 £187 £187 £187 £187 £187 £187 £187 £187 £187 £187 £187
Donations £197 £197 £197 £197 £197 £197 £197 £197 £197 £197 £197 £197
Entertainment 50% £175 £175 £175 £175 £175 £175 £175 £175 £175 £175 £175 £175
Employee Benefits £4,129 £4,335 £4,552 £4,780 £5,019 £5,270 £5,534 £5,811 £6,102 £6,407 £6,727 £7,063
Equipment Buy/Rental £244 £256 £269 £282 £296 £311 £327 £343 £360 £378 £397 £417
Interest/Bank Charges (£17) (£17) (£17) (£17) (£17) (£17) (£17) (£17) (£17) (£17) (£17) (£17)
Tool Repair/Replacement £230 £230 £230 £230 £230 £230 £230 £230 £230 £230 £230 £230
Computer/Hardware/Software Consultants £541 £568 £596 £626 £657 £690 £724 £760 £798 £838 £880 £924
Dues/Sub/Licenses/Royalties/Trade Assoc £237 £237 £237 £237 £237 £237 £237 £237 £237 £237 £237 £237
Corp & Business Taxes £175 £175 £175 £175 £175 £175 £175 £175 £175 £175 £175 £175
Legal Expenses £109 £109 £109 £109 £109 £109 £109 £109 £109 £109 £109 £109
Accounting Expenses £194 £194 £194 £194 £194 £194 £194 £194 £194 £194 £194 £194
Rent of Office/Warehouse Space £1,210 £1,210 £1,210 £1,210 £1,210 £1,210 £1,210 £1,210 £1,210 £1,210 £1,210 £1,210
Repairs/Maintenance £95 £95 £95 £95 £95 £95 £95 £95 £95 £95 £95 £95
Communications £780 £780 £780 £780 £780 £780 £780 £780 £780 £780 £780 £780
Utilities £77 £77 £77 £77 £77 £77 £77 £77 £77 £77 £77 £77
Office Expenses £701 £701 £701 £701 £701 £701 £701 £701 £701 £701 £701 £701
Miscellaneous/Other £382 £382 £382 £382 £382 £382 £382 £382 £382 £382 £382 £382
Liability Insurance £626 £626 £626 £626 £626 £626 £626 £626 £626 £626 £626 £626
Vehicle Expenses & Insurance £866 £866 £866 £866 £866 £866 £866 £866 £866 £866 £866 £866
Liability Insurance for employees £42 £42 £42 £42 £42 £42 £42 £42 £42 £42 £42 £42
Vehicle Expenses & Insurance £337 £337 £337 £337 £337 £337 £337 £337 £337 £337 £337 £337
Insurance - General (#43) 15% £85 £85 £85 £85 £85 £85 £85 £85 £85 £85 £85 £85
Payroll Taxes 18% £5,471 £5,472 £5,472 £5,472 £5,472 £5,472 £5,472 £5,472 £5,472 £5,472 £5,472 £5,472
Total Operating Expenses £49,578 £49,944 £50,334 £50,750 £51,194 £51,668 £52,176 £52,719 £53,298 £53,918 £54,582 £55,293
Profit Before Interest and Taxes (£14,549) (£13,061) (£12,062) (£4,217) £862 £4,460 £3,150 £5,856 £5,557 £7,143 £2,323 £1,603
EBITDA (£13,811) (£12,323) (£11,324) (£3,479) £1,600 £5,198 £3,888 £6,594 £6,295 £7,881 £3,061 £2,341
Interest Expense £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Taxes Incurred £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Net Profit (£14,549) (£13,061) (£12,062) (£4,217) £862 £4,460 £3,150 £5,856 £5,557 £7,143 £2,323 £1,603
Net Profit/Sales -18.94% -16.18% -14.42% -4.17% 0.76% 3.67% 2.63% 4.62% 4.37% 5.42% 1.89% 1.30%
Pro Forma Cash Flow
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Cash Received
Cash from Operations
Cash Sales £19,200 £20,182 £20,919 £25,283 £28,203 £30,356 £29,937 £31,656 £31,809 £32,978 £30,789 £30,789
Cash from Receivables £294,000 £294,000 £177,719 £59,171 £61,726 £69,740 £80,521 £88,053 £90,396 £92,561 £95,213 £97,297
Subtotal Cash from Operations £313,200 £314,182 £198,638 £84,454 £89,928 £100,096 £110,457 £119,709 £122,205 £125,539 £126,002 £128,086
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 £313,200 £314,182 £198,638 £84,454 £89,928 £100,096 £110,457 £119,709 £122,205 £125,539 £126,002 £128,086
Expenditures Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Expenditures from Operations
Cash Spending £30,566 £30,567 £30,567 £30,567 £30,567 £30,567 £30,567 £30,568 £30,568 £30,568 £30,568 £30,568
Bill Payments £71,721 £60,124 £62,550 £64,755 £74,265 £80,810 £85,646 £85,430 £89,493 £90,475 £93,331 £89,552
Subtotal Spent on Operations £102,288 £90,691 £93,117 £95,322 £104,832 £111,377 £116,213 £115,998 £120,061 £121,044 £123,899 £120,120
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 £102,288 £90,691 £93,117 £95,322 £104,832 £111,377 £116,213 £115,998 £120,061 £121,044 £123,899 £120,120
Net Cash Flow £210,912 £223,491 £105,522 (£10,868) (£14,904) (£11,281) (£5,756) £3,710 £2,144 £4,495 £2,103 £7,967
Cash Balance £394,340 £617,831 £723,353 £712,485 £697,581 £686,300 £680,544 £684,255 £686,399 £690,894 £692,997 £700,964
Pro Forma Balance Sheet
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Assets Starting Balances
Current Assets
Cash £183,428 £394,340 £617,831 £723,353 £712,485 £697,581 £686,300 £680,544 £684,255 £686,399 £690,894 £692,997 £700,964
Accounts Receivable £735,000 £498,599 £265,145 £150,184 £166,863 £189,744 £211,071 £220,360 £227,276 £232,307 £238,679 £235,834 £230,904
Other Current Assets £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380 £31,380
Total Current Assets £949,808 £924,318 £914,356 £904,916 £910,728 £918,705 £928,751 £932,284 £942,911 £950,086 £960,953 £960,211 £963,249
Long-term Assets
Long-term Assets £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879 £145,879
Accumulated Depreciation £56,879 £57,617 £58,355 £59,093 £59,831 £60,569 £61,307 £62,045 £62,783 £63,521 £64,259 £64,997 £65,735
Total Long-term Assets £89,000 £88,262 £87,524 £86,786 £86,048 £85,310 £84,572 £83,834 £83,096 £82,358 £81,620 £80,882 £80,144
Total Assets £1,038,808 £1,012,580 £1,001,880 £991,702 £996,776 £1,004,015 £1,013,323 £1,016,118 £1,026,007 £1,032,444 £1,042,573 £1,041,093 £1,043,393
Liabilities and Capital Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Current Liabilities
Accounts Payable £69,720 £58,041 £60,402 £62,286 £71,577 £77,955 £82,803 £82,448 £86,481 £87,360 £90,347 £86,543 £87,239
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 £69,720 £58,041 £60,402 £62,286 £71,577 £77,955 £82,803 £82,448 £86,481 £87,360 £90,347 £86,543 £87,239
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Liabilities £69,720 £58,041 £60,402 £62,286 £71,577 £77,955 £82,803 £82,448 £86,481 £87,360 £90,347 £86,543 £87,239
Paid-in Capital £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
Retained Earnings £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088 £949,088
Earnings £0 (£14,549) (£27,610) (£39,672) (£43,889) (£43,027) (£38,567) (£35,418) (£29,562) (£24,004) (£16,861) (£14,538) (£12,935)
Total Capital £969,088 £954,539 £941,478 £929,416 £925,199 £926,061 £930,521 £933,670 £939,526 £945,084 £952,227 £954,550 £956,153
Total Liabilities and Capital £1,038,808 £1,012,580 £1,001,880 £991,702 £996,776 £1,004,015 £1,013,323 £1,016,118 £1,026,007 £1,032,444 £1,042,573 £1,041,093 £1,043,393
Net Worth £969,088 £954,539 £941,478 £929,416 £925,199 £926,061 £930,521 £933,670 £939,526 £945,084 £952,227 £954,550 £956,153
Long-term
FY 2009 FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018
Sales £1,328,403 £1,496,903 £1,666,998 £1,822,098 £1,982,202 £1,995,000 £2,024,925 £2,055,299 £2,086,128 £2,117,420
Cost of Sales £715,885 £805,135 £895,541 £978,094 £1,063,327 £1,057,350 £1,073,210 £1,089,308 £1,105,648 £1,122,233
Gross Margin £612,517 £691,768 £771,457 £844,004 £918,875 £937,650 £951,715 £965,990 £980,480 £995,188
Gross Margin % 46.11% 46.21% 46.28% 46.32% 46.36% 47.00% 47.00% 47.00% 47.00% 47.00%
Operating Expenses £625,452 £668,161 £703,328 £740,345 £779,309 £778,050 £789,721 £801,567 £813,590 £825,794
Operating Income (£12,935) £23,607 £68,129 £103,658 £139,566 £159,600 £161,994 £164,424 £166,890 £169,394
Net Income (£12,935) £17,705 £51,097 £77,744 £104,675 £1,321,466 £1,453,613 £1,598,974 £1,758,872 £1,934,759
Current Assets £963,249 £989,191 £1,059,473 £1,156,141 £1,280,569 £1,283,130 £1,285,696 £1,288,267 £1,290,844 £1,293,426
Long-term Assets £80,144 £70,822 £61,009 £50,680 £39,807 £36,031 £39,634 £43,598 £47,958 £52,753
Current Liabilities £87,239 £86,155 £95,527 £104,122 £113,002 £92,950 £102,245 £112,470 £123,716 £136,088
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Equity £956,153 £973,858 £1,024,955 £1,102,699 £1,207,374 £1,226,211 £1,223,085 £1,219,396 £1,215,085 £1,210,091