Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
template for monthly interest expense for invested monies | New Users to Excel | |||
percentage return on charcters not numbers | Excel Worksheet Functions | |||
annual percentage return | Excel Worksheet Functions | |||
Invested 1,000 1/30/02, 4006.34 5/2/02,350/mo since 11/22/02 Valu. | Excel Worksheet Functions | |||
Return A, B, C, or D depending on percentage | Excel Worksheet Functions |