Mr. Vishwas, a friend of Mr. Pramod who is one of the Directors of Ashirwad Limited, is a citizen of Mauritius. His immediate family members…
CA Final · Advanced Financial Management · RTP · May 2024
Mr. Vishwas, a friend of Mr. Pramod who is one of the Directors of Ashirwad Limited, is a citizen of Mauritius. His immediate family members including his parents, born in India are residing in India. He has many friends in different parts of India, due to which he happens to visit India on frequent basis. He along with Mr. Pramod evince interest in setting up business in India and formally incorporate a company to commence their operations. Accordingly, a company is called “Aerious Private Ltd." got incorporated in Mumbai. To start with he received a business proposal from one of his friends Nimish a consultant. It is estimated that in equivalent terms the business shall require an initial investment of MUR 100 Million and thereafter MUR 2 Million each year will be needed as working capital fund. He wished to evaluate whether the business proposal is viable or not. The information related to exchange rate and inflation rate is as follows: Spot Rate for 1 Mauritian Dollar (MUR) = 1.88 Indian Rupee (INR) The inflation in India is 6% and in Mauritius is 5%. It is expected that this inflation rate will remain unchanged for the next 4 years. INR 8 Crore out of initial investment shall be required for setting up a plant. The useful life of the plant is 4 years. At the end of 4 th year estimated salvage value of this plant shall be INR 80 lakhs. Depreciation of the plant shall be charged on the basis of straight-line method. 40% of the investment shall be through debt funds from Mauritius at the cost of 10% (post tax) while remaining funds shall be arranged by him and his friends. They expect a rate of return of 12% on their funds. Expected revenues & costs (excluding depreciation) in real term are as under: Year 1 2 3 4 Revenues (₹ Crore) 6.00 7.00 8.00 8.00 Costs (₹ Crore) 3.00 4.00 4.00 4.00 Assume that applicable tax rate in India is 30%. Since there is Double tax avoidance agreement between India and Mauritius, the company is not required to pay tax in Mauritius if tax has been paid in India. The applicable inflation rates for revenues & costs are as follows: Year Revenues Costs 1 10% 12% 2 9% 10% 3 8% 9% 4 7% 8% He wants an expert opinion for the same investment proposal. Demonstrate whether investment in this project is viable option or not. Note: 1. Round off calculations upto 4 decimal points. 2. Show INR calculations in Crore and MUR calculations in Million.
Suggested Answer and Working Notes:
To evaluate whether investment in same project is a viable option or not, we shall compute the NPV of the project. Working Note: (1) Expected Exchange Rates End of Year INR INR/MUR 1 INR 1.88 x (1+0.06)/(1+0.05) 1.8979 2 INR 1.8979 x (1+0.06)/(1+0.05) 1.9160 3 INR 1.9160 x (1+0.06)/(1+0.05) 1.9342 4 INR 1.9342 x (1+0.06)/(1+0.05) 1.9526 (2) Initial Investment = MUR 100 Million x INR 1.88 = INR 18.80 crore Working Capital (Year 1) = MUR 2 Millionx1.8979 = INR 0.3796 crore Working Capital (Year 2) = MUR 2 Millionx1.9160 = INR 0.3832 crore Working Capital (Year 3) = MUR 2 Millionx1.9342 = INR 0.3868 crore Working Capital (Year 4) = MUR 2 Millionx1.9526 = INR 0.3905 crore (3) WACC = 40% x 10% + 60% x 12% = 11.20% (4) Inflation adjusted Revenue Year Revenue (₹) Revenue (Inflation Adjusted) (₹) 1 6.00 crore 6.00 crore x 1.10 = 6.60 crore 2 7.00 crore 7.00 crore x 1.10 x 1.09 = 8.393 crore 3 8.00 crore 8.00 crore x 1.10 x 1.09 x 1.08 = 10.3594 crore 4 8.00 crore 8.00 crore x 1.10 x 1.09 x 1.08 x 1.07 = 11.0845 crore (5) Inflation adjusted Cost Year Cost (₹) Cost (Inflation Adjusted) (₹) 1 3.00 crore 3.00 crore x 1.12 = 3.3600 crore 2 4.00 crore 4.00 crore x 1.12 x 1.10 = 4.9280 crore 3 4.00 crore 4.00 crore x 1.12 x 1.10 x 1.09 = 5.3715 crore 4 4.00 crore 4.00 crore x 1.12 x 1.10 x 1.09 x 1.08 = 5.8012 crore (6) Annual cash flows (₹ Crore) Year 1 2 3 4 Revenue 6.600 8.393 10.3594 11.0845 Less: Cost 3.360 4.928 5.3715 5.8012 Less: Depreciation 1.800 1.800 1.800 1.800 Profit before Tax (PBT) 1.440 1.665 3.1879 3.4833 Tax @ 30% 0.432 0.4995 0.9564 1.0450 Profit after Tax 1.008 1.1655 2.2315 2.4383 Add: Depreciation 1.800 1.800 1.800 1.800 Cash Flows 2.808 2.9655 4.0315 4.2383 NPV of the Project Year 0 1 2 3 4 Initial Investment (₹ Crore) (18.80) Working Capital (₹ Crore) (0.3796) (0.3832) (0.3868) (0.3905) Scrap Value (₹ Crore) 0.8000 W.C Recovered (₹ Crore) 1.5401 Annual Cash flows 2.8080 2.9655 4.0315 4.2383 Net Cash Flow (18.80) 2.4284 2.5823 3.6447 6.1879 Exchange Rate 1.88 1.8979 1.9160 1.9342 1.9526 Cash Flows (in Million MUR) (100) 12.7952 13.4776 18.8434 31.6906 [email protected]% 1 0.8993 0.8087 0.7273 0.6540 Present value (in Million MUR) (100) 11.5067 10.8993 13.7048 20.7257 Net Present Value = - MUR 43.1635 Million Advise: Since NPV of the project is negative the proposal is not a viable option for investment.
Topics: International Financial Management
Related Questions in this Topic
- ABN-Amro Bank, Amsterdam, wants to purchase ₹ 80 million for funding its account with Canara Bank, New Delhi. Out of th...
- Explain the term “Political Risk" and its various forms. Is Political Risk covered under Financial Risk? If so, explain ...
- ICL an Indian MNC is executing a plant in Sri Lanka. It has raised 400 billion. Half of the amount will be required afte...
- An Indian company is investing in a 2-year project in Europe (EURO). Initial Investment = €4,000,000 Annual after-tax ...
- Bharat Infrastructure Ltd (BIL), a premier Indian Engineering firm, has been invited to establish and operate a high-spe...