455x Filetype XLSX File size 0.05 MB Source: assets.publishing.service.gov.uk
Inputs
Investment type
Investment 1 Grant
Investment 2 Social enterprise
Investment 3 UK Equity Fund
Investment 4 N/A
Investment 5 N/A
Investment 6 N/A
Investment 7 N/A
Total
Endowment calculator
Investment 1 Grant
Investment 2 Social enterprise
Investment 3 UK Equity Fund
Investment 4 N/A
Investment 5 N/A
Investment 6 N/A
Investment 7 N/A
Total social impact 209085
Amount Financial return Cost
£100,000 0.05 0.01
£100,000 0.06 0.00
£0 0.11 0.01
£0 0.05 0.01
£0 0.05 0.01
£0 0.05 0.01
£0 0.05 0.01
£100,000
% (£)
Amount Net Financial return Total investment size
£100,000 0 £104,000
£100,000 0.06 £179,085
£0 0.10 £0
£0 0.04 £0
£0 0.04 £0
£0 0.04 £0
£0 0.04 £0
Investment period (years) No of years per grant
10 1
10 10
10 10
10 1
10 1
10 1
10 1
Social impact through grant Social impact through investment
100,000 -
179,085 - 70,000
- -
- -
- -
- -
- -
Total social impact p.a.
SIMP SIMP
1 0 0.05 0.1
-0.7 0 100,000 105,000 110,000
0 1 110,462 115,462 120,462
1 ) 2 121,899 126,899 131,899
%
(
1 3 134,392 139,392 144,392
.
a
1 . 4 148,024 153,024 158,024
p
1 n 5 162,889 167,889 172,889
r
u
t 6 179,085 184,085 189,085
e
r
7 196,715 201,715 206,715
t
e
N 8 215,892 220,892 225,892
9 236,736 241,736 246,736
Social impact p.a. 10 259,374 264,374 269,374
100,000
109,085
- SIMP
- 0 -0.05 -0.1
- 0 100,000 95,000 90,000
- 1 110,462 105,462 100,462
- ) 2 121,899 116,899 111,899
%
(
. 3 134,392 129,392 124,392
a
.
p 4 148,024 143,024 138,024
n
r 5 162,889 157,889 152,889
u
t 6 179,085 174,085 169,085
e
r
t 7 196,715 191,715 186,715
e
N 8 215,892 210,892 205,892
9 236,736 231,736 226,736
10 259,374 254,374 249,374
no reviews yet
Please Login to review.