Find the present values of the following cash flow streams. The appropriate interest rate is 11%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that, when working with the calculator's cash flow register, you must enter CF0 = 0. Note also that it is quite easy to work the problem with Excel, using procedures described in the Ch04 Tool Kit.xlsx.) Do not round intermediate calculations. Round your answers to the nearest cent. Year Cash Stream A Cash Stream B 1 $100 $300 2  400  400 3  400  400 4  400  400 5  300  100 Stream A: $   Stream B: $   What is the value of each cash flow stream at a 0% interest rate? Round your answers to the nearest dollar. Stream A $   Stream B $

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter26: Capital Budgeting (capbud)
Section: Chapter Questions
Problem 6R: Reset the Data Section of the CAPBUD2 worksheet to the original values. In requirement 4, you...
icon
Related questions
Question

Uneven Cash Flow Stream

 

  1. Find the present values of the following cash flow streams. The appropriate interest rate is 11%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that, when working with the calculator's cash flow register, you must enter CF0 = 0. Note also that it is quite easy to work the problem with Excel, using procedures described in the Ch04 Tool Kit.xlsx.) Do not round intermediate calculations. Round your answers to the nearest cent.

    Year Cash Stream A Cash Stream B
    1 $100 $300
    2  400  400
    3  400  400
    4  400  400
    5  300  100

    Stream A: $  

    Stream B: $  

  2. What is the value of each cash flow stream at a 0% interest rate? Round your answers to the nearest dollar.

    Stream A $  

    Stream B $  

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Present Value
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning