Construct a spreadsheet to compare the cash flows

Assignment Help Finance Basics
Reference no: EM131911977

Supplementary Assignment -

This assignment consists of 2 parts.

PART A -

As a financial analyst for Aussie Blades, Pty Ltd, you are reasonably satisfied with Aussie Blades' current set-up of exporting 'Speedos' (rollerblades) to Thailand. Due to the unique arrangement with Aussie Blades' primary customer in Thailand, forecasting the revenue to be generated there is a relatively easy task. Specifically, your customer has agreed to purchase 180,000 pairs of Speedos annually, for a period of three years, at a price of THB4594 (THB = Thai baht) per pair. The current direct quotation of the Australian dollar-baht exchange rate is A$0.0.0381.

The cost of goods sold incurred in Thailand (due to imports of the rubber and plastic components from Thailand) runs at approximately THB2871 per pair of Speedos, but Aussie Blades currently only imports materials sufficient to manufacture about 72,000 pairs of Speedos. Aussie Blades' primary reasons for using a Thai supplier are the high quality of the components and the low cost, which has been facilitated by a continuing depreciation of the Thai baht against the Australian dollar. If the Australian dollar cost of buying components becomes more expensive in Thailand than in Australia, Aussie Blades is contemplating providing its Australian supplier with the additional business.

Your plan is quite simple; Aussie Blades is currently using its Thai-denominated revenues to cover the cost of goods sold incurred there. During the last year, excess revenue was converted to Australian dollars at the prevailing exchange rate. Although your cost of goods sold is not fixed contractually as the Thai revenues are, you expect them to remain relatively constant in the near future. Consequently, the baht-denominated cash inflows are fairly predictable each year because the Thai customer has committed to the purchase of 180,000 pairs of Speedos at a fixed price. The excess Australian dollar revenue resulting from the conversion of baht is used either to support the Australian production of Speedos, if needed, or to invest in Australia. Specifically, the revenues are used to cover cost of goods sold in the Australian manufacturing plant, located in Perth, Western Australia.

Ben Holt, Aussie Blades' CFO, notices that Thailand's interest rates are approximately 15 per cent (versus 8 per cent in Australia). You interpret the high interest rates in Thailand as an indication of the uncertainty resulting from Thailand's unstable economy. Holt asks you to assess the feasibility of investing Aussie Blades' excess funds from operations in Thailand at an interest rate of 15 per cent. After you express your opposition to his plan, Holt asks you to put forward the reasons in a detailed report.

1) One point of concern for you is that there is a trade-off between the higher interest rates in Thailand and the delayed conversion of baht into Australian dollars. Explain what this means.

2) If the net baht received from the Thailand operation are invested in Thailand, how will Australian operations be affected? (Assume that Aussie Blades is currently paying 10 per cent on Australian dollars borrowed and needs more financing for the company.)

3) Construct a spreadsheet to compare the cash flows resulting from two plans. Under the first plan, net baht-denominated cash flows (received today) will be invested in Thailand at 15 per cent for a one-year period, after which the baht will be converted to Australian dollars. The expected spot rate for the baht in one year is about A$0.0361 (Ben Holt's plan). Under the second plan, net baht-denominated cash flows are converted to Australian dollars immediately and invested in Australia for one year at 8 per cent. For this question, assume that all baht-denominated cash flows are due today. Does Holt's plan seem superior in terms of Australian dollar cash flows available after one year? Compare the choice of investing the funds versus using the funds to provide needed financing to the company.

4) The difference between the Thai baht interest rate (15 per cent) and the Australian dollar interest rate (8 per cent) is 7 per cent. If you anticipate that the Thai baht will depreciate by at least 7 per cent in one year, which plan in question (3) (the first or second plan) is it better to exercise? Explain your recommendation.

PART B -

Select 2 Australian MNCs that are part of the ASX20 Index. The 2 chosen companies must have significant operations overseas and cannot be from the same industry group (if you choose one from the financial sector the second company must not be from the financial industry). Wrong selection of companies will immediately result in failure of this part of the assignment.

