Finkler - Problem 5-20. $1 million Retirement Account. Part 2
Problem 5-19 Requirements: Suppose your parents have just retired and have $1 million in a retirement account. For how many years can they withdraw $5,000 at the beginning of each month for expenses, assuming that the account will continue to earn a 5 percent annual return until it is exhausted?
Requirements: Now, suppose your parents have decided that they will depend on their retirement savings for 20 years. Everything else remains the same. How much money can they afford to withdraw at the beginning of each month? What excel formula(s) would I use?
	Rate	5.00%
	Time	240
	Pv	$1,000,000
	Pmt	($5,000.00)