Register
Jimmy has $167,933 accumulated in a 401K plan. The fund is earning a low, but safe, 3% per year. The withdrawals will take place at the end of each year starting a year from now. How soon will the fund
227k views
5 votes
Jimmy has $167,933 accumulated in a 401K plan. The fund is earning a low, but safe, 3% per year. The withdrawals will take place at the end of each year starting a year from now. How soon will the fund be exhausted if Jimmy withdrawals $31,000 each year

User Rob VS
by
5.4k points

1 Answer

5 votes

Answer:

6 years

Step-by-step explanation:

Rate = 3%

PMT = 31,000

PV = -167,933

FV = 0

Using the MS Excel Nper function

How soon the fund will be exhausted = Nper(Rate, PMT, -PV, FV)

= Nper (3%, 31,000, -167,933, 0)

= 6.0000255

= 6 years

Thus, it will take 6 years for the fund to be exhausted

User Richard Neish
by
5.6k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

5.9m questions

7.7m answers

Other Questions

_____ reminds customers and clients that they made a good choice in selecting a company with which to do business, or it reminds them of the good qualities of their purchase.​
Demonstrate how binomial nomenclature is related to classification systems by identifying the genus name and the specific name of the domestic cat felis catus
The dark printed words on the page of a book are easily read because they are printed on a light ground. this is an example of the principle of ____________.
On august 1 the darius co. purchased a photocopy machine for $8,000. the estimated annual depreciation on the machine is $1,680. if the company prepares annual financial statements on december 31, the
When president obama was elected, the u.s. economy was in trouble, and has slid into a recession. consumer spending was low and getting worse. in an effort to stop the decline, president obama proposed
Link Copied!