Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Ryan Berg RB Search AutoSave . Off MB excel project-Spring 2021 sec2 - Saved . Share Comments File Home Insert Page Layout Formulas Data Review View Help & Cut ~ 10 ~ A A = = = 2h Wrap Text Genera Normal Bad Good Neutral Calculation [ AutoSum ~ AY O Arial Fill [B) Copy Input Sort & Find 8 Analyze Paste IU. BLA. BEE EE Merge & Center " $ ~ % 9 00 0 Conditional Format as Check Cell Explanatory ... Followed Hyp. Hyperlink Insert Delete Format Clear Filter ~ Select Data Format Painter Formatting " Table Analysis Number Styles Cells Editing Clipboard Font lignment A42 X v fx M P Q R U W B D G H LP 9 year LP 10 year YTM 4 year YTM 5 year YTM 6 year YTM 7 year YTM 8 year YTM 9 year YTM 10 year LP 1 year LP 2 year LP 3 year LP 4 year LP 5 year LP 6 year LP 7 year LP 8 year 1 Student ID House Price Rate 1 Years Rate 2 YTM 1 year YTM 2 year YTM 3 year 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 4.30% 4.60% 4.75% 805415364 $300,000 15.00% 6.00% 2.25% 2.50% 3.00%% 3.40% 3.80% 4.00% 0.00% 0.10 .20% 0.30% 0.40% .50% 0.60% 0.70% ).80% 0.90% $350,000 16.00% 9 8.00% 5.00% 5.25% 5.75% 6.00% 6.20% 6.40% 6.80% 7.00% 7.30% 7.80% 805287285 4.75% 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.30% 0.35% 0.40% 0.45% 805966831 $400,000 18.00% 9.00% 2.25% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% 4.60% 6.40% 5.80% 7.00% 7.30% .80% 0.00% 0.10% .20% 0.30% 0.40% 0.50% .60% 0.70% 0.80% 0.90% 805749243 $450,000 15.009 9 12.00% 5.00% 5.25% 5.75% 6.00% 6.20% 0.45% 3.40% 3.80% 4.00% 4.30% 4.60% .75% 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 805806153 $500,000 16.00% 6.00% 2.25% 2.50% 3.00% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% .90% 8.00% 5.00% 5.25% 5 75% 6.00% 6.20% 6.40% 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 805573956 $300,000 18.00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 805482809 $350,000 15.00% 9.00% 2.25% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% 4.60% 4.75% 5.00% 0.00% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 12.00% 5.25% 5.75% 6.00% 6.20% 6.40% 6.80% 7.00% 7.30% 7.80% 305466492 $400,00 16.00% 9 5.00% .00% 0.00% 0.05% .10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 805995895 $450,000 18.00% 6.00% 2.25% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% 4.60% 1.75% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 805965760 $500,00 15.009 8.00% 5.00% 5.25% 5.75% 6.00% 6.20% 6.40% 6.80% 7.00% 7.30% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% 4.60% 4.75% 5.00% 0.00% 0.05% 0.10% 0.15% 805967580 $300,000 16.00% 9.00% 2.25% 7.80% 0.00% 0.10% 0.20% 0.30% .40% 0.50% 0.60% 0.70% 0.80% 0.90% 804544298 $350,000 6.40% 6.80% 7.00% .30% 18.00% 12.00% 5.00% 5.25% 5.75% 6.00% 6.20% 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.30% 0.35% 0.40% 0.45% 805807798 $400,000 15.00% 6.00% 2.25% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% 4.60% 4.75% 0.50% 0.60% 0.70% 0.80% 0.90% 8.00% 5.00% 5.25% 5.75% 6.00% 6.20% 6.40% 6.80% 7.00% 7.30% .80% 0.00% 0.10% .20% 0.30% 0.40% 805710603 $450,00 16.00% 0.20% 0.35% 0.40% 0.45% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% 1.60% 4.75% 5.00% 0.00% 0.05% 0.10% 0.15% 0.25% 0.30% 805763810 $500,000 18.00% 9.00% 2.25% 0.00% 0.20% 0.50% 0.60% 0.90% 0.10% 0.30% 0.40% 0.70% 0.80% 805735383 $300,000 15.00% 12.00% 5.00% 5.25% 5.75% 6.00% 6.20% 6.40% 6.80% 7.00% 7.30% 7.80% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 18 804678299 $350,000 16.00% 6.00% 2.25% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% .60% 1.75% 5.00% 0.00% 0.20% 0.30% 0.40% 0.60% 0.70% 0.80% 0.90% $400,000 18.00% 8.00% 5.00% 5.25% 5.75% 6.00% 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 805966278 6.20% 5.40% 5.00% 0.00% 0.05% 0.10% .15% 0.20% 0.259% 0.30% 0.35% 0.40% 0.45% $450,000 15.00% 2.25% 2.50% 3.00% 3.40% 805813433 9.00% 3.80% 4.00% 4.30% 4.60% 4.75% 6.40% 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 805729363 $500,000 16.00% 12.00% 5.00% 5.25% 5.75% 6.00% 6.20% 0.30% 0.35% 0.40% 0.45% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% 4.60% 4.75% 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.25% 80596340 $300,000 18.00% 6.00% 2.25% 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% .40% 0.50% 0.60% 0.70% 0.80% 0.90% 805773211 $350,000 15.00% 8.00% .00% 5.25% 5.75% 6.00% 6.20% 6.40% 0.35% 0.40% 0.45% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% 4.60% 4.75% 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.30% 805212056 $400,000 16.00% 9.00% 2.25% 0.50% .60% 0.70% 0.80% 0.90% 5.00% 5.25% 5.75% 6.00% 5.20% 6.40% 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% .20% 0.30% 0.40% 805929185 $450,00 18.00% 12.00% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 6.00% 2.25% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% 1.60% 4.75% 5.00% 0.00% 0.05% 0.10% 0.15% 805757713 $500,000 15.00% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 804704248 $300,000 16.00% 8.00% 5.00% 5.25% 5.75% 6.00% 6.20% 6 40% 6.80% 7.00% 7.30% 7.80% .75% 0.00% 0.05% 0.10% 0.15% 0.20% 4.30% 500% 0.25% 0.30% 0.35% 0.40% $350,000 9.00% 2.25% 2.50% 3.00% 3.40% 3.80% 4.00% .60% 805959061 8.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 805541168 $400,000 15.00% 12.00% 5.00% 5.25% 5.75% 6.00% 6.20% 6.40% 6.80% 7.00% 7.30% 7.80% 0.00% 0.45% 3.40% 3.80% 4.00% 4.30% 4.60% 4.75% 5.00% 0.00% 0.05% .10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 05962638 $450,000 16.00% 6.00% 2.25% 2.50% 3.00% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 6.20% 6.40% 6.80% 7.00% 7.30% 7.80% 805392838 $500,000 18.00% 8.00% 5.00% 5.25% 5.75% 6.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 4.00% 4.30% 4.60% 4.75% 5.00% 805486603 $300,000 15.00% 9.00% 2.25% 2.50% 3.00% 3.40% 3.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 805395848 $350,000 16.00% 12.00% .00% 5.25% 5.75% 6.00% 6.20% 6.40% 6.80% 0.35% 0.40% 0.45% 4.75% 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 800745315 $400,000 18.00% 6.00% 2.25% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% 4.60% 0.90% 5.75% 6.00% 6.20% 6.40% 5.80% 7.00% 7.30% 7.80% 0.00% 0.10% .20% 0.30% 0.40% 0.50% .60% 0.70% 0.80% 05404031 $450,00 5.00% 8.00% 5.00% 5.25% 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% $500,000 16.00% 9.00% 2.25% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% 4.60% 4.75% 0.90% 805599737 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 805766113 $300,000 18.00% 12.00% 5.00% 5.25% 5.75% 6.00% 6.20% 6.40% 6.80% 7.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 4.00% 4.30% .60% 1.75% 5 00% 805995860 $350,000 15.00% 6.00% 2.25% 2.50% 3.00% 3.40% 3.80% 0.40% 0.50% 0.70% 0.80% 0.90% 8.00% 5.00% 5.25% 5.75% 6.00% 6.20% 6.40% 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.60% 0.45% 805694076 $400,000 16.00% 0.25% 0.30% 0.35% 0.40% 9.00% 2.25% 2.50% 3.00% 3.40% 3.80% 4.00% 4.30% 4.60% 4.75% 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 805764244 $450,000 18.00% 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 805660574 $500,000 15.00% 12.00% 5.00% 5.25% 5.75% 6.00% 6.20% 5.40% 47 48 49 50 data 100% 8:29 PM 1 0 / 4)) 5/14/2021 9 SearchAutoSave . Off MB excel project-Spring 2021 sec2 - Saved . Search Ryan Berg RB Share Comments File Home Insert Page Layout Formulas Data Review View Help & Cut [ AutoSum ~ AY Arial * 10 AA = = = 24 Wrap Text Genera Normal Bad Good Neutral Calculation O Fill [)Copy Insert Delete Format Analyze $ ~ % 9 60 28 Conditional Format as Check Cell Explanatory ... Followed Hyp. Hyperlink Input Sort & Find 8 Paste IU. BLA. BEE E Merge & Center Clear Filter ~ Select Data Format Painter Formatting " Table Cells Analysis Clipboard Font lignment Number Styles Editing A42 X v fx AD AE A AG AH Al AJ M N O P Q R S W AA AB AC LP 4 year LP 5 year LP 6 year LP 7 year LP 8 year LP 9 year LP 10 year Start year End year observation_date M1SL AMBSL EXUSEU EXUSAL EXCAUS 1 YTM 7 year YTM 8 year YTM 9 year YTM 10 year LP 1 year LP 2 year LP 3 year 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2002 2012 1/1/200 1122.2 618.603 1.0131 0.656 1.4486 4.30% 4.60% .75% 5.00% 0.00% 2013 602.285 0.9834 0.6278 .4512 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% .50% 0.60% 0.70% 0.80% 0.90% 2003 /1/200 1108.6 0.45% 2014 3/1/2000 107.5 600.018 0.9643 0.6094 1.4608 4.30% 4.60% 4.75% 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.30% 0.35% 0.40% 2004 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% .80% 0.90% 2005 2015 1/1/2000 1115.6 601.78 0.9449 0.596 1.4689 6.80% 7.00% 7.30% 7.80% 0.00% .10% 2002 5/1/2000 604.233 .4957 2012 104.9 0.9059 0.5784 4.30% 1.60% 1.75% 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 0.5949 1.477 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 2003 2013 5/1/2000 102.6 605.473 0.9505 0.05% 0. 15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2004 2014 7/1/2000 1103.5 606.453 0.9386 0.587 4778 4.30% 1.60% 4.75% 5.00% 0.00% 0.10% 0.9045 0.5808 1.4828 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 2005 2015 8/1/2000 100.2 05.65 0.00% 0.05% .10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2002 012 9/1/200 1099.7 606.40 0.8695 0.5521 1.4864 4.30% .60% 4.75% .00% 0.8525 0.528 1.5125 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% .80% 0.90% 2003 2013 10/1/200 1098.7 610.390 0.05% 0 10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2004 2014 0.8552 0.5218 1.5426 4.30% 4.60% 1.75% 5.00% 0.00% 1/1/2000 1092.4 611.281 2015 1088.6 12.76 0.8983 0.5466 1.5219 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% .40% 0.50% 0.60% 0.70% .90% 2005 12/1/2000 0.05% 0.10% 0.15% 0.20% 0.30% 0.35% 0.40% 0.45% 2002 2012 1/1/2001 1096.7 616.736 0.9376 0.5552 1.5032 4.30% 4.60% 4.75% 5.00% 0.00% 2013 2/1/200 101.2 619.42 0.9205 0.5338 1.5216 6.80% 7.00% 7.30% .80% 0.00% .10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 180% 0.90% 2003 .00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% .40% 0.45% 2004 2014 3/1/2001 108.9 622.211 0.9083 0.5031 1.5587 4.30% 4.60% 4.75% 5.00% 1.5578 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 200 2015 1/1/2001 1116.7 625.428 0.8925 0.5016 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2002 2012 5/1/2001 1118.5 630.352 0.8753 0.5199 1.5411 4.30% .60% 1.75% 5.00% 0.00% 0.853 0.518 1.5245 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 2003 2013 5/1/2001 1126.2 632.623 0.8615 0.5089 1.5308 4.30% 1.60% 4.75% .00% 0.00% .05% .10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2004 2014 7/1/2001 138.9 638.380 .80% 0.90% 2005 2015 8/1/2001 1150.2 645.828 0.9014 0.5246 1.5399 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 1.75% 0.00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2002 2012 9/1/2001 1205.7 671.483 0.9114 0.5036 1.5679 4.30% 4.60% 5.00% 0/1/200 0.905 0.5042 .5717 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 2003 2013 1165.7 563.791 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2004 2014 1 1/1/2001 1171.0 561.227 0.8883 0.5165 1.5922 4.30% 4.60% 4.75% 5.00% 0.00% 0.05% 0.10% 0.8912 0.5138 1.5788 6.80% 7.00% 7.30% .80% 0.00% .10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 180% 0.90% 2005 2015 2/1/2001 183.2 665.580 0.517 1.5997 4.30% 4.60% 4.75% 5.00% .00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2002 2012 1/1/2002 190.7 673.731 0.8832 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 2003 2013 2/1/2002 1190.6 681.875 0.8707 0.5128 1.5964 0.05% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2004 2014 3/1/2002 1193.3 685.137 0.8766 0.5256 .5877 4.30% .60% 1.75% 5 00% 0.00% 0.10% 0.15% 0.90% 2005 2015 4/1/2002 1186.9 38.997 0.886 0.5352 1.5815 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.917 0.5498 1.5502 4.30% 1.60% 4.75% 5.00% 0.00% 0.05% .10% .15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2002 2012 5/1/2002 189.3 92.75 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 2003 2013 6/1/2002 1193.3 697.001 0.9561 0.5682 1.5318 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 7/1/2002 1199.1 700.996 0.9935 0.5538 1.5456 4.30% 4.60% 1.75% 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2004 2014 0.9781 0.5413 .5694 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 2005 2015 8/1/2002 1187.1 702.801 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2002 2012 9/1/2002 196.1 04.27 0.9806 0.5465 1.5761 4.30% 4.60% 4.75% 5.00% 0.00% 6.80% 7.00% 7.30% .80% 0.00% .10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 180% 0.90% 2003 2013 0/1/2002 204.0 710.710 0.9812 0.5502 1.578 2014 712.616 1.0013 0.5613 1.5715 4.30% 4.60% 4.75% 5.00% ).00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2004 11/1/2002 1209.6 0.90% 200 2015 12/1/2002 1220.2 714.044 1.0194 0.5624 37 0.70% 1.5592 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.80% 0.40% 2002 2012 1/1/2003 1227.3 719.608 1.0622 0.5829 1.5414 4.30% 1.60% 1.75% 5 00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.45% 2/1/2003 728.914 1.0785 0.5956 1.5121 6.80% 7.00% 7.30% 7.80% 0.00% 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 2003 2013 1238.2 .6015 .476 4.30% 4.60% 4.75% 5.00% 0.00% 0.05% 0.10% 0.15% 0.20% 0.25% 0.30% 0.35% 0.40% 0.45% 2004 2014 3/1/2003 1239.3 32.459 1.0797 41 0.10% 0.20% 0.30% 0.40% 0.50% 0.60% 0.70% 0.80% 0.90% 2005 2015 1/1/2003 1250.0 736.665 1.0862 0.61 .4582 6.80% 7.00% 7.30% 7.80% 0.00% 5/1/2003 1268.8 738.86 1.1556 1.384 42 6/1/2003 1281.0 739.918 1.1674 0.6652 .3525 741.596 0.6607 4 4 /1/2003 1287.5 1.1365 3821 3/1/2003 1296.4 745.667 1.1155 0.6518 1.3963 9/1/2003 1297.2 745.839 1.1267 0.663 1.3634 10/1/2003 1297.8 53.935 1.1714 0.6948 1.3221 47 11/1/2003 1299.1 54.991 1.171 0.7158 1.313 48 2/1/2003 1306.2 752.960 1.2298 0.7391 1.3128 49 1/1/2004 1306.0 756.82 1.2638 0.7717 1.2958 50 2/1/2004 1321.4 763.246 1.264 0.777 .3299 3/1/2004 1328.7 64.406 1.2261 0.7496 1.3286 4/1/2004 1332.8 768.08 1989 0.7443 1.342 5/1/2004 1333.3 770.188 1.2 0.7039 1.3789 1242 7 data O U -- 100% 8:30 PM ~ 0 ( 4 5/14/2021 9 SearchAutoSave . Off MB excel project-Spring 2021 sec2 - Saved . Search File Home Insert Page Layout Formulas Ryan Berg RB Data Review View Help & Cut Share Comments [a Copy Arial 10 ~ AA = = = ah Wrap Text Genera Normal Bad Good Paste Neutral Calculation [ AutoSum ~ AY O Format Painter IU. BLA. BEE E Merge & Center " $ ~ % " 60 $8 Conditional Format as Check Cell Fill Formatting * Table v Explanatory ... Followed Hyp.. Hyperlink Input Insert Delete Format Sort & Find & Analyze Clipboard Clear Filter ~ Select Data Font lignment Number Styles Cells Editing Analysis A42 x v fx M N O P Q 41 R S 6.80% 7.00% U V W 7.30% 7.80% 0.00% 0.10% 0.20% AA 0.30% B 42 0.40% AC AD AE 0.50% AF 0.60% 0.70% 0.80% 0.90% AG AH Al AJ 2005 2015 4/1/2003 1250.0 736.665 1.0862 0.61 1.4582 43 5/1/2003 1268.8 738.86 1.1556 0.6468 1.384 4 4 5/1/2003 281.0 39.918 1.1674 0.6652 .3525 /1/2003 287.5 741.596 1.1365 0.6607 1.3821 8/1/2003 1296.4 745.667 47 1.1155 0.6518 1.3963 9/1/2003 1297.2 45.839 48 1. 1267 0.663 1.3634 10/1/2003 1297.8 53.935 1.1714 0.6948 1.3221 49 11/1/2003 1299.1 54.991 1.171 0.7158 1.313 12/1/2003 1306.2 752.960 1.2298 0.7391 1.3128 1/1/2004 1306.0 756.824 1.2638 0.7717 1.2958 2/1/2004 1321.4 76.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Macroeconomics Principles and Applications

Authors: Robert E. Hall, Marc Lieberman

6th edition

1111822352, 1111822354, 9781133708742 , 978-1111822354

More Books

Students also viewed these Economics questions