Question

In: Finance

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

(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(…), =FV(…), =PMT(…), =NPER(…), =RATE(…), =PRICE(…) or =YIELD(…) whenever applicable. Please show me the EXCEL functions that was used to help me better understand was equals what. Using Excel finance formulas

Case 3:

We find the data for a municipal bond issued by the Illinois state 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) is quoted as “4.280%” per year.    

(a) Based on the aforementioned settlement date, maturity date, coupon rate, coupon payment frequency and yield to maturity, what shall be the corresponding bond PRICE (relative to redemption par of 100)?

(b) Assumes that the Fed suddenly tightens its monetary policy now, causing interest rates to rise across financial markets. The aforementioned IL municipal bond’s yield-to-maturity also rises from 4.280% to “5.280%” per year. Will the bond PRICE go up or go down then? By how much?

(c) Assumes that the Fed suddenly loosens its monetary policy now, causing interest rates to rise across financial markets. The aforementioned IL municipal bond’s yield-to-maturity also drops from 4.280% to “3.280%” per year. Will the bond PRICE go up or go down 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 same direction”, negative association means “moving in the opposite directions”, while zero association means “one moves but the other does not get affected”.)

Solutions

Expert Solution

Formula sheet:


Related Solutions

(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(…), =FV(…), =PMT(…), =NPER(…), =RATE(…), =PRICE(…) or =YIELD(…) whenever applicable. Please show me the EXCEL functions that was used to help me better understand was equals what. Using Excel finance formulas You apply for a 20-year, fixed-rate (APR 6.48%) monthly-payment-required mortgage loan for a house selling for $150,000 today. Your bank requires 22% initial down payment of house value (to be paid in cash immediately),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) whenever applicable). Please show excel formulas. Given the following information for Bajor Co.: Debt: Bajor’s long-term debt capital consists of bonds with 6.250 percent coupon rate (semiannual coupon payments), 9 years time to maturity, and current price of 106.61 percent of its par value (i.e., price = 106.61 relative to full amount redemption par of 100). Preferred stock: Bajor has not...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) Case Two (22 pts) Given the following information for Bajor Co.: Debt: Bajor’s long-term debt capital consists of bonds with 6.250 percent coupon rate (semiannual coupon payments), 9 years time-to-maturity, and current price of 106.61 percent of its par value (i.e., price = 106.61 relative to full amount redemption par of 100). Preferred stock: Bajor has not issued any preferred stocks....
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) whenever applicable..) Ferengi, Inc. is subject to an applicable corporate tax rate of 21 percent, and the weighted average cost of capital (WACC) of 12.5 percent. There is no specific time constraint on investment project payback requirements. Q1: Ferengi is currently contemplating two capital investment plans. Plan A: the upgrade of an information system with an installed cost of $2,400,000. The...
use Excel Solver to answer the following question.You must provide sufficient evidence that you did the...
use Excel Solver to answer the following question.You must provide sufficient evidence that you did the work on your own. For example, what equations did you use in your model? How was the excel spread sheet laid out? A student at a local university has just completed a decision modeling course. On her assignments, she has earned a 86 on the mid-term, a 94 on the final, a 93 on problem sets, and 85 for participation. She has a unique...
Solve the following financial problems using the time value of money functions in Excel (PV, FV,...
Solve the following financial problems using the time value of money functions in Excel (PV, FV, PMT, NPER, RATE, EFFECT) OR using your financial calculator. Assume you deposit $3,000 today, and $300 at the end of each year, in an account earning 4% per year for 20 years. What is the future value? General Electric has an unfunded pension liability of $300 million that must be paid in 15 years. The CFO deposits $10 million in account today to help...
Solve the following financial problems using the time value of money functions in Excel (PV, FV,...
Solve the following financial problems using the time value of money functions in Excel (PV, FV, PMT, NPER, RATE, EFFECT) OR using your financial calculator. Assume you deposit $3,000 today, and $300 at the end of each year, in an account earning 4% per year for 20 years. What is the future value? General Electric has an unfunded pension liability of $300 million that must be paid in 15 years. The CFO deposits $10 million in account today to help...
In part 2 you will be creating multiple functions to calculate the present value. You may...
In part 2 you will be creating multiple functions to calculate the present value. You may be asking what a "present value" is. Suppose you want to deposit a certain amount of money into a savings account and then leave it alone to draw interest for some amount of time, say 12 years. At the end of the 12 years you want to have $15,000 in the account. The present value is the amount of money you would have to...
Please use Excel functions like PV A company is considering two capital budgeting projects. Each project...
Please use Excel functions like PV A company is considering two capital budgeting projects. Each project requires an initial outlay of $4,000,000. Cash inflows for each project are given in the table below. Each project has a life of 3 years. The company uses the NPV method to evaluate capital budgeting projects and its required rate of return is 9%. Here are the cash inflows from the projects. Project A         Project B         Year 1                                                 $1,900,000            0                Year 2                                                 $1,900,000           ...
As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash...
As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year 1 2 3 4 5 6 Payment 195 220 270 320 350 470 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT