Question

Clipboard Font Styles H4 А в L------ ------ - D E F ___G_ I . Assume the current interest rate on a 1-year Treasury bond (R) is 6.50 percent, the current rate on a 2-year Treasury bond (R) is 7.25 percent, and the current rate on a 3-year Treasury bond (R) is 8.50 percent. If the unbiased expectations theory of the term structure of interest rates is correct, what is the 1-year forward rate expected on Treasury bills during year 3, 3f,? (Do not round intermediate calculations. Round your answer to 2 decimal places.) 6.50% 7.25% 8.50% Complete the following analysis. Do not hard code values in your calculations. !---------3'1___ PPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP ... Sheet1 ... + READY | | | | | -- -+ 100% Attemptis) Hint

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

BOND - Microsoft Excel (Product Activation Failed) Add-Ins File Home Insert Page Layout Formulas Data Review View - 2x % Cut Calibri Dr General -11AA = = = A E E E Wrap Text FMerce Merge & Center - Center Σ AutoSum : A Fill 2 Sort & BI U D s $ % % 4.0 .00 88 Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles 2 Clear Filter Editing Find & Select Font Alignment Number Cells E Copy Paste Format Painter Clipboard G7 А for C в E F G H I J K L M E vouw 1R1 1R2 1R3 6.50% 7.25% 8.50% 14 15 2f1= 3f1 = CELL REFERENCES 8.01% (=(1+08)^2/(1+D7)^1 - 1] 11.04% (=((1+D9)^3/(1+D8)^2) - 1] FORMULA (1+1R2)^2/(1+1R1)^1 -1 (1+1R3)^3/(1+1R2)^2-1 18 19 20 HEM Rea CLEAN PRICE 510 BIDDING, UNDERWRITING EUAC AW LIFELP, IP, MRP, INFLATION WARRANT refund 54 55 56 57 58 BANKING NOTE 51 53 ferences 59 s11 Sheet: BOJ 140% - 0 2. B 9 * 40 ENG 30-11-2019