The cash flow for a company for their investment account is shown in the table below: Cash Year Cash Inflow Outflow $50,000 ($2.000) ($5,100) 3Q ($4,500) 3 $1,600 (36Q) 4 $0 $0 5 12Q ($8,500) 20Q ($4,500) 7 $7,500 ($6,500) 8 $0 (16Q) a. lf the value of Q is $2,750 at what interest rate will the net cash flow be balanced and equivalent? (Hint: at what interest rate per year NPW is equal to zero) b. If the interest rate is 6% per year compounded yearly, for what value of Q will| to the cash flow have equivalence? (Hint: for what value of Q. NPW is equal zero) 2.

Financial Accounting: The Impact on Decision Makers
10th Edition
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Gary A. Porter, Curtis L. Norton
Chapter12: The Statement Of Cash Flows
Section: Chapter Questions
Problem 12.19E
icon
Related questions
Question

Please do it in excel table 

The cash flow for a company for their investment account is shown in the table
below:
Cash
Year Cash Inflow
Outflow
$50,000
($2,000)
1
($5,100)
3Q
($4,500)
$1,600
(36Q)
4
$0
$0
12Q
($8,500)
20Q
($4,500)
7
$7,500
($6,500)
8
$0
(16Q)
a. If the value of Q is $2,750 at what interest rate will the net cash flow be
balanced and equivalent? (Hint: at what interest rate per year NPW is equal to
zero)
b. If the interest rate is 6% per year compounded yearly, for what value of Q will|
the cash flow have equivalence? (Hint: for what value of Q. NPW is equal to zero)
Transcribed Image Text:The cash flow for a company for their investment account is shown in the table below: Cash Year Cash Inflow Outflow $50,000 ($2,000) 1 ($5,100) 3Q ($4,500) $1,600 (36Q) 4 $0 $0 12Q ($8,500) 20Q ($4,500) 7 $7,500 ($6,500) 8 $0 (16Q) a. If the value of Q is $2,750 at what interest rate will the net cash flow be balanced and equivalent? (Hint: at what interest rate per year NPW is equal to zero) b. If the interest rate is 6% per year compounded yearly, for what value of Q will| the cash flow have equivalence? (Hint: for what value of Q. NPW is equal to zero)
Expert Solution
steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Stock Market Analysis
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
Recommended textbooks for you
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning