Orange Computers has transformed into one of the largest smartphone companies in the world. Based on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Orange Computers has transformed into one of the largest smartphone companies in the world. Based on recent changes to the federal tax code, building phones in the US has become more attractive. Orange wants to build a single factory in either Pennsylvania, Texas, or North Carolina. Each state is offering incentives to woo Orange. Pennsylvania and Texas have proposed building a new facility, while North Carolina is offering grants to help renovate a recently closed factory. Build a workbook to calculate the net present value and internal rate of return (rounded to two decimal places) for each location over ten years using the information provided. Determine where Orange should locate their factory and give a brief explanation of why. Below are the pieces of information necessary to calculate the net present value and internal rate of return: 1. The factories in Pennsylvania and Texas could produce and sell 20 million phones annually, while the North Carolina factory could produce and sell 12 million. 2. Orange can sell all the phones produced at an average of $400 per phone in 2023¹. Orange forecasts that they can gradually raise the price of their phones by 2% per year over the next 10 years. 3. A new factory would be 5 million square feet at a cost of $160/ft² to build in Pennsylvania or Texas. After grants, Orange would only need to pay $125/ft² to renovate the existing 3 million square foot factory in North Carolina. 4. Pennsylvania will lease publicly owned land for the factory to Orange tax free, but the local government won't waive the 1% annual property tax which is calculated on the initial cost of the factory. The land in Texas will cost $20 million, and the local property tax is 0.5%, calculated based on the initial cost of the factory plus the cost of the land. Since there is an existing factory in North Carolina, there will be no cost in purchasing the land, and the state has agreed to pay the local property tax for 10 years. 5. Orange plans to spend $500 million on equipment for the new factories in Texas or Pennsylvania. Salvage value for the equipment after 10 years is expected to be 10% of the equipment's purchase price. North Carolina is offering to help pay for the equipment which lowers the cost to $300 million, but it has added a caveat that forces Orange to sell the equipment to the state for $1 when Orange disposes of the equipment after 10 years. 6. Orange can depreciate 100% of the cost of equipment when it's put into service for tax purposes.² (Since salvage value will be taxed as a gain at the end of 10 years, do not subtract it from the equipment's value for depreciation.) All other depreciation will be on a straight-line basis over 15 years. (Don't forget that there is no depreciation on land.) 7. The federal income tax rate for Orange is 21%. In their pursuit of new manufacturing jobs, all three states have offered different incentive packages that result in a state income tax equivalent to 3% for the first 10 years. State income tax is not deductible on federal taxes, so the effective tax rate is 24%. 8. Orange plans on hiring 8,000 workers in Pennsylvania or Texas with a total annual expense of $80,000 per worker. The factory in North Carolina would require 5,000 workers at $90,000 per year. Wage inflation is forecasted to be 5% per year in Pennsylvania, 4% in Texas, and 3% in North Carolina over the life of the project. 9. For operational expenses, assume that fixed overhead will be 10% of annual sales and cost of goods sold (excluding labor) will be 60% of annual sales at each factory. Orange will also need to maintain a total of 10% of next year's sales in working capital. In other words, this is the cash that Orange will have to reserve for this project. It cannot be used elsewhere in the company.³ 10. Orange keeps a stable debt-to-equity ratio of 0.8 and will use the same mix of debt and equity to finance this project. The average interest rate on its debt is only 3%, but its required rate of return on equity is 35%. Note that interest expense is not included in operating income as the interest rate has already impacted the weighted average cost of capital (WACC). Including interest expense in the operating income will double-count the effect of interest on the project. Orange Computers has transformed into one of the largest smartphone companies in the world. Based on recent changes to the federal tax code, building phones in the US has become more attractive. Orange wants to build a single factory in either Pennsylvania, Texas, or North Carolina. Each state is offering incentives to woo Orange. Pennsylvania and Texas have proposed building a new facility, while North Carolina is offering grants to help renovate a recently closed factory. Build a workbook to calculate the net present value and internal rate of return (rounded to two decimal places) for each location over ten years using the information provided. Determine where Orange should locate their factory and give a brief explanation of why. Below are the pieces of information necessary to calculate the net present value and internal rate of return: 1. The factories in Pennsylvania and Texas could produce and sell 20 million phones annually, while the North Carolina factory could produce and sell 12 million. 2. Orange can sell all the phones produced at an average of $400 per phone in 2023¹. Orange forecasts that they can gradually raise the price of their phones by 2% per year over the next 10 years. Orange Computers has transformed into one of the largest smartphone companies in the world. Based on recent changes to the federal tax code, building phones in the US has become more attractive. Orange wants to build a single factory in either Pennsylvania, Texas, or North Carolina. Each state is offering incentives to woo Orange. Pennsylvania and Texas have proposed building a new facility, while North Carolina is offering grants to help renovate a recently closed factory. Build a workbook to calculate the net present value and internal rate of return (rounded to two decimal places) for each location over ten years using the information provided. Determine where Orange should locate their factory and give a brief explanation of why. Below are the pieces of information necessary to calculate the net present value and internal rate of return: 1. The factories in Pennsylvania and Texas could produce and sell 20 million phones annually, while the North Carolina factory could produce and sell 12 million. 2. Orange can sell all the phones produced at an average of $400 per phone in 2023¹. Orange forecasts that they can gradually raise the price of their phones by 2% per year over the next 10 years. 3. A new factory would be 5 million square feet at a cost of $160/ft² to build in Pennsylvania or Texas. After grants, Orange would only need to pay $125/ft² to renovate the existing 3 million square foot factory in North Carolina. 4. Pennsylvania will lease publicly owned land for the factory to Orange tax free, but the local government won't waive the 1% annual property tax which is calculated on the initial cost of the factory. The land in Texas will cost $20 million, and the local property tax is 0.5%, calculated based on the initial cost of the factory plus the cost of the land. Since there is an existing factory in North Carolina, there will be no cost in purchasing the land, and the state has agreed to pay the local property tax for 10 years. 5. Orange plans to spend $500 million on equipment for the new factories in Texas or Pennsylvania. Salvage value for the equipment after 10 years is expected to be 10% of the equipment's purchase price. North Carolina is offering to help pay for the equipment which lowers the cost to $300 million, but it has added a caveat that forces Orange to sell the equipment to the state for $1 when Orange disposes of the equipment after 10 years. 6. Orange can depreciate 100% of the cost of equipment when it's put into service for tax purposes.² (Since salvage value will be taxed as a gain at the end of 10 years, do not subtract it from the equipment's value for depreciation.) All other depreciation will be on a straight-line basis over 15 years. (Don't forget that there is no depreciation on land.) 7. The federal income tax rate for Orange is 21%. In their pursuit of new manufacturing jobs, all three states have offered different incentive packages that result in a state income tax equivalent to 3% for the first 10 years. State income tax is not deductible on federal taxes, so the effective tax rate is 24%. 8. Orange plans on hiring 8,000 workers in Pennsylvania or Texas with a total annual expense of $80,000 per worker. The factory in North Carolina would require 5,000 workers at $90,000 per year. Wage inflation is forecasted to be 5% per year in Pennsylvania, 4% in Texas, and 3% in North Carolina over the life of the project. 9. For operational expenses, assume that fixed overhead will be 10% of annual sales and cost of goods sold (excluding labor) will be 60% of annual sales at each factory. Orange will also need to maintain a total of 10% of next year's sales in working capital. In other words, this is the cash that Orange will have to reserve for this project. It cannot be used elsewhere in the company.³ 3. A new factory would be 5 million square feet at a cost of $160/ft² to build in Pennsylvania or Texas. After grants, Orange would only need to pay $125/ft² to renovate the existing 3 million square foot factory in North Carolina. 4. Pennsylvania will lease publicly owned land for the factory to Orange tax free, but the local government won't waive the 1% annual property tax which is calculated on the initial cost of the factory. The land in Texas will cost $20 million, and the local property tax is 0.5%, calculated based on the initial cost of the factory plus the cost of the land. Since there is an existing factory in North Carolina, there will be no cost in purchasing the land, and the state has agreed to pay the local property tax for 10 years. 5. Orange plans to spend $500 million on equipment for the new factories in Texas or Pennsylvania. Salvage value for the equipment after 10 years is expected to be 10% of the equipment's purchase price. North Carolina is offering to help pay for the equipment which lowers the cost to $300 million, but it has added a caveat that forces Orange to sell the equipment to the state for $1 when Orange disposes of the equipment after 10 years. 6. Orange can depreciate 100% of the cost of equipment when it's put into service for tax purposes.² (Since salvage value will be taxed as a gain at the end of 10 years, do not subtract it from the equipment's value for depreciation.) All other depreciation will be on a straight-line basis over 15 years. (Don't forget that there is no depreciation on land.) 7. The federal income tax rate for Orange is 21%. In their pursuit of new manufacturing jobs, all three states have offered different incentive packages that result in a state income tax equivalent to 3% for the first 10 years. State income tax is not deductible on federal taxes, so the effective tax rate is 24%. 8. Orange plans on hiring 8,000 workers in Pennsylvania or Texas with a total annual expense of $80,000 per worker. The factory in North Carolina would require 5,000 workers at $90,000 per year. Wage inflation is forecasted to be 5% per year in Pennsylvania, 4% in Texas, and 3% in North Carolina over the life of the project. 9. For operational expenses, assume that fixed overhead will be 10% of annual sales and cost of goods sold (excluding labor) will be 60% of annual sales at each factory. Orange will also need to maintain a total of 10% of next year's sales in working capital. In other words, this is the cash that Orange will have to reserve for this project. It cannot be used elsewhere in the company.³ 10. Orange keeps a stable debt-to-equity ratio of 0.8 and will use the same mix of debt and equity to finance this project. The average interest rate on its debt is only 3%, but its required rate of return on equity is 35%. Note that interest expense is not included in operating income as the interest rate has already impacted the weighted average cost of capital (WACC). Including interest expense in the operating income will double-count the effect of interest on the project. 10. Orange keeps a stable debt-to-equity ratio of 0.8 and will use the same mix of debt and equity to finance this project. The average interest rate on its debt is only 3%, but its required rate of return on equity is 35%. Note that interest expense is not included in operating income as the interest rate has already impacted the weighted average cost of capital (WACC). Including interest expense in the operating income will double-count the effect of interest on the project.
Expert Answer:
Answer rating: 100% (QA)
To calculate the net present value NPV and internal rate of return IRR for each location we need add... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
1. How strong are the competitive forces confronting J. Crew in the market for specialty retail? Do a [Michael Porter] five-forces analysis to support your answer. (see chapter 3 in the textfor...
-
An application program is executed on a nine-computer cluster. A benchmark program took time T on this cluster. Further, it was found that 25% of T was time in which the application was running...
-
The following transactions of Drumheller Technology of Calgary, Alberta, occurred during 2013 and 2014. The company's year-end is December 31. 2013 Mar. 3 Purchased a machine for $66,000 plus...
-
What line integrals can be converted to surface integrals and conversely? How?
-
In 2016, a father of two minor children in Cuyahoga county, Ohio, filed a claim to determine custody of the children. At the pretrial, the father informed the magistrate he wanted to be named a legal...
-
The Matsui Lubricants plant uses the weighted-average method to account for its work-in-process inventories. The accounting records show the following information for a particular day: Beginning WIP...
-
The OLAP (Online Analytical Processing) discussion gives examples of multidimensional information. Give your own example of useful three-dimensional information.
-
Using lab 7 with a three-day lead time (all original values), we will analyze six different scenarios to determine which would be the best scenario based on the total cost. Scenario A - Min is 3,500...
-
A square-loop of wire on the x-y plane with four corners of (0,0,0), (1,0,0), (1,1,0) and (0,1,0) carries a current of 10 A counterclockwise. Find the magnetic field at (0,0,1).
-
Discuss the various types of communication styles you have seen in your field placement. How does your field placement agency effectively communicate at the various levels of service and why?
-
The Regulatory Framework Quiz Interpreting financial services compliance legislation, professionalism, the Code and good conduct Question: You are a financial adviser at Aotearoa Bank. You meet with...
-
BRAND EQUITY Ariel Research, a market research company, had just collected a large dataset from a random sample of Canadian consumers. This data set contained 125,000 entries on different brands of...
-
An ice dancer with her arms stretched out starts into a spin with an angular velocity of 1.00 rad/s. Her moment of inertia with her arms stretched out is 2.48 kg m2. What is the increase in her...
-
Consider a situation in which the government is considering whether to provide universal healthcare coverage, which would mean that workers would no longer need to keep their current job to maintain...
-
Identify any discrepancies by reconciling the bank statement against the claims made by Julie Palmer (table 1 provided). 2) Recalculate the assessable income and allowable deductions with...
-
Show that the block upper triangular matrix A in Example 5 is invertible if and only if both A 11 and A 22 are invertible. Data from in Example 5 EXAMPLE 5 A matrix of the form A = [ A11 A12 0 A22 is...
-
Identify and discuss problems associated with assessing advertising effectiveness in foreign markets.
-
Electrolux was incorporated as Elektromekaniska AB in 1901. In 1919 the founder Axel Wenner-Gren merged that company with Swedish AB Lux in 1919 to form Aktiebolaget Electrolux (AB Electrolux at...
-
Identify appropriate organizational structures for managing international product development. Discuss key features of the structure(s) suggested.
-
Which source of the criminal law is the most influential? Why?
-
At what levels of government are modern statutes found?
-
In what ways is the criminal law different from the law of criminal procedure?
Study smarter with the SolutionInn App