Note:

Q7 (c) - Your calculation should include both Australian and Chinese Sales.

Q7 (d) The new selling price is referring to the selling price in China

Q7 (e) Your table should report the following (please just type in a positive integer, for example, please type 345678 without any symbol for $345,678.34). Please note that we will check your spreadsheet to make sure you don't lose marks for a wrong data entry.

New selling price in CNY in China

New variable cost in CNY in China

New units sold in China

Please upload Excel worksheet. Additional 2 marks are allocated for clear Excel presentation.

Tesla, a US car manufacturer, has a Chinese sabsidiary "Shanghai Tesla Super factory" that manufactures and sells electric cars in China. a. The main input is priced in USD (USD 10,000 unit) b. All other costs are in CNY (Fixed cost-CNY 500 million, Variable cost= CNY 50,000 unit). c. Depreciation =CNY1 millioa d. S0=CNY6.5USD e. Expects to sell 10,000 cars this year at CNY300,000 each. f. Tax mate-30\%; assuming tax credits are available for inmediate use if losses occur Please type your answers as a number to 0 decimal place in the boxes below and do not include the currency symbols. For example, if your answer is AID12345.67, please enter 12346. Please create an Excel spreadsheet to answer all of the following questions and upload your Excel spreadsheet in the next file response question. (Hint: you may use the goal seek and/or solver functions in Excel). a. What are the operating cash flows in CNY ? (2 marks) What are the operating cash flows in USD? (2 marks) b. How many units does Tesla need to sell to break even in operating cash flows in dollars? (2 marks) Besides sales in China, Tesla Shanghai Super Factory also exports cars to Australia. For the rest of the question, assume that the additional sale to Australia is 1,000 cars and the price is ADD (60,000. The shipment cost per exported car is CNY,000. The sales revenue in Australia will be translated to the C.S. direetly at the spot exchange rate. Now the exchange rate is ACD1.5.CSD and CNY 6.5 LSD. (Note: all productions are in China, but Chinese corporate tax is exempt for these exports. Please do NoT consider L.S. tax or Australian tax). c. What are the operating cash flows in dollars now? (2 marks) d. If the spot rate reduces to CNY6.0USD, Tesla would like to pass all benefits to its client by reducing the selling price. What would be the new selling price that would maintain Tesla's operating cash flow in USD in Part (c) and would pass all benefits to its client at the same time? (2 marks) e. If the spot rate increases to CNY7 USD, Tesla would like to maximize its operating cash flow in USD by changing the selling price and variable cost in CNY (main ingut in USD and exports are NOT changed) but its actions are restricted by the following constraints: 1. The selling price cannot increase by more than 20% from the original selling price; ii. The variable usit cost in CNY (not including the main input) can only be between 90% and 110% of the original cost; iii. Units sold will reduce at the same rate as the selling price increases. For example, units sold will reduce by 10% if the selling price increases by 10%. Plense fill out the values of the following three variables that would maximise Tesla's operating cash flows in USD. 2UESTION 8 f. (Continue from the previous question) Please upload Excel worksheet. Additional 2 marks are allocated for clear Excel presentation. Tesla, a US car manufacturer, has a Chinese sabsidiary "Shanghai Tesla Super factory" that manufactures and sells electric cars in China. a. The main input is priced in USD (USD 10,000 unit) b. All other costs are in CNY (Fixed cost-CNY 500 million, Variable cost= CNY 50,000 unit). c. Depreciation =CNY1 millioa d. S0=CNY6.5USD e. Expects to sell 10,000 cars this year at CNY300,000 each. f. Tax mate-30\%; assuming tax credits are available for inmediate use if losses occur Please type your answers as a number to 0 decimal place in the boxes below and do not include the currency symbols. For example, if your answer is AID12345.67, please enter 12346. Please create an Excel spreadsheet to answer all of the following questions and upload your Excel spreadsheet in the next file response question. (Hint: you may use the goal seek and/or solver functions in Excel). a. What are the operating cash flows in CNY ? (2 marks) What are the operating cash flows in USD? (2 marks) b. How many units does Tesla need to sell to break even in operating cash flows in dollars? (2 marks) Besides sales in China, Tesla Shanghai Super Factory also exports cars to Australia. For the rest of the question, assume that the additional sale to Australia is 1,000 cars and the price is ADD (60,000. The shipment cost per exported car is CNY,000. The sales revenue in Australia will be translated to the C.S. direetly at the spot exchange rate. Now the exchange rate is ACD1.5.CSD and CNY 6.5 LSD. (Note: all productions are in China, but Chinese corporate tax is exempt for these exports. Please do NoT consider L.S. tax or Australian tax). c. What are the operating cash flows in dollars now? (2 marks) d. If the spot rate reduces to CNY6.0USD, Tesla would like to pass all benefits to its client by reducing the selling price. What would be the new selling price that would maintain Tesla's operating cash flow in USD in Part (c) and would pass all benefits to its client at the same time? (2 marks) e. If the spot rate increases to CNY7 USD, Tesla would like to maximize its operating cash flow in USD by changing the selling price and variable cost in CNY (main ingut in USD and exports are NOT changed) but its actions are restricted by the following constraints: 1. The selling price cannot increase by more than 20% from the original selling price; ii. The variable usit cost in CNY (not including the main input) can only be between 90% and 110% of the original cost; iii. Units sold will reduce at the same rate as the selling price increases. For example, units sold will reduce by 10% if the selling price increases by 10%. Plense fill out the values of the following three variables that would maximise Tesla's operating cash flows in USD. 2UESTION 8 f. (Continue from the previous question) Please upload Excel worksheet. Additional 2 marks are allocated for clear Excel presentation