EXCEL ASSIGNMENT EXPORT VERSUS INVEST DECISION Palo Alto Electronics (PAE) of the US exports 360,000 sets...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66496ecc6bf55_52366496ecbed553.jpg)
Transcribed Image Text:
EXCEL ASSIGNMENT EXPORT VERSUS INVEST DECISION Palo Alto Electronics (PAE) of the US exports 360,000 sets of routers per year to the Philippines. It sells them for the equivalent of $58 per set. Current total costs are $47 per set and are expected to stay the same for the next ten years. PAE is studying an offer to start a subsidiary in the Philippines (to be named PAE Philippines) that would establish a project to produce and sell the routers locally. Initial investment would be $19,600,000 in plant and equipment plus $400,000 in shipping and installation and $5,000,000 in initial net working capital. Plant and equipment will be depreciated to a book value of $5,240,000 on a straight-line basis over the ten-year project life, but will have 8,800,000 market salvage value. PAE Philippines would import all the parts it needs from the parent company at a cost of $25 per set. Additional local variable costs are $13 per set. Local fixed costs are $2,500,000. The parent's pre-tax profit margin on the $25 per unit sale to its subsidiary is $10.40. Tax rate in the US and the Philippines is 25%. Discount rate for Palo Alto is 12% and it applies to both the parent company and its prospective subsidiary. Assume there is no increase in the number of units sold over the ten year period. a. Use an income statement format and an excel spreadsheet to calculate all relevant cash flows from the subsidiary's perspective. b. Is the project profitable in its own right (i.e. from the subsidiary's perspective)? Show all calculations that enter into this decision masking process. c. Assuming no limits on repatriation, what are the effective annual cash flows to PAE (the parent company)? d. Should PAE build the plant in the Philippines instead of exporting? Show all calculations. EXCEL ASSIGNMENT EXPORT VERSUS INVEST DECISION Palo Alto Electronics (PAE) of the US exports 360,000 sets of routers per year to the Philippines. It sells them for the equivalent of $58 per set. Current total costs are $47 per set and are expected to stay the same for the next ten years. PAE is studying an offer to start a subsidiary in the Philippines (to be named PAE Philippines) that would establish a project to produce and sell the routers locally. Initial investment would be $19,600,000 in plant and equipment plus $400,000 in shipping and installation and $5,000,000 in initial net working capital. Plant and equipment will be depreciated to a book value of $5,240,000 on a straight-line basis over the ten-year project life, but will have 8,800,000 market salvage value. PAE Philippines would import all the parts it needs from the parent company at a cost of $25 per set. Additional local variable costs are $13 per set. Local fixed costs are $2,500,000. The parent's pre-tax profit margin on the $25 per unit sale to its subsidiary is $10.40. Tax rate in the US and the Philippines is 25%. Discount rate for Palo Alto is 12% and it applies to both the parent company and its prospective subsidiary. Assume there is no increase in the number of units sold over the ten year period. a. Use an income statement format and an excel spreadsheet to calculate all relevant cash flows from the subsidiary's perspective. b. Is the project profitable in its own right (i.e. from the subsidiary's perspective)? Show all calculations that enter into this decision masking process. c. Assuming no limits on repatriation, what are the effective annual cash flows to PAE (the parent company)? d. Should PAE build the plant in the Philippines instead of exporting? Show all calculations.
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Which power plant has high load factor?
-
Give examples of allocation bases used to allocate support-department cost pools to operating departments.
-
Rhapsody Co supplies a wide range of garden and agricultural products to trade and domestic customers. The company has 11 divisions, with each division specialising in the sale of specific products;...
-
Work backward to find missing values (Learning Objective 2) Hanco has a relative range extending to 30,000 units each month. The following performance report provides information about Hancos budget...
-
The trial balance of Watteau Co. (shown on the next page) does not balance. Each of the listed accounts should have a normal balance per the general ledger. An examination of the ledger and journal...
-
\fFind the value of the composition: -2 W O NN f(x) 0 4 f(8(8(-1))) g(x) -1 0 -3
-
Which of the following statements is CORRECT? Select one: a.Other things equal, the IRR of a project increases when the WACC decreases. b.Other things equal, the discounted payback period of a...
-
A subject weighing 162 lbs wants to lose of her weight. If shewere to exercise for a total of 4 hours every week at an intensityof 31.4 mLkg -1 min -1 , how many weeks wouldit take her to lose this...
-
what ways can ecosystem services be quantitatively valued, and what are the implications of this valuation for environmental policy ?
-
Cathy has a permanent insurance contract with a death benefit of $500,000, a cash surrender value of $55,000, and an adjusted cost base of $35,000. She needs $30,000 to renovate her kitchen, so...
-
Use the given partial stock table. Round dollar amounts to the nearest cent when necessary. Michele Desjardins bought 850 shares of Apple (APPL) at the 52-week low and sold the shares at the 52-week...
-
A girl weighing 425 N jumps from a tree, and her center of mass falls a vertical distance of 1.80 m. Find the impulse necessary to bring her to rest. Over what time interval must the deceleration...
-
ABC Industries Income Statement For The Years Ended December 31, 2022 And 2023 2022 2023 Sales $601,000 $589,000 Cost of goods sold 279,000 296,000 Gross profit 322,000 293,000 Operating expenses...
-
Controls can be identified based on their function. The functions are preventive, detective, and corrective. A. True B. False
-
Qualitative Characteristics} Listed below are the fundamental and enhancing qualitative characteristics that make accounting information useful. a. Relevance b. Faithful representation c....
-
Events and Transactions OBJECTIVE 2 Several events are listed below. a. Common shares are issued to investors. b. An agreement is signed with a janitorial service to provide cleaning services over...
-
Events and Transactions} The following economic events that were related to A\&P Grocery Store occurred during 2018. a. On February 7, A\&P received a bill from Chatham Power and Light indicating...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App