Calculate the cash flows for the following CMO with sequential pay tranches. Consider that the payments...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Calculate the cash flows for the following CMO with sequential pay tranches. Consider that the payments into the pool from mortgage borrower occur annually and that there is no prepayment. These mortgages are all FHA mortgages; all are fully amortizing mortgages with a maturity of 5 years and an interest rate of 11%. Assume that Tranche Zs interests are allocated to paid Tranches A and B until principal in A and B get fully paid. (15 points) Coupon Rate Amount Issued Assets Mortgages 6- year interest 5-year maturity $75,000,000 Total Assets $75,000,000 Liabilities Class A Bond Class 2 Bond Class B Bond 2-4 years Total Bonds Maturity Equity 1-3 years 9.25% 4-5 years Total Debt and net worth 10% 11% 1. Calculate the weighted average coupon rate of this deal. (1 points) 2. Calculate the Loan Schedule for the mortgage pool (3 points) 3. Calculate the cash flow for Tranches A, B and Z. (6 points) $27,000,000 $15,000,000 $30,000,000 $62,000,000 $3,000,000 $65,000,000 4. Calculate the cash flow for the residual class (Equity position). (3 points) 5. Calculate the IRR of the residual class. (2 points) Calculate the cash flows for the following CMO with sequential pay tranches. Consider that the payments into the pool from mortgage borrower occur annually and that there is no prepayment. These mortgages are all FHA mortgages; all are fully amortizing mortgages with a maturity of 5 years and an interest rate of 11%. Assume that Tranche Zs interests are allocated to paid Tranches A and B until principal in A and B get fully paid. (15 points) Coupon Rate Amount Issued Assets Mortgages 6- year interest 5-year maturity $75,000,000 Total Assets $75,000,000 Liabilities Class A Bond Class 2 Bond Class B Bond 2-4 years Total Bonds Maturity Equity 1-3 years 9.25% 4-5 years Total Debt and net worth 10% 11% 1. Calculate the weighted average coupon rate of this deal. (1 points) 2. Calculate the Loan Schedule for the mortgage pool (3 points) 3. Calculate the cash flow for Tranches A, B and Z. (6 points) $27,000,000 $15,000,000 $30,000,000 $62,000,000 $3,000,000 $65,000,000 4. Calculate the cash flow for the residual class (Equity position). (3 points) 5. Calculate the IRR of the residual class. (2 points)
Expert Answer:
Answer rating: 100% (QA)
1 Calculate the weighted average coupon rate of this deal The weighted average coupon rate is calculated by taking the sum of the products of the amounts of each bond and its coupon rate and then divi... View the full answer
Related Book For
Essentials of Business Analytics
ISBN: 978-1285187273
1st edition
Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams
Posted Date:
Students also viewed these finance questions
-
A $10,000 loan amortized over 5 years at an interest rate of 10% per year requires payments of $2638 to completely remove the loan when interest is charged on the unrecovered balance of the...
-
Following are the cash flows for three investments (originally presented in end-of-chapter problem 25) that actually occur at the beginning of each year rather than at the end of each year. a. Find...
-
The cash flows for two small raw water treatment systems are shown. Determine which should be selected on the basis of an annual worth analysis at 10% per yearinterest. MF UF First cost, S Annual...
-
Let S be the portion of the cylinder y = e x in the first octant that projects parallel to the x-axis onto the rectangle R yz : 1 y 2, 0 z 1 in the yz-plane. Let n be the unit vector normal to S...
-
The following transactions were incurred by Howley Fabricators during January, the first month of its fiscal year. Requirements 1. Record the proper journal entry for each transaction. a. $ 180,000...
-
Why do some companies in a given industry, like eCourier above, adopt and deploy innovative technologies while others in the same line of business do not? Break into small groups with your classmates...
-
Refer to the information in Problem 21-1B. Tohono Companys actual income statement for 2017 follows. Required 1. Prepare a flexible budget performance report for 2017. Analysis Component 2. Analyze...
-
The budget director of Royal Furniture Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning...
-
Assume a simultaneous open market purchase of 100 million from the Bank of England and a repayment of a discount loan of 5 million from Bank A to the Bank of England. Show the overall change in their...
-
Implement the following LP problem in a spreadsheet. Use Solver to solve the problem and create a Sensitivity Report. Use this information to answer the following questions: MAX: 4X1 + 2X2 Subject...
-
How can training stakeholder scorecard and balanced scorecard be applied to HRD and training?
-
Javier Martinez's (63) filing status is Single. His Form SSA-1099 is shown. In addition he received the following income: Taxable pension $19,217, wages from a part-time job $4,773, for a total of...
-
A rectangular box is h = 19.5 inches in high, w = 29.5 cm wide, and L = 1.3 yards long. What is the volume of the box in cubic feet? V=
-
Account Balance as of December 31 220210 Production Machinery, Equip & Fixtures (Dir.Post) 915,000 220310 Accumulated Depreciation-Machinery (Direct Post) 305,000 CSI Barcode system and installation...
-
Organizations often have two portfolios in the heavy construction machinery and mining equipment industry: an explore portfolio and an exploit portfolio. The explore portfolio focuses on innovative...
-
As the engineering manager, what steps would you take to collect relevant financial data and prepare the operational budget for your division? Explain how you would ensure accuracy and completeness ?
-
My Sister's company's required return on debt is 4.5%, and her tax rate is 20%, plus there is a required return on equity is 9%. If the company has 20 billion dollars of debt and has a book equity is...
-
Which one of the following anhydrous chloride is not obtained on direct heating of its hydrated chloride? (A) BaCl2 (B) CaClz (C) MgCl2 (D) SrCl2
-
A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last...
-
In 2011, home prices and mortgage rates fell so far that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent for...
-
A Wall Street Journal subscriber survey asked 46 questions about subscriber characteristics and interests. State whether each of the following questions provides categorical or quantitative data. a....
-
A firm is looking to locate its production facilities in one of two countries. The wage rate in Country 1 is 10 and the cost of capital is also 10 . The wage rate in Country 2 is \(20 \%\) higher,...
-
While processes differ somewhat among the three main manufacturers of cricket balls in international matches, all top-quality cricket balls are handcrafted to exacting specifications and standards....
-
Governments may use, and have used, wage subsidies to reduce unemployment in times of economic recession. For example, from January to August 2009, Mexico provided wage subsidies to certain firms in...
Study smarter with the SolutionInn App