282x 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.