PS5
.xlsx
keyboard_arrow_up
School
University of Texas, Rio Grande Valley *
*We aren’t endorsed by this school
Course
ONLINE
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
7
Uploaded by DukeRiverPolarBear11
Problem Set 5
Chapter 11 -- Capital Budgeting
Assigned Problem 1
Winston Clinic is evaluating a project that costs $52,125 and has expected net cash flows of $12,000
per year for eight years. The first inflow occurs one year after the cost outflow, and the project has a
cost of capital of 12 percent.
a. What is the project's payback?
b. What is the project's NPV? Its IRR?
c. Is the project financially acceptable? Explain your answer.
ANSWER
a.
Table of cash flows for the project:
Annual
Cumulative
NPV
Year
Cash Flow
Cash Flow
Values
0
-$52,125
-$52,125
1
$12,000
-$40,125
$10,714
2
$12,000
-$28,125
$9,566
3
$12,000
-$16,125
$8,541
4
$12,000
-$4,125
$7,626
5
$12,000
$7,875
$6,809
6
$12,000
$19,875
$6,080
7
$12,000
$31,875
$5,428
8
$12,000
$43,875
$4,847
Payback
4.34
b.
NPV
$7,486.68 IRR
16%
c.
The project has a positive NPV and the IRR (16%) is greater than the cost of capital of (12%), therefore it is acceptable.
A
B
C
D
E
F
G
H
I
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
44
45
46
47
48
Problem Set 5
Chapter 11 -- Capital Budgeting
Assigned Problem 2
Great Lakes Clinic has been asked to provide exclusive healthcare services for next year's World
Exposition. Although flattered by the request, the clinic's managers want to conduct a financial
analysis of the project. There will be an up-front cost of $160,000 to get the clinic in operation. Then,
a net cash inflow of $1 million is expected from operations in each of the two years of the exposition.
However, the clinic has to pay the organizers of the exposition a fee for the marketing value of the
opportunity. This fee, which must be paid at the end of the second year, is $2 million.
a. What are the cash flows associated with the project that are relevant for capital budgeting purpose?
b. Find the project NPV if its cost of capital is 25 percent and if its cost of capital is 400%. Why would a financial calculator give an error message when attempting to calculate this project's IRR?
c. If the project cost capital is 10 percent, what would be the project's NPV in each case? Shoud the project be undertaken?
ANSWER
a.
Cash flows: Year
Cash Flow
0
-$160,000
1
$1,000,000
2
-$1,000,000
b.
NPV @
25%
$0 NPV @
400%
$0 c.
NPV @
10%
($77,355)
A
B
C
D
E
F
G
H
I
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
Problem Set 5
Chapter 11 -- Capital Budgeting
Assigned Problem 3
California Health Center, a for-profit hospital, is evaluating the purchase of new diagnostic
equipment. The equipment, which costs $600,000, has an expected life of five years and an estimated
pretax salvage value of $200,000 at that time. The equipment is expected to be used 15 times a day
for 250 days a year for each year of the project's life. On average, each procedure is expected to
generate $80 in collections, which is net of bad debt losses and contractual allowances, in its first
year of use. Thus, net revenues for Year 1 are estimated at 15 x 250 x $80 = $300,000.
Labor and maintenance costs are expected to be $100,000 during the first year of operation, while
utilities will cost another $10,000 and cash overhead will increase by $5,000 in Year 1. The cost for
expendable supplies is expected to average $5 per procedure during the first year. All costs and
revenues, except depreciation, are expected to increase at a 5 percent inflation rate after the first year.
The equipment falls into the MACRS five-year class for tax depreciation and hence is subject to the
following depreciation allowances: Year
Allowance
1
0.2
2
0.32
3
0.19
4
0.12
5
0.11
6
0.06
The hospital's tax rate is 40 percent, and its corporate cost of capital is 10 percent.
a. Estimate the project's net cash flows over its five-year estimated life.
b. What are the project's NPV and IRR? (Assume that the project has average risk.)
A
B
C
D
E
F
G
H
I
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
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 Questions
Question 6
A project has expected cash inflows, starting with year 1, of $2,200, $2,900, $3,500 and finally in year four, $4,000. The profitability index is 1.14 and the discount rate is 12 percent. What is the initial cost of the project?
Group of answer choices
$9,211.06
$9,250.00
$8,166.19
$7,899.16
$8,098.24
arrow_forward
Question 4
Assume that you are analysing a capital budgeting project. The initial investment for buying machichnary
and equipment cost $5million and project will last for 5 year. The expected revenue is to be $2 million per
year and operating cost is expected to be 30% of the total revenue. If the salvage (scrap) value at the end
of 5 is estimated to be $0.50 million. You may use straight-line method to calculate the depreciation for
the project. The tax rate is estimated to be 30% per annum. The project has the cost of capital of 10%.
a. Calculate net cash flows for each year.
b.
Calculate the NPV and determine the payback period.
c.
Will you accept this project based on NPV? If the project payback policy is 4 years, will you
accept this project?
arrow_forward
Question 4: Capital Budgeting
a). Consider the following two mutually exclusive projects:
YEAR
0
CASH FLOW (A)
-$300,000
1
20,000
2
70,000
3
80,000
4
400,000
CASH FLOW (B)
-$39,000
18,000
12,000
18,000
19,000
Whichever project you choose, if any, you require a 15 percent return on your investment.
(i) If you apply the payback period (PBP) criterion, which investment will you choose?
Why?
(ii) If you apply the net present value (NPV) criterion, which investment will you choose?
Why?
(iii)If you apply the profitability index (PI) criterion, which investment will you choose?
Why?
(iv) If you apply the internal rate of return (IRR) criterion, which investment will you choose?
Why?
(v) Based on your answers in (i) through (iv), which project will you finally choose? Why?
Examiner: Prof. Ebenezer Bugri Anarfo
Page 9
b). You are trying to determine whether to expand your business by building a new
manufacturing plant. The plant has an installation cost of $15 million, which will be…
arrow_forward
PROBLEM TWO: Capital Budgeting
The plant manager of IHK is considering the purchase of a new robotic assemble plant. The
new robotic line will cost $125,000. The manager believes that the new investment will
result in direct labor savings of $31,250 per year for ten years.
Requirements:
a. What is the payback period for this project
b. What is the net present value or PV assuming a 10% rate of return?
c. Should the plant manager accept or reject the project?
arrow_forward
QUESTION 3 - Capital budgeting Technique
You are considering two independent projects, Project A and Project B. The initial cash outlay
associated with project A is RM50,000 and the initial cash outlay associated with project B is
RM70,000. The required rate of return on both project is 12 percent. The expected annual free cash
flows from each project are as follows
Year
Project A
Project B
1
-RM50,000
-RM70,000
2
12,000
13,000
3
12,000
13,000
4
12,000
13,000
12,000
13,000
12,000
13,000
Calculate the NPV, PI, and IRR for each project and indicate if the project should be accepted.
arrow_forward
more.
3. Net present value method
Aa Aa
Consider the case of Underwood Manufacturing:
Underwood Manufacturing is evaluating a proposed capital budgeting project that will require an initial investment of
$120,000. The project is expected to generate the following net cash flows:
Year
Cash Flow
Year 1
$37,600
Year 2
$50,500
Year 3
$45,000
Year 4
$41,900
Assume the desired rate of return on a project of this type is 10%. What is the net present value of this project?
-$4,415.10
$18,344.79
-$7,244.50
$23,914.50
Suppose Underwood Manufacturing has enough capital to fund the project, and the project is not competing for
funding with other projects. Should Underwood Manufacturing accept or reject this project?
Accept the project
Reject the project
arrow_forward
which one is correct please confirm?
QUESTION 19
Whipple Industries Inc. is in the process of determining its optimal capital budget for next year. The following investment projects are under consideration:
Required
Expected Rate
Project
Investment
of Return
A
$2 million
20.0%
B
$3 million
15.0%
C
$1 million
13.5%
D
$4 million
13.0%
E
$1 million
12.5%
F
$3 million
12.0%
G
$5 million
11.5%
The firm's marginal cost of capital schedule is as follows:
Amount of
Funds Raised
Cost
$0 - $6 million
12.0%
$6 million - $12 million
12.5%
$12 million - $18 million
13.5%
Over $18 million
15.0%
Determine Whipple's optimal capital budget (in dollars) for the coming year.
a.
$5 million
b.
$10 million
c.
$14 million
d.
$11 million
arrow_forward
Problem 21
Compute the (1) net present value and (ii) discounted payback period of the following capital budgeting projects.
The firm's required rate of return is 12 percent.
Projects
Year
123
Zeta
$(50,000)
20,000
15,000
30,000
Omega
$(45,000)
42,000
9,000
1,850
Based on your calculations, which project will be selected if you have to choose only one of the two projects?
arrow_forward
Question:
You are a financial analyst for the Hitler Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each project is 12 percent. The projects’ expected net cash flows are as follows:
Expected Net Cash Flows
Year
Project X
Project Y
0
($10,000)
($10,000)
1
6,500
3,500
2
3,000
3,500
3
3,000
3,500
4
1,000
3,500
Required:
Calculate each project’s payback period, discounted payback period, net present value (NPV), profitability index and internal rate of return (IRR).
Which project or projects should be accepted if they are independent?
Which project should be accepted if they are mutually exclusive?
arrow_forward
PROBLEM TWO: Capital Budgeting The plant manager of IHK is considering the purchase of a new robotic assemble plant. The new robotic line will cost $250,000. The manager believes that the new investment will result in direct labor savings of $62,500 per year for ten years.Requirements:What is the payback period for this projectWhat is the net present value or PV assuming a 10% rate of return?Should the plant manager accept or reject the project?What else should the manager consider in the analysis?
arrow_forward
Practical Question
The total investment required for two projects are estimated at OMR100, 000. The cash flows
expected from the two projects for the first four years are explained in the table below.
Year
Project A Project B
Year 1
15,000
15,000
Year 2
28,500
40,000
Year 3
40,000
21,500
Year 4
50,000
35,000
Use the above information and advise which project to select based on payback period method
11
直
hp
arrow_forward
Part 1
Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive projects. The required rate of return is 15% and the target payback is 4 years. Explain which project is preferable under each of the four capital budgeting methods mentioned above:
Table 1
Cash flows for two mutually exclusive projects
Year
Investment A
Investment B
0
-$5,000,000
-5,000,000
1
$1,500,000
$1,250,000
2
$1,500,000
$1,250,000
3
$1,500,000
$1,250,000
4
$1,500,000
$1,250,000
5
$1,500,000
$1,250,000
6
$1,500,000
$1,250,000
7
$2,000,000
$1,250,000
8
0
$1,600,000
Part 2
Please study the following capital budgeting project and then provide explanations for the questions outlined below:
You have been hired as a consultant for Pristine Urban-Tech Zither, Inc. (PUTZ), manufacturers of fine zithers. The market for zithers is growing quickly. The company bought some land three years ago…
arrow_forward
CENGAGE MINDTAP
Assignment: Chapter 09 Capital Budgeting Techniques
Locke Manufacturing Inc. is analyzing a project with the following projected cash flows:
Year Cash Flow
0
1
2
3
4
-$1,324,800
300,000
450,000
546,000
360,000
This project exhibits
Locke's desired rate of return is 7.00%. Given the cash flows expected from the company's new project, compute the project's anticipated modified
internal rate of return (MIRR). (Hint: Round all dollar amounts to the nearest whole dollar, and your final MIRR value to two decimal places.)
O 6.70%
O 7.53%
8.37%
cash flows.
O 9.21%
Q Search this course
X
arrow_forward
It's urgently plz sir please help
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Question 6 A project has expected cash inflows, starting with year 1, of $2,200, $2,900, $3,500 and finally in year four, $4,000. The profitability index is 1.14 and the discount rate is 12 percent. What is the initial cost of the project? Group of answer choices $9,211.06 $9,250.00 $8,166.19 $7,899.16 $8,098.24arrow_forwardQuestion 4 Assume that you are analysing a capital budgeting project. The initial investment for buying machichnary and equipment cost $5million and project will last for 5 year. The expected revenue is to be $2 million per year and operating cost is expected to be 30% of the total revenue. If the salvage (scrap) value at the end of 5 is estimated to be $0.50 million. You may use straight-line method to calculate the depreciation for the project. The tax rate is estimated to be 30% per annum. The project has the cost of capital of 10%. a. Calculate net cash flows for each year. b. Calculate the NPV and determine the payback period. c. Will you accept this project based on NPV? If the project payback policy is 4 years, will you accept this project?arrow_forwardQuestion 4: Capital Budgeting a). Consider the following two mutually exclusive projects: YEAR 0 CASH FLOW (A) -$300,000 1 20,000 2 70,000 3 80,000 4 400,000 CASH FLOW (B) -$39,000 18,000 12,000 18,000 19,000 Whichever project you choose, if any, you require a 15 percent return on your investment. (i) If you apply the payback period (PBP) criterion, which investment will you choose? Why? (ii) If you apply the net present value (NPV) criterion, which investment will you choose? Why? (iii)If you apply the profitability index (PI) criterion, which investment will you choose? Why? (iv) If you apply the internal rate of return (IRR) criterion, which investment will you choose? Why? (v) Based on your answers in (i) through (iv), which project will you finally choose? Why? Examiner: Prof. Ebenezer Bugri Anarfo Page 9 b). You are trying to determine whether to expand your business by building a new manufacturing plant. The plant has an installation cost of $15 million, which will be…arrow_forward
- PROBLEM TWO: Capital Budgeting The plant manager of IHK is considering the purchase of a new robotic assemble plant. The new robotic line will cost $125,000. The manager believes that the new investment will result in direct labor savings of $31,250 per year for ten years. Requirements: a. What is the payback period for this project b. What is the net present value or PV assuming a 10% rate of return? c. Should the plant manager accept or reject the project?arrow_forwardQUESTION 3 - Capital budgeting Technique You are considering two independent projects, Project A and Project B. The initial cash outlay associated with project A is RM50,000 and the initial cash outlay associated with project B is RM70,000. The required rate of return on both project is 12 percent. The expected annual free cash flows from each project are as follows Year Project A Project B 1 -RM50,000 -RM70,000 2 12,000 13,000 3 12,000 13,000 4 12,000 13,000 12,000 13,000 12,000 13,000 Calculate the NPV, PI, and IRR for each project and indicate if the project should be accepted.arrow_forwardmore. 3. Net present value method Aa Aa Consider the case of Underwood Manufacturing: Underwood Manufacturing is evaluating a proposed capital budgeting project that will require an initial investment of $120,000. The project is expected to generate the following net cash flows: Year Cash Flow Year 1 $37,600 Year 2 $50,500 Year 3 $45,000 Year 4 $41,900 Assume the desired rate of return on a project of this type is 10%. What is the net present value of this project? -$4,415.10 $18,344.79 -$7,244.50 $23,914.50 Suppose Underwood Manufacturing has enough capital to fund the project, and the project is not competing for funding with other projects. Should Underwood Manufacturing accept or reject this project? Accept the project Reject the projectarrow_forward
- which one is correct please confirm? QUESTION 19 Whipple Industries Inc. is in the process of determining its optimal capital budget for next year. The following investment projects are under consideration: Required Expected Rate Project Investment of Return A $2 million 20.0% B $3 million 15.0% C $1 million 13.5% D $4 million 13.0% E $1 million 12.5% F $3 million 12.0% G $5 million 11.5% The firm's marginal cost of capital schedule is as follows: Amount of Funds Raised Cost $0 - $6 million 12.0% $6 million - $12 million 12.5% $12 million - $18 million 13.5% Over $18 million 15.0% Determine Whipple's optimal capital budget (in dollars) for the coming year. a. $5 million b. $10 million c. $14 million d. $11 millionarrow_forwardProblem 21 Compute the (1) net present value and (ii) discounted payback period of the following capital budgeting projects. The firm's required rate of return is 12 percent. Projects Year 123 Zeta $(50,000) 20,000 15,000 30,000 Omega $(45,000) 42,000 9,000 1,850 Based on your calculations, which project will be selected if you have to choose only one of the two projects?arrow_forwardQuestion: You are a financial analyst for the Hitler Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each project is 12 percent. The projects’ expected net cash flows are as follows: Expected Net Cash Flows Year Project X Project Y 0 ($10,000) ($10,000) 1 6,500 3,500 2 3,000 3,500 3 3,000 3,500 4 1,000 3,500 Required: Calculate each project’s payback period, discounted payback period, net present value (NPV), profitability index and internal rate of return (IRR). Which project or projects should be accepted if they are independent? Which project should be accepted if they are mutually exclusive?arrow_forward
- PROBLEM TWO: Capital Budgeting The plant manager of IHK is considering the purchase of a new robotic assemble plant. The new robotic line will cost $250,000. The manager believes that the new investment will result in direct labor savings of $62,500 per year for ten years.Requirements:What is the payback period for this projectWhat is the net present value or PV assuming a 10% rate of return?Should the plant manager accept or reject the project?What else should the manager consider in the analysis?arrow_forwardPractical Question The total investment required for two projects are estimated at OMR100, 000. The cash flows expected from the two projects for the first four years are explained in the table below. Year Project A Project B Year 1 15,000 15,000 Year 2 28,500 40,000 Year 3 40,000 21,500 Year 4 50,000 35,000 Use the above information and advise which project to select based on payback period method 11 直 hparrow_forwardPart 1 Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive projects. The required rate of return is 15% and the target payback is 4 years. Explain which project is preferable under each of the four capital budgeting methods mentioned above: Table 1 Cash flows for two mutually exclusive projects Year Investment A Investment B 0 -$5,000,000 -5,000,000 1 $1,500,000 $1,250,000 2 $1,500,000 $1,250,000 3 $1,500,000 $1,250,000 4 $1,500,000 $1,250,000 5 $1,500,000 $1,250,000 6 $1,500,000 $1,250,000 7 $2,000,000 $1,250,000 8 0 $1,600,000 Part 2 Please study the following capital budgeting project and then provide explanations for the questions outlined below: You have been hired as a consultant for Pristine Urban-Tech Zither, Inc. (PUTZ), manufacturers of fine zithers. The market for zithers is growing quickly. The company bought some land three years ago…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you