Use the goal seek function to answer these questions. 6a. What is the value of P at 4.2% interest to make all of the cash flow transactions balance out? 6b. If P is $19,000 what is the NEW interest rate we will need?

Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter10: Financial Statements And Reports
Section: Chapter Questions
Problem 3.5C
icon
Related questions
icon
Concept explainers
Topic Video
Question
1
234567
5
7
8
9
Please examine the provided cash flow table
20
Year
Cash Flow
0 -9P
1 -P
2 48000
3 4.5P
4 3.5P
5 -1.5P
6
7 3P
8
9 P
10
11
12
13
14
15
16
17 Use the goal seek function to answer these questions.
18
6a. What is the value of P at 4.2% interest to make all of the cash flow transactions balance out?
19
6b. If P is $19,000 what is the NEW interest rate we will need?
-27000
47650
Transcribed Image Text:1 234567 5 7 8 9 Please examine the provided cash flow table 20 Year Cash Flow 0 -9P 1 -P 2 48000 3 4.5P 4 3.5P 5 -1.5P 6 7 3P 8 9 P 10 11 12 13 14 15 16 17 Use the goal seek function to answer these questions. 18 6a. What is the value of P at 4.2% interest to make all of the cash flow transactions balance out? 19 6b. If P is $19,000 what is the NEW interest rate we will need? -27000 47650
Expert Solution
steps

Step by step

Solved in 4 steps with 8 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage