Project Description

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.