ch13 Risk and Capital Budgeting- numerical excercise
docx
keyboard_arrow_up
School
NorQuest College *
*We aren’t endorsed by this school
Course
2230
Subject
Finance
Date
Jan 9, 2024
Type
docx
Pages
3
Uploaded by BailiffArtLoris14
Question #1 – Analyze Investment Risk Mary Beth Clothes is considering opening an additional suburban
outlet. An after tax cash flow of $100 per day (expected value) is projected for each of the two locations
being evaluated. Which of these sites would you select based on the distribution of these cash flows?
(Use the coefficient of variation as your measure of risk.)
Probability Cash Flows Probability Cash Flows
Site A
Site B
probability
Cash flow
Probability
Cash flow
.20
50
.10
20
.30
100
.20
50
.30
110
.40
100
.20
135
.20
150
.10
180
Expected value
100
Expected value
100
Cash
flow
Expected
value
Deviation
(D-D)
Squared
deviation
(D-D)
2
probability
50
100
-50
2500
.20
500
100
100
0
0
.3
0
110
100
10
100
.30
30
135
100
35
1225
.2
245
775
775
under score=
27.8
Standard deviation =27.8
Coefficient of Variation(V)=27.8/100=.278
Site B
Cash flow
Expected
value
deviation
Squared
deviation
Probability
(P)
product
20
100
-80
6400
.10
640
50
100
-50
2500
.20
500
100
100
0
0
0
0
150
100
50
2500
.20
500
180
100
80
6400
.10
640
2280
2280 square root= 47.75
Coefficient of Variation(V)=47.75/100=.4775
Which investment is preferred?
Site A is the preferred site since it has the smallest coefficient of variation. Because both alternatives
have the same expected value, the standard deviation alone would have been enough for a decision. Site
A will be just as profitable as B but with less risk.
Question #1 – Analyze an Investment Cash Flows
Silverado Mining Company is analyzing the purchase of two silver mines. Only one investment will be
made. The Yukon mine will cost $2 million, The Yukon Mine will produce $400,000 per year in Years 5
through 15 and $800,000 per year in Years 16 through 25. The Labrador mine will cost $2.4 million and
will produce $300,000 per year for the next 25 years. The cost of capital is 10 percent. a. Which
investment should be made? b. If the Yukon mine justifies an extra 4 percent premium over the normal
cost of capital because of its riskiness and relative uncertainty of flows, does the investment decision
change?
Investment 1
Cost=2,000,000
Cash flow year 5-15=400,000/year
Cash flow year 16-25=800,000/year
Investment 2
Cost=2,400,000
Cash flow=300,000/year
Cost of capital=10
Pv of cash flow year 5-15
n=10,pmt-400,000, i=10 pv=?
2,457,827
pv of cash flow now
= n=5, i=5, fv=2457827 pv=?
1,526,117
Pv of investment 1 year 16-25
n=10,pmt-800,000, i=10 pv=?
4,915,654
Pv of cash flow year 1-15
1,176,768
Present value of all the cash flows =(1,176,768+
1,526,117= =2,702,885
Cast of capital
=2,000,000
NPV
=702,885
Pv of investment 2 year
2,723,112
Cost of capital
2400,000
NPV
323,112
Which investment should be made? Both projects have a positive NPV: therefore, both projects should
be accepted. However, if the projects are mutually exclusive, then select the Yukon mine with the higher
NPV.
If the Yukon project justifies an extra 5 percent premium over the normal cost of capital because of its
riskiness and relative uncertainty of flows, does the investment decision change?
Discount rate = 15%
Pv of 5-15 years cash flow= 998086
Pv of 16-25 years cash flow=493423
Pv of cash flows=1,491,509
Cost of capital=
2,000,000
NPV
Which investment should be made? Now the decision should be made to reject the
purchase of the Yukon Mine and proceed with the Labrador mine. smelter.
Question #1 – Analyze Investment Risk Western Dynamite Company is evaluating two methods of
blowing up old buildings for commercial purposes over the next five years. Method one (implosion) is
relatively low in risk for this business and will carry a 10 percent discount rate. Method two (explosion) is
less expensive to perform but more dangerous and will call for a higher discount rate of 15 percent.
Either method will require an initial capital outlay of $100,000. The inflows from projected business over
the next five years are given below. Which method should be selected using net present value analysis?
year
Product1
Product 2
1
25,000
28,000
2
30,000
32,000
3
38,000
39,000
4
31,000
33,000
5
19,000
25,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
use excel
arrow_forward
Karamo's Shoe Stores Incorporated is considering opening an additional suburban outlet. An aftertax expected cash flow of $100 per
week is anticipated from two stores that are being evaluated. Both stores have positive net present values.
Site A
Probability
0.2
0.2
0.2
0.4
Site A
Site B
Cash Flows
$50
100
110
120
Coefficient of
Variation
Site B
Probability
0.1
0.2
0.2
0.2
0.3
a. Compute the coefficient of variation for each site.
Note: Do not round intermediate calculations. Round your answers to 3 decimal places.
Cash Flows:
$ 20
50
100
150
190
arrow_forward
Karamo's Shoe Stores Incorporated is considering opening an additional suburban outlet. An aftertax expected cash flow of $120 per
week is anticipated from two stores that are being evaluated. Both stores have positive net present values.
Probability
0.2
0.2
9.4
0.2
Site A
Site B
Site A
Cash Flows
$ 70
Site A
Site B
120
130
150
Coefficient of
Variation
Probability
0.1
0.2
9.2
0.4
0.1
Site B
a. Compute the coefficient of variation for each site.
Note: Do not round intermediate calculations. Round your answers to 3 decimal places.
Cash Flows
$ 40
79
120
140
220
b. Which store site would you select based on the distribution of these cash flows? Use the coefficient of variation as your measure of
risk.
arrow_forward
What is the profitability index for an investment solve this question
arrow_forward
Accounting question
arrow_forward
Complete the following 6 Wk 3 Financial Exercises: Problem Set 1, Part 2
problems:
1. Calculate the net present value (NPV) of the following cash flow stream if the
required rate is 12%:
Insert your NPV calculation.
Year
Cash Flow
Is this a good project for the business to accept? Explain why or why not.
Insert your answer.
2. Calculate the NPV of the following cash flow projections based on a required
rate of 10.5%:
Insert your NPV calculation.
Year
Cash Flow
Is this a good project for the business to accept? Explain why or why not.
Insert your answer.
3. A company needs to decide if it will move forward with 2 new products that it is
evaluating. The 2 initiatives have the following cash flow projections:
Project A
Project B
Year
Cash Flow
Year
Cash Flow
Based on the risk of each project, the company has a required rate of return of
11% for Project A and 11.5% for Project B. The company has a $1.5 million
budget to spend on new projects for the year. Should the company move forward…
arrow_forward
Typed plz and asap please provide a quality solution take care of plagiarism
arrow_forward
Consider the following two projects:
Project
Year 0
Year 1
Year 2
Cash Flow
Cash Flow Cash Flow
A
B
- 100
-73
40
30
30
The profitability index for project B is closest to:
OA. 25.99
B. 0.1
O C. 17.33
O D. 0.17
50
Year 3
Cash Flow
60
30
Year 4
Cash Flow
N/A
30
Discount
Rate
0.15
0.15
arrow_forward
1
2
The following cash flow pattern has two IRRs. Use Excel to draw a graph of the NPV of
these cash flows as a function of the discount rate. Then use the IRR function to identify
the two IRRS. Would you invest in this project if the opportunity cost were 30%?
3 Discount rate
10.00%
-34.96
Data table
4
NPV
S
Year
Cash flow
6
7
0
-300
8
1
300
9
2
200
10
3
150
11
4
122
12
5
133
13
6
-800
14
15 IRR 1
16 IRR2
17
18
19
+
?
?
arrow_forward
Whiplash Airbags has been presented an investment opportunity that is summarized below.
Year
0
1
3
5
60
100
Cash Flow S(440) 20
(1000's)
Determine the IRR for the proposed investment.
2
40
4
80
6
120
7
140
8
160
arrow_forward
You are offered a chance to buy an asset for $4,000 that is expected to produce cash flows of $750 at the end of Year 1, $1,000 at the end of Year 2, $850 at the end of Year 3. and $6,250 at the end of Year 4. What rate of return would you earn if you bought this asset? Select the correct answer. a. 28.08% b. 26.48% с. 28.88% d. 25.68% e. 27.28%.
arrow_forward
Nikul
Don't upload image please
arrow_forward
5.
LL
Consider the following cash flows of a project: Year
Year
1.
50
0.
2.
3.
4.
1.
Find the internal rate of return for this investment.
0.
20.
Multiple Choice
< Prev
10 of 15 Next
here to search
F11
F12
F4
F5
69
81
9F-
arrow_forward
13. I need help with finance home work question asap please
What is the profitability index for a project that requires an initial cash outflow in the amount of $5,000,000 and has a NPV of $750,000?
arrow_forward
Please see attached:
arrow_forward
Below are four cases that you will have to solve
using Excel spreadsheets.
1st case
The company COMERCIAL SA has two investment alternatives that present the following
information:
PROJECT
A
B
It is requested
Initial
investment.
$25,000
$22,000
Cash flows
year 1
1. Determine the internal rate of return.
2. Determine the present value.
$7,000
$12,000
The discount rate for the project will be 10% and the MARR will be 20%.
3. Determine the recovery period.
4. Define which is the most viable project.
Year 2 cash
flows
$15,000
$8,000
Year 3 cash
flows
$18,000
$12,000
arrow_forward
A firm wants to start a project. A team of financial analysts estimated the following cash flows
year cash flow
0 -$100,000
1 55,000
2 43,000
3 45,000
Suppose that the discount rate (interest rate) is 12%. The profitability index (PI) is
Group of answer choices
15,416.59
1.15
0.87
2.15
arrow_forward
Assume an investment is priced today at $5,000 and has the following income
stream:
Year Cash Flow
1
123
2
3
4
$ 1,000
- 2,000
3,000
3,000
Would an investor with a required rate of return of 15 percent be wise to invest at
a price of $5,000?
Multiple Choice
No, because the investment has a net present value of -
$1,139.15.
No, because the investment has a net present value of -
$1,954.91.
Yes, because the investment has a net present value of
$1,069.66.
Yes, because the investment has a net present value of
$1,954.91.
An investor would be indifferent between purchasing and
not purchasing the above investment at the stated price.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- use excelarrow_forwardKaramo's Shoe Stores Incorporated is considering opening an additional suburban outlet. An aftertax expected cash flow of $100 per week is anticipated from two stores that are being evaluated. Both stores have positive net present values. Site A Probability 0.2 0.2 0.2 0.4 Site A Site B Cash Flows $50 100 110 120 Coefficient of Variation Site B Probability 0.1 0.2 0.2 0.2 0.3 a. Compute the coefficient of variation for each site. Note: Do not round intermediate calculations. Round your answers to 3 decimal places. Cash Flows: $ 20 50 100 150 190arrow_forwardKaramo's Shoe Stores Incorporated is considering opening an additional suburban outlet. An aftertax expected cash flow of $120 per week is anticipated from two stores that are being evaluated. Both stores have positive net present values. Probability 0.2 0.2 9.4 0.2 Site A Site B Site A Cash Flows $ 70 Site A Site B 120 130 150 Coefficient of Variation Probability 0.1 0.2 9.2 0.4 0.1 Site B a. Compute the coefficient of variation for each site. Note: Do not round intermediate calculations. Round your answers to 3 decimal places. Cash Flows $ 40 79 120 140 220 b. Which store site would you select based on the distribution of these cash flows? Use the coefficient of variation as your measure of risk.arrow_forward
- What is the profitability index for an investment solve this questionarrow_forwardAccounting questionarrow_forwardComplete the following 6 Wk 3 Financial Exercises: Problem Set 1, Part 2 problems: 1. Calculate the net present value (NPV) of the following cash flow stream if the required rate is 12%: Insert your NPV calculation. Year Cash Flow Is this a good project for the business to accept? Explain why or why not. Insert your answer. 2. Calculate the NPV of the following cash flow projections based on a required rate of 10.5%: Insert your NPV calculation. Year Cash Flow Is this a good project for the business to accept? Explain why or why not. Insert your answer. 3. A company needs to decide if it will move forward with 2 new products that it is evaluating. The 2 initiatives have the following cash flow projections: Project A Project B Year Cash Flow Year Cash Flow Based on the risk of each project, the company has a required rate of return of 11% for Project A and 11.5% for Project B. The company has a $1.5 million budget to spend on new projects for the year. Should the company move forward…arrow_forward
- Typed plz and asap please provide a quality solution take care of plagiarismarrow_forwardConsider the following two projects: Project Year 0 Year 1 Year 2 Cash Flow Cash Flow Cash Flow A B - 100 -73 40 30 30 The profitability index for project B is closest to: OA. 25.99 B. 0.1 O C. 17.33 O D. 0.17 50 Year 3 Cash Flow 60 30 Year 4 Cash Flow N/A 30 Discount Rate 0.15 0.15arrow_forward1 2 The following cash flow pattern has two IRRs. Use Excel to draw a graph of the NPV of these cash flows as a function of the discount rate. Then use the IRR function to identify the two IRRS. Would you invest in this project if the opportunity cost were 30%? 3 Discount rate 10.00% -34.96 Data table 4 NPV S Year Cash flow 6 7 0 -300 8 1 300 9 2 200 10 3 150 11 4 122 12 5 133 13 6 -800 14 15 IRR 1 16 IRR2 17 18 19 + ? ?arrow_forward
- Whiplash Airbags has been presented an investment opportunity that is summarized below. Year 0 1 3 5 60 100 Cash Flow S(440) 20 (1000's) Determine the IRR for the proposed investment. 2 40 4 80 6 120 7 140 8 160arrow_forwardYou are offered a chance to buy an asset for $4,000 that is expected to produce cash flows of $750 at the end of Year 1, $1,000 at the end of Year 2, $850 at the end of Year 3. and $6,250 at the end of Year 4. What rate of return would you earn if you bought this asset? Select the correct answer. a. 28.08% b. 26.48% с. 28.88% d. 25.68% e. 27.28%.arrow_forwardNikul Don't upload image pleasearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you