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
Kl textiles writes 22 checks a day for an average amount of $827 each. these checks generally clear the bank 3.5 days after they are written. in addition, the firm generally receives an average of $23,902 a day in checks.
Answers (1)
Rosewood Company made a loan of $16,000 to one of the company's employees on April 1, Year 1. The one-year note carried a 6% rate of interest.
Answers (1)
At the end of the year, Dahir Incorporated's balance of Allowance for Uncollectible Accounts is $2,400 (credit) before adjustment. The company estimates future uncollectible accounts to be $12,000.
Answers (1)
Python Company sells merchandise on account for $5000 to Monte Company with credit terms of 2/10, n/30. Monte Company returns $1500 of merchandise that was damaged, along with a check to settle the account within the discount period.
Answers (1)
The following transactions occur for Cardinal Music Academy during the month of October: Provide music lessons to students for $17,000 cash. Purchase prepaid insurance to protect musical equipment over the next year for $4,200 cash.
Answers (1)
New Questions in Business
Read the following except from a warranty. What time period is this warranty for? "This warranty is given by XYZ motors. The Zoom car is guaranteed to be free of defects for 30,000 miles or three years, whichever is reached first.
Answers (1)
Orange Corporation is developing standards for its products. Product A requires a material that is purchased for $80.00 per pound from the supplier. By paying cash, the company gets a discount of 3% off this purchase price.
Answers (1)
The most recent financial statements for Alexander Co. are shown here: Income Statement Balance Sheet Sales $ 42,800 Current assets $ 17,500 Long-term debt $ 37,000 Costs 35,500 Fixed assets 68,300 Equity 48,800 Taxable income $ 7,300 Total $ 85,800
Answers (1)
Which of the following is a positive economic statement? A. The government should implement a national consumption tax. B. The standard of living in the United States is too low. C. The U. S.
Answers (1)
Rachel is working on a project that technically allows three activities to be done at the same time. if they were to be implemented at the same time, she would need 5 contractors in order for the activities to be completed on time.
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?