Question
In: Finance
1. Assume you have the following cashflows Time: 0 1 2. 3 4 5 Cf: 21...
1.
Assume you have the following cashflows
Time: 0 1 2. 3 4 5
Cf: 21 4 5 6. 6(1 + .02). 6(1+.02)^2
After year 3 cashflows will grow by constant 2% rate
What is the discounted present value of these cashflows if
your project's cost of capital is 13%?
Solutions
Expert Solution
Net Present value has to be calculated using NPV function in EXCEL
=NPV(rate,Year1 to Year5 cashflows)-Year0 cashflow
=NPV(13%,Year1 to Year5 cashflows)-21=-$2.24
| cost of capital | 13% |
| Year0 | -21 |
| Year1 | 4 |
| Year2 | 5 |
| Year3 | 6 |
| Year4 | 6.12 |
| Year5 | 6.24 |
| NPV | -2.24 |
jeff jeffy answered 2 years agoRelated Solutions
exampleInput.txt 1 2 3 0 2 3 4 0 1 3 5 0 1 2 6...
exampleInput.txt
1 2 3
0 2 3 4
0 1 3 5
0 1 2 6
1 5 6 8
2 4 6 7
3 4 5 9 10
5 8 9
4 7 9
6 7 8
6
How can I detect when 'cin' starts reading from a new line. The
amount of numbers in each row is unknown. I need them in type 'int'
to use the data.
Given the following dataset x 1 1 2 3 4 5 y 0 2 4 5 ...
Given the following dataset x 1
1 2 3 4 5
y 0 2 4
5 5 3
We want to test the claim that there is a correlation between
xand y. The level of cretaine phosphokinase (CPK) in blood samples
measures the amount of muscle damage for athletes. At Jock State
University, the level of CPK was determined for each of 25 football
players and 15 soccer players before and after practice. The two
groups of athletes are trained...
Given the following dataset x 1 1 2 3 4 5 y 0 2 4 5...
Given the following dataset
x
1
1
2
3
4
5
y
0
2
4
5
5
3
We want to test the claim that there is a correlation between
xand y.
(a) What is the null hypothesis Ho and the alternative
hypothesis H1?
(b) Using α= 0.05, will you reject Ho? Justify your answer by
using a p-value.
(c) Base on your answer in part (b), is there evidence to
support the claim?
(d) Find r, the linear correlation...
Consider the following page reference string: 0, 1, 2, 3, 1, 0, 4, 5, 1, 0,...
Consider the following page reference string: 0, 1, 2, 3, 1, 0,
4, 5, 1, 0, 1, 2, 6, 5, 2, 1, 0, 1, 2, 5 How many page faults would
occur for the following replacement algorithms, assuming one,
three, five, and seven frames? Remember that all frames are
initially empty, so your first unique pages will cost one fault
each. Optimal replacement LRU replacement CLOCK replacement FIFO
replacement
DATA 3 8 2 15 2 2 0 0 4 5 2 7 0 1 5...
DATA
3
8
2
15
2
2
0
0
4
5
2
7
0
1
5
3
0
2
5
4
1
6
9
5
3
1
2
10
6
1
1
2
1
19
6
6
6
7
0
4
1
1
1
0
1
9
2
2
2
1
16
10
10
5
2
3
1
4
4
4
3
6
2
8
5
2
7
1
6
4
0
3
1
1
1
Background:
A group of...
Assume that you have a fair 6 sided die with values {1, 2, 3, 4, 5,...
Assume that you have a fair 6 sided die with values {1, 2, 3, 4,
5, 6} and a fair 12 sided die with values {1, 2, 3, 4, 5, 6, 7, 8,
9, 10, 11, 12}. A discrete random variable is generated by rolling
the two dice and adding the numerical results together.
(a) Create a probability mass function that captures the
probability of all possible values of this random variable. You may
use R or draw the pmf...
x (Bins) frequency 0 0 1 0 2 0 3 2 4 5 5 8 6...
x (Bins)
frequency
0
0
1
0
2
0
3
2
4
5
5
8
6
13
7
33
8
42
9
66
10
77
11
105
12
103
13
110
14
105
15
84
16
70
17
51
18
40
19
27
20
27
21
15
22
5
23
7
24
2
25
2
26
1
27
0
28
0
29
0
30
0
(7) On the Histogram worksheet, calculate all
frequencies of the distribution using the table shown....
Find the distances: A) Between ?1=〈2+2?,−1+?,−3?〉and ?2=〈4,−5−3?,1+4?〉 . B) Between the planes 2?−?+5?=0 and 2?−?+5?=5 ....
Find the distances:
A) Between ?1=〈2+2?,−1+?,−3?〉and ?2=〈4,−5−3?,1+4?〉 .
B) Between the planes 2?−?+5?=0 and 2?−?+5?=5 .
C) From the point (1,2,3) to the line ?=〈−?,4−?,1+4?〉 .
You have 3 projects with the following cash flows: Year 0 1 2 3 4 Project...
You have 3 projects with the following cash flows:
Year
0
1
2
3
4
Project 1
-$ 152
$22
$39
$58
$82
Project 2
−826
0
0
7,010
−6,506
Project 3
21
41
61
80
−247
a. For which of these projects is the IRR rule reliable?
b. Estimate the IRR for each project (to the nearest1%).
c. What is the NPV of each project if the cost of capital is
5%?20 %50%?
a. For which of these...
You have 3 projects with the following cash flows: Year 0 1 2 3 4 Project...
You have 3 projects with the following cash flows:
Year
0
1
2
3
4
Project 1
−$151
$ 21
$ 39
$ 59
$ 80
Project 2
−824
00
00
6,999
−6,501
Project 3
2020
40
62
81
−245
a. For which of these projects is the IRR rule reliable?
b. Estimate the IRR for each project (to the nearest
1%).
c. What is the NPV of each project if the cost of capital is
5%?
20%?
50%?
a....
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- In C# The Saffir-Simpson Hurricane Scale classifies hurricanes into five categories numbered 1 through 5. Write...
- Draw a flowchart and pseudocode that accepts three numbers from a user and displays a message...
- Discuss the benefits of an effective reverse logistics process. Would you consider working in reverse logistics...
- Q.no.1. (B) Circular and linear thinking are two types of ‘thinking as a process’. How each...
- Web design is the planning and creation of websites. This includes a number of separate skills...
- Evaluate the following projects, using the net present value criteria. Assume a cost of capital of...
- Between 1988 and 1990 three $150 million amusement parks opened in France. By 1991 two of...
ADVERTISEMENT