View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Markey Markey is offline
external usenet poster
 
Posts: 2
Default Percentage to Get Invested Return

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.