ps1 (1)

pdf

School

Columbia University *

*We aren’t endorsed by this school

Course

8306

Subject

Economics

Date

Jan 9, 2024

Type

pdf

Pages

3

Uploaded by CorporalHerring3953

Report
B8306 Fall 2023 Professor Xuelin Li Due Date: Fri, Sept 29 1 Problem Set 1 PROBLEM SET INSTRUCTIONS Hand in your answers in an Excel spreadsheet. Please use a separate worksheet to answer each question; make sure to show all your work. Type the names of all group members at the top of the first worksheet and set the print area to one page wide. Turn in homework on CANVAS by 11:59PM on the above due date. Turn on one assignment per group. Late homework will be penalized. Question 1. Bond arbitrage Suppose that the current term structure of spot rates is given by Year ( n ) 𝑟 𝑛 (annualized) 0.5 1.45% 1.0 1.70% 1.5 1.79% 2.0 1.98% a) Price zero coupon bonds for each maturity b) Price a 3% (annualized coupon rate) coupon bond for each maturity. c) Suppose the two-year 3% coupon bond is trading for 101.75 dollars. Is there an arbitrage opportunity? If so, construct a trade that delivers a risk-free profit of approximately $50k today. That is, detail the number of units of each security that you buy/sell, your initial costs and future payoffs for the entire portfolio in each time period. d) When the two-year 3% coupon bond is trading at 101.75 dollars, what is its yield? Question 2. Student loan replication with a savings account A friend of yours is asking for advice on whether he should pay back his student loan. The loan is a ten-year, amortizing loan with a principal amount of $200,000, and annual payments. An amortizing loan (like mortgages) is one where your annual payment is the same every year of the loan (so unlike a bond, there is no large principal payment at the end). The payment is intended to cover that year’s interest, and the remaining portion of the payment , after interest has been paid, goes to paying back the principal. This particular student loan has an annual rate of 5%. Given the terms of the loan, your friend owes an annual payment of $25,901, to be made at the end of years 1, 2, …, 10. The spreadsheet given out with this homework shows how this calculation is done, though the details are not important for the rest of this question. (All interest rate calculations should use annual compounding.) a) What is the total dollar amount your friend has to pay back on his student loan (don’t calculate the present value, just sum up all the required payments)?
B8306 Fall 2023 Professor Xuelin Li Due Date: Fri, Sept 29 2 b) Now assume that your friend has access to a savings account that pays a 2% annual interest rate (let’s assume this rate stays fixed for the next ten years though in reality deposit rates change regularly in response to market conditions). What is the present value of the payments he owes on his student loan , if you discount them at 2% (we’ll return to why this is the correct discount rate soon)? c) Say that your friend is able to pay back the entire $200,000 principal of the loan at time 0 (and hence owe no future payments). What is the NPV of paying back the loan (i.e. the difference between the present value at 2% of the owed payments and the $200,000 to pay off the loan today)? d) At what discount rate is the NPV of paying back the loan right now exactly zero? How does this compare to th e loan’s interest rate? e) Now assume your friend wants to put aside enough money today in his savings account which earns 2% per year for ten years to be able to make all future payments on the student loan. This money, say $X, will then earn 2% for the next year, at which point he will pay $25,901 dollars that are owed in year 1. The remaining money will then grow for 2% for another year, at which point he will pay the $25,901 owed at the end of year 2. This continues until year 10 (again assume the 2% rate is locked in for the life of the savings account). How much money should your friend put into his savings account to make sure that at the end of year 10, there is no money left there (i.e. the balance is zero) after all the owed payments on the student loan have been made? (Having $X would then allow your friend to replicate the payments due on the student loan with the cash available in the savings account.) f) How does $X relate to the NPV of paying back the loan today in part (c)? Why was 2% the appropriate discount rate to use in part (b) of the question. Question 3. Determine coupon bond from zero coupon bond prices Consider the following STRIPS prices: ½-year $99.5 1-year $99.25 1.5-year $98.75 2-year $98.25 For all parts of this question assume that coupons are paid semi-annually, and also use semi- annually compounded rates. a) Calculate the ½-, 1-, 1.5-, and 2-year spot rates. Plot them against time-to-maturity. b) Now price a 2-year 2.75% annual coupon Treasury note.
B8306 Fall 2023 Professor Xuelin Li Due Date: Fri, Sept 29 3 c) Calculate the yield of the bond in part (b). How does the yield of this bond compare to the spot rates? d) Now assume that you are pricing a risky (i.e. there is a small chance this bond will default) 2-year bond with an annual 2.75% coupon. You believe the risk of this bond warrants that it trade at a 200 basis point spread to the comparable Treasury yield. What will be the price of this risky 2-year bond? Question 4. 2s10s curve and economic growth The 2s10s curve measures the difference in yields between the 10- and the 2-year US Treasury bonds; 2s10s is positive when the 10-year yield is above the 2-year yield. It is common Wall Street folk wisdom that an inverted yield curve (i.e. when the 10-year yield is less than the 2-year yield, or the 2s10s is negative) forecasts recessions. We will measure the extent to which the US economy is near a recession by the year-over-year growth rate of real GDP. The purpose of this question is to test whether the 2s10s curve forecasts year-ahead GDP growth. a) Go to the fred.stlouisfed.org (FRED) website and download the 2s10s curve (search for the series called “ 10-Year Treasury Constant Maturity Minus 2-Year Treasury Constant Maturity ”). Make sure to choose the “Edit Graph” option and specify that you want this series to have quarterly end-of-period values. b) Now choose the “Add Line” options and search for “Real Gross Domestic Product.” Then choose “Edit Line 2” and under units choose the option “Percent Change from Year Ago.” Make sure this is also at a quarterly frequency. c) Now go to FRED’s “Download” butt on and download these two data series as an Excel or CSV file. When you download the raw data, replace the “.” (period) with a blank cell in Excel, to allow for plotting of the data. d) Now create a new column called “GDP +4” which for every date should hav e the 4-quarter ahead year-over-year percent GDP growth. Now plot a scatter plot of year-ahead GDP growth against the current 2s10s curve. e) Now add the best-fitting regression line to this scatter plot, and show the regression equation as well as the R-sq uared. Go to “Add Chart Element” “Trend Line” “Linear”. To add the regression equation and the R - squared, go to “Add Chart Element” “Trend Line” “More Trendline Options” and click on “Display Equation on chart” and “Display R -squared value on cha rt.” You may need to click on and drag the resulting legend box to a more visible part of the figure. f) Interpret the resulting graph. Is there evidence that an inverted 2s10s curve forecasts recessions as measured by GDP growth?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help