Org Chart Template - Excel by bhb11449

VIEWS: 142 PAGES: 5

More Info
									Gift Pyramid Templates
Purpose: This spreadsheet will allow you to do the following:
1. Plan a campaign gift strategy for hitting a specific goal.
2. Enter gifts as they are received to track progress.

  The second tab is the Pyramid tab where you create your own gift pyramid for a campaign, or for the
annual program.

  The third tab has a $4m Goal example showing how a campaign of this amount would be structured.
The fourth tab contains a $10m Goal Example with three scenarios for a campaign of this size.
Total
                                           G
                                               ift




        $0
             $0
                  $0
                       $0
                            $0
                                 $0
                                      $0
                                                     Le
                                                          ve
                                                                 Gift Pyramid



                                                             l
                                           #




0
        0
             0
                  0
                       0
                            0
                                 0
                                      0
                                            of
                                               G
                                           N ift
                                            ee s
                                               de
                                                 d

                                           To
                                                ta
                                                   l




$0
        $0
             $0
                  $0
                       $0
                            $0
                                 $0
                                      $0




0
        0
             0
                  0
                       0
                            0
                                 0
                                      0




                                            pr
                                               o
                                           ne sp
                                             ed ec
                                                 ed ts



0
        0
             0
                  0
                       0
                            0
                                 0
                                      0




                                           G        (4
                                            ift        :1
                                               s          )
                                                 R
                                                   ec
                                                     'd

                                           G
                                            ift
                                                  to
                                                       ta
$0
        $0
             $0
                  $0
                       $0
                            $0
                                 $0
                                      $0




                                                         ls
                                           B
                                            al
                                               a
0
        0
             0
                  0
                       0
                            0
                                 0
                                      0




                                           pr nce
                                              os o
                                                 p f
                                             ne ec
                                                ed ts
                                                  ed
Gift Pyramid $4m goal
Example

                                                                    )
                                                               s :1       d                            of cts d
                       el           s                        ct (4      c'               al
                                                                                            s
                  L ev           ift ed           l        pe ed      Re              ot             ce pe de
                                G ed           ta        os d      ts                t             an s     e
            ift               of Ne                    pr nee Gif              ift               al pro ne
        G                   #                To                               G                 B
$1,000,000                  1        $1,000,000        4      1         $1,000,000                  0
  $500,000                  2        $1,000,000        8      2         $1,000,000                  0
  $250,000                  2             $500,000     8      1           $250,000                  4
  $100,000                  6             $600,000    24      2           $200,000                  16
   $50,000                  16            $800,000    64      12          $600,000                  16
 < $25,000                  30            $100,000    120     10                     $0             80
        misc                50             $50,000    200     50                     $0             0


Total                   107          $4,050,000       428     78        $3,050,000              116
$10 million campaign pyramid

An average 80/20 pyramid
                    # of
 Contribution Contributions                 prospects
    Level         Needed         Total     needed (4:1)
    $2,000,000       1          $2,000,000      4
    $1,000,000       2          $2,000,000      8
        $500,000    4           $2,000,000       16
        $250,000    6           $1,500,000       24
        $100,000    12          $1,200,000       48
         $50,000    15            $750,000       60
         $25,000    22            $550,000       88


Total               62         $10,000,000       248



$10 million campaign pyramid

A steep 90/10 pyramid
                    # of
 Contribution Contributions                   prospects
     Level        Needed         Total       needed (4:1)
    $4,000,000        1         $4,000,000        4
    $2,000,000        1         $2,000,000        4
    $1,000,000        1         $1,000,000        4
      $500,000        2         $1,000,000        8
        $250,000     4          $1,000,000       16
        $100,000     5            $500,000       20
         $50,000    10            $500,000       40


Total               24         $10,000,000       96
$10 million campaign pyramid

A flat 80/20 pyramid
                  # of
 Contribution Contributions                 prospects
    Level       Needed           Total     needed (4:1)
   $2,000,000       1           $2,000,000      4
   $1,000,000       1           $1,000,000      4
        $500,000        2       $1,000,000      8
        $250,000        3        $750,000       12
        $100,000       20       $2,000,000      80
         $50,000       35       $1,750,000     140
         $25,000       60       $1,500,000     240


Total                  122     $10,000,000     488

								
To top