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...
icon
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(
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Future Value
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
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT