Construct a spreadsheet to compare the cash flows

Assignment Help Other Subject
Reference no: EM132258302

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.

Verified Expert

This assignment is a two-part analysis which explains a practical perspective of the Australia and the exchange rate system.It details the concept of the exchange rate analysis which is beneficial in terms with the practical analysis and exchange rate perspective.It also shows the project financing and its benefits as per this system and working.

Reference no: EM132258302

Questions Cloud

How did europeans make sense of native societies : What regional differences in native societies and economies existed on the North American continent before European arrival?
Difference between income and substitution effect : What is the difference between income and substitution effect in regards to labour economics?
Government policy or private solution : State whether or not there is a government policy or private solution that could be used to reduce the externality, and what would be required for either
Determine if the proportion distribution of likely : Perform the appropriate test to determine if the proportion distribution of likely most popular majors in the next two years appears to be significantly
Construct a spreadsheet to compare the cash flows : FIN302 - Construct a spreadsheet to compare the cash flows resulting from two plans. Under the first plan, net baht-denominated cash flows
Given the topics of gdp-supply and demand : Given the topics of GDP, supply and Demand, CPI, interest rates, describe their importance and impact on national and global economy and businesses.
What were the attitudes of progressives : What were the attitudes of progressives toward the plight of African-Americans? Were the problems of African-Americans handled differently?
Do we need more or less government intervention : Do we need more or less government intervention to decide WHAT, HOW, and FOR WHOM? Give specific examples.
Do you think the rise of the tea party has been beneficial : Do you think the rise of the Tea Party has been beneficial for the Republican Party? Why or why not?

Reviews

len2258302

3/16/2019 3:33:25 AM

Supplementary Assignment (25% of total marks) This assignment consists of 2 parts which together makes up 25% of the total assessment for FIN302 subject.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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