Imagine you are working at a mortgage-backed securities (MBS…

Imagine you are working at a mortgage-backed securities (MBS) desk at an investment bank. A housing finance company has just securitized a pool of mortgages, and you are tasked with valuing the pass-through security that investors will buy. The deal contains [number] identical [year]-year fixed-rate mortgages, each with a balance of $100,000 and a [coupon]% annual coupon. Assume the following: Constant prepayment rate (CPR) = [cpr]% annually. Risk-free discount rate = [rf]%. No default risk (only prepayments).   Task:Estimate the value of the MBS.   Please round your answer to the nearest two decimals. Do not type the $ symbol.

An hour passed and the meeting is still going on. There are…

An hour passed and the meeting is still going on. There are multiple reports over the table, and differences of opinion start arising. The discussion revolves around a series of plain-vanilla bonds that were priced using a volatility assumption of [vol]%. You recall that the volatility assumption implies we acknowledge uncertainty about future interest rates, and very soon you notice the conventional binomial lattice used in that case. Peter is also looking at the report and mentions that 1-year forward rate starting one year from now in the good state of the world is now missing. He asks you: “Can you estimate it?” Face Value: $100.00 Spot Rate Today: [spot0a]% Forward Rate 1-year duration, starting 1-year from today (Node C): [f11c]% Volatility: [vol]%   *Round your answer to the nearest three decimals if needed. *Type your answer in percentage and not in decimals (i.e. 5.2 and not 0.052). Do not type the % symbol.

Opening the Excel Spreadsheet: Click on the arrow next to th…

Opening the Excel Spreadsheet: Click on the arrow next to the file below. Next, create a new sheet in the Respondus LockDown Browser spreadsheet. You can use this blank spreadsheet to calculate the answer. Make the column you are using as wide as possible. Otherwise, you might be seeing only the last decimals. Blank Spreadsheet-1.xlsx Blank Spreadsheet-1.xlsx

The first round of negotiations will begin in approximately…

The first round of negotiations will begin in approximately 45 minutes. You are excited about the opportunity to participate in the discussions. Moreover, your supervisor informs you that you will be leading the conversation if the topic of funding comes up. More precisely, you should advise the investments team on whether long term borrowing vs. short term borrowing is preferrable under the current market conditions. You recall that forward rates should provide a rough idea on whether markets expect rates to move up or down. Luckily, you have now obtained all the current spot rates listed below, so estimating forward rates is rather straightforward:  1-year spot rate: [spot1] 2-year spot rate: [spot2] 3-year spot rate: [spot3] 4-year spot rate: [spot4] 5-year spot rate: [spot5] 6-year spot rate: [spot6] 7-year spot rate: [spot7] 8-year spot rate: [spot8]   For your potential intervention during the meeting, you consider that the [length]-year forward rate starting at year [start] is the best proxy to make a recommendation.    After some calculations, you find that the [length]-year forward rate starting at year [start] is exactly ________.   Round your answer to the nearest three decimals if needed. Type your answer in percentage and not in decimals (i.e. 5.212 and not 0.052). Do not type the % symbol.  

The morning round of negotiations concludes, and everyone wi…

The morning round of negotiations concludes, and everyone will reconvene in the afternoon. By now, you have become a reliable participant in the meetings, especially for quick, precise calculations. Nancy, one of your colleagues, gives you a heads-up that the afternoon session will be shorter and focused on swaps. Although you have not received significant training in swaps, you understand that the pricing principles should be similar to those for other fixed-income instruments. You go over the data that will be used in the afternoon session, and you give it a try at calculating the price of an interest-rate-swap price, as a starting point. You are familiar with par rates, so you know that the calculation is exactly the same.   Please provide your answer as percentage and not as decimal (i.e. 5.2% and not 0.052). Please round to the nearest three decimals if needed. TTM DF 1yr [pvf1] 2yr [pvf2] 3yr [pvf3] 4yr [pvf4]