Blank Room Lease Agreement by pxi10158

VIEWS: 0 PAGES: 52

Blank Room Lease Agreement document sample

More Info
									OUTPUTS
NAME OF PROJECT


Scheme summary                                                             Outdoor
                                          Number        Buildings m2      spaces m2
Affordable homes                                    0                 0
Community building                                  0                 0
Office premises
Meeting rooms                                       0                 0
Shops                                               0                 0
Workspaces                                          0                 0
Multi-use games area                                0                                0
Sportsfield                                         0                                0
Pavilion/changing rooms                                               0
Circulation                                                           0
Homes for sale                                      0                 0
TOTAL AREA                                                            0              0


Cost                                                         £
Land                                                                  0
Building work                                             #DIV/0!
Fees                                                      #DIV/0!
Fitting out costs                                         #DIV/0!
Other costs                                               #DIV/0!
TOTAL EXPENDITURE                                         #DIV/0!


Income
Housing - equity sales                                                0
Housing - loans repaid from rent                                      0
Housing for sale                                                      0
Workshop/shop loans repaid from rent
Workshop sales                                                        0
Loan on community building                                            0
Loan on meeting spaces                                                0
Loan on sports facilities                                             0
Other sources
Parish Council                                                        0
District authority                                                    0
County authority                                                      0
Devon CCD scheme                                                      0
s106                                                                  0
Local Action Group (LEADER4)                                          0
CommunityBuilders                                                     0
Lottery                                                               0
Sport England                                                         0
Charitable Trusts                                                     0
Homes & Communities Agency                                            0
Local fundraising                                                     0
Others                                                                0
TOTAL INCOME                                                          0


Development cash flow forecast         Buy land             1-Apr-10
                                       Planning
                                       granted              1-Jun-10
                                       Start                1-Jan-11
                                       Complete             1-Jan-12
Expenditure                                Pre-         Jan-Jun '10       Jul-Dec '10 Jan-Jun '11 Jul-Dec '11 Jan-Jun '12 Jul-Dec '12
                                         purchase
                                             £               £                £            £             £             £             £
Land                                                0     #DIV/0!                    0             0             0             0             0
Building work                             #DIV/0!                     0              0   #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Fitting out costs                                   0                 0              0             0   #DIV/0!       #DIV/0!       #DIV/0!
Fees and charges including VAT            #DIV/0!         #DIV/0!          #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Total income                              #DIV/0!         #DIV/0!          #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!


Income
Sales                                               0                 0              0             0             0             0             0
Loans                                               0                 0              0             0             0             0             0
Grants                                    #DIV/0!         #DIV/0!          #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Own funds                                           0                 0              0             0             0             0             0
Total expenditure                         #DIV/0!         #DIV/0!          #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Net income                                #DIV/0!         #DIV/0!          #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Cumulative income                     #DIV/0!          #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!   #DIV/0!

Maximum development loan required:    #DIV/0!       (note may exceed number above if peak loan is not at end of a quarter)




Revenue forecast
Inflation                                 2.50%
Wage/cost inflation                       3.00%                                     2009/10
                                                                                      £
Staff salaries including NI/pension                                                           0
Advertising/marketing                                                                         0
Equipment depreciation                                                                        0
Fire and alarm maintenance                                                                    0
Service charges                                                                               0
Rates                                                                                         0
Water rates                                                                                   0
Training                                                                                      0
Heat, light power                                                                             0
Telephones                                                                                    0
Postage                                                                                       0
Printing and stationery                                                                       0
Recruitment                                                                                   0
Insurance                                                                                     0
Repairs and maintenance                                                                       0
Cleaning                                                                                      0
Cleaning materials                                                                            0
Book-keeping and finance support                                                              0
IT                                                                                            0
Website                                                                                       0
Refuse collection                                                                             0
Sportsfield maintenance                                                                       0
Miscellaneous                                                                                 0
SUBTOTAL                                                                                      0
Housing costs                                                                                 0
Loan repayments                                                                               0
TOTAL                                                                                         0


Income                                                                                £
Housing income                                                                                0
Workshop rent                                                                                 0
Use of community building                                                                     0
Office and shop rent                                                                          0
Meeting room lettings                                                                         0
Sportsfield, MUGA and pavilion                                                                0
TOTAL                                                                                         0


Surplus/deficit                                                                               0




Start up funding
                                      Year 1            Year 2        Year 3        Year 4        Year 5
                                         £                £              £            £             £
Income                                          0                0              0             0             0
Expenditure                                     0                0              0             0             0
Surplus/deficit                                 0                0              0             0             0


Surplus/deficit                                 0                0              0             0             0
Brought forward                                 0                0              0             0             0
Grant required                                  0
Carried forward                                 0                0              0             0             0
Your scheme
1. What will it include?


Summary                                         Communi Office       Meeting                 Work                   Circulation
                                  Homes                                        Shops                 Pavilion                     TOTAL
                                                ty building premises rooms                  spaces
m2                                          0           0                  0           0         0              0             0       0

Affordable homes
                           "1-bed 2-person" "2bed 3p" "2-bed 4p" "3bed 4p" "3bed 5/6p" "4bed 6p" "4bed 7/8p""5bed 8/10p"
Shared equity sale                                                                                                                    0
Submarket rent                                                                                                                        0
TOTAL                                       0           0         0        0           0         0              0             0       0
For older people                                                                                                                      0
Disabled                                                                                                                              0


