Ask Question
BusinessBusiness
4 October, 16:12

Jimmy has $255,906 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 withdraws $30,000 each year?

+4
Answers (1)
  1. 4 October, 16:32
    0
    In this problem, we have to calculate the number of years it takes to fully exhaust the fund if Jimmy withdraws 30,000 per year

    This can be calculated using NPER function in excel as in = NPER (rate, pmt, pv) where

    RATE = annual interest rate = 3% = 0.03

    PMT = annual withdrawal amount = 30000

    PV = Present value of accumulated savings = 255906

    Number of years = NPER (0.03,-30000,255906) = 9.9999 years = 10 years

    (Note the PMT is input with a negative sign since it is a withdrawal and is a cash outflow)

    Number of years it takes to completely exhaust the fund = 10 years
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Jimmy has $255,906 accumulated in a 401k plan. the fund is earning a low, but safe, 3% per year. the withdrawals will take place at the end ...” in 📗 Business if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers
You Might be Interested in
A financial statement showing the revenue and expenses for a fiscal period. True or False
Answers (1)
According to the principle of comparative advantage, worldwide output and consumption will be higher when nations specialize in the production of those goods and services a. they can provide at a lower opportunity costs. b.
Answers (1)
Successful use of financial leverage requires a firm to: a. negotiate with lenders to establish a line of credit. b. register with the local government commission that administers market leverage. c.
Answers (1)
A warrantless search of a vehicle must be based on:
Answers (1)
A manager wants to motivate the maintenance staff to be more productive. She starts by providing training and assures employees that high productivity will be rewarded. Employees are asked to identify the rewards that would mean the most to them.
Answers (1)
New Questions in Business
A corporation has 44,904 shares of $26 par value stock outstanding that has a current market value of $238 per share. If the corporation issues a 5-for-1 stock split, determine the number of shares outstanding. Select the correct answer.
Answers (1)
A tire manufacturer produces 400 tires valued at $20 each. Three hundred tires are sold to a tire shop, which then sells them to households for $50 each. The remaining tires are unsold and are added to the tire manufacturer’s inventory.
Answers (1)
Cunningham, Inc. sells MP3 players for $60 each. Variable costs are $40 per unit, andfixed costs total $60,000. How many MP3 players must Cunningham sell to earn netincome of $140,000?
Answers (1)
Calculate the accounting profit or loss as well as the economic profit or loss in each of the following situations: a. A firm with total revenues of $150 million, explicit costs of $90 million, and implicit costs of $40 million b.
Answers (1)
A price-discriminating firm charges the lowest price to the group that
Answers (1)
Home » Business » Jimmy has $255,906 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.
Sign Up Forgot Password?