PLEASE USE THE TEMPLATE THAT WAS PROVIDED.

Today is 27^th April, 2017. You are a senior financial analyst with IBM in their capital budgeting division. IBM is considering expanding in Australia due to its positive business atmosphere and cultural similarities to the U.S.

The new facility would require a one-off initial investment in fixed assets of $5 billion in Australian and additional capital investment of 3% of revenue each year in year 1-4. All capital investments would be depreciated straight-line to zero over five years. Assume that at the end of the project the sales price of equipment is zero and the tax effect is also zero. First-year revenues from the facility are expected to be $6 billion Australian and grow at 10% per year. The cost of goods sold (COGS) would be 40% of revenue; the other operating expenses would amount to 12% of revenue. Depreciation and amortisation expenses (D&A) are included in COGS and other operating expenses. Net working capital requirements would be 11% of sales and would be required the year prior to the actual revenues. All net working capital would be recovered at the end of the fifth year. Assume that the tax rates are the same in the two countries, and that two markets are internationally integrated, and that the cash flow uncertainty of the project is un-correlated with changes in the exchange rate (hint: you can use the home currency approach to value the Australian business; the home currency is USD). You manager wants you to find the NPV of the project in U.S. dollars using a USD cost of capital of 12%.

You have the following market data:

Spot exchange rate: AUD1.3174/USD or 1 USD= 1.3174 AUD (as of 27^th April 2017, Bloomberg)

Yield-to-maturity (YTM) of zero-coupon government bonds (as of 27^th April 2017, Bloomberg and estimates) (Hint: use these as interest rates to derive synthetic forward exchange rates)

(annual rates)	1-year	2-year	3-year	4-year	5-year
Australian yield-curve	1.73%	1.87%	1.96%	2.02%	2.06%
U.S. yield-curve	0.55%	0.78%	1.03%	1.16%	1.29%

Assume that IBMs marginal corporate tax rate is 20%.

Requirements: (1) In your Excel spreadsheet, create a projection with timeline from year 0 to 5). Project free cash flows from this project (without considering any financing effects) from year 0 to year 5 in Australian S (t Assume that amortisation is zero in all years and that all million). cash flows occur at the year end. Provide your projection as Appendix 2(1). Yau should use the template provided on Canvas (Waksheet "Q2" of FIN351 2017FC Assignment2 Data.xlsx) (20 marks (1+r) (2) Compute symthetic forward rates for each of the five years of the project (FoT So). Then, use the forward rates to convert the cash flows to U S. dollars. Provide your worksheet in Appendix 2020. (15 marks (3) Compute the NPV of the project in S. dollars using the 12% required return given by your manager. Include your DCF in Appendix 2030. (5 marks