Answers should be on spreadsheets with brief explanations when necessary. Collin
ID: 2714643 • Letter: A
Question
Answers should be on spreadsheets with brief explanations when necessary.
Collins Electronics, Inc. of Oklahoma exports 30,000 sets of low-density light bulbs per year to Chile under an import license that expires in five years. In Chile the bulbs are sold for the Chilean peso equivalent of $50 per set. Direct manufacturing costs in the United States and shipping together amount to $30 per set, and there are no other costs. The market for this type of bulb in Chile is stable, neither growing nor shrinking, and Collins holds the major portion of the market.
The Chilean government has invited Collins to open a manufacturing plant so imported bulbs can be replaced by local production. If Collins makes the investment, it will operate the plant for five years and then sell the building and equipment to the Chilean investors at net book value at the time of sale, plus the value of any net working capital. (Net working capital is the amount of current assets less any portion financed by local debt.) Collins will be allowed to repatriate all net income and depreciation funds to the United States each year.
Outlay: Collins’ anticipated cash outlay in dollars, in 2015 would be:
Building and equipment $1,400,000
Net working capital 1,000,000
Total $2,400,000
All investment outlays will be made in 2015, and all operating cash inflows will occur at the end of years 2016 through 2020. Assume the Chilean peso is pegged to the U.S. dollar, so no change in exchange rate is expected.
Depreciation and investment recovery: Building and equipment will be depreciated over five years on a straight-line basis. At the end of the fifth year, the $1,000,000 of net working capital may also be repatriated to the United States, as may the remaining net book value of the plant if any.
Sales price of bulbs: Locally manufactured bulbs will be sold for the Chilean peso equivalent of $50 per set.
Operating expenses per set of bulbs:
Materials purchased in Chile (dollar equivalent) $12 per set
Materials imported from Collins Electronics $10 per set
Variable costs $22 per set
Transfer prices: The $10 transfer price per set for raw material sold by the parent consists of $6 of direct costs incurred in the United States and $4 of pretax profit to Collins. There are no other operating costs in either Chile or the United States.
Taxes: The corporate income tax rate is 40% in both Chile and the United States (combined federal and state).
Discount rate: Collins Electronics uses a 15% discount rate to evaluate all domestic and foreign projects.
a. Using the data given, calculate annual project cash flows for the years 2015 through 2020.
b. Using the data given, calculate annual cash flows to the parent for the years 2015 through 2020. Cash inflows to Collins Electronics consist of
i. profit on component sales to Chile, less taxes,
ii. dividends remitted from Chile at 100% of net profit after tax
iii. funds equal to depreciation charges, remitted to the United States,
iv. cash received from liquidating building and equipment, if any,
v. cash received from recapture of working capital investments
vi. cash flow losses due to the ending of export sales of bulbs manufactured in the United States.
c. Using the data given, calculate the net present value of the project from both the subsidiary viewpoint and the parent viewpoint. Discuss the results.
Explanation / Answer
Notes:
Cash Flow Losses will be equal to (Sales-Variable Cost)-Tax= $12 Per Set and for 30,000 Sets it will equal to 60,000 Sets.
Net Present Value of the Project from Subsidiary View point is= Discounted Cash inflow-Discounted Cash outflow
= $27,74,984.80-$24,00,000
=$3,74,984.80
Net Present Value of the Projcet from Parent View Point= $20,54,737.60
Hence the Project is viable from both Parent and subsidiary view point and Collins should consider opening of manufacturing plant at Chille
Cash Flow of the Project for the Year 2015-2020 30,000 Sets Cash Flow 2015 2016 2017 2018 2019 2020 Discount Value@ 15% 1.0000 0.7561 0.6575 0.5718 0.4972 0.4323 Building & Equipment (1,400,000) Working Capital (1,000,000) Sales-Variable cost 840000 840000 840000 840000 840000 Depreciation (280,000) (280,000) (280,000) (280,000) (280,000) Net Profit before tax 1,120,000 1,120,000 1,120,000 1,120,000 1,120,000 Income Tax 448,000 448,000 448,000 448,000 448,000 Net Profit after Tax 672,000 672,000 672,000 672,000 672,000 Depreciation added back 280000 280000 280000 280000 280000 Total Cash Flow (2,400,000) 952,000 952,000 952,000 952,000 952,000 Discouted Cash Flow (2,400,000) 719,807.20 625,940.00 544,353.60 473,334.40 411,549.60 Cash Flow of Collins Electronics 30,000 Sets Cash Flow 2015 2016 2017 2018 2019 2020 Discount Value@ 15% 0.8696 0.7561 0.6575 0.5718 0.4972 0.4323 Profit On Component Sales to Chille Less Taxes 72000 72000 72000 72000 72000 Dividends 672,000 672,000 672,000 672,000 672,000 Depreciation 280000 280000 280000 280000 280000 Recapture Working Capital 0 0 0 0 1000000 Cash Flow Losses -360000 -360000 -360000 -360000 -360000 -360000 Total Cash Flow -360000 664000 664000 664000 664000 1664000 Discounted Cash Flow -313056 502050.4 436580 379675.2 330140.8 719347.2Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.