Galt Motors currently produces 50,000 electric motors a year and expects output levels to remain steady...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Galt Motors currently produces 50,000 electric motors a year and expects output levels to remain steady in the future. It buys armatures from an outside supplier at a price of $2.00 each. The plant manager believes that it would be cheaper to make these armatures rather than buy them. Direct in-house production costs are estimated to be only $1.50 per armature. The necessary machinery would cost $400,000 and would be obsolete in 10 years. This investment would be depreciated to zero for tax purposes using a 10-year straight line depreciation. The plant manager estimates that the operation would require an upfront one-off cost of $100,000 to re-organize the factory. An additional payable at 20% of cost per unit is required one year before the production. The company also needs to maintain 2 months of inventory (as raw materials, as a percentage of production cost) one year before the production. All working capital will be recoverable at the end of the ten years. The expected proceeds from scrapping the machinery after 10 years are estimated to be $10,000. Galt Motors pays tax at a rate of 30% and has an opportunity cost of capital of 10%. What is the net present value (NPV) of the decision to produce the armatures in-house instead of purchasing them from the supplier? Hint: it is easier to find answers to these questions using an Excel spreadsheet, even you do not need to submit the spreadsheet. Refer to the figure below for a suggested layout for your FCF projection (it only shows the first three years of the projection; you need to build a projection of the Free Cash Flows from year 0 to year 10, for the two alternatives respectively). (1) CFO EBIT EBIT (1-t) Add back D&A CFO (2) CAPEX (3) Increase in OWC OCA OCL OWC (4) After-tax cash flow from asset Increase in OWC sales FCF = (1)-(2)-(3)+ (4) Discount factor PV NPV Year 0 Year 1 Year 2 Required: Complete all questions below by filling in your answers or choosing the correct answer. Note: Please provide your answer to the nearest integer with no comma or $ sign e.g. if the answer is $1,234,567.08, type in 1234567; if the answer is - $1,234,567.08, type in -1234567 (a) The annual FCF in years 1 to 10 of buying the armatures is $ (b) The NPV of buying the armatures from the FCF is $ (c) The initial FCF of producing the armatures (in year zero) is $ (d) The annual FCF in years 1 to 9 of producing the armatures is $ (e) The FCF in year 10 of producing the armatures is $ (f) The NPV of producing the armatures from the FCF is $ (g) The NPV of making the armatures in-house instead of purchasing them from the supplier is $ (h) Galt Motors should therefor Select alternative produce armatures in-house s this gives higher NPV. purchase armatures from the supplier Galt Motors currently produces 50,000 electric motors a year and expects output levels to remain steady in the future. It buys armatures from an outside supplier at a price of $2.00 each. The plant manager believes that it would be cheaper to make these armatures rather than buy them. Direct in-house production costs are estimated to be only $1.50 per armature. The necessary machinery would cost $400,000 and would be obsolete in 10 years. This investment would be depreciated to zero for tax purposes using a 10-year straight line depreciation. The plant manager estimates that the operation would require an upfront one-off cost of $100,000 to re-organize the factory. An additional payable at 20% of cost per unit is required one year before the production. The company also needs to maintain 2 months of inventory (as raw materials, as a percentage of production cost) one year before the production. All working capital will be recoverable at the end of the ten years. The expected proceeds from scrapping the machinery after 10 years are estimated to be $10,000. Galt Motors pays tax at a rate of 30% and has an opportunity cost of capital of 10%. What is the net present value (NPV) of the decision to produce the armatures in-house instead of purchasing them from the supplier? Hint: it is easier to find answers to these questions using an Excel spreadsheet, even you do not need to submit the spreadsheet. Refer to the figure below for a suggested layout for your FCF projection (it only shows the first three years of the projection; you need to build a projection of the Free Cash Flows from year 0 to year 10, for the two alternatives respectively). (1) CFO EBIT EBIT (1-t) Add back D&A CFO (2) CAPEX (3) Increase in OWC OCA OCL OWC (4) After-tax cash flow from asset Increase in OWC sales FCF = (1)-(2)-(3)+ (4) Discount factor PV NPV Year 0 Year 1 Year 2 Required: Complete all questions below by filling in your answers or choosing the correct answer. Note: Please provide your answer to the nearest integer with no comma or $ sign e.g. if the answer is $1,234,567.08, type in 1234567; if the answer is - $1,234,567.08, type in -1234567 (a) The annual FCF in years 1 to 10 of buying the armatures is $ (b) The NPV of buying the armatures from the FCF is $ (c) The initial FCF of producing the armatures (in year zero) is $ (d) The annual FCF in years 1 to 9 of producing the armatures is $ (e) The FCF in year 10 of producing the armatures is $ (f) The NPV of producing the armatures from the FCF is $ (g) The NPV of making the armatures in-house instead of purchasing them from the supplier is $ (h) Galt Motors should therefor Select alternative produce armatures in-house s this gives higher NPV. purchase armatures from the supplier
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
A bicycle manufacturer currently produces 300,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $2 a chain. The plant...
-
A bicycle manufacturer currently produces 310,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $2.10 a chain. The plant...
-
Currently the rate of return of the risk-free government bond is 3% while the expected rate of return on the market is 11%. Using CAPM, calculate the rate of return required for A plc who has a beta...
-
Explain how T cells recognize an antigen. What are the types of T cells, and how do they function in immunity?
-
The current asset section of the 2017 and 2016 fiscal year end balance sheets of The Kroger Co. are presented in the accompanying table: In addition, Kroger provides the following footnote describing...
-
Reconsider Parts (a) through (f) of Problem 2. For each "true" statement, develop a mathematical proof based on the time value of money factor equations from Table 2.6 in Chapter 2. Data from problem...
-
Operating profits and losses for the seven industry segments of Foley Corporation are: Penley $ 90 Cheng $ (20) Konami (40) Takuhi 34 KSC 25 Molina 150 Red Moon 50 Based only on the operating profit...
-
Can you explain why we neglect the gravitational force between most objects unless at least one of them has an enormous mass (Earth, moon, Sun)
-
What are multiple ways a company can hold a competitive advantage over another?
-
Q2. A dielectric sphere is carrying surface charge density as shown. a. Determine the electric field intensity in all space (Hint: use Gauss's Law). b. Determine the electric potential in all space....
-
In a Cartesian coordinate system, the charge q = -1.20 x 104 C is at the origin, the charge q = 1.80 x 10- C has coordinates x = 7.50 m, y =0.00, and the charge q3 = -2.80 x 10-4 C has coordinates x...
-
3. Find the complete state diagram of the following A Circuit. Show Work in detail clock AB D agree! FF AC 4. Implement the state diagram shown, using three FFS W, X, Y (W is MSB) Where Wis JKFF, x...
-
Use Pollard-rho algorithm to find the factorization of the following numbers a) 7429 b) 262063
-
QUESTION 4 Match the following terms with the correct definition. A situation in which there are too many free radicals and not enough antioxidants, leading to damage to important molecules. A...
-
A hydroponic garden uses the 10 m long perforated pipe system shown below to deliver water at 20 degrees Celsius. The pipe is 5 cm in diameter and contains a circular hole every 20 cm. A pump...
-
Wilsons Auto Repair ended 2011 with Accounts Receivable of $85,000 and a credit balance in Allowance for Uncollectible Accounts balance of $11,000. During 2012, Wilsons Auto Repair had the following...
-
In September 2008, the IRS changed tax laws to allow banks to utilize the tax loss carryforwards of banks they acquire to shield their future income from taxes (prior law restricted the ability of...
-
You own a copper mine. The price of copper is currently $1.50 per pound. The mine produces 1 million pounds of copper per year and costs $2 million per year to operate. It has enough copper to...
-
Under the assumptions that Idekos market share will increase by 0.5% per year (implying that the investment, financing, and depreciation will be adjusted as described in Problems 3 and 4) and that...
-
Why is it important to synchronize data and process models?
-
Create the use-case descriptions and diagram(s) for the system in problems 1 and 2. Be sure to create your use cases so that they are complete and clear. Remember, in real life, the system...
-
Conduct a technical feasibility study. What would you recommend the company use in the creation and maintenance of their site (e.g. languages, speciific host, encryption)? Why does your choice affect...
Study smarter with the SolutionInn App