(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(…),...

80.2K

Verified Solution

Question

Finance

(For this part, you MUST present sufficient solution steps, andMUST apply specific Excel functions =PV(…), =FV(…),=PMT(…), =NPER(…), =RATE(…), =PRICE(…) or =YIELD(…)whenever applicable. Please show me the EXCEL functions that wasused to help me better understand was equals what. Using Excelfinance formulas
Case 3:
We find the data for a municipal bond issued by the Illinoisstate government.
The bond’s “last trade date” (i.e., settlement date) is June 05,2019.
The bond’s “maturity date” is March 14, 2054.
The bond’s “coupon rate” is fixed as “5.000%” per year.
The bond’s coupon “payment frequency” is “semi-annual”.
The bond’s “last trade yield” (i.e., yield-to-maturity) isquoted as “4.280%” per year.
(a) Based on the aforementioned settlement date, maturity date,coupon rate, coupon payment frequency and yield to maturity, whatshall be the corresponding bond PRICE (relative to redemption parof 100)?
(b) Assumes that the Fed suddenly tightens its monetary policynow, causing interest rates to rise across financial markets. Theaforementioned IL municipal bond’s yield-to-maturity also risesfrom 4.280% to “5.280%” per year. Will the bond PRICE go up or godown then? By how much?
(c) Assumes that the Fed suddenly loosens its monetary policynow, causing interest rates to rise across financial markets. Theaforementioned IL municipal bond’s yield-to-maturity also dropsfrom 4.280% to “3.280%” per year. Will the bond PRICE go up or godown then? By how much?
(d) Based on your answers to (b) and (c), is there a positive,negative or zero association between bond YIELD and its PRICE?(Hint: Positive association means “moving in the samedirection”, negative association means “moving in the oppositedirections”, while zero association means “one moves but the otherdoes not get affected”.)

Answer & Explanation Solved by verified expert

4.4 Ratings (970 Votes)

See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

(For this part, you MUST present sufficient solution steps, andMUST apply specific Excel functions =PV(…), =FV(…),=PMT(…), =NPER(…), =RATE(…), =PRICE(…) or =YIELD(…)whenever applicable. Please show me the EXCEL functions that wasused to help me better understand was equals what. Using Excelfinance formulasCase 3:We find the data for a municipal bond issued by the Illinoisstate government.The bond’s “last trade date” (i.e., settlement date) is June 05,2019.The bond’s “maturity date” is March 14, 2054.The bond’s “coupon rate” is fixed as “5.000%” per year.The bond’s coupon “payment frequency” is “semi-annual”.The bond’s “last trade yield” (i.e., yield-to-maturity) isquoted as “4.280%” per year. (a) Based on the aforementioned settlement date, maturity date,coupon rate, coupon payment frequency and yield to maturity, whatshall be the corresponding bond PRICE (relative to redemption parof 100)?(b) Assumes that the Fed suddenly tightens its monetary policynow, causing interest rates to rise across financial markets. Theaforementioned IL municipal bond’s yield-to-maturity also risesfrom 4.280% to “5.280%” per year. Will the bond PRICE go up or godown then? By how much?(c) Assumes that the Fed suddenly loosens its monetary policynow, causing interest rates to rise across financial markets. Theaforementioned IL municipal bond’s yield-to-maturity also dropsfrom 4.280% to “3.280%” per year. Will the bond PRICE go up or godown then? By how much?(d) Based on your answers to (b) and (c), is there a positive,negative or zero association between bond YIELD and its PRICE?(Hint: Positive association means “moving in the samedirection”, negative association means “moving in the oppositedirections”, while zero association means “one moves but the otherdoes not get affected”.)