? 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...
-
a. Given the following diagram for a product, determine the quantity of each component required to assemble one unit of the finished product. b. Draw a tree diagram for a stapler given the following...
-
What two methods may a company use to allocate a premium or discount over the life of a bond issue? Briefly describe each method.
-
The following data were taken from the financial statements of The Amphlett Corporation, which is all equity financed. Required: 1. Calculate the following ratios for 2016 and 2017: a. Return on...
-
Temco Industries has developed a forecasting model that was used to forecast during a ten-month period. The forecasts and actual demand are shown as follows: Measure the accuracy of the forecast...
-
Determine the missing amount for each separate situation involving manufacturing cost flows. (2) Direct materials used $ 151,880 $ 35,290 Direct labor used 76,400 47,120 Factory overhead 123,400...
-
Match the marketing data to the marketing mix component (product, price, place, or promotion) that it would be most helpful for analyzing. Marketing Data Competitor price Order fulfillment time...
-
If one of your herds that you visit is averaging 82/lb/day of milk, the farmer is receiving $21.50/cwt for the milk, the cows are eating an average of 52 lb/day of DM that cost $0.1250/lb, calculate...
-
How do advanced techniques in artificial intelligence and machine learning contribute to process modeling, and what are the potential benefits and risks of incorporating AI-based approaches in...
-
Provide comprehensive information, and examples if applicable to support your answer. In what ways do goals and objectives help managers control the organization?
-
Complete the following Statement of EU FIFO methods Farmers Ltd operates a process costing system. Details of process 1 are as follows: All materials used are added at the beginning of the process....
-
A harmonic travelling wave has the equation: y ( x , t ) = 0 . 0 1 cos ( 1 . 2 x - 1 1 . 5 t ) Where x and y are measured in m and t is measured in s . What is the wavelength of this wave? Your...
-
Construct the probability distribution and calculate the expected value for the given scenario. Show all of your work and round your answers to the nearest hundredth, if needed. Then summarize your...
-
A fitness center is interested in the mean amount of time a client exercises in the center each week, so they send out a survey to 100 randomly selected clients. a. the mean amount of time for all...
-
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...
-
Distinguish between traceable expenses and common expenses. Which are more likely to be controllable at the department level?
-
What is meant by departmental contribution to common expenses? What advantages does this measure have over net income in measuring departmental performance?
-
The higher the management level receiving reports, the more detailed the reports should be. Comment.
Study smarter with the SolutionInn App