Ask Question
BusinessBusiness
2 July, 20:46

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. 2 July, 21: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?
Get 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 there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers
You Might be Interested in
News Express has 26,200 shares outstanding at a market price of $33.30 a share. Nu-News has 15,000 shares outstanding at a price of $54 a share. The News Express is acquiring Nu-News. Both firms are all-equity financed.
Answers (1)
On November 1, 2021, Aviation Training Corp. borrows $48,000 cash from Community Savings and Loan. Aviation Training signs a three-month, 6% note payable. Interest is payable at maturity. Aviation's year-end is December 31. Required: 1.-3.
Answers (1)
Bailey, Inc., is considering buying a new gang punch that would allow them to produce circuit boards more efficiently. The punch has a first cost of $70,000 and a useful life of 15 years. At the end of its useful life, the punch has no salvage value.
Answers (1)
Most consumer complaints are resolved by: a. legal action. b. assistance from a government agency. c. contacting a company's headquarters. d. returning to the place of purchase.
Answers (1)
Division A of Barsema, Inc. has operating data as follows: Capacity 20,000 units Selling price $80 per unit Variable costs $45 per unit Fixed costs $20 per unit Division B wants to purchase units from Division A.
Answers (1)
New Questions in Business
On November 1, 2021, Blossom Company purchased Splish, Inc., 10-year, 10%, bonds with a face value of $900000, for $820000. An additional $34000 was paid for the accrued interest. Interest is payable semiannually on January 1 and July 1.
Answers (1)
Which of the following statements regarding rational ignorance are true? Check all that apply. a. Because candidates take stands on a wide range of issues, a rationally ignorant voter may choose not to fully assess the costs and benefits of voting
Answers (1)
Jacob is creating a table to record his work schedule. When he typed in Wednesday, part of the word was not visible. Which of the following suggestions would be the quickest resolution to this problem? a.
Answers (1)
Chang industries has 1,400 defective units of product that have already cost $13.40 each to produce. a salvage company will purchase the defective units as they are for $4.40 each.
Answers (1)
Economic agents who generate externality are distinct from those who experience them. Example: one fisher catches juvenile fish that do not mature and are otherwise caught by another fisher in another location. O True O False
Answers (2)
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?