LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
template for monthly interest expense for invested monies kbergsma New Users to Excel 1 October 5th 06 05:12 PM
percentage return on charcters not numbers kent Excel Worksheet Functions 1 October 3rd 06 01:35 PM
annual percentage return Stephen Watson Excel Worksheet Functions 2 April 5th 06 01:29 AM
Invested 1,000 1/30/02, 4006.34 5/2/02,350/mo since 11/22/02 Valu. dnsworld Excel Worksheet Functions 3 March 22nd 05 12:49 AM
Return A, B, C, or D depending on percentage lawrend Excel Worksheet Functions 7 November 23rd 04 04:25 PM


All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"