I have this question i struggled with along with few other similar questions. my teacher had excel set up for students but it seem confusing especially with dates. so i copied and pasted along with screenshot of excel so can you show me how to solve this from start to end and how to fill the boxes correctly so i can use this as a support aid to try to do other questions on my own.

Both bond bill and bond ted have 5.8& coupons, make semiannual payments, and are priced at par value. bond bill has 5 years to maturity while bond ted has 25 years to maturity. if interest rates suddenly rise by 2%, what is the percentage change in the price of bond bill and bond ted? both bonds have a pair value of $1,000. if raes in the price of bond bill be then? of bond ted? Illustrate your answers by graphing bond prices versus YTM. What does this problem tell you about the interest rate risk of longer-term bonds?

. . . X D13 X V fx A B C D E F G H I J K L M N O P Q R S 23 24 Output area: 25 26 27 Price of Bond Bill #NUM! 28 29 Price of Bond Ted #NUM! YTM and Bond Price 30 $2,500 31 % change in Bond Bill #NUM! 32 $2,300 33 % change in Bond Ted #NUM! 34 $2,100 35 All else same, the longer the maturity 36 of a bond, the greater is its price sensitivity $1,900 37 to changes in interest rates. 38 $1,700 39 Bond Bill 40 YTM Price $1,500 Bon 41 0% #NUM! Bond Price $1,300 Bon 42 1% #NUM! 43 2% #NUM! $1,100 44 3% #NUM! 45 4% #NUM! $900 46 5% #NUM! 47 6% #NUM! $700 48 7% #NUM! 49 8% #NUM! $500 50 9% #NUM! 0% 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 51 10% #NUM! Yield to Maturity 52 Chapter 6 #18 #19 #34 + : 0 D Type here to search O 9 W A X ENG 1:20 PM 10/19/2020\fAutoSave O Off) Ross_ECF_10e_EOC_Chapter_06_student - Excel O Search Bradley Persson BP X File Home Insert Page Layout Formulas Data Review View Help Share Comments Insert LO X Arial 12 ~ A A ab Wrap Text Percentage Ex AY O Conditional Format as Cell Delete * Paste BIU ~ E GEE Merge & Center $ ~ % " Sort & Find & Ideas Sensitivity Formatting Table Styles ~ Format Filter * Select v Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity D13 X V A B C D E F G H J K L M N O P Q R S W Input area. Bond Bill: Coupon rate 5.8% Settlement date 10 Maturity date 11 Redemption (% of par) 12 # of coupons per year 13 14 Bond Ted: 15 Coupon rate 5.8% 16 Settlement date 17 Maturity date 18 Redemption (% of par) 19 # of coupons per year CH Chart Area 20 21 Change in interest rate 22 23 24 Output area. 25 Chapter 6 #18 #19 #34 Ready + 100% Type here to search O 7 9 W X A PDX ENG 1:19 PM 10/19/2020