The following should be done in excel.

Question 1) You purchase a house for (see Column B) using a 30-year mortgage that makes monthly payments with an annualized interest rate of (see Column C)

How much are the monthly mortgage payments?

After (see Column D) number of years you refinance the remaining balance at a new lower interest rate (see column E)

How much are the new monthly mortgage payments? DONE

Question 2) You need to calculate the 1-year interest rates for 10 years using the yield to maturities for bonds of various terms to maturity (see Columns F to Column O) and liquidity premiums (see Column P to Column Y) provided under the Expectations Theory and Liquidity Premium Theory.

Question 3) Using the start year (see Column Z) and end year (see Column AA) plot the M1 money supply (see Column AC) and Monetary Base (see Column AD) on the same graph from January of the start year to December of the end year (see Column AB.) Comment on what happened to the money multiplier. Your comment should be included with the graph.

Question 4) Using the start year (see Column Z) and end year (see Column AA) plot the US Dollar to Euro exchange rate (see Column AE), the US Dollar to Australian Dollar exchange rate (see Column AF) and Canadian Dollar to US Dollar exchange rate (see Column AG) plot the value of the three currencies in terms of both US Dollar to Foreign Currency and Foreign Currency to US Dollar from January of the start year (see Column Z) to December of the end year (see Column AA) Comment on what happened to the value of the dollar compared to each currency. Your comment should be included with the graph

\fAA AD AE AF AG W Z AB AC R S observation_ LP 10 year Start year End year date M1SL AMBSL EXUSEU EXUSAL EXCAUS LP 3 year LP 4 year LP 5 year LP 6 year LP 7 year LP 8 year LP 9 year 0.917 0.5498 1.5502 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2002 2012 5/1/02 1189.3 692.751 0.10% 0.15%