Hey Chegg, I need your help with this question. Natural Mosaic. Natural Mosaic C
ID: 2800500 • Letter: H
Question
Hey Chegg, I need your help with this question.
Natural Mosaic. Natural Mosaic Company (U.S.) is considering investing Rs50,000,000 in India to create a wholly owned tile manufacturing plant to export to the European market. After five years, the subsidiary would be sold to Indian investors for Rs100,000,000. A pro forma income statement for the Indian operation predicts the generation of Rs7,000,000 of annual cash flow, is listed in the following table.
Sales Revenue 30,000,000
Less cash operating expenses (17,000,000)
Gross income 13,000,000
Less depreciation expenses (1,000,000)
Earnings before interest and taxes 12,000,000
Less Indian taxes at 50% (6,000,000)
Net Income 6,000,000
Add back depreciation 1,000,000
Annual cash flow 7,000,000
The initial investment will be made on December 31, 2011, and cash flows will occur on December 31st of each succeeding year. Annual cash dividends to Philadelphia Composite from India will equal 75% of accounting income.
The U.S. corporate tax rate is 40% and the Indian corporate tax is 50%. Because the Indian tax rate is greater than the U.S. tax rate, annual dividends paid to Natural Mosaic will not be subject to additional taxes in the United States. There are no capital gains taxes on the final sale. Natural Mosaic uses a weighted average cost of capital of 14% on domestic investments, but will add six percentage points for the Indian investment because of perceived greater risk. Natural Mosaic forecasts the rupee/dollar exchange rate for December 31st on the next six years are listed below.
R$/$ R$/$
2011 50 2014 62
2012 54 2015 66
2013 58 2016 70
What is the net present value and internal rate of return on this investment?
Please show all work because I need to understand the steps required to solve the problem. Please show work for NPV and IRR with the formula used for both. It would help a lot.
Explanation / Answer
Net income (Rs) 6000000 Dividend payout 75% Salvage value (Rs) 100000000 Initial investment (Rs) 50000000 Cost of capital = 14 + 6 = 20% 1) Year Net income (in Rs) Dividend (In Rs) Exchange rates Cash flows($) PV Factor @ 20% PV of dividends (NI x 75%) (Dividend/ Exchange rate) 31-12-2012 6000000 4500000 54 83333.333 0.833333 69444.44 31-12-2013 6000000 4500000 58 77586.207 0.694444 53879.31 31-12-2014 6000000 4500000 62 72580.645 0.578704 42002.69 31-12-2015 6000000 4500000 66 68181.818 0.482253 32880.89 31-12-2016 6000000 4500000 70 64285.714 0.401878 25834.99 224042.3 $ Value of Initial investment (50000000/50) 1000000 Terminal sale value ($) 100000000/70 = 1428571 Pv of terminal cash flow 1428571 x 0.4019= 574110.8 NPV = ($) PV of dividends repatriated = 224042.3 PV of terminal flow = 574110.8 Less: Initial investment = 1000000 NPV -201847 IRR is the rate at which Outflow = Inflow Or NPV = 0 Year Cash Flow PV Factors Present value 13% 14% 13% 14% 0 -1000000 1 1 -1000000 -1000000 1 83333.33 0.884956 0.877193 73746.313 73099.42 2 77586.21 0.783147 0.769468 60761.381 59700.07 3 72580.65 0.69305 0.674972 50302.028 48989.87 4 68181.82 0.613319 0.59208 41817.186 40369.11 5 64285.71 0.54276 0.519369 34891.71 33387.99 5 1428571 0.54276 0.519369 775371.34 741955.2 36889.954 -2498.32 r= NPV = 13% 36889.95 r 0 14% -2498.32 r-13/14-13 = (0-36889.95)/(-2498.32-36889.95) r-13 = .9366 x 1 r = 13 + 0.9366 r = 13.94% Approx IRR = 13.94% NPV = -201847 Please provide feedback…. Thanks in advance…. :-)