{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Assumptions","Capital Investment DCF "],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Assumptions","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Capital Investment Proposal"]
["Project Reference Number:"]
["Project Name:"]
["Discounted Cashflow"]
[]
["Assumptions"]
[]
[1,"Costs are assumed to increase at a rate of 2% pa"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]

{"sheet":"Capital Investment DCF ","index":1,"n_rows":66,"n_cols":24,"rows_kept":66,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Capital Investment Proposal"]
[null,"Template","6ms","12m"]
[null,"Discounted Cashflow","18/19","19/20","20/21"]
[]
[null,null,null,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005,0.005]
[null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Discount Factor",1,0.9615384615384615,0.9245562130177514,0.8889963586709149,0.8548041910297257,0.8219271067593515,0.7903145257301457,0.7599178132020633,0.7306902050019838,0.7025867355788304,0.6755641688257985,0.6495809315632679,0.6245970495800651,0.600574086134678,0.5774750828218058,0.5552645027132748,0.533908175685841,0.5133732458517702,0.4936281210113175,0.47464242404934376,0.45638694620129205]
[null,null,null,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"1. Capital Investment requirements"]
[null,"Capital Costs £k","Year 0","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Total 20 Years"]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[null,"Contingency 10%",{"$nulls":21},0]
[null,"VAT",{"$nulls":21},0]
[null,"Total Capital Expenditure £k",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Capital Grants / Donations £k"]
[null,"Source of Funding - <>",{"$nulls":21},0]
[{"$nulls":23},0]
[null,"Total Capital Grants / Donations £K",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Net Capital Expenditure",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"2. Cashflow Impact on Income & Expenditure"]
[null,null,"Year 0","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Total 20 Years"]
[null,"Incremental Income"]
[]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[]
[]
[null,"Total Incremental Income £K",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Incremental Costs"]
[]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[]
[]
[null,"Total Incremental Costs £K",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Net Surplus / (Deficit)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"3. DISCOUNTED CASHFLOW","Year 0","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Total 20 Years"]
[null,"TOTAL PROJECT CASHFLOW £K",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL CUMULATIVE PROJECT CASHFLOW £K",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL PROJECT CASHFLOW £K (DISCOUNTED)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL CUMULATIVE PROJECT CASHFLOW £K (DISCOUNTED)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"CUMULATIVE DISCOUNTED CASHFLOW (5 YEARS) - £K",null,null,0]
[null,"CUMULATIVE DISCOUNTED CASHFLOW (10 YEARS) - £K",null,null,0]
[null,"CUMULATIVE DISCOUNTED CASHFLOW (20 YEARS) - £K",null,null,0]
[]
[null,"Notes"]
[null,"All costs should be input as negative numbers, and benefits as positive numbers"]
[null,"Discounted cashflows are calculated using a weighted average cost of capital of 4%"]
[null,"There is no discounting in year 0 in calculating discounted cashflows"]
[null,"VAT should be included at 20% on all costs as appropriate"]
[null,"Inflation rates should be included as appropriate"]
[null,"Only project specific capital grants or donations should be included"]
[null,"Salary costs should include costs of national insurance & superannuation"]