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
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
- A research team conducted a study showing that approximately 20% of all businessmen who wear ties...
- Research the internet for companies that have executed data science projects. Pick one company and describe...
- Explain two theories or frameworks for understanding how Western Europe emerged out of 1,000 years of...
ADVERTISEMENT