Question

In: Accounting

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 space below:

What is the IRR that you calculated?

Solutions

Expert Solution

The required rate of return is 12% but the machine is generating negative retures. So the proposal should not be accepted .

If you are benefited from the solution then please LIKE , if disliked then please specify the reason.


Related Solutions

The management of Penfold Corporation is considering the purchase of a machine that would cost $300,000,...
The management of Penfold Corporation is considering the purchase of a machine that would cost $300,000, would last for 5 years, and would have no salvage value. The machine would reduce labor and other costs by $70,000 per year. The company requires a minimum pretax return of 12% on all investment projects. Click here to view Exhibit 13B-1 and Exhibit 13B-2 to determine the appropriate discount factor(s) using the tables provided. The net present value of the proposed project is...
Jack and Jill would like to purchase a house priced at $300,000 with a 30-year mortgage....
Jack and Jill would like to purchase a house priced at $300,000 with a 30-year mortgage. The bank requires they put a 20% downpayment on the mortgage. The rest of the amount will be provided to J&J by the bank as a loan with 4.25% interest compunded monthly. The initial plan of J&J is to pay off the mortgage on the house in 12x30 = 360 months with equal monthly payments. Calculate the equal end-of-month payments. What is the remaining...
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...
You are considering the purchase of a 3-D printing machine. This machine will have an estimated...
You are considering the purchase of a 3-D printing machine. This machine will have an estimated service life of 5 years with a salvage value of $12,000. Its annual net revenues are estimated to be $100,000. To get a 12% rate of return on investment, what is the maximum amount that you are willing to pay for the machine?
MARC Printing Ltd. is considering the purchase of a new copy machine. The machine will cost...
MARC Printing Ltd. is considering the purchase of a new copy machine. The machine will cost $90,000 plus $6,000 for shipping and $4,000 for installation. The machine’s useful life is four years and falls under the straight line depreciation (with no salvage value). Operating of this printing machine requires additional inventories of $32.000. On the other hand, $12.000 of the inventories will be on account and receivable of the project. Will be $5.000. MARC Ltd. forecasts that new machine will...
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?
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT