Question

In: Accounting

12) Lockwood Company would like to purchase a production machine for $100,000. It is likely to...

12) Lockwood Company would like to purchase a production machine for $100,000. It is likely to bring in after-tax cash inflows of $40,000 in year 1, $45,000 in year 2, $50,000 in year 3, and $35,000 in year 4. HINT: USE EXCEL function A) Calculate the Internal Rate of Return (IRR) of the production machine when the discount rate (hurdle rate) is 8%. B) Should the company accept this proposal?

Solutions

Expert Solution

Year Cash Flow
0 -100000
1 40000
2 45000
3 50000
4 35000
Use Excel Function , 25.41%

IRR= 25.41%

Yes Company should acept the proposal because IRR is greater than Cost of Capital


Related Solutions

Wood Products Company would like to purchase a computerized wood lathe for $100,000. The machine is...
Wood Products Company would like to purchase a computerized wood lathe for $100,000. The machine is expected to have a life of 5 years, and a salvage value of $5,000. Annual maintenance costs will total $20,000. Annual cash receipts resulting from this machine are predicted to be $45,000. The company’s required rate of return is 15 percent. Use Excel to calculate the net present value. (7.2) Use Excel to calculate the internal rate of return. (7.3) Based on your answer...
QUESTION 11 The management of Consumers Mfg. would like to purchase a specialized production machine for...
QUESTION 11 The management of Consumers Mfg. would like to purchase a specialized production machine for $95,000. The machine is expected to last three years, with a salvage value of $5,000. Annual maintenance costs will total $12,000, and annual labor and material savings are predicted to be $55,000. The company's required rate of return in 15%. Find the NPV of this investment. $5,623 $2,811 $6,466 $1,406 QUESTION 12 The Montana Consulting is evaluating the profitability of their two clients, X...
Ponpon produces cans of jelly. The company would like to purchase a canning machine. The machine...
Ponpon produces cans of jelly. The company would like to purchase a canning machine. The machine costs $25,000 and the company needs a loan to make the purchase. Before agreeing to the loan, their bank requires Ponpon to provide both current (2020) and budgeted (3 months in 2021) financial statements. Use the following information from Ponpon to provide the bankers with the 2021 budgeted financial states. Balance Sheet Cash                                        $50,000    Accounts Receivable               $31,000    Inventory                                $12,000 Fixed Assets                            $37,000 Total Assets                            $130,000 Accounts Payable                   $22,500...
Ponpon produces cans of jelly. The company would like to purchase a canning machine. The machine...
Ponpon produces cans of jelly. The company would like to purchase a canning machine. The machine costs $25,000 and the company needs a loan to make the purchase. Before agreeing to the loan, their bank requires Ponpon to provide both current (2020) and budgeted (3 months in 2021) financial statements. Use the following information from Ponpon to provide the bankers with the 2021 budgeted financial states. Balance Sheet Cash                                        $50,000    Accounts Receivable               $31,000    Inventory                                $12,000 Fixed Assets                            $37,000 Total Assets                            $130,000 Accounts Payable                   $22,500...
Ponpon produces cans of jelly. The company would like to purchase a canning machine. The machine...
Ponpon produces cans of jelly. The company would like to purchase a canning machine. The machine costs $25,000 and the company needs a loan to make the purchase. Before agreeing to the loan, their bank requires Ponpon to provide both current (2020) and budgeted (3 months in 2021) financial statements. Use the following information from Ponpon to provide the bankers with the 2021 budgeted financial states. Balance Sheet Cash                                        $50,000    Accounts Receivable               $31,000    Inventory                                $12,000 Fixed Assets                            $37,000 Total Assets                            $130,000 Accounts Payable                   $22,500...
Weir Inc. is considering to purchase of new production machine for $100,000. although the purchase of...
Weir Inc. is considering to purchase of new production machine for $100,000. although the purchase of this machine will not produce ny increase in sales revenues , it will result in a reduction of labor costs by $31,000 per year. the shipping cost is is $7,000. in addition it would cost $3,000 to install this machine properly. also because this machine is extremely efficient its purchase would necessitate an increase in inventory of $25,000. this machine has an expected life...
Marion Dexter Company is evaluating a proposal to purchase a new machine that would cost $100,000...
Marion Dexter Company is evaluating a proposal to purchase a new machine that would cost $100,000 and have a salvage value of $10,000 in four years. It would provide annual operating cash savings of $10,000, as follows: Old Machine      New Machine Salaries $ 40,000              $ 36,000 Supplies 7,000                   5,000 Maintenance 9,000                   5,000 Total $56,000              $46,000 ​ If the new machine is purchased, the old machine will be sold for its current salvage value of $20,000. If the new machine is...
Rump Industries is considering the purchase of a new production machine for $100,000. The introduction of...
Rump Industries is considering the purchase of a new production machine for $100,000. The introduction of the machine will result in an increase in earnings before interest and tax of $25,000 per year. Set-up of the machine will involve installation costs of $5,000 after-tax. Additionally, the machine will require workers to undergo training that will cost the company $5,000 after-tax. An initial increase in raw materials and inventory of $25,000 will also be required. The machine has an expected life...
G Wagon would like to purchase a printing machine for $300,000. The machine is expected to...
G Wagon would like to purchase a printing machine for $300,000. The machine is expected to have a life of three years and a salvage value of $30,000. Annual maintenance costs will total $96,000. Annual cash savings are predicted to be $125,000. G Wagon required rate of return is 12%.   Now, use Excel to compute the internal rate of return (IRR) of this capital opportunity. Again, press Ctrl + `. Copy your work in this form from Excel into the...
Brock and Company would like to purchase equipment for its increased demand for production. The business...
Brock and Company would like to purchase equipment for its increased demand for production. The business plans to purchase equipment with a cost of $50,000. The estimated cash inflow for each year is $11,000. The equipment has a useful life of seven years.   What is the payback period? Question 14 options: 4.5 years 7 years 6.5 years 3.5 years
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT