Investment X offers to pay you $5,300 per year for eight years, whereas Investment Y offers to pay you $7,300 per year for five years. Which of these cash flow streams has the higher present value if the discount rate is 5 percent? If the discount rate is 15 percent? Input area: Payment for X Number of years for X Payment for Y Number of years for Y O Discount rate 1 Discount rate 2 $5,300 8 $7,300 5 5% 15%
Investment X offers to pay you $5,300 per year for eight years, whereas Investment Y offers to pay you $7,300 per year for five years. Which of these cash flow streams has the higher present value if the discount rate is 5 percent? If the discount rate is 15 percent? Input area: Payment for X Number of years for X Payment for Y Number of years for Y O Discount rate 1 Discount rate 2 $5,300 8 $7,300 5 5% 15%
Financial Management: Theory & Practice
16th Edition
ISBN:9781337909730
Author:Brigham
Publisher:Brigham
Chapter4: Time Value Of Money
Section: Chapter Questions
Problem 12MC: (1) What is the value at the end of Year 3 of the following cash flow stream if the quoted interest...
Related questions
Question
please provide answer in PMT form for excel. Unsure how to input it
![2
3
4
5
6
7
Investment X offers to pay you $5,300 per year for eight years, whereas
Investment Y offers to pay you $7,300 per year for five years. Which of these
cash flow streams has the higher present value if the discount rate is 5
percent? If the discount rate is 15 percent?
Input area:
Payment for X
Number of years for X
Payment for Y
Number of years for Y
Discount rate
Discount rate
8
9
10
11
12
13 (Use cells A6 to B11 from the given information to complete this question.Your answers should be positive values.)
14
15 Output area:
16
$5,300
8
17 Value of X at 5%
18 Value of Y at 5%
19 Value of X at 15%
20 Value of Y at 15%
21
22
$7,300
5
5%
15%
PMT(rate, nper, pv, [fv], [type]) ^
=PMT(](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F9870bfeb-e26e-42f8-8342-bb7dac6347ce%2Faeda3d3a-b8c4-4703-943a-c22fff866726%2F5226r1l_processed.jpeg&w=3840&q=75)
Transcribed Image Text:2
3
4
5
6
7
Investment X offers to pay you $5,300 per year for eight years, whereas
Investment Y offers to pay you $7,300 per year for five years. Which of these
cash flow streams has the higher present value if the discount rate is 5
percent? If the discount rate is 15 percent?
Input area:
Payment for X
Number of years for X
Payment for Y
Number of years for Y
Discount rate
Discount rate
8
9
10
11
12
13 (Use cells A6 to B11 from the given information to complete this question.Your answers should be positive values.)
14
15 Output area:
16
$5,300
8
17 Value of X at 5%
18 Value of Y at 5%
19 Value of X at 15%
20 Value of Y at 15%
21
22
$7,300
5
5%
15%
PMT(rate, nper, pv, [fv], [type]) ^
=PMT(
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![EBK CFIN](https://www.bartleby.com/isbn_cover_images/9781337671743/9781337671743_smallCoverImage.jpg)
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![EBK CFIN](https://www.bartleby.com/isbn_cover_images/9781337671743/9781337671743_smallCoverImage.jpg)
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT