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 3 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
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- For the past several weeks you have addressed several different areas of telecommunications and information technology...
- Draw the structure of a compound with molecular formula C5H12 that exhibits only one kind of...
- (1) Discuss your reaction to Hitler's Degenerate Art Show. Is it ever justified for a government...
- The probability of success is 0.68. A sample of 15 is taken. Assume independent trials. (Please...
- The following data are taken from the financial statements of Sigmon Inc. Terms of all sales...
- what is Transcranial magnetic stimulation (TMS)? For who and when is it used on? How effective...
- A value stream has three activities and two products. The units produced and shipped per week...
ADVERTISEMENT