Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Year Cash Flow 0 -9P 1 -3P 2 43000 3 2.5P 4 4P 5 P 6 -18000 7 2P The interest rate is 3.9% Use
| Year | Cash Flow | ||||||
| 0 | -9P | ||||||
| 1 | -3P | ||||||
| 2 | 43000 | ||||||
| 3 | 2.5P | ||||||
| 4 | 4P | ||||||
| 5 | P | ||||||
| 6 | -18000 | ||||||
| 7 | 2P | ||||||
| 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? | |||||||
Can someone show this in excel please?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Promoting Microfinance Challenges And Innovations In Developing Countries And Countries In Transition
Authors: R. Manos , J. Gueyie, J. Yaron
1st Edition
1137034904, 1137034912, 9781137034908, 9781137034915
