Monetary Economic Assignment

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

QUESTION
I. Question 1: Parity Conditions (20 Marks)
As an analyst in Commonwealth Bank (Sydney), you are required to analyse two economies, namely Australia and U.S., and their associated currencies AUD$, and USD $, respectively.
Part A (10 marks): Excel Calculations
You first need to download the quarterly data of Australia and U.S. from Internet for the period between 2000Q4 and 2017Q4. In order to provide the below analysis, you need to have interest rate, exchange rate, inflation rate and forward rate data for both countries.
Hint: Data Download from Internet
Interest Rate Using (mid yield) data
Australia Australia 10 yr Govt Bond Yield Index
US US Treasury Yield Curve Rate T Note Constant Maturity 10 Year
Exchange rate (1) Make sure USD is unit currency
AUD / USD Australian Dollar (spot / forward exchange rates) Term = 3 months
Inflation rate
Australia CPI Index
US CPI Index
Forward AUD USD 3 month Forward points
For interest rate, please use Australia 10 year government bond yield index and US 10 Year Treasury yield curve rate. Both interest rates should be mid yield data.
The USD is foreign currency and unit currency for both spot / forward exchange rate in your calculation. The term of forward exchange rate is 3 month.
Please use CPI Index and US – CPI Index to download inflation rate for Australia and the US respectively.
a. For each period of 2000Q4 and 2017Q4, calculate the changes of the exchange rate, forward premium (discount). (5 marks)
b. For each period of 2000Q4 and 2017Q4, calculate the implied forward rate by the interest rate parity (IRP). Identify the periods in which the interest rate parity (IRP) condition was violated. (Hint: we keep the first two decimal places when we compare implied forward rate calculated
from IRP and actual forward rate as the theory and reality may not be perfectly matched.)
(5 marks)
c. For each period of 2000Q4 and 2017Q4, calculate the expected exchange rate by the relative purchasing power parity (PPP). Identify the periods in which the relative purchasing power parity (PPP) condition was violated. (Hint: we keep the first two decimal places when we compare expected exchange rate calculated from relative PPP and actual exchange rate next period as the theory and reality may not be perfectly matched. (5 marks)
d. For each period of 2000Q4 and 2017Q4, calculate the carry trade strategy returns. (5 marks)
II. Presentation of your work (5 marks):
• Formulas for the calculations in Excel should have cell references wherever possible. If you have computed a number incorrectly and just typed that number into the spreadsheet (or typed a formula using numbers when cell references could have been used), you will not receive partial credit for any portion of your computation that is correct. (5 marks)

Sample Solutions
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Phasellus hendrerit. Pellentesque aliquet nibh nec urna. In nisi neque, aliquet vel, dapibus id, mattis vel, nisi. Sed pretium, ligula sollicitudin laoreet viverra, tortor libero sodales leo, eget blandit nunc tortor eu nibh. Nullam mollis. Ut justo. Suspendisse potenti.

Get sample solution
Order Now

Sed egestas, ante et vulputate volutpat, eros pede semper est, vitae luctus metus libero eu augue. Morbi purus libero, faucibus adipiscing, commodo quis, gravida id, est. Sed lectus. Praesent elementum hendrerit tortor. Sed semper lorem at felis. Vestibulum volutpat, lacus a ultrices sagittis, mi neque euismod dui, eu pulvinar nunc sapien ornare nisl. Phasellus pede arcu, dapibus eu, fermentum et, dapibus sed, urna.

Morbi interdum mollis sapien. Sed ac risus. Phasellus lacinia, magna a ullamcorper laoreet, lectus arcu pulvinar risus, vitae facilisis libero dolor a purus. Sed vel lacus. Mauris nibh felis, adipiscing varius, adipiscing in, lacinia vel, tellus. Suspendisse ac urna. Etiam pellentesque mauris ut lectus. Nunc tellus ante, mattis eget, gravida vitae, ultricies ac, leo. Integer leo pede, ornare a, lacinia eu, vulputate vel, nisl.
Suspendisse mauris. Fusce accumsan mollis eros. Pellentesque a diam sit amet mi ullamcorper vehicula. Integer adipiscing risus a sem. Nullam quis massa sit amet nibh viverra malesuada. Nunc sem lacus, accumsan quis, faucibus non, congue vel, arcu. Ut scelerisque hendrerit tellus. Integer sagittis. Vivamus a mauris eget arcu gravida tristique. Nunc iaculis mi in ante. Vivamus imperdiet nibh feugiat est.
Ut convallis, sem sit amet interdum consectetuer, odio augue aliquam leo, nec dapibus tortor nibh sed augue. Integer eu magna sit amet metus fermentum posuere. Morbi sit amet nulla sed dolor elementum imperdiet. Quisque fermentum. Cum sociis natoque penatibus et magnis xdis parturient montes, nascetur ridiculus mus. Pellentesque adipiscing eros ut libero. Ut condimentum mi vel tellus. Suspendisse laoreet. Fusce ut est sed dolor gravida convallis. Morbi vitae ante. Vivamus ultrices luctus nunc. Suspendisse et dolor. Etiam dignissim. Proin malesuada adipiscing lacus. Donec metus. Curabitur gravida

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services