Question: Please explain how you got to the solution using Goal Seek. I cannot seem to get it to give me the correct answer. Please examine
Please explain how you got to the solution using Goal Seek. I cannot seem to get it to give me the correct answer.

Please examine the provided cash flow table Year Cash Flow 0 -9P 1 -3P 2 43000 3 2.5P 4 4P 5 P 6 -18000 7 2P p 1 The interest rate is 3.9% Use the goal seek function to answer these questions. 6a. What is the value of P at 3.9% to make all of the cash flow transactions balance out? 6b. If P is $5500 what rate do we need? Please examine the provided cash flow table Year Cash Flow 0 -9P 1 -3P 2 43000 3 2.5P 4 4P 5 P 6 -18000 7 2P p 1 The interest rate is 3.9% Use the goal seek function to answer these questions. 6a. What is the value of P at 3.9% to make all of the cash flow transactions balance out? 6b. If P is $5500 what rate do we need
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
