PLEASE SHOW ALL WORK! PLEASE GET INFO FROM RECENT DATES AND DO NOT COPY AND PASTE OLD/PREVIOUS ANSWERS!

PLEASE PROVIDE A LINK OF WHERE YOU GOT YOUR NUMBERS/ANSWERS FROM, THANK YOU!

Qi Chi (15%) Go to the St. Louis Federal Reserve FRED database and find data on the three-month treasury bill rate (TB3MS), the three-month AA non-financial commercial paper rate (CPN3M), the 30-year treasury bond rate (GS30), the 30-year fixed rate mort- gage average (MORTGAGE30US), and the NBER recession indicators (USREC). For the mortgage rate indicator, set the frequency setting to 'monthly'. a. In general, how do these interest rates behave during expansionary periods? b. In general, how do the three-month interest rates compare to the 30-year rates? How do the Treasury rates compare to the respective commercial paper and mortgage rates? c. For the most recent available month of data, take the average of each of the three- month rates and compare it to the average of the three-month rates from January 2000. How do the averages compare? d. For the most recent available month of data, take the average of each of the 30-year rates and compare it to the average of the 30-year rates from January 2000. How do the averages compare? Q4 Ch 2 (20%) Go to the St. Louis Federal Reserve FRED database, and find data on federal debt held by the Federal Reserve (FDHBFRBN), by private investors (FDHBPIN), and by international and foreign investors (FDHBFIN). Using these series, calculate the total amount held and the percentage held in each of the three categories for the most recent quarter available. Repeat for the first quarter of 2000 and compare the results. Q7 Ch 4 (15%) Go to the St. Louis Federal Reserve FRED database, and find data on the interest rate on a four-year auto loan (TERMCBAUTO48NS). Assume that you borrow $20,000 to purchase a new automobile and that you finance it with a four-year loan at the most recent interest rate given in the database. If you make one payment per year for four years, what will the yearly payment be? What is the total amount that will be paid out on the $20,000 loan? Qi Chi (15%) Go to the St. Louis Federal Reserve FRED database and find data on the three-month treasury bill rate (TB3MS), the three-month AA non-financial commercial paper rate (CPN3M), the 30-year treasury bond rate (GS30), the 30-year fixed rate mort- gage average (MORTGAGE30US), and the NBER recession indicators (USREC). For the mortgage rate indicator, set the frequency setting to 'monthly'. a. In general, how do these interest rates behave during expansionary periods? b. In general, how do the three-month interest rates compare to the 30-year rates? How do the Treasury rates compare to the respective commercial paper and mortgage rates? c. For the most recent available month of data, take the average of each of the three- month rates and compare it to the average of the three-month rates from January 2000. How do the averages compare? d. For the most recent available month of data, take the average of each of the 30-year rates and compare it to the average of the 30-year rates from January 2000. How do the averages compare? Q4 Ch 2 (20%) Go to the St. Louis Federal Reserve FRED database, and find data on federal debt held by the Federal Reserve (FDHBFRBN), by private investors (FDHBPIN), and by international and foreign investors (FDHBFIN). Using these series, calculate the total amount held and the percentage held in each of the three categories for the most recent quarter available. Repeat for the first quarter of 2000 and compare the results. Q7 Ch 4 (15%) Go to the St. Louis Federal Reserve FRED database, and find data on the interest rate on a four-year auto loan (TERMCBAUTO48NS). Assume that you borrow $20,000 to purchase a new automobile and that you finance it with a four-year loan at the most recent interest rate given in the database. If you make one payment per year for four years, what will the yearly payment be? What is the total amount that will be paid out on the $20,000 loan