UnThreaded | Threaded | Whole Thread (20) | Ignore Thread Prev | Next
Author: gougmonk2 Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 76101  
Subject: Re: Present value calculation Date: 4/1/2007 8:38 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 0
My take:

500 per month or 6000 per year income and 5% return is equilivent to starting with 76643 at the beginning of year 1, taking out 6000 per year, and the remaining capital earning 5% per year. At the end of 20 years you will have taken out 120000 and be left with zero capital.calculation.

simple excel spreadsheet

year start ...end ...out ..income
01 76643 74325 6000 3682
02 74325 71891 6000 3566
03 71891 69336 6000 3445
04 69336 66652 6000 3317
05 66652 63835 6000 3183
06 63835 60877 6000 3042
07 60877 57770 6000 2894
08 57770 54509 6000 2739
09 54509 51084 6000 2575
10 51084 47489 6000 2404
11 47489 43713 6000 2224
12 43713 39749 6000 2036
13 39749 35586 6000 1837
14 35586 31216 6000 1629
15 31216 26626 6000 1411
16 26626 21808 6000 1181
17 21808 16748 6000 940
18 16748 11435 6000 687
19 11435 5857. 6000 422
20 5857. 0.0000 6000 143

total withdrawal 120000

start = beginning of year balance
end = end of year balance
out = amount withdrawn per year
income = earnings at 5% of the average balance during year
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (20) | Ignore Thread Prev | Next

Announcements

The Retire Early Home Page
Discussion on accelerating retirement day.
Pencils of Promise - Back to School Drive
"Pencils of Promise works with communities across the globe to build schools and create programs that provide education opportunities for children."
Post of the Day:
Apple

Wal-Mart Nixes Apple Pay
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and "#1 Media Company to Work For" (BusinessInsider 2011)! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.
Advertisement