This is a problem in which the present value, future value and the number of periods is known, and the interest rate is unknown,
Your company needs $1,500,000 to build a new manufacturing plant six years from now. Your company currently has $800,000 to invest to build this plant. At what rate of interest must it invest the $800,000 to fund the plant six years from now?
First, plug in the known values into the appropriate cells:
The future value – FV – is $1,500,000
The present value – PV – is ($800,000)
The number of periods – NPER is 6
Going to the formulas tab, look for the Rate function.
The function wizard pops up
Select PV,
Select NPER,
Select FV
Hit OK
The rate is 11%