Assumptions Value Growth Assumptions Value
Light bulb export volume to Argentina, per year 24,000 4.00% Sales multiple in year 5 6.00
Sales price per set in Argentina 60.00$ 7.00% Spot rate, 2003 (Pesos/US$) 3.50
Material costs per set in Argentina 20.00$ 6.00% US inflation rate, per annum 1.00%
Project Year 0 1 2 3 4 5
Year 2012 2013 2014 2015 2016 2017
PPP Expected Exchange Rate (Pesos/US$) 3.50 3.64 3.78 3.93 4.09 4.25
Project Cash Flows in Argentina: Project Viewpoint (Argentine pesos)
Annual units sold (sets) 24,000 24,960 25,958 26,997 28,077
Sales price in Argentina per set (in US$) 60.00$ 64.20$ 68.69$ 73.50$ 78.65$
Sales price in Argentine per set (in pesos) 218.32 242.85 270.14 300.50 334.27
Sales revenue (Argentine pesos) 5,239,604 6,061,547 7,012,430 8,112,479 9,385,094
Less direct manufacturing and shipping costs (1,746,535) (2,001,632) (2,293,990) (2,629,048) (3,013,046)
Less cost of US components @ $10/set (873,267) (944,166) (1,020,821) (1,103,700) (1,193,307)
Gross profit 2,619,802 3,115,749 3,697,619 4,379,731 5,178,741
Less depreciation (700,000) (700,000) (700,000) (700,000) (700,000)
Internal rate of return (IRR) 43.9%
Net present value (NPV) 6,725,072
The Parent Viewpoint needs to consider all incremental cash flow impacts including loss on export sales to Argentina (current practice).
Cash Flows to Hermosa in US: Parent Viewpoint
Sales revenue on exports to Argentina 240,000$ 249,600$ 259,584$ 269,967$ 280,766$
Less direct and indirect costs on exported sets (120,000) (124,800) (129,792) (134,984) (140,383)
Profit on Hermosa’s component sales 120,000$ 124,800$ 129,792$ 134,984$ 140,383$
Less US taxes on component profits @ 40% 40% (48,000) (49,920) (51,917) (53,993) (56,153)
a) Net profit on component sales after-tax 72,000$ 74,880$ 77,875$ 80,990$ 84,230$
b) Cash flow from Argentina to Hermosa (US) 508,952$ 568,229$ 635,360$ 711,263$ 796,964$
Internal rate of return (IRR) 29.1%
Net present value (NPV) 684,343