1) Provide a brief background of each companies' business, listing the countries where each have operations in. Determine the country where each of them derives the most revenue outside of Australia. From the company's annual reports and other sources, explain in details how the company manage their foreign currency exposure to that country to reduce their transactions and translations risk.

2) From question 1, plot the weekly chart of the foreign currency vs AUD exchange rate for each of the companies against its ASX listed share price for the past 2 years. Determine if there is any correlation between the exchange rate and its share price over that period. Explain your findings (provide an explanation based on the companies' global operation and management of its forex exposure) in details specific to each company that you have chosen.

3) Determine if the two companies have a separate listing on a foreign stock exchange. If they do, explain why you think the company has chosen to list its shares on that secondary stock exchange. Explain the benefits and downside to having that secondary listing. If the companies do not have a secondary listing, explain why it may be beneficial for them to do so and recommend which stock exchange the companies should consider a secondary listing. Explain your recommendation in details.

Reference no: EM131911977

Questions Cloud

Describe vwbs new strategy : How can Schmall and his team use the scorecard to deal with the challenges faced by the company in January 2009?
Specific behavioral problems of multidisciplinary groups : 1. What are the specific behavioral problems of multidisciplinary groups? 2. Discuss the concept of organizational culture.
Discuss the various approaches to ethical decision making : Discuss the various approaches to ethical decision making by leaders and their impacts and outcomes on organizations and their stakeholders.
Reimbursement for telemedicine services : There are many controversies regarding reimbursement for telemedicine services. Imagine that you are negotiating with an insurance carrier
Construct a spreadsheet to compare the cash flows : FIN302 - Supplementary Assignment - Construct a spreadsheet to compare the cash flows resulting from two plans
Does anyone have first-hand experience : I honestly don't envy those in Unions, that said, I have never been a part of one, so I do not know first hand. Does anyone have first-hand experience?
Managing in health programs and projects : List and describe the three principles that underpin a total quality approach to managing in health programs and projects?
How has leadership shape thinking about religious traditions : What similarities and differences do you see across the four religious traditions? How has this shaped your thinking about other religious traditions?
Turnover in canadian long-term-care services : What factors are related to staff retention and turnover in Canadian long-term-care services?

Reviews

Write a Review

Finance Basics Questions & Answers

  Discuss how irr and npv are related

FIN 370- Discuss how IRR and NPV are related and describe the situations in which the NPV and IRR metrics can provide conflicting signal. If there is a conflicting signal, which one would you place more emphasis on and why?

  Significance to test the hypothesis

Use a 0.10 level of significance to test the hypothesis that the mean wealth is less than $500,000.

  What is the maximum that can be consumed in the first period

If the borrowing/lending rate is 20%, what is the opportunity set? What is the maximum that can be consumed in the first period? In the second period?

  Could sox have prevented the phar-mor fraud

Could SOX have prevented the Phar-Mor fraud? How? Which specific sections of SOX? Describe the scandal. Could SOX have prevented this scandal?

  Calculate the theoretical intrinsic value of the call option

Given the following information, calculate the theoretical intrinsic value of the Call option using the Black Scholes Model. IF the market price for the Call option = $11, should the investor buy?

  What is the current stock price

A stock just paid a dividend of $1.2. The required rate of return is 11.5%, and the constant growth rate is 3.6%. What is the current stock price.

  Which would provide the greatest diversicication

Which would provide the greatest diversicication?

  A firm buys on terms of 28 net 45 days it does not take

a firm buys on terms of 28 net 45 days it does not take discounts and it actually pays after 58 days. what is the

  What level of pretax cost savings do we require

The device has an estimated Year 5 salvage value of $60,000. What level of pretax cost savings do we require for this project to be profitable?

  Compute taxable income and taxes payable

Beginning with pre-tax accounting income, compute taxable income and taxes payable for 2014. Clearly label all amounts used in arriving at taxable income.

  Determine the annual financing cost

Determine the annual financing cost of a 6-month (182 day) $20,000 discounted bank loan at a stated annual interest rate of 10 percent. Assume that no compensating balance is required.

  If the interest rate of 10 increases to 12 how many basis

if the interest rate of 10 increases to 12 how many basis points did it

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd