? TWB Corporation is considering two possible investments and needs your help in determining which will be
Fantastic news! We've Found the answer you've been seeking!
Question:
?
Transcribed Image Text:
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). 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? 24 5. What is the value of the Present Value Index? (round to the nearest thousandths place/input code: 0.000) Investment Option "South" %24 %24 %24 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). 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? 24 5. What is the value of the Present Value Index? (round to the nearest thousandths place/input code: 0.000) Investment Option "South" %24 %24 %24
Expert Answer:
Answer rating: 100% (QA)
Calculation of Cash flow for year 7 Net cash inflow for year 7 salvage value Calculation of Cash flow for year 7 26250 57800 Calculation of Cash flow ... View the full answer
Posted Date:
Students also viewed these economics questions
-
DOS 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...
-
Ray Summers Company operates at full capacity of 11,777 units per year. The company, however, is still unable to fully meet the demand for its product, estimated at 15,000 units annually. This level...
-
Youve just been hired onto ABC Company as the corporate controller. ABC Company is a manufacturing firm that specializes in making cedar roofing and siding shingles. The company currently has annual...
-
Use the data in the table to complete the following. (a) Make a scatterplot of the data. Estimate a value for b so that f(x) = 0.0002x b models the data. (b) Check the accuracy of f(x). (c) The moon...
-
What is the present value of a perpetuity of $4000 per year if the appropriate discount rate is 11%?
-
Timlin Associates is a recently formed law partnership. Ellery Hanley, the managing partner of Timlin Associates, has just finished a tense phone call with Martin Offiah, president of Widnes Coal....
-
In Problem 3.5 a regression model was developed for the gasoline mileage data using the regressor engine displacement \(x_{1}\) and number of carburetor barrels \(x_{6}\). Calculate the PRESS...
-
A rookie quarterback is negotiating his first NFL contract. His opportunity cost is 10%. He has been offered three possible 4-year contracts. Payments are guaranteed, and they would be made at the...
-
Given the importance of network security, describe the key features that a network security policy should include, as well as procedures that should be included. a)Given the importance of network...
-
1. 3. 5. 7. 9. 11. passive : change:: active: O movement O increase O flight stagnation convent: cloister :: eyrie: O hide nest O open show rotate: energy :: stop: O brake Ostart Orun push fumble:...
-
ABC Co. uses a perpetual inventory system and had the following inventory transactions for the month of June. June 1 On hand, 100 units at $9.00 each June 4 Purchased 350 units at $9.20 each June 5...
-
Explain why property investors are expected to sell in London and buy in New York and why a fall in the pound might make this predicted effect of Brexit less likely. Property investors are looking...
-
Why might the Bank of Canada decide to keep the overnight loans rate at 1 percent in 2018? In September 2015, the unemployment rate was 7.0 percent, the inflation rate was 0.1 percent, and the...
-
Trident Health System has been experiencing difficulties attracting and retaining registered nurses (RNs) at its central hospital. Based on data from follow-up surveys with former applicants and from...
-
What do Rolls-Royce, Walmart, Royal Dutch Shell, and SAP have in common? These companies and others have faced investigations of corruption and bribing government officials to facilitate winning...
-
Why might the Bank of Canada decide to lower the overnight loans rate in 2018? In September 2015, the unemployment rate was 7.0 percent, the inflation rate was 0.1 percent, and the overnight loans...
-
Romans had an extensive costume production industry. There were districts of craftsmen for shoe styles, jewelry, and other wearable items. Fabric weaving and production was done mostly by women...
-
1A. If the researcher is concerned about the number of variables, the nature of the analysis, and completion rates, then, he/she is at which stage of the sampling design process (Figure 11.1 in the...
-
Microchips, particularly those for power electronics, get hot. If they get too hot they cease to function. The need: a scheme for removing heat from power microchips. One such scheme is sketched in...
-
A cantilever beam has a length L=50 mm. It has a rectangular cross-section width b=5 mm and a thickness t=1 mm. It is made of an aluminium alloy. By how much will the end deflect under an end-load of...
-
The speed of sound in Pyrex (borosilicate) glass is 5610 m/s. Find the density of this glass from Appendix A and use it to estimate the modulus E of Pyrex.
Study smarter with the SolutionInn App