Question

In: Operations Management

1)Swift Oil Company is considering investing in a new oil well. It is expected that the...

1)Swift Oil Company is considering investing in a new oil well. It is expected that the oil well will increase annual revenues by $132,000 and will increase annual expenses by $81,000 including depreciation. The oil well will cost $474,000 and will have a $11,000 salvage value at the end of its 10-year useful life. Calculate the annual rate of return. (Round answer to 2 decimal places, e.g. 12.47.)

2)Caine Bottling Corporation is considering the purchase of a new bottling machine. The machine would cost $187,663 and has an estimated useful life of 8 years with zero salvage value. Management estimates that the new bottling machine will provide net annual cash flows of $33,000. Management also believes that the new bottling machine will save the company money because it is expected to be more reliable than other machines, and thus will reduce downtime. Assume a discount rate of 10%. Click here to view PV table.

-Net present value $ ___

-How much would the reduction in downtime have to be worth in order for the project to be acceptable? (Round answer to 0 decimal places, e.g. 125.)

3)McKnight Company is considering two different, mutually exclusive capital expenditure proposals. Project A will cost $506,194, has an expected useful life of 12 years, a salvage value of zero, and is expected to increase net annual cash flows by $69,900. Project B will cost $314,010, has an expected useful life of 12 years, a salvage value of zero, and is expected to increase net annual cash flows by $45,200. A discount rate of 7% is appropriate for both projects. Click here to view PV table.

Net present value - Project A $ __

Profitability Index - Project A $ ___

Net present value - Project B $ __

Profitability Index - Project B $ __

4)

Hillsong Inc. manufactures snowsuits. Hillsong is considering purchasing a new sewing machine at a cost of $2.45 million. Its existing machine was purchased five years ago at a price of $1.8 million; six months ago, Hillsong spent $55,000 to keep it operational. The existing sewing machine can be sold today for $245,788. The new sewing machine would require a one-time, $85,000 training cost. Operating costs would decrease by the following amounts for years 1 to 7:

Year 1 $389,300
2 399,900
3 410,000
4 425,500
5 432,400
6 434,500
7 438,000

The new sewing machine would be depreciated according to the declining-balance method at a rate of 20%. The salvage value is expected to be $379,400. This new equipment would require maintenance costs of $98,800 at the end of the fifth year. The cost of capital is 9%.

Net present value $ ___

5) Bruno Corporation is involved in the business of injection molding of plastics. It is considering the purchase of a new computer-aided design and manufacturing machine for $437,200. The company believes that with this new machine it will improve productivity and increase quality, resulting in an increase in net annual cash flows of $106,338 for the next 6 years. Management requires a 10% rate of return on all new investments.

Internal rate of return ___%

Solutions

Expert Solution

(there are five questions in this post. Only one question is allowed in single post. So the first question is being solved below)

1) Annual rate of return (IRR) is the interest rate at which Net Present Value (NPV) of the project is zero. So we equate the NPV to zero using Goal seek function in Excel to determine the IRR. The spreadsheet model is following

Formulas:

F2 =SUM(B2:E2)   copy to F2:F12

G2 =F2/(1+$G$17)^A2 copy to G2:G12

G14 =SUM(G2:G12)

Annual rate of return (IRR) = 1.73 %


Related Solutions

You are investigating the possibility of investing in a productive oil well that is expected to...
You are investigating the possibility of investing in a productive oil well that is expected to produce 2,500 barrels of oil per year for 5 years. The current price of oil is $70 per barrel, but the price is expected to increase at a constant rate of 3 percent per year for the next 5 years. If your opportunity cost of funds is 13.50 percent p.a., what would be the upper limit of how much you would be willing to...
Campbell Company is considering investing in two new vans that are expected to generate combined cash...
Campbell Company is considering investing in two new vans that are expected to generate combined cash inflows of $30,000 per year. The vans’ combined purchase price is $94,500. The expected life and salvage value of each are four years and $20,900, respectively. Campbell has an average cost of capital of 12 percent. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.) Required Calculate the net present value of the investment opportunity.
Jordan Company is considering investing in two new vans that are expected to generate combined cash...
Jordan Company is considering investing in two new vans that are expected to generate combined cash inflows of $30,500 per year. The vans’ combined purchase price is $96,000. The expected life and salvage value of each are five years and $20,500, respectively. Jordan has an average cost of capital of 16 percent. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.) Required Calculate the net present value of the investment opportunity. (Negative amount should be...
considering investing in a new piece of equipment that is expected to generate $30,000 of revenue...
considering investing in a new piece of equipment that is expected to generate $30,000 of revenue the first year, increasing 15% per year for the 9 year useful life. The salvage value is expected to be 20% of the initial investment. Using a MARR of 10% and an equivalent worth method, determine the maximum your company should pay for the equipment in order for this to be a satisfactory investment.
Your firm is considering investing $30 million to develop a new product. It is expected that...
Your firm is considering investing $30 million to develop a new product. It is expected that it will take 18 months to develop the product. If the firm decides to take the product to market it will cost $300 million and six months to build production and distribution facilities. The expected incremental after-tax inflows from this new product will be $10 million in year 1 of operations and is expected to grow by 3%/year in perpetuity. If the discount rate...
Good Time Corparation is considering investing in a new engine is expected to increase the production...
Good Time Corparation is considering investing in a new engine is expected to increase the production produced. Price of the machine to be purchased $ 1,000,000 with an economic life of 5 years. The machine is depressed by the straight line method. The machine is expected to produce 30,000 units of product every year at a price of $ 60 in the first year and due to price increases are expected to rise by 5% every year. Unit production costs...
QUESTION 1 ABC Inc, a publishing company is considering investing in a new press. For the...
QUESTION 1 ABC Inc, a publishing company is considering investing in a new press. For the purpose of your valuation, limit the project’s life to 5 years. The press will cost $1’000’000, will required additional $20’000 in installation fees to bring it to working condition, will have a useful life of 5 years, salvage value of $100’000, will be depreciated on straight-line basis and sold at the end of project’s life for an estimated value of $300’000. The press will...
1. Zeebo company is considering investing $425,000 for new equipment. The new equipment is much more...
1. Zeebo company is considering investing $425,000 for new equipment. The new equipment is much more efficient than the current machine Zeebo is using. The machine will save $105,000/year in labor and other costs but will require annual maintenance costs of $13,000/year. The machine is expected to last 6 years and will have no salvage value. Estimate the project's Internal Rate of Return and Payback Period.
"An oil and gas company is considering whether to begin drilling a new oil field. The...
"An oil and gas company is considering whether to begin drilling a new oil field. The company will need to pay $4.6 million as an initial investment in order to extract the oil. The company will operate the field for a total of 5 years, during which its annual profit will be $3,344,000. During the 6th year, the company will not operate or gain any revenue from the oil field, but it will need to pay $8,990,000 in environmental remediation...
A company is considering drilling four oil wells. The probability of success for each well is...
A company is considering drilling four oil wells. The probability of success for each well is 0.40, independent of the results for any other well. The cost of each well is $200,000. Each well that is successful will be worth $600,000. a) What is the probability that one or more wells will be successful? b) What is the expected number of successes? c) What is the expected gain? d) What will be the gain if only one well is successful?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT