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 explain how you got to the solution using Goal Seek. I

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!