Community building                                                             Size                                                         Kitchen
Size m2                                   100        150        200      250          300      350        400              450       500
Enter number                                                                                                                                          0
Default fee for weekday daytime           20           20        20       22          22        25          25               25       25
Default fee for weekday evening           25           30        30       35          35        40          40               45       45
Default fee for weekend daytime           25           30        30       35          35        40          40               45       45
Default fee for weekend evening           40           45        50       55          60        70          80               90      100
Fee for weekday daytime                                                                                                                    Income from 3 lettings/ day, 7
Fee for weekday evening                                                                                                                         a week, 52 weeks a year
Fee for weekend daytime
Fee for weekend evening
TOTAL MAXIMUM, one
letting per session                  26260         29120     29640     33540     34060       39000      40040            43420     44460
Potential for subdivision                0             0      10%       20%       20%         25%        40%              50%       50%
TOTAL MAXIMUM INCOME                     0             0         0         0         0           0          0                0         0

Office premises                                 Rent/m2
                                   m2                       Income
                                                     120          0                                                                        Income from 3 lettings/ day, 7
                                                                                                                                                a week, 52 weeks a year
Meeting rooms             Size (m2)                  5       10            15                25        40           65          100 Total area
                          Number                                                                                                             0
                          Fee per 3 hours                                                                                                              Income as % of maximum
                          Default fee          £12.00     £15.00       £20.00         £25.00        £30.00    £45.00       £60.00

Shops                                         25m2       50m2         100m2        Total m2                  Rent        Income
                          Number                                                           0                                      0

Workspaces                                    10m2       25m2         50m2          75m2           100m2     200m2       Total m2 Rent £/m2 Rent m2
                          Number                                                                                                 0
                                                     0           0           0               0          0            0
                                                                                                                                                   Sales m2
                              400m2         1-hour fee Hrs/week                                                          Income                            0
Multi-use games area                                                                                                              0

                              Football      Half-size                                                                    Income
                                                                                 Fee for          Fee for
                             6,000m2        2,500m2 Total m2                     full size        half-size Weeks                     (assumed 39)
Sportsfield                                                0                                                                0
                                                                     Default fee         £50          £25

Pavilion/changing rooms                       50m2       100m2       Total m2
                                                                            0 No extra fees assumed


Homes for sale            "1-bed 2-person" "2bed 3p" "2-bed 4p" "3bed 4p" "3bed 5/6p" "4bed 6p" "4bed 7/8p""5bed 8/10p"                Total         m2
Number                                                                                                                                         0          0
              Toilets,
              storage
                              Total m2
                         0       0




Income from 3 lettings/ day, 7 days
     a week, 52 weeks a year
                      £0



                         £0




Income from 3 lettings/ day, 7 days
     a week, 52 weeks a year
                  £0

Income as % of maximum
               £0




     Total rent
                  0


                  0




         Sales
                  £0
                                                                                    Operational
Elements of a financial plan   Project     Capital budget                               budget
                               develop-   Sources                                 Sources
                                ment         of     Expen- Capital Start-up          of     Expen- Revenue
                                budget    income diture cash flow budget          income diture cash flow Reserves
Project idea
Project outline
Project development plan
Business plan
Project funding secured
Capital work priced
Complete: starting up
Up and running

                                          You know what the project aims to do; where the funds might come from if it
                                          will involve capital spending; and how it would meet its costs once up and
                                          You have broadly worked out the numbers and can answer questions about
                                          how the project will work
                                          You have prepared a forecast based on evidence or professional advice
                                          You have figures which you are confident can be achieved
                                          Your financial plan is in operation: real costs replace estimates
Project development budget

 Work needed to move project to            Who could do the work?           Likely costs                   Notes
  major grant application stage
Project feasibility study                                                                  Dependent on size of project and
                                                                                           work necessary
Building design brief
Printing, volunteer expenses, hire of
premises etc.
Legal advice on legal structures for
the project group

General legal advice on the terms
of the land purchase or agreements
with funders etc
Bid writing (for project development
costs)
Site feasibility study

Measured survey of site
Site investigations

Planning drawings (to RIBA stage                                                           Around 2% (35% of 6%) of build
D) and indicative costs                                                                    cost but architects/building
                                                                                           surveyors may well agree to get
                                                                                           your site to planning stage for a
                                                                                           fixed fee which is lower than this if
                                                                                           they will have the opportunity to
Planning application fees
Business Plan

Bid writing (for project)

Legal fees for land search if buying/
leasing land
Legal advice on the terms of the
purchase or lease agreement
Disabled access advice

Environmental Impact Assessment                                                            Contact English Nature, Devon
                                                                                           Wildlife Trust etc.
Full set of drawings

Full Bill of Quantities

                                        Stage 1 - to enable the project
                                        development funds to be raised               £0
                                        Stage 2 - to enable a business
                                        plan to be developed                         £0
                                        Stage 3 - to secure the funds for
                                        the project itself (which may be
                                        dependent on securing planning               £0
                                        Total                                        £0
Project development budget

 Work needed to move project to            Who could do the work?           Likely costs                 Notes
  major grant application stage
Project feasibility study

Building design brief
Printing, volunteer expenses, hire of
premises etc.
Legal advice on legal structures for
the project group

General legal advice on the terms
of the land purchase or agreements
with funders etc
Bid writing (for project development
costs)
Site feasibility study

Measured survey of site                                                                    Often around £1,000 (entered as
Site investigations                                                                        default)


Planning drawings (to RIBA stage                                                           Usually a sum of around £270 per
D) and indicative costs                                                                    house (entered as default).
Planning application fees
Business Plan

Bid writing (for project)

Legal fees for land search if buying/
leasing land
Legal advice on the terms of the
purchase or lease agreement
Disabled access advice

Environmental Impact Assessment                                                            Contact English Nature, Devon
                                                                                           Wildlife Trust etc.
Full set of drawings

Full Bill of Quantities

                                        Stage 1 - to enable the project
                                        development funds to be raised               £0
                                        Stage 2 - to enable a business
                                        plan to be developed                     £1,000
                                        Stage 3 - to secure the funds for
                                        the project itself (which may be
                                        dependent on securing planning               £0
                                        Total                                    £1,000
PROJECT NAME:

INCOME
   1             2           3             4            5             6             7            8        9          10             11         12        13
                                                                                                                               Management,
                           Number                             Open                                                               insurance,
                              of                             market                                                        maintenance, cyclical Mortgage
                          bedrooms Number                     value                                     Number                  and planned        based
               Suggested     and   of each                   (OMV)        Number of            Equity of rented            maintenance and void   on this
Type Size (m2) sizes (m2) persons    type                      (£)        part-equity   % OMV share (£) homes              cost per week (M&M):   rent (£)
                                                                                                                                 M&M:
                                                                                                                                        Typical
                                                                                                                           Rent £pw        £pw
A           55          55         1bed 2p       0            90,000         0            50%         45,000           0                        85       0
B           65          65         2bed 3p       0           140,000         0            50%         70,000           0                        97       0
C           72          72         2bed 4p       0           170,000         0            50%         85,000           0                       105       0
D           77          77         3bed 4p       0           180,000         0            50%         90,000           0                       115       0
E           92          92        3bed 5/6p      0           190,000         0            50%         95,000           0                       130       0
F           98          98         4-bed 6p      0           210,000         0            50%        105,000           0                       140       0
G          105         105        4-bed 7/8p     0           220,000         0            50%        110,000           0                       155       0
H          112         112       5-bed 8/10p     0           240,000         0            50%        120,000           0                       165       0
Subtotal                                         0                           0             Sales:          0           0              Rental loan:       0
           m2                0                                      Rental element        0.75%                 OK               Part-equity sales       0
                                                            Loan on rental element:                       0                Loan on rental element:       0
TOTAL INCOME                                                                                                                                             0

                                                             Annual
                                                            increase
                                                                in
                                    Rate       Period        payment
Loan terms available

EXPENDITURE                                                                                 £
INCOME                                                                                                                                          0

                                                                                            £                                               £
LAND                                                                                                                                            0
                                                                            Estimate
                                                                          £/m2      (2- Agreed
                                                                              bed)       price
CONSTRUCTION                                                                                                                                    0


ON-COSTS                                                                                                                                        0
                                                                                                                                                0

Surplus/deficit                                 Per                                                                                             0
                                               equity
                                 Per rented    share
Additional income                  home        home                                                                            £            £
HCA grant                                                                                                                                       0
                                      Source
Other grant


Surplus from sales                                                                      Number              0 Income                  0
                                                                                                              Cost                    0         0
                                                                                        % of build cost as sweat                                0
Self-build option
                                                                                        Extra supervision costs                                 0
Total additional income                                                                                                                         0

Total cost                                                                                                                                      0
Total income                                                                                                                                    0
OVERALL SURPLUS/DEFICIT                                                                                                                         0
PROJECT NAME:

Details of cost                                            Types of home
                                                   TOTAL
Number                                               0
Size                                  m2             0
                                                     £

Land                                                   0
Legals - acquisition and set-up                        0
Legals - part-equity sales. HCA                        0
Site investigation & survey                            0
                               2-bed4p
                                £/m2     Typical
Build (from "quick" sheet)                1,200        0
Elderly/disabled adaptations              3,000        0
Disabled adaptations                      7,000        0
                              Per home
Infrastructure                            7,000        0
                            Total scheme
Exceptional costs                                      0
Architects fees                           3-6%         0
QS fees                                   0-4%         0
                              Per home
Planning                                   270         0
Building regs                                          0
Other fees and charges                    0-2%         0
Employer's agent                       1.5%-2.5%       0
RSL costs                                 0-3%         0

10 year guarantees                     1,000           0
Finance fees                           1.00%           0
CLT fee                                1.50%           0

CLT contingency /dowry                 2.00%           0
                           Per home
Marketing/sale                         0-500           0
VAT                                                    0
Interest                               7.00%           0
TOTAL COST                                             0
Grant                                                  0
Total cost                                             0
Build £/m2
Types of home
                TOTAL
                  0
                  0
                  £

                    0
                    0
                    0
                    0



                    0
                    0
                    0

                    0

                    0
                    0
                    0

                    0
                    0
                    0
                    0
                    0

                    0
                    0
                    0

                    0


                    0
                    0
                    0
                    0
                    0
                    0
                    0
m2                                                       0                    Total m2
Staff                                                    0



General admin cost of centre
Inflation                                           2.50%                     Year
Wage/cost inflation        Charge %                 3.00%
                           to                                NI/pension
Job title                  services?            Salary                        % full-time

                                                                          0
                                                                          0
                                                                          0              0%
                                                                          0              0%
                                                                          0              0%
                                                                          0              0%
Subtotal                                                                                 0.0

                                                                                 Basis for
                                   Notes                     Suggestion         default calc   Your estimate
                                                                 £                   £               £
Advertising/marketing                      1 see note                500      see note
Equipment depreciation                                                  0     cost/m2
Fire and alarm maintenance                                         1,200      lump sum
Service charges                            2 see note                   0     see note
Rates                                                                   0     cost/m2
Water rates                                                             0     cost/person
Training                                                                0     cost/m2
Heat, light power                                                       0     cost/m2
Telephones                                                              0     cost/person
Postage                                    3 see note                   0     cost/person
Printing and stationery                                                 0     cost/person
Recruitment                                4 see note                400      lump sum
Insurance                                                               0     cost/m2
Repairs and maintenance                                                 0     cost/m2
Cleaning                                                                0     cost/m2
Cleaning materials                                                      0     cost/m2
Book-keeping and finance support                                     133      % total
IT                                                                      0     cost/person
Website                                                              700      lump sum
Refuse collection                                                       0     cost/m2
Sportsfield maintenance                                                 0     cost/m2
Miscellaneous                                                         19      % total
SUBTOTAL
Housing costs
Loan repayments
TOTAL

Income
Housing income
Workshop rent
Use of community building
Office and shop rent
Office service charges
Meeting room lettings
Sportsfield, MUGA and pavilion
TOTAL

Surplus/deficit
Notes
1. The need for advertising and marketing depends very much on the project. If you are meeting the needs of a known
group it coiuld be quite low - say £1,500 for producing an annual report and a leaflet to explain your aims: if you have
rooms and office space to be let, or events to attract people to, £10,000 or so may be needed.
2. If you are part of a larger building there may be a service charge from your landlord. If you are the building owner
but share it with others, you may need to prepare a building running cost budget and allocate it between your
organisation and others. You would then need to re-introduce your share of costs here.
3. A substantial promotional budget may well also need a higher postage budget to pay for mailshots. Otherwise a
cost of around £200 per person might suffice.
4. You will have a substantial recruitment cost in year 1: thereafter you may go several years without cost. You can
either handle these costs when they arise or create a sinking fund. Recruitment via the press can cost £1,000-£3,000:
recruitment via websites can be a lot cheaper and may be no more than a few hundred pounds.
    1
 2009/10
     0.00%



             0
             0
             0
             0
             0
             0
             0


Plus inflation
      £
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
              0
                             0



                             0
                             0
                             0
                             0
                             0
                             0
                             0
                             0

                             0

eting the needs of a known
in your aims: if you have
d.
u are the building owner
e it between your


mailshots. Otherwise a


s without cost. You can
 s can cost £1,000-£3,000:
nds.
                                                    1         2          3          4
                                            April       May       June       July
Expenditure                                  £           £          £         £
Salaries/NI/pension                0   M            0         0          0          0
Advertising/marketing              0    B           0         0          0          0
Equipment depreciation             0   AE           0         0          0          0
Fire and alarm maintenance         0   AE           0         0          0          0
Service charges                    0   M            0         0          0          0
Rates                              0    B           0         0          0          0
Water rates                        0    B           0         0          0          0
Training                           0    B           0         0          0          0
Heat, light power                  0   M            0         0          0          0
Telephones                         0   M            0         0          0          0
Postage                            0   M            0         0          0          0
Printing and stationery            0   M            0         0          0          0
Recruitment                        0   AS           0         0          0          0
Insurance                          0   AS           0         0          0          0
Repairs and maintenance            0   M            0         0          0          0
Cleaning                           0   M            0         0          0          0
Cleaning materials                 0   M            0         0          0          0
Book-keeping and finance support   0   M            0         0          0          0
IT                                 0   AS           0         0          0          0
Website                            0   M            0         0          0          0
Refuse collection                  0   M            0         0          0          0
Sportsfield maintenance            0   M            0         0          0          0
Miscellaneous                      0   M            0         0          0          0
SUBTOTAL                           0                0         0          0          0
Housing costs                      0   M            0         0          0          0
Loan repayments                    0   B            0         0          0          0
TOTAL                              0                0         0          0          0

Income
Housing income                     0   M            0         0          0          0
Workshop rent                      0   M            0         0          0          0
Use of community building          0   M            0         0          0          0
Office and shop rent               0   M            0         0          0          0
Meeting room lettings              0   M            0         0          0          0
Sportsfield, MUGA and pavilion     0   M            0         0          0          0
TOTAL                              0                0         0          0          0

Surplus/deficit                                     0         0          0          0
Brought forward                                     0         0          0          0
Carried forward                                     0         0          0          0
      5         6         7         8         9         10         11         12
Aug       Sep       Oct       Nov       Dec       Jan        Feb        Mar
 £         £         £         £         £         £          £          £
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0    0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0


      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0    0

      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
      0         0         0         0         0          0         0          0
                                                              Year 1                        Year 2
                                                   Your view Suggested           Your view Suggested
              Inflation                                          2.50%             0.00%      2.50%
Items higher in year 1                                            120%                          90%
Items that continue                                               100%                         100%
Items that grow                    Full year                       75%                          90%
Expenditure                                                              £
Salaries/NI/pension                            0                 100%        0                100%
Advertising/marketing                          0                 120%        0                 90%
Equipment depreciation                         0                 100%        0                100%
Fire and alarm maintenance                     0                 100%        0                100%
Service charges                                0                 100%        0                100%
Rates                                          0                 100%        0                100%
Water rates                                    0                 100%        0                100%
Training                                       0                 120%        0                 90%
Heat, light power                              0                 100%        0                100%
Telephones                                     0                  75%        0                 90%
Postage                                        0                 100%        0                100%
Printing and stationery                        0                 100%        0                100%
Recruitment                                    0                 120%        0                 90%
Insurance                                      0                 100%        0                100%
Repairs and maintenance                        0                  75%        0                 90%
Cleaning                                       0                 100%        0                100%
Cleaning materials                             0                 100%        0                100%
Book-keeping and finance support               0                  75%        0                 90%
IT                                             0                 100%        0                100%
Website                                        0                 100%        0                100%
Refuse collection                              0                 100%        0                100%
Sportsfield maintenance                        0                 100%        0                100%
Miscellaneous                                  0                 100%        0                100%
SUBTOTAL                                       0                 100%        0                100%
Housing costs                                  0                  75%        0                 90%
Loan repayments                                0                 100%        0                100%
TOTAL                                          0                             0

Income
Housing income                                 0                 100%        0                100%
Workshop rent                                  0                 100%        0                100%
Use of community building                      0                  75%        0                 90%
Office and shop rent                           0                 100%        0                100%
Meeting room lettings                          0                  75%        0                 90%
Sportsfield, MUGA and pavilion                 0                  75%        0                 90%
TOTAL                                          0                             0

Deficit grant required                         0


Surplus/deficit                                0                             0
Brought forward                                0                             0
Carried forward                                0                             0
Year 2                      Year 3                         Year 4                        Year 5
                 Your view Suggested           Your view Suggested           Your view Suggested
                              2.50%                          2.50%                         2.50%
                                90%                           100%                          100%
                               100%                           100%                          100%
                               100%                           100%                          100%
         £                             £                             £                             £
             0                100%         0                 100%        0                 100%        0
             0                 90%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                 90%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                 90%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%
             0                100%         0                 100%        0                 100%        0
             0                             0                             0                             0


             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                100%         0                 100%        0                 100%        0
             0                             0                             0                             0




             0                             0                             0                             0
             0                             0                             0                             0
             0                             0                             0                             0
              ITEM                                                                  Offices,
                                                                         Communit meeting
                                                             Homes       y building rooms             Shop
                                                   Guide
                                                   cost/m                    1,700         1,100          900
                                                    2 or
Proposed cost/m2 - new build                        cost
Proposed cost/m2 - refurb
Total m2                                                             0              0             0             0
                                                     %
New build                                                      100%          100%         100%          100%
Refurbishment                                                    0%            0%           0%            0%
Refurbishment (m2)                                                0             0            0             0

Land/property acquistion - if                                  £            £             £             £
single sum                                                     0          #DIV/0!       #DIV/0!       #DIV/0!
Acquisition -if price for each
element work
Building
 Construction                                                      0                0             0             0
 Housing adapatations for                                          0
elderly/disabled
 Site investigation                        1,000               1,000       #DIV/0!       #DIV/0!       #DIV/0!
 Site clearance/demolition                                         0       #DIV/0!       #DIV/0!       #DIV/0!
 Externals: access roads, service        S
connections, landscape                                               0              0             0             0
 Exceptional costs to be shared
across scheme: access road,
renewable energy plant, planning                                           #DIV/0!       #DIV/0!       #DIV/0!
 Exceptionals: related to each                                     0
element work subtotal
Building                                                       1,000      #DIV/0!       #DIV/0!       #DIV/0!
Fees and expenses                    6-14% total
 Architect                              3-6%                         0    #DIV/0!       #DIV/0!       #DIV/0!
 Building surveyor                      10%                          0    #DIV/0!       #DIV/0!       #DIV/0!
 Quantity surveyor                      0-4%                         0    #DIV/0!       #DIV/0!       #DIV/0!
 Employer's agent                      1-2.5%                        0    #DIV/0!       #DIV/0!       #DIV/0!
 Others: structural engineer;           0-2%
mechanical and electrical engineer                                   0    #DIV/0!       #DIV/0!       #DIV/0!
 Sustainability and energy            £1,000-
assessment; wildlife assessment;      £20,000                        0     #DIV/0!       #DIV/0!       #DIV/0!
Fees subtotal
archaeology etc.                                   #DIV/0!           0    #DIV/0!       #DIV/0!       #DIV/0!
 Planning fee                             0                          0    #DIV/0!       #DIV/0!       #DIV/0!
 Building control fee                  0.50%                         0    #DIV/0!       #DIV/0!       #DIV/0!
Equipment
 Kitchen fittings                     £500/m2                                       0
 Furniture: ctty bldg                £200/m2                                        0
 Furniture: meeting rooms            £100/m2                                                      0
 Shop fitting                        £400/m2                                                                    0
                                      shops
 Play/sports equipment                                              #DIV/0!     #DIV/0!     #DIV/0!
 Other                                                 FALSE       FALSE       FALSE       FALSE
                                                         0           0           0           0
Equipment subtotal                                 0           0   #DIV/0!     #DIV/0!     #DIV/0!

Legal fees (acquisition)              £2,000-
                                      £5,000                   0    #DIV/0!     #DIV/0!     #DIV/0!
Other legal fees (agreements,                                  0    #DIV/0!     #DIV/0!     #DIV/0!
External project management fees      2.50%                    0   #DIV/0!     #DIV/0!     #DIV/0!
Own costs                             1.50%                    0   #DIV/0!     #DIV/0!     #DIV/0!
Guarantees (homes for sale or       £1,000/hom                 0           0           0           0
part-sale)
Marketing                                e
                                       £100-                   0    #DIV/0!     #DIV/0!     #DIV/0!
Finance fees                          £5,000
                                       1%                      0   #DIV/0!     #DIV/0!     #DIV/0!
Interest                             5%-7.5%                   0   #DIV/0!     #DIV/0!     #DIV/0!
VAT on fees and costs                                          0   #DIV/0!     #DIV/0!     #DIV/0!
VAT on building costs                                          0   #DIV/0!     #DIV/0!     #DIV/0!
Contingency                            1.50%                       #DIV/0!     #DIV/0!     #DIV/0!
Dowry to create initial reserve         40%                    0    #DIV/0!     #DIV/0!     #DIV/0!
Other                               running cost        #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!
TOTAL                                                  #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!

Income

Housing - equity sales
Housing - loans repaid from rent
Housing for sale
Workshop/shop loans repaid from
Workshop sales
Office loans repaid from rent              90%
Loan on community building repaid          20%
Loan on meeting spaces repaid              20%
Loan on sports facilities                  20%
Other sources
Parish Council
District authority
County authority
Devon CCD scheme
s106
Local Action Group (LEADER4)
CommunityBuilders
Lottery
Sport England
Charitable Trusts
Homes & Communities Agency                         0




Sweat equity
Local fundraising
Other income - enter sources




FUNDING GAP                    #DIV/0!


                               #DIV/0!
Work-                       Sportsfiel
spaces        MUGA             d           Pavilion      TOTAL

    800       200,000        250,000          1,400




          0                                          0             0

  100%          100%            100%          100%
    0%            0%              0%            0%            0%
     0             0               0             0             0

  £             £              £             £             £
#DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!
                                                                   0

          0             0              0             0             0

 #DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!      #DIV/0!
 #DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!      #DIV/0!

          0             0              0             0             0


 #DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!      #DIV/0!
                                                                   0
#DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!

#DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!

#DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!

 #DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!      #DIV/0!
#DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!
                                                                   0
                                                                   0
                                                                   0
                                                                   0
                                                                   0
 #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!    #DIV/0!
FALSE       FALSE       FALSE       FALSE                 0
  0           0           0           0
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!


 #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!    #DIV/0!
 #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!    #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!
        0           0           0           0             0
 #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!    #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!
 #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!    #DIV/0!
 #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!    #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!




                                                          0
                                                          0
                                                          0
                                                          0
                                                          0
                                                          0 Total non-
                                                          0 housing
                                                          0             0
                                                          0 Loans x 4/6
                                                                        0
                                                          0
                                                          0
                                                          0
                                                          0
                                                          0
                                                          0
                                                          0
                                                          0
                                                          0
                                                          0
                                                          0

                                                          0


                                                          0
                                                          0
0
0
0
0
0
0
ASSUMPTIONS                            Your entry          Dates
Buy land                                                     1.4.10
Planning granted                                             1.6.10
Start                                                        1.1.11
Complete                                        1.1.12       1.1.12
                              Month                      Phase        Pre-purchase     1.1.10        1.2.10        1.3.10
Expenditure                                 £                                          £             £             £
Acquisition                             #DIV/0!                                                0             0             0
Build cost                              #DIV/0!                                                              0             0
Site investigation                      #DIV/0!                        #DIV/0!
Legal fees                              #DIV/0!                                  0             0             0    #DIV/0!
Design fees                             #DIV/0!                        #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!
Project manager's fee                   #DIV/0!                        #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!
Other costs and fees                    #DIV/0!                        #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!
Finance fee                             #DIV/0!                                  0             0             0    #DIV/0!
Marketing                               #DIV/0!                                                0             0             0
Fit out costs                           #DIV/0!                                                0             0             0
Interest                                #DIV/0!                                                0             0             0
Own costs                               #DIV/0!                                                0             0             0
Dowry                                   #DIV/0!                                                0             0             0
VAT                                     #DIV/0!                        #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!
TOTAL EXPENDITURE                       #DIV/0!                        #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!


Income
Housing - equity sales                              0                                          0             0             0
Housing for sale                                    0                                          0             0             0
Workshop sales                                      0                                          0             0             0
Housing - loans repaid from rent                    0                                          0             0             0
Workshop/shop loans repaid from rent                0                                          0             0             0
Loan on community building repaid from income       0                                          0             0             0
Loan on meeting spaces repaid from income           0                                          0             0             0
Loan on sports facilities                           0                                          0             0             0
Parish Council                                      0                  #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
District authority                                  0                  #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
County authority                                    0                  #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Devon CCD scheme                                    0                  #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
s106                                                0                  #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Local Action Group (LEADER4)                        0                  #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
CommunityBuilders                                   0                  #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Lottery                                             0                  #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Sport England                                       0                  #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Charitable Trusts                                   0                  #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Homes & Communities Agency                          0                            0             0             0             0
Local fundraising                                   0                            0
Other sources                                       0                  #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
TOTAL INCOME                                        0                  #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Net                                     #DIV/0!                        #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Loan b/f                                                     0   #DIV/0!       #DIV/0!       #DIV/0!
New loan                                           #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
Total loan                                         #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!

Interest                     6.50%                               #DIV/0!       #DIV/0!       #DIV/0!


Assumed casdh flow on site
Month                            0             1             2             3             4             5
Build - 12 months                0   #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
                                 0        2.0%          5.0%          8.0%          9.0%         10.5%
Month                            0             1             2             3             4             5
Fit out                          0   #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
%                                        40.0%         40.0%         20.0%
Month                            0             1             2             3             4             5
Housing - equity sales           0             0             0             0             0             0
Month                            0             1             2             3             4             5
Housing for sale                 0             0             0             0             0             0
Month                            0             1             2             3             4             5
Workshop sales                   0             0             0             0             0             0
  1.4.10        1.5.10        1.6.10        1.7.10        1.8.10        1.9.10       1.10.10       1.11.10       1.12.10        1.1.11
  £             £             £             £             £             £             £             £             £             £
 #DIV/0!                0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0    #DIV/0!


          0             0             0             0             0             0             0             0             0             0
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!



          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
          0             0             0             0             0             0             0             0             0             0


#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!

#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!




          6             7             8             9             10             11             12             13             14             15
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
    11.5%         11.5%         11.0%         10.0%          9.0%           7.0%           4.0%           0.0%           0.0%           0.0%
          6             7             8             9             10             11             12             13             14             15
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!


          6             7             8             9             10             11             12             13             14             15
          0             0             0             0             0              0              0              0              0              0
          6             7             8             9             10             11             12             13             14             15
          0             0             0             0             0              0              0              0              0              0
          6             7             8             9             10             11             12             13             14             15
          0             0             0             0             0              0              0              0              0              0
  1.2.11        1.3.11        1.4.11        1.5.11        1.6.11        1.7.11        1.8.11        1.9.11       1.10.11       1.11.11
  £             £
          0             0             0             0             0             0             0             0             0             0
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!


          0             0             0             0             0             0             0             0             0             0
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
          0             0             0             0             0             0             0             0             0             0
          0    #DIV/0!                0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!



          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
          0             0             0             0             0             0             0             0             0             0


#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!

#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!




          16             17             18             19             20             21             22             23             24             25
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
     0.0%           0.0%           1.5%                0              0              0              0              0              0              0
          16             17             18             19             20             21             22             23             24             25
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!


          16             17             18             19             20             21             22             23             24             25
          0              0              0              0              0              0              0              0              0              0
          16             17             18             19             20             21             22             23             24             25
          0              0              0              0              0              0              0              0              0              0
          16             17             18             19             20             21             22             23             24             25
          0              0              0              0              0              0              0              0              0              0
 1.12.11        1.1.12        1.2.12        1.3.12        1.4.12        1.5.12        1.6.12        1.7.12        1.8.12        1.9.12


          0             0             0             0             0             0             0             0             0             0
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!


          0             0             0             0             0             0             0             0             0             0
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
          0             0             0    #DIV/0!                0             0             0             0             0             0
          0             0             0    #DIV/0!                0             0             0             0             0             0
          0             0             0    #DIV/0!                0             0             0             0             0             0
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!



          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
          0             0             0             0             0             0             0             0             0             0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
          0             0             0             0             0             0             0             0             0             0


#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!

#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!




          26             27             28             29             30             31             32             33             34             35
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
          0              0              0              0              0              0              0              0              0              0
          26             27             28             29             30             31             32             33             34             35
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!


          26             27             28             29             30             31             32             33             34             35
          0              0              0              0              0              0              0              0              0              0
          26             27             28             29             30             31             32             33             34             35
          0              0              0              0              0              0              0              0              0              0
          26             27             28             29             30             31             32             33             34             35
          0              0              0              0              0              0              0              0              0              0
 2.10.12       2.11.12       3.12.12        3.1.13        3.2.13 TOTAL                  check
                                                                         £          £
          0             0             0             0             0      #DIV/0!        #DIV/0!
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!        #DIV/0!
                                                                         #DIV/0!        #DIV/0!
          0             0             0             0             0      #DIV/0!        #DIV/0!
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!        #DIV/0!
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!        #DIV/0!
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!        #DIV/0!
          0             0             0             0             0      #DIV/0!        #DIV/0!
          0             0             0             0             0      #DIV/0!        #DIV/0!
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!        #DIV/0!
          0             0             0             0             0      #DIV/0!        #DIV/0!
          0             0             0             0             0      #DIV/0!        #DIV/0!
          0             0             0             0             0      #DIV/0!        #DIV/0!
 #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!        #DIV/0!
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!           #DIV/0!



          0             0             0             0             0             0                 0
          0             0             0             0             0             0                 0
          0             0             0             0             0             0                 0
          0             0             0             0             0             0                 0
          0             0             0             0             0             0                 0
          0             0             0             0             0             0                 0
          0             0             0             0             0             0                 0
          0             0             0             0             0             0                 0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!          #DIV/0!                  0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!          #DIV/0!                  0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!          #DIV/0!                  0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!          #DIV/0!                  0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!          #DIV/0!                  0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!          #DIV/0!                  0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!          #DIV/0!                  0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!          #DIV/0!                  0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!          #DIV/0!                  0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!          #DIV/0!                  0
          0             0             0             0             0             0                 0
                                                                                0                 0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!          #DIV/0!                  0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!                     0
#DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!          #DIV/0!
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!

#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!                       #DIV/0!



          36             37             38             39             40
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!                  0
          0              0              0              0              0          100.0%
          36             37             38             39             40
#DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!                  0


          36             37             38             39             40
          0              0              0              0              0
          36             37             38             39             40
          0              0              0              0              0
          36             37             38             39             40
          0              0              0              0              0
0
13
15
16
Full cost recovery spreadsheet
Enter data in unshaded cells only. Do not alter shaded cells.
Refer to the guidance notes for assistance with each step.

Step 1: Information about your project
1.1      Funding year              2009                                         e.g. 2007/2008, 2007
         Project duration                                                       If the project will run for the
1.2      (weeks) in the funding    39                                           whole of the funding year,
         year                                                                   enter 52 or leave blank
         Percentage of the
1.3                                75%
         funding year

Step 2: Enter your project's direct costs
                                                                                   Revenue
                                                                                              Capital Costs
                                                                                    Costs
List cost descriptions and amounts below                                              £             £
Various                                                                                50,000          3,000




Total direct project costs                                                               50,000              3,000

Step 3: Describe how your organisation's overheads are to be shared
                                                            Overhead type            Overhead          Overhead
                                                                         1              type 2            type 3
                                   Describe the type of
                                   overhead, for example,                                           Premises,
3.1      Type of overhead          administration,             Management          Finance          stationery,
                                   premises, management                                              audit etc
                                   and support
                                   Describe how each type
         How the overheads are     will be shared, for                            Number of
3.2                                                           Number of staff                       Floor area
         to be shared              example number of                                staff
                                   staff, floor area occupied

Step 4: Share the overheads
                                                            Enter projects' shares below:
                                   List Projects below:     Number of staff      Number of             Floor area
                                                                                       staff
4.1      Your project                                                  2.00            2.00                100.00
4.2      Other projects:            Project 2                 0.50         0.50          50.00
                                    Project 3                 1.00         1.00         100.00




4.3      Overheads                  Management
                                    Finance

Totals                                                         3.50        3.50         250.00
Increase in activity due to your project                     133%        133%            67%
Percentage due to your project                                57%         57%            40%

Step 5: Enter your organisation's overheads
                                                     Overhead type    Overhead     Overhead
                                                                  1       type 2      type 3
List overheads and amounts                                 £            £           £
Management                                                   25,000
Finance                                                                  20,000
Premises etc                                                                            21,000




Totals                                                      25,000       20,000         21,000

Step 6: Full costs of your project
These are the full costs of your project                                £           £
Direct costs                        Revenue costs                        50,000
                                    Capital costs                         3,000
Total direct project costs                                                              53,000
                                             57.1%                       10,714
The project's share of
overheads
The project's share of
                               57.1%   8,571
overheads
                               40.0%   6,300
Total share of the overheads                   25,586

Full project costs                             78,586
Salary spreadsheet
Enter National Insurance (NI) Rates
 Secondary Earnings threshold (£ per week)    104.52 This is the rate above which employers must pay employers'
                                                     This is the
                                                     rate of
                                                     employers'
                               Employers'
                                             12.80% NI on
                                     rate
                                                     earnings
                                                     above the
                                                     threshold

    Enter post                                                                 Calculated amounts
                           Enter amounts and rates below
 description below
                                            Weeks
                                         employed     Employer           Employers'
                              Post hours in project    Pension             National Employers' Total cost
                     Pay Rate per week       period       Rate Gross Pay Insurance    Pension     of post
Post                   £/hour hours/week     weeks           %         £          £          £          £
#N/A                  #N/A       #N/A         52.00    12.20%    #N/A      #N/A       #N/A       #N/A
#N/A                  #N/A       #N/A         52.00    12.20%    #N/A      #N/A       #N/A       #N/A
#N/A                  #N/A       #N/A         52.00    12.20%    #N/A      #N/A       #N/A       #N/A
                                                                       -           -         -           -
                                                                       -           -         -           -
                                                                       -           -         -           -
                                                                       -           -         -           -
                                                                       -           -         -           -
                                                                       -           -         -           -
                                                                       -           -         -           -
                                                                       -           -         -           -
                                                                       -           -         -           -
                                                                       -           -         -           -
                                                                       -           -         -           -
                                                                       -           -         -           -
                                                                       -           -         -           -
Total staff costs                                                                                #N/A
                                                               ALLOCATED TO
                             TOTAL      Old School    Training   Exhibitions
COSTS                           £           £            £           £
Salaries                        50,000        2,000       20,000       8,000
NI                                5,460         218        2,184          874
Employer's pension contrib        3,500         140        1,400          560
Advertising/marketing             2,000          80          800          320
Equipment depreciation            2,000           0        1,000          500
Office costs                      4,000         160        1,600          640
Training                          1,000          40          400          160
Recruitment                         500          20          200           80
Insurance                         3,900       1,500          500       1,000
Book-keeping and finance support 6,000          240        2,400          960
IT                                2,000          80          800          320
Website                           1,000          40          400          160
Miscellaneous                     1,000          40          400          160
Loan repayments                   1,860       1,000          500          360
TOTAL                           84,220        5,558       32,584      14,094
Re-allocate central costs                     1,638        9,604       4,154
TOTAL                           84,220        7,197       42,188      18,248




INCOME
Rent                            5,544        5,544
Service charge fee              2,033        2,033
Fees                           22,000                                21,000
Revenue grants                 57,500                    43,500
TOTAL                          87,077        7,577       43,500      21,000

Net income                       2,857         380        1,312       2,752
LOCATED TO
             Events    Project X     Central cost
               £             £             £          check
                 2,000         1,000       17,000             0
                   218           109         1,856            0
                   140            70         1,190            0
                    80            40           680            0
                     0             0           500            0
                   160            80         1,360            0
                    40            20           340            0
                    20            10           170            0
                   500             0           400            0
                   240           120         2,040            0
                    80            40           680            0
                    40            20           340            0
                    40            20           340            0
                     0             0              0           0
                 3,558         1,529       26,896       84,220
                 1,049           451       16,896       16,896
                 4,607         1,980       10,000       84,220




                 1,000
                 2,000         2,000        10,000
                 3,000         2,000        10,000

                -1,607            20             0

								
To top