Multinational Capital Budgeting

Xpress Tel is planning on investing US $40 million in Belarus this year for network communications systems to generate new business over the next three years,

• In addition to the initial investment for plant and equipment, 10 million Belarusian rubles (BYN) is needed for working capital and will be borrowed by the subsidiary from a Belarusian bank. The Belarus subsidiary will pay interest only on the loan each year, at an interest rate of 11 percent. The loan principal is to be paid in 10 years.
• The project will be terminated at the end of year 3, when the subsidiary will be sold.
• Initial price in year 1 is set at BYN 350 with variable cost of BYN 120. The price and variable cost of the product are expected to increase at the Belarus inflation rate.
• Demand for the product is expected at 120,000 units in the first year and expected to grow at 20%.
• The fixed costs, such as overhead expenses, are estimated to be BYN 3.5 million per year and will grow at 10%.
• The Belarus government will impose an income tax of 35% on income. Plus, the Belarus capital gains tax rate is 20%.In addition, it will impose a withholding tax of 10% on earnings remitted by the subsidiary. The U.S. government will not impose any additional taxes.
• All cash flows received by the subsidiary are to be sent to the parent at the end of each year. The subsidiary will use its working capital to support ongoing operations.
• The plant and equipment are depreciated over 10 years using the straight-line depreciation method.
• In three years, the subsidiary is to be sold. Xpress plans to let the acquiring firm assume the existing Belarusian loan.
• The working capital will not be liquidated but will be used by the acquiring firm when it sells the subsidiary. Xpress expects to receive BYN 70 million before taxes. Assume that this amount is not subject to withholding tax, but is subject to capital gains tax.
• The Belarus current and expected inflation rate is 5.2% per annum over this period and the U.S. inflation rate is expected to be 2.8% per annum.
• The current exchange rate is US$.5/BYN.
• Xpress has a WACC of 14% and will add 100 basis points for the Belarus project due to additional country risk

4. Assume Xpress used the original financing proposal and that funds are blocked until the subsidiary is sold. The funds to be remitted are reinvested at a rate of 7% (after taxes) until the end of Year 3. How is the projects NPV affected? Assume that the PPP holds.

Here is the answer, I just need the steps

\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|l|}{ Xpress Tel } \\ \hline \multicolumn{6}{|l|}{ iv. } \\ \hline Initial price & 350 & per unit in BYN & & & \\ \hline Initial variable costs & 120 & per unit in BYN & & & \\ \hline Initial sales units & 120,000 & & & & \\ \hline Initial fixed costs & 3,500,000 & in BYN & & & \\ \hline Initial investment & 40,000,000 & in USD & & & \\ \hline Salvage value & 70,000,000 & in BYN & & & \\ \hline Interest & 11% & & & & \\ \hline Belarustax rate & 35.0% & & & & \\ \hline Withholding tax rate & 10.0% & & & & \\ \hline Belarus cap. gains tax rate & 20.0% & & & & \\ \hline WACC & 15.0% & & & & \\ \hline Sales units growth & 20.0% & & & & \\ \hline FC growth & 10.0% & & & & \\ \hline Price/Vc growth & 5.2% & & & & \\ \hline Working capital & 10,000,000 & in BYN & & & \\ \hline Reinvestment rate & 7.0% & & & & \\ \hline Project life & 3 & yrs & & & \\ \hline \multicolumn{6}{|l|}{ Exchange Rate Forecast } \\ \hline US Inflation Forecast & 2.80% & & & & \\ \hline Belarus Inflation Forecast & 5.20% & & & & \\ \hline ppp (Chg of Value of Foreign Currency) & -0.02281369 & & & & \\ \hline Year & 0 & 1 & 2 & 3 & \\ \hline Exchange Rates & 0.50000000 & 0.48859316 & 0.47744654 & 0.46655423 & $/BYN \\ \hline Year & 0 & 1 & 2 & 3 & Remaining years \\ \hline Sales units & & 120,000 & 144,000 & 172,800 & \\ \hline Price per unit & & 350.00 & 368.20 & 387.35 & in BYN \\ \hline VC per unit & & 120.00 & 126.24 & 132.80 & in BYN \\ \hline Straight Line Depreciation ( % ) & & 10.00% & 10.00% & 10.00% & 70.00% \\ \hline \multicolumn{6}{|l|}{ Projections (Belarusian ruble) } \\ \hline Revenue & & 42,000,000.00 & 53,020,800.00 & 66,933,457.92 & \\ \hline Variable costs & & 14,400,000,00 & 18,178,560.00 & 22,948,614.14 & \\ \hline Fixed costs & & 3,500,000.00 & 3,850,000.00 & 4,235,000,00 & \\ \hline Interest payments & & 1,100,000.00 & 1,100,000.00 & 1,100,000.00 & \\ \hline Depreciation & & 8,000,000.00 & 8,000,000.00 & 8,000,000.00 & \\ \hline Pretax profit & & 15,000,000.00 & 21,892,240.00 & 30,649,843.78 & \\ \hline Tax & & 5,250,000.00 & 7,662,284.00 & 10,727,445.32 & \\ \hline Net income & & 9,750,000.00 & 14,229,956.00 & 19,922,398.45 & \\ \hline CF from operations - Subsidiary & & 17,750,000.00 & 22,229,956.00 & 27,922,398.45 & \\ \hline OCF reinvested from yr 1 & & & * from yr 1 & 20,321,975.00 & \\ \hline OCF reinvested from yr 2 & & & from yr 2 & 23,786,052.92 & \\ \hline Total OCF remitted & & & & 72,030,426.37 & \\ \hline Withholding taxes & & & & 7,203,042.64 & \\ \hline BYI remitted after withholding taxes & & & & 64,827,383.74 & \\ \hline Cf from Salvage value & & & & 67,200,000.00 & = \\ \hline Total CF & & - & - & 132,027,383.74 & \\ \hline \multicolumn{6}{|l|}{ Projections (US \$) } \\ \hline Exchange Rate Scenario \#1 & 0.500000 & 0.488593 & 0.477447 & 0.466554 & $/BYN \\ \hline Cash flows to parent & & s & s & \$ 61,597,934.01 & \\ \hline CF from capital investments & $(40,000,000.00) & & & & \\ \hline Total cF & S(40,000,000.00) & 5 & s & \$ 61,597,934.01 & \\ \hline MPV - Expected & $501,641.50 & & & & \\ \hline IRR & 15.4787% & & & & \\ \hline \multicolumn{6}{|c|}{ *After-tax salvage value from subsidiary sales (BYW) } \\ \hline Initial Investment & 80,000,000 & & & & \\ \hline Cumulative Depreciation (Yr3) & 24,000,000 & & & & \\ \hline End Book Value (Yr3) & 56,000,000 & & & & \\ \hline Sale Price in Yr3 & 70,000,000 & & & & \\ \hline Capital Gains & 14,000,000 & & & & \\ \hline Taxes on Cap. Gain & 2,800,000 & & & & \\ \hline After tax cash flow & 67,200,000 & & & & \\ \hline \end{tabular}