In: Finance
Part 1:
Calculation of cash flows for year 1 in Australian dollars:
| Particulars | Australia | China | India | Malaysia | 
| Expected cash inflows | A$ 70 Million | CNY 60 Million | INR 40Million | MYR 33 Million | 
| Exchange Rate | - | A$/CNY 0.2225 | A$/INR 0.0421 | A$/MYR 0.5886 | 
| Cash flows in A$ | 70 Million | 13.35 Million | 1.85 Million | 19.40 million | 
Total Cash Inflows for Year 1
= 70+13.35+1.85+19.40 = 105 million
Part 2:
Calculation of cash flows for year 2 in Australian dollars:
Given, Cash inflows for subsidiaries are expected to increase by 5.41% of year 1 cash flows
| Particulars | China | India | Malaysia | 
| Cash inflows for year 1 | 60 million | 45 million | 33 million | 
| Cash inflows for year 2 [[email protected]% of year 1 cash flows] | 63.25 | 47.40 | 34.75 | 
| % of Amount to be invested for 1 year | 22% | 51% | 40% | 
| Amount allocation for Investment | 13.90 | 24.15 | 13.90 | 
| Balance amount to be remitted to Australia | 49.35 | 23.25 | 20.85 | 
| Exchange Rate for year 2 [ WN 1] | 0.2165 | 0.0390 | 0.5650 | 
| Cash flows in A$ | 10.65 million | 0.95 million | 11.75 million | 
Total cash inflows for year 2
= 10.65+0.95+11.75 = 23.35 million
WN 1: Exchange rate for year 2:
| Particulars | Australia | China | India | Malaysia | 
| Exchange Rate in year 1 | - | 0.2225 | 0.0421 | 0.5886 | 
| Nominal rate in year 2 | 5.94% | 8.75% | 13.67% | 10.18% | 
| Real rate | 2.34% | 2.34% | 2.34% | 2.34% | 
| Inflation rate [ Nominal rate - Real rate] | 3.6% | 6.41% | 11.33% | 7.84% | 
| Exchange Rate for year 2 [ F = S×[(1+Rp)÷(1+RB)] | 
 -  | 
 0.2225×(1.036÷1.0641) = 0.2165  | 
 0.0421×(1.036÷1.1133) = 0.0390  | 
 0.5886×(1.036÷1.0784) = 0.5650  | 
Here Rp is Inflation rate of price currency and Rb is Inflation rate of base currency
Part 3:
Calculation of cash flows for year 3 in Australian dollars:
Cash flows for year 3 are expected to increase by 9.51% of Year 1 cash flows for it's subsidiaries
| Particulars | China | India | Malaysia | 
| Cash inflows for year 1 | 60 million | 45 million | 33 million | 
| Cash inflows for year 3 [ Increase @9.51% of year 1 cash flows] | 65.75 million | 49.30 million | 36.15 million | 
| Investment proceeds of year 2 received in year 3 | |||
| Invested amount | 13.90 million | 24.15 million | 13.90 million | 
| Interest rate | 8.75% | 13.67% | 10.18% | 
| Investment proceeds | 15.10 million | 27.45 million | 15.30 million | 
| Total cash flows | 80.85 million | 76.75 million | 51.45 million | 
| Exchange Rate for year 3 [ WN 2] | 0.2085 | 0.035 | 0.5345 | 
| Cash inflows in A$ | 16.90 million | 2.70 million | 27.50 million | 
Total cash inflows for year 3
= 16.90+2.70+27.50
= 47.10 million
WN 2: Exchange rate for year 3:
| Particulars | Australia | China | India | Malaysia | 
| Exchange rate for year 2 | - | 0.2165 | 0.0390 | 0.5650 | 
| Inflation rate | 3.78% | 7.54% | 11.18% | 9.67% | 
| Exchange Rate for year 3 [ F = S ×[(1+Rp)÷(1+Rb)] | - | 
 0.2165×(1.0378÷1.0754) = 0.2085  | 
 0.0390×(1.0378÷1.1118) = 0.035  | 
 0.5650×(1.0378÷1.0967] = 0.5345  | 
Here Rp is inflation rate of price currency and Rb is Inflation rate of base currency
Part 4:
Calculation of Present value of cash inflows for year 1 to 3 in Australian dollars at required rate of return of 6.80%
| Particulars | year 1 | year2 | year3 | 
| Cash inflows in A$ | 105 million | 23.35 million | 47.10 million | 
| [email protected]% | 0.9363 | 0.8767 | 0.8209 | 
| Present value of cash inflows | 98.30 million | 20.45 million | 38.65 million | 
Total present value of cash inflows in A$
= 98.30+20.45+38.65
= 157 million