Reference no: EM131292941
Excel Assignment
Excel Assignment
1. Compare and Contrast two yield curves.
Plot a recent nominal constant maturity US Treasury yield curve (from the US Treasury website) and compare it to the one prior to the election result of Donald Trump.
On the same graph, for as many data points as possible, estimate in basis points the amount the yield curve rose due to a change in inflationary expectations (use a stacked line chart to shade this increase onto your plot). Also include an estimate for the real interest rate change. (Also shade the area that was due to a change in ‘real' interest rate expectations in a different color). Use the TIPS yield curve from the Treasury Website to estimate the change in inflationary vs real interest rates expectations.
(Plot both yield curves on the same graph, use different lines and spend some time making it look clear and pretty. If you can't shade the graph in excel, then shade it on your print out. Put the estimates for change in real and change in inflationary expectations on the graph somewhere).
2. From your last yield curve estimate a liquidity premium at the 5 year mark, to help estimate where you think the 3 months rate (or Fed Funds Rate) will be in 5 years time. Forward guidance on the Fed Funds rate is offered on the Fed's website.
3. Attach newspaper article(s) with your printed graph to hand in, that help explain/justify why expectations for future short term interest rates, long term interest rates, and inflationary expectations changed so dramatically.
|
What is the accumulated amount in the retirement account
: An individual begins depositing $400 per year for the first year and increases the amount by $50 each year for a 30-year period. The account earns 12% ROI. What is the accumulated amount in the retirement account? Which term is used to refer to how a..
|
|
Male and female interpretations of the advertisement
: Analyse the researcher's notes making use of a cognitive map and data display tables.- What differences do you note in terms of male and female interpretations/perceptions of the advertisement?
|
|
Why is the supply curve of labor for any specific occupation
: Why is the supply curve of labor for any specific occupation likely to be upward-sloping, even if, for the economy as a whole, people work fewer hours when wage rates increase?
|
|
How should the oral report differ from the written report
: When preparing a research report, where should you begin? Why?- List the various sections that go into making a marketing research report and briefly state what each section includes.
|
|
Nominal constant maturity us treasury yield curve
: Plot a recent nominal constant maturity US Treasury yield curve (from the US Treasury website) and compare it to the one prior to the election result of Donald Trump.
|
|
Complete accounting cycle for jordan company for the month
: You need to complete the accounting cycle for Jordan Company for the month of December 31, 2015. 1. Prepare the general journal entries to record these transactions using the accounts below. Dec. 1 Jordan invests $50,000 cash along with office equipm..
|
|
Seasonal or cyclical patterns
: Holt-Winter's double exponential smoothing would be an appropriate method to use to forecast a time series that exhibits a linear trend with no seasonal or cyclical patterns.
|
|
What challenges did you and your team face
: What challenges did you and your team face? What actions did you take to address and resolve the challenges? Describe in detail.In your judgment, was your team's training program effective in meeting the written objectives? Explain.How effective were..
|
|
Describe the effect of each payment basis on output
: Four common bases of payment for physicians are salary,fee for service,fee per case,and capitation. Describe the effect of each payment basis on output. Discuss studies that have examined the relative costs and benefits of each payment system.
|