In an Excel spreadsheet, compute the variables from: https://www.abs.gov.au/statistics/economy/international-trade/balance-payments-and-international-investment-position-australia/jun-2022#data-downloads

CLICK ON 'Data Downloads' CLICK 'Show all data (25 hidden)'

DOWNLOAD 'Table 30. Balance of payments, summary: original - financial year'

The charts should be neat and carefully labelled. You do not need to turn in a printout of your spreadsheet only the charts should be submitted.

(a) For the years 1960-2022, plot the current account, trade balance, net factor income from abroad, and net unilateral transfers, each as a percentage of GDP. You are actually required to find the GDP data on your own. All four variables should be on the same plot. The x-axis should be years.

(b) For the years 1960-2022, plot the financial and capital account balance, each as a percentage of GDP. Both variables should be on the same plot. The x-axis should be years.

(c) Repeat part (a) and (b), but for a country other than Australia or the United States. The starting year does not have to be 1960, but your time series should span at least 40 years.

Please show the charts. Thank you.