1 month Inflationrate_usa Inflationrate_australia Interest_rate_usa Interest_rate_aus spot_exchange_rate future_rate 2 Aug-2015 0.0137 0.0122 0.0325 0.0536 0.7141 0.7666...

Transcribed Image Text:

1 month Inflationrate_usa Inflationrate_australia Interest_rate_usa Interest_rate_aus spot_exchange_rate future_rate 2 Aug-2015 0.0137 0.0122 0.0325 0.0536 0.7141 0.7666 3 Sep-2015 0.0165 0.0131 0.0325 0.0541 0.7004 0.7770 4 Oct-2015 0.0103 0.0137 0.0325 0.0546 0.7090 0.7127 5 Nov-2015 0.0125 0.0144 0.0325 0.0546 0.7184 0.7253 6 Dec-2015 0.0119 0.0150 0.0337 0.0563 0.7285 0.7513 7 Jan-2016 0.0183 0.0122 0.0350 0.0563 0.7069 0.7400 8 Feb-2016 0.0202 0.0093 0.0350 0.0563 0.7128 0.7564 9 Mar-2016 0.0182 0.0065 0.0350 0.0563 0.7661 0.7256 10 Apr-2016 0.0256 0.0062 0.0350 0.0563 0.7607 0.7579 11 May-2016 0.0206 0.0059 0.0350 0.0539 0.7196 0.7603 12 Jun-2016 0.0188 0.0056 0.0350 0.0539 0.7470 0.7431 13 Jul-2016 0.0206 0.0068 0.0350 0.0539 0.7588 0.7601 14 Aug-2016 0.0189 0.0080 0.0350 0.0526 0.7524 0.7836 15 Sep-2016 0.0188 0.0092 0.0350 0.0526 0.7628 0.7862 16 Oct-2016 0.0192 0.0117 0.0350 0.0526 0.7598 0.7990 17 Nov-2016 0.0153 0.0142 0.0350 0.0526 0.7484 0.7865 18 Dec-2016 0.0181 0.0166 0.0364 0.0526 0.7209 0.7642 19 Jan-2017 0.0264 0.0169 0.0375 0.0526 0.7565 0.7670 20 Feb-2017 0.0147 0.0172 0.0375 0.0528 0.7676 0.7879 21 Mar-2017 0.0127 0.0175 0.0388 0.0528 0.7655 0.7914 22 Apr-2017 0.0182 0.0156 0.0400 0.0529 0.7483 0.7704 23 May-2017 0.0123 0.0138 0.0400 0.0523 0.7459 0.7778 24 Jun-2017 0.0191 0.0119 0.0413 0.0522 0.7685 0.7552 25 Jul-2017 0.0128 0.0122 0.0425 0.0522 0.7986 0.7431 26 Aug-2017 0.0172 0.0124 0.0425 0.0522 0.7907 0.7429 27 Sep-2017 0.0193 0.0127 0.0425 0.0522 0.7846 0.7286 28 Oct-2017 0.0212 0.0133 0.0425 0.0522 0.7698 0.7192 29 Nov-2017 0.0173 0.0139 0.0425 0.0522 0.7567 0.7137 30 Dec-2017 0.0209 0.0145 0.0440 0.0522 0.7808 0.7300 31 Jan-2018 0.0277 0.0154 0.0450 0.0522 0.8101 0.7185 32 Feb-2018 0.0193 0.0163 0.0450 0.0522 0.7794 0.7201 33 Mar-2018 0.0174 0.0172 0.0458 0.0522 0.7678 0.7119 34 Apr-2018 0.0197 0.0162 0.0475 0.0522 0.7575 0.7098 Sheet1 Ready A B C D E F G 35 May-2018 0.0267 0.0153 0.0475 0.0522 0.7571 0.7175 36 Jun-2018 0.0230 0.0144 0.0489 0.0522 0.7346 0.6962 37 Jul-2018 0.0184 0.0137 0.0500 0.0531 0.7407 0.6866 38 Aug-2018 0.0152 0.0131 0.0500 0.0534 0.7262 0.7030 39 Sep-2018 0.0199 0.0125 0.0503 0.0534 0.7225 0.6777 40 Oct-2018 0.0172 0.0128 0.0525 0.0534 0.7099 0.6858 41 Nov-2018 0.0260 0.0130 0.0525 0.0537 0.7322 0.6795 42 Dec-2018 0.0176 0.0133 0.0535 0.0537 0.7045 0.6805 43 Jan-2019 0.0110 0.0121 0.0550 0.0537 0.7255 0.6892 44 Feb-2019 0.0207 0.0109 0.0550 0.0537 0.7148 0.6904 45 Mar-2019 0.0254 0.0097 0.0550 0.0515 0.7087 0.6713 46 Apr-2019 0.0294 0.0103 0.0550 0.0494 0.7055 0.6125 47 May-2019 0.0149 0.0109 0.0550 0.0494 0.6906 0.6369 48 Jun-2019 0.0203 0.0115 0.0550 0.0480 0.7004 0.6483 49 Jul-2019 0.0244 0.0114 0.0550 0.0480 0.6875 0.6862 50 Aug-2019 0.0193 0.0114 0.0525 0.0480 0.6736 0.6986 51 Sep-2019 0.0134 0.0114 0.0515 0.0480 0.6865 0.7214 52 Oct-2019 0.0215 0.0137 0.0499 0.0480 0.6898 0.7296 53 Nov-2019 0.0169 0.0161 0.0475 0.0461 0.6765 0.7094 54 Dec-2019 0.0180 0.0184 0.0475 0.0456 0.7001 0.7303 55 Jan-2020 0.0281 0.0175 0.0475 0.0451 0.6708 0.7549 56 Feb-2020 0.0212 0.0166 0.0475 0.0438 0.6580 0.7695 57 Mar-2020 0.0108 0.0157 0.0378 0.0443 0.6169 0.7736 58 Apr-2020 0.0152 0.0076 0.0325 0.0416 0.6555 0.7732 59 May-2020 0.0209 -0.0006 0.0325 0.0422 0.6634 0.7624 60 Jun-2020 0.0150 -0.0087 0.0325 0.0422 0.6872 0.7625 61 Jul-2020 0.0270 -0.0057 0.0325 0.0400 0.7204 0.7626 62 Aug-2020 0.0222 -0.0028 0.0325 0.0442 0.7373 0.7626 63 Sep-2020 0.0141 0.0001 0.0325 0.0401 0.7144 0.7628 64 Oct-2020 0.0086 0.0018 0.0325 0.0394 0.7038 0.7629 65 Nov-2020 0.0086 0.0035 0.0325 0.0395 0.7400 0.7630 66 Dec-2020 0.0181 0.0051 0.0325 0.0389 0.7689 0.7631 67 Jan-2021 0.0147 0.0134 0.0325 0.0383 0.7644 0.7595 68 Feb-2021 0.0181 0.0085 0.0325 0.0377 0.7870 0.7586 Sheet1 Ready 1 month Inflationrate_usa Inflationrate_australia Interest_rate_usa Interest_rate_aus spot_exchange_rate future_rate 2 Aug-2015 0.0137 0.0122 0.0325 0.0536 0.7141 0.7666 3 Sep-2015 0.0165 0.0131 0.0325 0.0541 0.7004 0.7770 4 Oct-2015 0.0103 0.0137 0.0325 0.0546 0.7090 0.7127 5 Nov-2015 0.0125 0.0144 0.0325 0.0546 0.7184 0.7253 6 Dec-2015 0.0119 0.0150 0.0337 0.0563 0.7285 0.7513 7 Jan-2016 0.0183 0.0122 0.0350 0.0563 0.7069 0.7400 8 Feb-2016 0.0202 0.0093 0.0350 0.0563 0.7128 0.7564 9 Mar-2016 0.0182 0.0065 0.0350 0.0563 0.7661 0.7256 10 Apr-2016 0.0256 0.0062 0.0350 0.0563 0.7607 0.7579 11 May-2016 0.0206 0.0059 0.0350 0.0539 0.7196 0.7603 12 Jun-2016 0.0188 0.0056 0.0350 0.0539 0.7470 0.7431 13 Jul-2016 0.0206 0.0068 0.0350 0.0539 0.7588 0.7601 14 Aug-2016 0.0189 0.0080 0.0350 0.0526 0.7524 0.7836 15 Sep-2016 0.0188 0.0092 0.0350 0.0526 0.7628 0.7862 16 Oct-2016 0.0192 0.0117 0.0350 0.0526 0.7598 0.7990 17 Nov-2016 0.0153 0.0142 0.0350 0.0526 0.7484 0.7865 18 Dec-2016 0.0181 0.0166 0.0364 0.0526 0.7209 0.7642 19 Jan-2017 0.0264 0.0169 0.0375 0.0526 0.7565 0.7670 20 Feb-2017 0.0147 0.0172 0.0375 0.0528 0.7676 0.7879 21 Mar-2017 0.0127 0.0175 0.0388 0.0528 0.7655 0.7914 22 Apr-2017 0.0182 0.0156 0.0400 0.0529 0.7483 0.7704 23 May-2017 0.0123 0.0138 0.0400 0.0523 0.7459 0.7778 24 Jun-2017 0.0191 0.0119 0.0413 0.0522 0.7685 0.7552 25 Jul-2017 0.0128 0.0122 0.0425 0.0522 0.7986 0.7431 26 Aug-2017 0.0172 0.0124 0.0425 0.0522 0.7907 0.7429 27 Sep-2017 0.0193 0.0127 0.0425 0.0522 0.7846 0.7286 28 Oct-2017 0.0212 0.0133 0.0425 0.0522 0.7698 0.7192 29 Nov-2017 0.0173 0.0139 0.0425 0.0522 0.7567 0.7137 30 Dec-2017 0.0209 0.0145 0.0440 0.0522 0.7808 0.7300 31 Jan-2018 0.0277 0.0154 0.0450 0.0522 0.8101 0.7185 32 Feb-2018 0.0193 0.0163 0.0450 0.0522 0.7794 0.7201 33 Mar-2018 0.0174 0.0172 0.0458 0.0522 0.7678 0.7119 34 Apr-2018 0.0197 0.0162 0.0475 0.0522 0.7575 0.7098 Sheet1 Ready A B C D E F G 35 May-2018 0.0267 0.0153 0.0475 0.0522 0.7571 0.7175 36 Jun-2018 0.0230 0.0144 0.0489 0.0522 0.7346 0.6962 37 Jul-2018 0.0184 0.0137 0.0500 0.0531 0.7407 0.6866 38 Aug-2018 0.0152 0.0131 0.0500 0.0534 0.7262 0.7030 39 Sep-2018 0.0199 0.0125 0.0503 0.0534 0.7225 0.6777 40 Oct-2018 0.0172 0.0128 0.0525 0.0534 0.7099 0.6858 41 Nov-2018 0.0260 0.0130 0.0525 0.0537 0.7322 0.6795 42 Dec-2018 0.0176 0.0133 0.0535 0.0537 0.7045 0.6805 43 Jan-2019 0.0110 0.0121 0.0550 0.0537 0.7255 0.6892 44 Feb-2019 0.0207 0.0109 0.0550 0.0537 0.7148 0.6904 45 Mar-2019 0.0254 0.0097 0.0550 0.0515 0.7087 0.6713 46 Apr-2019 0.0294 0.0103 0.0550 0.0494 0.7055 0.6125 47 May-2019 0.0149 0.0109 0.0550 0.0494 0.6906 0.6369 48 Jun-2019 0.0203 0.0115 0.0550 0.0480 0.7004 0.6483 49 Jul-2019 0.0244 0.0114 0.0550 0.0480 0.6875 0.6862 50 Aug-2019 0.0193 0.0114 0.0525 0.0480 0.6736 0.6986 51 Sep-2019 0.0134 0.0114 0.0515 0.0480 0.6865 0.7214 52 Oct-2019 0.0215 0.0137 0.0499 0.0480 0.6898 0.7296 53 Nov-2019 0.0169 0.0161 0.0475 0.0461 0.6765 0.7094 54 Dec-2019 0.0180 0.0184 0.0475 0.0456 0.7001 0.7303 55 Jan-2020 0.0281 0.0175 0.0475 0.0451 0.6708 0.7549 56 Feb-2020 0.0212 0.0166 0.0475 0.0438 0.6580 0.7695 57 Mar-2020 0.0108 0.0157 0.0378 0.0443 0.6169 0.7736 58 Apr-2020 0.0152 0.0076 0.0325 0.0416 0.6555 0.7732 59 May-2020 0.0209 -0.0006 0.0325 0.0422 0.6634 0.7624 60 Jun-2020 0.0150 -0.0087 0.0325 0.0422 0.6872 0.7625 61 Jul-2020 0.0270 -0.0057 0.0325 0.0400 0.7204 0.7626 62 Aug-2020 0.0222 -0.0028 0.0325 0.0442 0.7373 0.7626 63 Sep-2020 0.0141 0.0001 0.0325 0.0401 0.7144 0.7628 64 Oct-2020 0.0086 0.0018 0.0325 0.0394 0.7038 0.7629 65 Nov-2020 0.0086 0.0035 0.0325 0.0395 0.7400 0.7630 66 Dec-2020 0.0181 0.0051 0.0325 0.0389 0.7689 0.7631 67 Jan-2021 0.0147 0.0134 0.0325 0.0383 0.7644 0.7595 68 Feb-2021 0.0181 0.0085 0.0325 0.0377 0.7870 0.7586 Sheet1 Ready