Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

round all answers to nearest whole dollar TWB Corporation is considering two possible investments and needs your help in determining which will be the better

image text in transcribedimage text in transcribed

round all answers to nearest whole dollar

TWB 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). CS Investment Option "North" This potential investment is a little more risky and longer term, so it has a minimum rate of return of 13.20%. This investment would require an initial outlay of cash to purchase a piece of equipment for $144,500, and at the end of the 7-year life of this investment is expected to have a salvage value of $57,800. For each year of this investment, net annual cash inflows are expected to be $26,250. $ $ $ 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) $ Investment Option "South" This potential investment is less risky and shorter term, so it has a minimum rate of return of 5.90%. This investment would require an initial outlay of cash of $169,000, and at the end of the 5-year life of this investment TWB Corporation is expected to have to pay a wind-down cost of $8,450. For the first 4 years of this investment, net annual cash inflows are expected to be $44,750 and for the last year of the investment, the net annual cash inflow is expected to be $111,875. $ $ 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 nresent $ Investment Option "South" This potential investment is less risky and shorter term, so it has a minimum rate of return of 5.90%. This investment would require an initial outlay of cash of $169,000, and at the end of the 5-year life of this investment TWB Corporation is expected to have to pay a wind-down cost of $8,450. For the first 4 years of this investment, net annual cash inflows are expected to be $44,750 and for the last year of the investment, the net annual cash inflow is expected to be $111,875. $ $ 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) $ $ % Previous

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Principles

Authors: Jerry Weygandt, Paul Kimmel, Donald Kieso

11th Edition

111856667X, 978-1118566671

More Books

Students also viewed these Accounting questions

Question

=+What is the response variable?

Answered: 1 week ago