please on excel spreadsheet with formula. or do not answered it please. 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\mathrm{.}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.