Company LDC is contemplating on acquiring new machine replace the old one. Year O is when...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Company LDC is contemplating on acquiring new machine replace the old one. Year O is when the new machine will be acquired and the old one disposed. This new machine will operate for 4 years. As the CPA-CMA (istikoy) of the company you are asked by the management for advise on whether to go on with the proposed acquisition. The data attached were given to you for your consideration. You must support your recommendations with appropriate calculations of the Initial Investment Cost (itemized), Present Value of Cash Flows (itemized yearly), Net Present Value, Internal Rate of Return, and Profitability Index. Your recommendation and supporting calculations must be in excel format. Other than the IRR, you are not allowed to use "EXCEL FUNCTION". You may use however excel functions to validate your answer. Caution: Do not forget the tax effect on the transactions. Old Machine New Machine Acquisition Cost Accumulated Dep'n Disposal Price - Old Machine at year 0 Remaining Life - years Sales Commission to agent for disposal of old machine 320,000.00 480,000.00 192,000.00 80,000.00 100,000.00 4 4 10% Asset Removal Cost 2,000.00 95,000.00 Tax Rate 40% 40% Revenue per annum 400,000.00 1,400,000.00 Cash Opex per annum WC to recover at end of life 320,000.00 1,000,000.00 50,000.00 200,000.00 Sales value net of commission at end of life (pretax) 1,500.00 wC Commitment for new machine One-time employee training - year 1 pretax 200,000.00 50,000.00 WACC 10% Employee relocation cost at end of year 4 (pretax) 150,000.00 Company LDC is contemplating on acquiring new machine replace the old one. Year O is when the new machine will be acquired and the old one disposed. This new machine will operate for 4 years. As the CPA-CMA (istikoy) of the company you are asked by the management for advise on whether to go on with the proposed acquisition. The data attached were given to you for your consideration. You must support your recommendations with appropriate calculations of the Initial Investment Cost (itemized), Present Value of Cash Flows (itemized yearly), Net Present Value, Internal Rate of Return, and Profitability Index. Your recommendation and supporting calculations must be in excel format. Other than the IRR, you are not allowed to use "EXCEL FUNCTION". You may use however excel functions to validate your answer. Caution: Do not forget the tax effect on the transactions. Old Machine New Machine Acquisition Cost Accumulated Dep'n Disposal Price - Old Machine at year 0 Remaining Life - years Sales Commission to agent for disposal of old machine 320,000.00 480,000.00 192,000.00 80,000.00 100,000.00 4 4 10% Asset Removal Cost 2,000.00 95,000.00 Tax Rate 40% 40% Revenue per annum 400,000.00 1,400,000.00 Cash Opex per annum WC to recover at end of life 320,000.00 1,000,000.00 50,000.00 200,000.00 Sales value net of commission at end of life (pretax) 1,500.00 wC Commitment for new machine One-time employee training - year 1 pretax 200,000.00 50,000.00 WACC 10% Employee relocation cost at end of year 4 (pretax) 150,000.00
Expert Answer:
Answer rating: 100% (QA)
Answer Solution Initial Cashflows Particulars Amount Acqusition cost of new machine 480000 Disposal ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
You are asked by a client to outline the procedures you would recommend for handling of unclaimed wages. What procedures do you recommend?
-
You are asked by the owner of a medium sized firm manufacturing digital alarm clocks. He thinks there is a market for his product in the BRIC countries. How would you advise him on what to look for...
-
Mega Coal ple has bought land that contains deposits of coal that will be mined. The land is expected to produce coal for five years and then the land will be sold. The initial costs involved in...
-
Dominic and Magalie have been married for five years and have thes children, aged four, seven and nine. Dominic and Magale are diverong and Magalie has been ordered to pay child support, until the...
-
Explain why some corporate executives may perceive that their independent auditors are a necessary evil. How can auditors combat or change that attitude?
-
Bishop has a capital balance of $120,000 in a local partnership, and Cotton has a $90,000 balance. These two partners share profits and losses by a ratio of 60 percent to Bishop and 40 percent to...
-
Which data entry application control would detect and prevent entry of alpha betic characters as the price of an item in the inventory master file? a. field check c. completeness check b. limit check...
-
BlueBolt Bottlers has a bottle-filling process with a mean value of 64 ounces and a standard deviation of 8 ounces. Suppose that the upper and lower tolerance limits are 71 and 57 ounces,...
-
What is the slope of the tangent line to the curve 12-212-6-2xy at the point (2, 3)? A. 0 B. 4 4P C. 1 D. E. 1/3 6715
-
Shah Entertainment Center borrowed money by issuing $6,000,000 of 4% bonds payable at 97.5. Interest is paid semiannually. Requirements 1. How much cash did Shah Entertainment Center receive when it...
-
A solid, uniform disk of radius 0.400 m and mass 65.0 kg rolls down a ramp of length 7.50 m that makes an angle of 14.5 with the horizontal. The disk starts from rest from the top of the ramp....
-
Shylo Tusk has just bought a majority of the shares in Elektriko Ltd - an ASX-listed public company involved in manufacturing e-scooters. He is now a shareholder with 15 million ordinary shares....
-
Explain the strategies and algorithms used by the kernel for memory management, including virtual memory allocation and paging. How does the kernel ensure efficient memory utilization and minimize...
-
Discuss the process of kernel configuration and customization to tailor the operating system to specific hardware requirements and use cases. What considerations should be taken into account when...
-
A snickers candy bar contains 28g of sugar. Calculate the totalATP yield if you assume all sugar is glucose and all of it wasmetabolized through glycolysis.
-
What are the general rules for deciding which method is used to account for an investment in the stock of another company? What are bonds? What are the characteristics of bonds? What factors affect...
-
Which one of the following correctly represents a firm's after-tax cost of debt? a.yield to maturity x (1 - tax rate) b.current yield x (1 - tax rate) c.current yield x tax rate d.coupon rate x (1 -...
-
1. As a general strategy, would you recommend that Carl take an aggressive approach to capacity expansion or more of a wait-and-see approach? 2. Should Carl go with the option for one facility that...
-
A business can be valued by capitalizing its earnings stream. How might you use the same idea to value securities, especially the stock of large publicly held companies? Is there a way to calculate a...
-
Calculate an IRR for the project in the previous problem using an iterative technique.
-
Define and discuss (words only, no equations) the concepts of expected return and required return.
-
Fashion Fabrics sells sewing and craft materials to specialty retail and department stores. For the year, the company's New York Division had the following performance targets: Actual information...
-
Assume that management at Subway has decided to implement a balanced scorecard for the organization. Visit the company's site map at http://www.subway.com/subway root/sitemap.aspx. Using the...
-
Go to http://www.carbonfootprint.com/calculator.aspx to compute your approximate carbon footprint. What goals and measurements would you put on a balanced scorecard to reduce the size of that...
Study smarter with the SolutionInn App