1. How much is the present value of the purchase of equipment? 2. How much is the present value of the salvage value? 3. How much is the present value of the $ -114500 $10004 $ 9699

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter11: Capital Budgeting And Risk
Section: Chapter Questions
Problem 12P
icon
Related questions
Question
do not give solution in image format
UGE Corporation is considering two possible investments and needs your help in
determining which will be the better financial option. Perform the necessary
calculations using Microsoft Excel so that maximum precision can be obtained.
(Unless indicated otherwise, enter your answers rounded to the nearest whole
dollar/input code: 0).
Investment Option "North"
This potential investment is a little more risky and longer term, so it has a minimum
rate of return of 16.20%. This investment would require an initial outlay of cash to
purchase a piece of equipment for $114,500, and at the end of the 7-year life of this
investment is expected to have a salvage value of $28,625. For each year of this
investment, net annual cash inflows are expected to be $27,750.
1. How much is the
present value of the
purchase of equipment?
2. How much is the
present value of the
salvage value?
3. How much is the
present value of the
annual cash inflows?
4. How much is the Net
Present Value?
5. What is the value of
the Present Value Index?
(round to the nearest
thousandths place/input
code: 0.000)
$ -114500
$10004
$9699
$ 19703
0.172
Transcribed Image Text:UGE Corporation is considering two possible investments and needs your help in determining which will be the better financial option. Perform the necessary calculations using Microsoft Excel so that maximum precision can be obtained. (Unless indicated otherwise, enter your answers rounded to the nearest whole dollar/input code: 0). Investment Option "North" This potential investment is a little more risky and longer term, so it has a minimum rate of return of 16.20%. This investment would require an initial outlay of cash to purchase a piece of equipment for $114,500, and at the end of the 7-year life of this investment is expected to have a salvage value of $28,625. For each year of this investment, net annual cash inflows are expected to be $27,750. 1. How much is the present value of the purchase of equipment? 2. How much is the present value of the salvage value? 3. How much is the present value of the annual cash inflows? 4. How much is the Net Present Value? 5. What is the value of the Present Value Index? (round to the nearest thousandths place/input code: 0.000) $ -114500 $10004 $9699 $ 19703 0.172
Investment Option "South"
This potential investment is less risky and shorter term, so it has a minimum rate of
return of 8.90%. This investment would require an initial outlay of cash of $152,000,
and at the end of the 5-year life of this investment UGE Corporation is expected to
have to pay a wind-down cost of $7,600. For the first 4 years of this investment, net
annual cash inflows are expected to be $40,250 and for the last year of the
investment, the net annual cash inflow is expected to be $100,625.
6. How much is the
present value of the
purchase of equipment?
7. How much is the
present value of the
wind-down cost?
8. How much is the
present value of the
annual cash inflows for
the first 4 years?
9. How much is the
present value of the
annual cash inflow for the
final year of this
investment?
10. How much is the Net
Present Value?
11. What is the Internal
Rate of Return? (round to
the nearest hundredths
place/input code: 0.00)
Show Transcribed Text
$-152000
3)111,413
4) 6,920
5) 1.060
6)-152,000
7) -4,962
8) 130,685
9) 65,700
10) 39,423
11) 17.21
$315
$
$
$
These are the correct answers but do not know the steps
1)-114,500
2) 10,007
%
Transcribed Image Text:Investment Option "South" This potential investment is less risky and shorter term, so it has a minimum rate of return of 8.90%. This investment would require an initial outlay of cash of $152,000, and at the end of the 5-year life of this investment UGE Corporation is expected to have to pay a wind-down cost of $7,600. For the first 4 years of this investment, net annual cash inflows are expected to be $40,250 and for the last year of the investment, the net annual cash inflow is expected to be $100,625. 6. How much is the present value of the purchase of equipment? 7. How much is the present value of the wind-down cost? 8. How much is the present value of the annual cash inflows for the first 4 years? 9. How much is the present value of the annual cash inflow for the final year of this investment? 10. How much is the Net Present Value? 11. What is the Internal Rate of Return? (round to the nearest hundredths place/input code: 0.00) Show Transcribed Text $-152000 3)111,413 4) 6,920 5) 1.060 6)-152,000 7) -4,962 8) 130,685 9) 65,700 10) 39,423 11) 17.21 $315 $ $ $ These are the correct answers but do not know the steps 1)-114,500 2) 10,007 %
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT