jagomart
digital resources
picture1_Investment Calculator Excel Template 43059 | Endowment Calculator   9 Dec 2014


 283x       Filetype XLSX       File size 0.05 MB       Source: assets.publishing.service.gov.uk


File: Investment Calculator Excel Template 43059 | Endowment Calculator 9 Dec 2014
inputs investment type investment 1 grant investment 2 social enterprise investment 3 uk equity fund investment 4 na investment 5 na investment 6 na investment 7 na total endowment calculator ...

icon picture XLSX Filetype Excel XLSX | Posted on 16 Aug 2022 | 3 years ago
Partial file snippet.
          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 
The words contained in this file might help you see if this file matches what you are looking for:

...Inputs investment type grant social enterprise uk equity fund na total endowment calculator impact amount financial return cost net size period years no of per through pa simp a p n r u t e...

no reviews yet
Please Login to review.