Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A Find the present value of the following cash flows at 2%, 5%, and 9%, T=6 |---------|---------|--------|--------|--------|---------|--------|--------|--------|--------| 30 30 30 30 30 30 1000 T=10

A

Find the present value of the following cash flows at 2%, 5%, and 9%,

                                                                                 T=6

  1. |---------|---------|--------|--------|--------|---------|--------|--------|--------|--------|

30        30        30        30        30        30

                                                       1000

         T=10

  1. |---------|---------|--------|--------|--------|--------|---------|--------|--------|---------|

30        30        30        30        30        30        30        30        30        30

                                                                                                       1000

                                                                                T=6

  1. |---------|---------|--------|---------|-------|--------|--------|--------|--------|--------|

50        50        50        50        50        50

                                                       1000

         T=10

  1. |---------|---------|--------|--------|--------|---------|--------|--------|--------|---------|

50        50        50        50        50        50        50        50        50        50

                                                                                                       1000

                                                                                 T=6

  1. |---------|---------|--------|--------|--------|---------|--------|--------|--------|--------|

80        80        80        80        80        80

                                                       1000

     T=10

  1. |---------|---------|--------|--------|--------|--------|---------|--------|--------|--------|

80        80        80        80        80        80        80        80        80        80

                                                                                                       1000

Part B

 

For each of the sets of cash flows, and using the value you derived at a 5%, do the following

Multiply each cash flow by the time period associated with the cash flow.  For example for the first set of cash flow you would:

30 * 1

30 * 2

30 * 3

30 * 4

30 * 5

1030 * 6

Divide each product you just calculated by (1.05)time

30 / 1.05

60 / 1.1025

90 / 1.15762

120 / 1.21551

150 / 1.27628

6180 / 1.34010

Add the numbers you just calculated  4988.602954

Divide that sum by whatever you got in part A for the first set of cash flows using the 5% rate  of 5.552228552

Repeat these steps for the remaining sets of cash flows limiting your analysis to the 5% rate for present value.

Discuss what you observe in Part A.  What do you observe in Part B?



Step by Step Solution

3.51 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

Solution Excel Formula PARTB SET2 Given NoteFrom the given set of cash flows limiting the analysis to 5rate of present value Nper10 PMT30 FV1000 Present value at 584557 Step1 Cash flow would be calcul... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microeconomics and Behavior

Authors: Robert Frank

9th edition

9780077723750, 78021693, 77723759, 978-0078021695

More Books

Students also viewed these Finance questions

Question

-x/2 x/4 If A = -x/2 and A-1 =6 then x equals

Answered: 1 week ago