Halls Construction is analyzing its capital expenditure proposals for the purchase of equipment in the coming year. The capital budget is limited to $5,000,000 for the year. Laura Bentley, staff analyst at Halls, is preparing an analysis of the three projects under consideration by Caden Halls, the company's owner. Data Table A B C D 1 Project A Project B Project C 2 Projected cash outflow 3 Net initial investment $3,000,000 $2,100,000 $3,000,000 4 Projected cash inflows 5 Year 1 $1,200,000 $1,200,000 $1,700,000 6 Year 2 1,200,000 600,000 1,700,000 7 Year 3 1,200,000 500,000 200,000 8 Year 4 1,200,000 100,000 9 Required rate of return 6% 6% 6 1.. Calculate the payback period for each of the three projects. Ignore income taxes. Using the payback method, which projects should Halls choose?. Ignore income taxes. (Round your answers to two decimal places.) Project A = Project B= Project C= 2. Bentley thinks that projects should be selected based on their NPVs. Assume all cash flows occur at the end of the year except for initial investment amounts. Calculate the NPV for each project. Ignore income taxes NPV of Project A= NPV of Project B= NPV of Project C= 3. Which projects, if any, would you recommend funding? Briefly explain why.
Halls Construction is analyzing its capital expenditure proposals for the purchase of equipment in the coming year. The capital budget is limited to $5,000,000 for the year. Laura Bentley, staff analyst at Halls,
is preparing an analysis of the three projects under consideration by Caden Halls, the company's owner.
Data Table
|
A
|
B
|
C
|
D
|
1
|
|
Project A
|
Project B
|
Project C
|
2
|
Projected
|
|
|
|
3
|
Net initial investment
|
$3,000,000
|
$2,100,000
|
$3,000,000
|
4
|
Projected
|
|
|
|
5
|
Year 1
|
$1,200,000
|
$1,200,000
|
$1,700,000
|
6
|
Year 2
|
1,200,000
|
600,000
|
1,700,000
|
7
|
Year 3
|
1,200,000
|
500,000
|
200,000
|
8
|
Year 4
|
1,200,000
|
|
100,000
|
9
|
Required
|
6%
|
6%
|
6
|
1.. |
Calculate the payback period for each of the three projects. Ignore income taxes. Using the payback method, which projects should Halls choose?. Ignore income taxes. (Round your answers to two decimal places.)
Project A = Project B= Project C= |
|
2. |
Bentley thinks that projects should be selected based on their NPVs. Assume all cash flows occur at the end of the year except for initial investment amounts. Calculate the
NPV of Project A= NPV of Project B= NPV of Project C= |
|
3. |
Which projects, if any, would you recommend funding? Briefly explain why. |
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images