Ask Question
12 May, 06:23

Acceleron is planning future expansion with a new facility in Indianapolis. The company will make the move when its real estate sinking fund has a total value of $1.2 million. If the fund currently has $400,000 and the company adds $50,000 per year, how many years will it take for the account to reach the desired value? The fund earns interest at a rate of 10% per year.

+2
Answers (1)
  1. 12 May, 06:37
    0
    6.67 years

    Explanation:

    The number of years for the firm to reach the desired value of $1.2 million can determined using the nper formula in excel as below:

    =nper (rate, pmt, pv,-fv)

    rate is the interest rate earns by the fund at 10% per year

    pmt is the addition to the fund in each year which is $50,000

    pv is the current amount in the fund which is $400,000

    fv is the desired value of $1.2 million

    =nper (10%,50000,400000,-1200000) = 6.67 years

    It would take 6.67 years for the sinking fund to reach the desired value of $1,200,000
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Acceleron is planning future expansion with a new facility in Indianapolis. The company will make the move when its real estate sinking ...” 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