BUDGET INCOME & EXPENDITURE ACCOUNT

Dukes Court (Lewisham) Residents Company Limited
Service Charge Budget 12 Year Plan - Y/E 31 March - All numbers in £ sterling
Historical Service Charge Budgets Current 2019 Future Service Charge Budgets
Income & Expnditure 2012 2013 2014 2015 2016 2017 2018 2020 2021 2022 2023
Income - service charges to 31 March Service Chg 16,398.00 17,591.00 14,000.00 14,325.53 13,500.00 13,500.00 13,500.00 13,000.00 14,500.00 14,500.00 14,500.00 14,500.00
Other Inc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Income £16398.00 £17591.00 £14000.00 £14325.53 £13500.00 £13500.00 £13500.00 £13000.00 £14500.00 £14500.00 £14500.00 £14500.00
Expenditure - Represents each category of expenditure budgeted for management of the block. Building Ins 2,500.00 2,776.00 2,508.00 2,140.00 2,074.00 2,137.00 2,393.00 2,338.00 2,358.00 2,341.00 2,286.00 2,258.00
Directors Ins 300.00 127.00 161.00 192.00 191.00 184.00 136.00 165.00 182.00 167.00 172.00 174.00
Repairs 2,000.00 3,459.00 3,000.00 2,045.00 3,500.00 3,500.00 3,500.00 3,167.00 3,021.00 3,149.00 3,110.00 3,124.00
Caretaking 1,500.00 3,898.00 3,360.00 2,907.00 2,879.00 2,895.00 2,914.00 3,142.00 4,000.00 3,116.00 3,019.00 2,976.00
Filing Fee 15.00 15.00 15.00 24.00 15.00 15.00 15.00 17.00 16.00 16.00 17.00 17.00
Management 2,520.00 2,500.00 2,500.00 2,180.00 2,500.00 2,500.00 2,500.00 3,000.00 2,525.00 2,526.00 2,529.00 2,532.00
Electricity 600.00 259.00 335.00 370.00 375.00 384.00 259.00 330.00 364.00 335.00 334.00 345.00
Accountancy 700.00 380.00 1,200.00 1,200.00 1,200.00 1,200.00 1,200.00 1,300.00 1,350.00 1,350.00 1,350.00 1,400.00
Major Works 12,000.00 5,000.00 0.00 0.00 0.00 0.00 0.00 12,000.00 0.00 0.00 0.00 0.00
Legal Fees 100.00 100.00 0.00 0.00 0.00 0.00 0.00 100.00 38.00 30.00 21.00 24.00
Bank Fees 100.00 100.00 21.00 95.00 88.00 81.00 12.00 150.00 81.00 78.00 76.00 82.00
Other 100.00 100.00 0.00 0.00 0.00 0.00 0.00 0.00 25.00 16.00 5.00 6.00
Total Spend £22435.00 £18714.00 £13100.00 £11153.00 £12822.00 £12896.00 £12929.00 £25709.00 £13960.00 £13124.00 £12919.00 £12938.00
(Deficit / Surplus -6037.00 -1123.00 900.00 3172.53 678.00 604.00 571.00 -12709.00 540.00 1376.00 1581.00 1562.00
Reserves Balance B/Fwd £18034.00 £11997.00 £10874.00 £11774.00 £14946.53 £15624.53 £16228.53 £16799.53 £4090.53 £4630.53 £6006.53 £7587.53
Accumulated Reserves £11997.00 £10874.00 £11774.00 £14946.53 £15624.53 £16228.53 £16799.53 £4090.53 £4630.53 £6006.53 £7587.53 £9149.53

BUDGET BALANCE SHEET
Note: the balance sheet is currently being updated and numbers are subject to change.
Dukes Court (Lewisham) Residents Company Limited
Service Charge Budget 12 Year Plan - As at 31 March - All numbers in £ sterling
Historical Service Charge Budgets Current 2019 Future Service Charge Budgets
BALANCE SHEET 2012 2013 2014 2015 2016 2017 2018 2020 2021 2022 2023
Current Assets Debtors 3,100.15 3,100.24 3,100.24 3,292.97 3,292.97 3,292.97 3,292.97 1,292.97 792.97 292.97 -207.03 -687.03
Prepayments 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Agent 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Cash 9,908.85 8,785.76 9,685.76 12,665.56 13,343.56 13,947.56 14,518.56 3,809.56 4,849.56 6,725.56 8,806.56 10,848.56
Total Current Assets £13009.00 £11886.00 £12786.00 £15958.53 £16636.53 £17240.53 £17811.53 £5102.53 £5642.53 £7018.53 £8599.53 £10161.53
Current Liabilities
Creditors 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
Agent Loan 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Accruals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Current Liabilities £1000.00 £1000.00 £1000.00 £1000.00 £1000.00 £1000.00 £1000.00 £1000.00 £1000.00 £1000.00 £1000.00 £1000.00
Net Current Assets £12009.00 £10886.00 £11786.00 £14958.53 £15636.53 £16240.53 £16811.53 £4102.53 £4642.53 £6018.53 £7599.53 £9161.53
Capital & Reserves Capital 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00
Reserves 11,997.00 10,874.00 11,774.00 14,946.53 15,624.53 16,228.53 16,799.53 4,090.53 4,630.53 6,006.53 7,587.53 9,149.53
Net Capital & Reserves £12009.00 £10886.00 £11786.00 £14958.53 £15636.53 £16240.53 £16811.53 £4102.53 £4642.53 £6018.53 £7599.53 £9161.53

BUDGET DEBTORS LEDGER CONTROL SUMMARY

Note: the balance sheet is currently being updated and numbers are subject to change.
DEBTORS CONTROL 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Sales Ledger Control Account Bal B/Fwd £3100.00 £3100.15 £3100.24 £3100.24 £3292.97 £3292.97 £3292.97 £3292.97 £1292.97 £792.97 £292.97 £-207.03
Billing 16,398.00 17,591.00 14,000.00 14,325.53 13,500.00 13,500.00 13,500.00 13,000.00 14,500.00 14,500.00 14,500.00 14,500.00
Receipts 16,397.85 17,590.91 14,000.00 14,132.80 13,500.00 13,500.00 13,500.00 15,000.00 15,000.00 15,000.00 15,000.00 14,980.00
Closing Debtors Balance £3100.15 £3100.24 £3100.24 £3292.97 £3292.97 £3292.97 £3292.97 £1292.97 £792.97 £292.97 £-207.03 £-687.03

BUDGET DEBTORS LEDGER ACCOUNT DETAIL

Note: the balance sheet is currently being updated and numbers are subject to change.
Opening Debtors Balance 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Budgeted Debtors Ledger Opening Balances Flat 1 2.00 2.01 2.02 2.02 194.56 194.56 194.56 194.56 24.56 -17.94 -60.44 -102.94
Flat 2 0.00 0.01 0.02 0.02 0.03 0.03 0.03 0.03 -169.97 -212.47 -254.97 -297.47
Flat 3 0.00 0.01 0.02 0.02 0.04 0.04 0.04 0.04 -117.96 -147.46 -176.96 -206.46
Flat 4 123.00 123.01 123.02 123.02 123.03 123.03 123.03 123.03 -46.97 -89.47 -131.97 -174.47
Flat 5 123.00 123.02 123.04 123.04 123.06 123.06 123.06 123.06 -104.94 -161.94 -218.94 -275.94
Flat 6 342.00 342.01 342.02 342.02 342.03 342.03 342.03 342.03 172.03 129.53 87.03 44.53
Flat 7 342.00 342.01 342.02 342.02 342.04 342.04 342.04 342.04 224.04 194.54 165.04 135.54
Flat 8 342.00 342.01 342.02 342.02 342.03 342.03 342.03 342.03 172.03 129.53 87.03 44.53
Flat 9 342.00 342.02 342.04 342.04 342.06 342.06 342.06 342.06 114.06 57.06 0.06 -56.94
Flat 10 342.00 342.01 342.02 342.02 342.03 342.03 342.03 342.03 172.03 129.53 87.03 44.53
Flat 11 342.00 342.01 342.02 342.02 342.04 342.04 342.04 342.04 224.04 194.54 165.04 135.54
Flat 12 800.00 800.01 800.02 800.02 800.03 800.03 800.03 800.03 630.03 587.53 545.03 502.53
Opening Debtors Budget £3100.00 £3100.15 £3100.24 £3100.24 £3292.97 £3292.97 £3292.97 £3292.97 £1292.97 £792.97 £292.97 £-207.03
Budgeted Invoices 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Billings Budget By Flat Flat 1 1,393.83 1,495.24 1,190.00 1,393.83 1,147.50 1,147.50 1,147.50 1,105.00 1,232.50 1,232.50 1,232.50 1,232.50
Flat 2 1,393.83 1,495.24 1,190.00 1,201.31 1,147.50 1,147.50 1,147.50 1,105.00 1,232.50 1,232.50 1,232.50 1,232.50
Flat 3 967.48 1,037.87 826.00 833.85 796.50 796.50 796.50 767.00 855.50 855.50 855.50 855.50
Flat 4 1,393.83 1,495.24 1,190.00 1,201.31 1,147.50 1,147.50 1,147.50 1,105.00 1,232.50 1,232.50 1,232.50 1,232.50
Flat 5 1,869.37 2,005.37 1,596.00 1,611.16 1,539.00 1,539.00 1,539.00 1,482.00 1,653.00 1,653.00 1,653.00 1,653.00
Flat 6 1,393.83 1,495.24 1,190.00 1,201.31 1,147.50 1,147.50 1,147.50 1,105.00 1,232.50 1,232.50 1,232.50 1,232.50
Flat 7 967.48 1,037.87 826.00 833.85 796.50 796.50 796.50 767.00 855.50 855.50 855.50 855.50
Flat 8 1,393.83 1,495.24 1,190.00 1,201.31 1,147.50 1,147.50 1,147.50 1,105.00 1,232.50 1,232.50 1,232.50 1,232.50
Flat 9 1,869.37 2,005.37 1,596.00 1,611.16 1,539.00 1,539.00 1,539.00 1,482.00 1,653.00 1,653.00 1,653.00 1,653.00
Flat 10 1,393.83 1,495.24 1,190.00 1,201.31 1,147.50 1,147.50 1,147.50 1,105.00 1,232.50 1,232.50 1,232.50 1,232.50
Flat 11 967.48 1,037.87 826.00 833.85 796.50 796.50 796.50 767.00 855.50 855.50 855.50 855.50
Flat 12 1,393.83 1,495.24 1,190.00 1,201.31 1,147.50 1,147.50 1,147.50 1,105.00 1,232.50 1,232.50 1,232.50 1,232.50
Total Billings Budget £16398.00 £17591.00 £14000.00 £14133.00 £13500.00 £13500.00 £13500.00 £13000.00 £14500.00 £14500.00 £14500.00 £14500.00
Budgeted Receipts 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Budget Sales Ledger Receipts By Flat Flat 1 1,393.82 1,495.23 1,190.00 1,201.29 1,147.50 1,147.50 1,147.50 1,275.00 1,275.00 1,275.00 1,275.00 1,255.00
Flat 2 1,393.82 1,495.23 1,190.00 1,201.29 1,147.50 1,147.50 1,147.50 1,275.00 1,275.00 1,275.00 1,275.00 1,275.00
Flat 3 967.47 1,037.86 826.00 833.83 796.50 796.50 796.50 885.00 885.00 885.00 885.00 885.00
Flat 4 1,393.82 1,495.23 1,190.00 1,201.29 1,147.50 1,147.50 1,147.50 1,275.00 1,275.00 1,275.00 1,275.00 1,275.00
Flat 5 1,869.35 2,005.36 1,596.00 1,611.14 1,539.00 1,539.00 1,539.00 1,710.00 1,710.00 1,710.00 1,710.00 1,710.00
Flat 6 1,393.82 1,495.23 1,190.00 1,201.29 1,147.50 1,147.50 1,147.50 1,275.00 1,275.00 1,275.00 1,275.00 1,275.00
Flat 7 967.47 1,037.86 826.00 833.83 796.50 796.50 796.50 885.00 885.00 885.00 885.00 885.00
Flat 8 1,393.82 1,495.23 1,190.00 1,201.29 1,147.50 1,147.50 1,147.50 1,275.00 1,275.00 1,275.00 1,275.00 1,275.00
Flat 9 1,869.35 2,005.36 1,596.00 1,611.14 1,539.00 1,539.00 1,539.00 1,710.00 1,710.00 1,710.00 1,710.00 1,710.00
Flat 10 1,393.82 1,495.23 1,190.00 1,201.29 1,147.50 1,147.50 1,147.50 1,275.00 1,275.00 1,275.00 1,275.00 1,275.00
Flat 11 967.47 1,037.86 826.00 833.83 796.50 796.50 796.50 885.00 885.00 885.00 885.00 885.00
Flat 12 1,393.82 1,495.23 1,190.00 1,201.29 1,147.50 1,147.50 1,147.50 1,275.00 1,275.00 1,275.00 1,275.00 1,275.00
Total Receipts Budget £16397.85 £17590.91 £14000.00 £14132.80 £13500.00 £13500.00 £13500.00 £15000.00 £15000.00 £15000.00 £15000.00 £14980.00
Closing Bal Analysis 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Debtors Ledger - Closing Balances Analysis Flat 1 2.01 2.02 2.02 194.56 194.56 194.56 194.56 24.56 -17.94 -60.44 -102.94 -125.44
Flat 2 0.01 0.02 0.02 0.03 0.03 0.03 0.03 -169.97 -212.47 -254.97 -297.47 -339.97
Flat 3 0.01 0.02 0.02 0.04 0.04 0.04 0.04 -117.96 -147.46 -176.96 -206.46 -235.96
Flat 4 123.01 123.02 123.02 123.03 123.03 123.03 123.03 -46.97 -89.47 -131.97 -174.47 -216.97
Flat 5 123.02 123.04 123.04 123.06 123.06 123.06 123.06 -104.94 -161.94 -218.94 -275.94 -332.94
Flat 6 342.01 342.02 342.02 342.03 342.03 342.03 342.03 172.03 129.53 87.03 44.53 2.03
Flat 7 342.01 342.02 342.02 342.04 342.04 342.04 342.04 224.04 194.54 165.04 135.54 106.04
Flat 8 342.01 342.02 342.02 342.03 342.03 342.03 342.03 172.03 129.53 87.03 44.53 2.03
Flat 9 342.02 342.04 342.04 342.06 342.06 342.06 342.06 114.06 57.06 0.06 -56.94 -113.94
Flat 10 342.01 342.02 342.02 342.03 342.03 342.03 342.03 172.03 129.53 87.03 44.53 2.03
Flat 11 342.01 342.02 342.02 342.04 342.04 342.04 342.04 224.04 194.54 165.04 135.54 106.04
Flat 12 800.01 800.02 800.02 800.03 800.03 800.03 800.03 630.03 587.53 545.03 502.53 460.03
Budget Closing Debtors £3100.15 £3100.24 £3100.24 £3292.97 £3292.97 £3292.97 £3292.97 £1292.97 £792.97 £292.97 £-207.03 £-687.03

BUDGET CASH CONTROL ACCOUNT

Note: the balance sheet is currently being updated and numbers are subject to change.
CASH CONTROL 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Cash Book Control Account Bal B/Fwd £15946.00 £9908.85 £8785.76 £9685.76 £12665.56 £13343.56 £13947.56 £14518.56 £3809.56 £4849.56 £6725.56 £8806.56
Receipts £16397.85 £17590.91 £14000.00 £14132.80 £13500.00 £13500.00 £13500.00 £15000.00 £15000.00 £15000.00 £15000.00 £14980.00
Payments £22435.00 £18714.00 £13100.00 £11153.00 £12822.00 £12896.00 £12929.00 £25709.00 £13960.00 £13124.00 £12919.00 £12938.00
Closing Cash Balance £9908.85 £8785.76 £9685.76 £12665.56 £13343.56 £13947.56 £14518.56 £3809.56 £4849.56 £6725.56 £8806.56 £10848.56
Copyright 2019 © Bigham Consulting Solutions - All rights reserved
Benchmark

2019 Budgeted Reserve Total = £ 16913.23
This is some sample text!

10 Year Trend - Based On Actual Accounts

Liquidity has deteriorated over the ten year period since 2006. This is caused by landlords not paying their service charges in a timely manner. Each landlord is obliged to pay their fees in advance of the year.

NB: We are currently updating the model and these numbers are subject to change
PLANACTUAL£ Change% ChangeSIGNAL
-263 892 -1155 439.16% trade well 14, signal :average trade!
13 12 1 439.16% trade well 14, signal :average trade!
14 30 439.16% One 14, Two :B!
127 138 -11 439.16% Favourable comment to go here 14, comment to go here:Adverse comment to go here!
14 13 1 439.16% comment to go here14, signal comment to go here :comment to go here!
Copyright 2019 © Bigham Consulting Solutions - All rights reserved - Tel: 07880 570 850