DO IT IN EXCEL, AND SHOW THE FORMULAS If the company purchases the machine, its cost of $276,000 will be financed with a loan at 14.8% interest for three years requiring equal annual payments including principal and interest. The machine will be depreciated at 20% per year. The company will pay $8,000 per year for maintenance services. The company plans to keep the machine even after its payback period. What is the total amount paid? A) $236,337.96 B) $304,972.67 C) None of the above D) $361,442.71 (Choose one option)

DO IT IN EXCEL, AND SHOW THE FORMULAS If the company purchases the machine, its cost of $276,000 will be financed with a loan at 14.8% interest for three years requiring equal annual payments including principal and interest. The machine will be depreciated at 20% per year. The company will pay $8,000 per year for maintenance services. The company plans to keep the machine even after its payback period. What is the total amount paid? A) $236,337.96 B) $304,972.67 C) None of the above D) $361,442.71 (Choose one option)

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 5PA: Falkland, Inc., is considering the purchase of a patent that has a cost of $50,000 and an estimated...

See similar textbooks

Similar questions

Caduceus Company is considering the purchase of a new piece of factory equipment that will cost $565,000 and will generate $135,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return In Excel, see Appendix C.
Falkland, Inc., is considering the purchase of a patent that has a cost of $50,000 and an estimated revenue producing life of 4 years. Falkland has a cost of capital of 8%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?
Gina Ripley, president of Dearing Company, is considering the purchase of a computer-aided manufacturing system. The annual net cash benefits and savings associated with the system are described as follows: The system will cost 9,000,000 and last 10 years. The companys cost of capital is 12 percent. Required: 1. Calculate the payback period for the system. Assume that the company has a policy of only accepting projects with a payback of five years or less. Would the system be acquired? 2. Calculate the NPV and IRR for the project. Should the system be purchasedeven if it does not meet the payback criterion? 3. The project manager reviewed the projected cash flows and pointed out that two items had been missed. First, the system would have a salvage value, net of any tax effects, of 1,000,000 at the end of 10 years. Second, the increased quality and delivery performance would allow the company to increase its market share by 20 percent. This would produce an additional annual net benefit of 300,000. Recalculate the payback period, NPV, and IRR given this new information. (For the IRR computation, initially ignore salvage value.) Does the decision change? Suppose that the salvage value is only half what is projected. Does this make a difference in the outcome? Does salvage value have any real bearing on the companys decision?
Mason, Inc., is considering the purchase of a patent that has a cost of $85000 and an estimated revenue producing lite of 4 years. Mason has a required rate of return that is 12% and a cost of capital of 11%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?
Each of the following scenarios is independent. All cash flows are after-tax cash flows. Required: 1. Patz Corporation is considering the purchase of a computer-aided manufacturing system. The cash benefits will be 800,000 per year. The system costs 4,000,000 and will last eight years. Compute the NPV assuming a discount rate of 10 percent. Should the company buy the new system? 2. Sterling Wetzel has just invested 270,000 in a restaurant specializing in German food. He expects to receive 43,470 per year for the next eight years. His cost of capital is 5.5 percent. Compute the internal rate of return. Did Sterling make a good decision?
2.-DO IT IN EXCEL, AND SHOW THE FORMULASIf the company purchases the machine, its cost of $276,000 will be financed with a loan at 14.8% interest for three years requiring equal annual payments including principal and interest. The machine will be depreciated at 20% per year. The company will pay $8,000 per year for maintenance services. The company plans to keep the machine even after its payback period.What is the amount of the annual payment? A) $120,480.90 B) $85,442.71 C) $276,000.00 D) $361,442.71
2.-DO IT IN EXCEL, AND SHOW THE FORMULASIf the company purchases the machine, its cost of $276,000 will be financed with a loan at 14.8% interest for three years requiring equal annual payments including principal and interest. The machine will be depreciated at 20% per year. The company will pay $8,000 per year for maintenance services. The company plans to keep the machine even after its payback period.What is the amount of the annual payment? A) $120,480.90 B) $85,442.71 C) $276,000.00 D) $361,442.71 (Choose one option)
4.-DO IT IN EXCEL, AND SHOW THE FORMULASIf the company purchases the machine, its cost of $276,000 will be financed with a loan at 14.8% interest for three years requiring equal annual payments including principal and interest. The machine will be depreciated at 20% per year. The company will pay $8,000 per year for maintenance services. The company plans to keep the machine even after its payback period. What is the total amount paid? A) $236,337.96 B) $304,972.67 C) None of the above D) $361,442.71
1.-DO IT IN EXCEL, AND SHOW THE FORMULAS If the company purchases factory equipment, its $719,000 cost will be financed with a five-year 18.4% interest loan that requires equal annual payments including principal and interest. The bank charges a 0.75% commission. The equipment will be depreciated with a useful life of 5 years. The company will pay $12,000 per year for maintenance services. The company plans to keep the machine even after its recovery period.What is the total amount paid to the bank? A) 1'160,034.00 B) None of the above C) 719,000.00 D) $938,672.81 (Choose one option)
XYZ Company is building an addition (building and machinery) to its manufacturing plant to increase its production capacity. The cost of the addition is $1,230,000. Its lender is willing to make a loan to the company at 70% loan to value, for 20 years, payments made monthly, and at an interest rate of 5% APR. a. How much of the total cost is CAPEX and how much of the total cost is OPEX? b. How much cash must the company have to make the down payment? c. What is the monthly payment?
3. Calculate the internal rate of return for a machine that costs $550,000 and provides annual revenue of $125,000 per year for 5 years. You can assume all revenue is received once a year at the end of the year. a. Compare the IRR to the interest rate on a loan to fund the machine cost at 5.3%. Based on this information should you take on a loan to purchase this machine. Justify your answer.
XYZ Company is building an addition (building and machinery) to its manufacturing plant to increase its production capacity. The cost of the addition is $1,230,000. Its lender is willing to make a loan to the company at 70% loan to value, for 20 years, payments made monthly, and at an interest rate of 5% APR. a. What is the total amount of monthly payments? b. What will be the total amount of interest paid on this loan? c. How much of the first monthly payment will be interest and how much of the last monthly payment will be interest?