Refer to the information in Exercise 26-12. Create an Excel spreadsheet to compute the internal rate of
Question:
Refer to the information in Exercise 26-12. Create an Excel spreadsheet to compute the internal rate of return for each of the projects.
Data From Exercise 26-12
Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company requires a 10% return from its investments. For each investment project, compute
(a) Net present value and
(b) Profitability index.
(c) If the company can only select one project, which should it choose on the basis of profitability index?
Pool Spa Initial investment.... $(160,000) $(105,000) Net cash flows: Year 1 40,000 32,000 Year 2 56,000 50,000 Year 3 80,295 66,000 Year 4 90,400 72,000 ..... Year 5 65,000 24,000
Step by Step Answer:
ANSWER a To calculate the net present value NPV and profitability index PI we need to first determin...View the full answer
Related Video
Internal rate of return is a method of calculating an investment’s rate of return. The term internal refers to the fact that the calculation excludes external factors, such as the risk-free rate, inflation, the cost of capital, or financial risk.
Students also viewed these Business questions
-
Compute the internal rate of return for each of the following projects, each of which requires an initial investment of $100,000 and provides the periodic cash flows indicated. a. $23,098 per period...
-
Refer to the information in Exercise 6-7. Ending inventory consists of 45 units from the March 14 purchase, 75 units from the July 30 purchase, and all 100 units from the October 26 purchase. Using...
-
Refer to the information in Exercise 17-16. Suppose Bio Doc determines standard costs of $6.60 per equivalent unit for direct materials and $10.40 per equivalent unit for conversion costs for both...
-
Consider the following grooves, each of width W, that have been machined from a solid block of material. (a) For each case obtain an expression for the view factor of the groove with respect to the...
-
A farmer runs a heat pump with a motor of 2 kW. It should keep a chicken hatchery at 30oC which loses energy at a rate of 0.5 kW per degree difference to the colder ambient. The heat pump has a...
-
Gold and other precious metals have traditionally been considered a hedge against inflation. If this is true, we would expect that a fund made up of precious metals (gold, silver, platinum, and...
-
Karpman Company is a manufacturer of personal computers. Various costs and Classify various costs into expenses associated with its operations are as follows. 1.Property taxes on the factory...
-
Martell Mining Companys ore reserves are being depleted, so its sales are falling. Also, its pit is getting deeper each year, so its costs are rising. As a result, the companys earnings and dividends...
-
Write the statement in symbolic form and construct a truth table. School is not in session or the kids are home, and I am not reading. Let statement p be "School is in session." Let statement q be...
-
Find the Thevenin equivalent at terminals a-b of the circuit in Fig. 4.102. 10 20 40 V + 40
-
Perez Co. is considering an investment of $27,336 that provides net cash flows of $9,000 annually for four years. (a) What is the internal rate of return of this investment? (b) The hurdle rate is...
-
Refer to the information in Exercise 26-10. (a) Create an Excel spreadsheet to compute the internal rate of return for each of the projects. (b) Based on internal rate of return, determine whether...
-
A spaceship in distress sends out two escape pod in opposite direction. One travels at a speed v1 = -0.60c in one direction, and the other travels at a speed v2 = +0.70c in the other direction, as...
-
Three point charges, q1 = -4.20nC, q2 = 4.94nC and q3 = 2.85nC are aligned along the x axis as shown in the figure below. Assume that L1 = 0.529m and L2 = 0.825m. L2 sta. 92 Calculate the electric...
-
Trust is crucial to leading a group effectively. Discuss a time when a leader did not have the trust of the group you were in and how it affected the groups performance. Charismatic leadership is...
-
Write at least one paragraphs to discuss inventory management. In your discussion post, you will address the following: 1. What factors in real inventory control are not included in the economic...
-
Create a cover letter highlighting your strength, weakness, achievements and how you are working to manage your weakness?
-
1.) Discuss actions that you found through the reading and your research that managers can take to motivate their employees. 2.) Identify actions that managers can take to improve employee...
-
The trial balance as of July 31, 2018, for Sheila Sanchez, Registered Dietician, is presented below: Requirements 1. Prepare the income statement for the month ended July 31, 2018. 2. Prepare the...
-
Prove that the mean heat capacities C P H and C P S are inherently positive, whether T > T 0 or T < T 0 . Explain why they are well defined for T = T 0 .
-
Label each item a through h below as a feature of either a job order or process operation. a. Routine, repetitive procedures b. Custom orders c. Low production volume d. Heterogeneous products and...
-
Label each item a through h below as a feature of either a job order or process operation. a. Routine, repetitive procedures b. Custom orders c. Low production volume d. Heterogeneous products and...
-
Edison Company manufactures wool blankets and accounts for product costs using process costing. The following information is available regarding its May inventories. The following additional...
-
QUESTION 1 On Jan 1, 2019 Pip's Puppy Company acquires a 70% interest in Suzy's Suitcase company for $560,000 cash. The Parent uses the Cost Method. On that date Pip had the following balances:...
-
Miramar Industries manufactures two products: A and B. The manufacturing operation involves three overhead activities-production setup, material handling, and general factory activities. Miramar uses...
-
Stangol Company uses process costing to account for the production of highlighter pens. All direct materials are added at the beginning of the process, and conversion costs are incurred uniformly...
Study smarter with the SolutionInn App