Consider the following cash flows: Year Cash Flow 2 $ 22,400 3 40,400 5 58,400 Assume an interest rate of 9.2 percent per year.
1 answer:
You might be interested in
Answer:
Ans. the rate of return of this invesment is 3.5278% annual.
Explanation:
Hi, what we need to do here is to find the future value of all six payments, beginning when the child turns 12, which will end when he turns 17. One year later (when the child turns 18) he will receive $25,000 per year, for the next 4 years. This is the equation that we need to use (and solve for "r").
Where:
A1=$14,000
A2=$25,000
So, everything should look like this
As you can see, this would take forever to solve, so what we have to do is to use MS Excel, we have to use the "Goal Seek" function. Please check the MS Excel spread sheet attached to this answer.
Please use this function with the following parameters.
Set Cell: G7
To Value: 0
By changing cell: G2
Ans. 3.5278%
Best of luck.