M
Markey
I pulled these numbers manually but would like to learn how to do it with
Excel.
A small nonprofit would like to receive $25,000 annually from their
endowment investment to cover operating costs. The question is how much is
needed in their endowment to receive that $25,000 if 2%, 3%, 4%, .... 9%,
etc. is the percentage of return? The board wants to be able to enter a
percentage and Excel calculate the endowment investment total.
Here are my manual totals.
Amount Percentage Amount to Operate
$1,250,000 2% $25,000
$833,340 3% $25,000
$625,000 4% $25,000
$500,000 5% $25,000
$416,660 6% $25,000
$357,140 7% $25,000
$312,500 8% $25,000
$277,780 9% $25,000
Thank you.
Excel.
A small nonprofit would like to receive $25,000 annually from their
endowment investment to cover operating costs. The question is how much is
needed in their endowment to receive that $25,000 if 2%, 3%, 4%, .... 9%,
etc. is the percentage of return? The board wants to be able to enter a
percentage and Excel calculate the endowment investment total.
Here are my manual totals.
Amount Percentage Amount to Operate
$1,250,000 2% $25,000
$833,340 3% $25,000
$625,000 4% $25,000
$500,000 5% $25,000
$416,660 6% $25,000
$357,140 7% $25,000
$312,500 8% $25,000
$277,780 9% $25,000
Thank you.