Please show how to solve this step by step to answer questions A. B. C. and D. The Green Bank originates a pool of containing 100 30-year fixed-rate mortgages with loan amount of $250,000 each. All mortgages in the pool carry a rate of 6.5% with monthly payments. The servicing fee is 0.05% each month. The Green Bank would like to sell the pool to investors via IO/PO Strips. Suppose that they issue 150,000 shares of IO/PO Strips and the market interest rate is 6%. A. Assume that there are no prepayment and no default, how much an investor would like to pay for each share of the IO/PO Strips? B. What is the price of each share of the IO/PO Strips if there are a constant prepayment rate of 1.5% every month and no default? C. What is the price of each share of the IO/PO Strips if there are a constant default rate of 1.5% every month (assuming the recovering rate is 50%) and no prepayment? D. Please explain your findings.

Please show how to solve this step by step to answer questions A. B. C. and D. The Green Bank originates a pool of containing 100 30-year fixed-rate mortgages with loan amount of $250,000 each. All mortgages in the pool carry a rate of 6.5% with monthly payments. The servicing fee is 0.05% each month. The Green Bank would like to sell the pool to investors via IO/PO Strips. Suppose that they issue 150,000 shares of IO/PO Strips and the market interest rate is 6%. A. Assume that there are no prepayment and no default, how much an investor would like to pay for each share of the IO/PO Strips? B. What is the price of each share of the IO/PO Strips if there are a constant prepayment rate of 1.5% every month and no default? C. What is the price of each share of the IO/PO Strips if there are a constant default rate of 1.5% every month (assuming the recovering rate is 50%) and no prepayment? D. Please explain your findings.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 15P

See similar textbooks

Similar questions

Use PMT= to determine the regular payment amount, rounded to the nearest dollar. The price of a home is $230,000. The bank requires a 20% down payment and three points at the time of closing. The cost of the home is financed with a 30-year foxed-rate mortgage at 6.5%. Complete parts (a) through (e) below. a. Find the required down payment. $ 46,000 b. Find the amount of the mortgage.
Please show how to solve this unsing excel and please show all formulas in the spreadsheet. You decide to buy a house with price of $500,000, You put 20% down payment and consider a 15-year fixed rate mortgage to pay the remaining balance. The lender offers you three choices of the mortgage with monthly payments shown in the table as a., b., and c. Assume that the origination cost is $8,000. A. If the loan will be outstanding for 15 years, what is the effective cost for each choice? Which choice is most ideal? explain? B. Which mortgage choices are not properly priced? explain?
Use an online loan calculator to determine the regular payment amount, rounded to the nearest dollar. The price of a home is $148,000. The bank requires a 20% down payment and three points at the time of closing The cost of the home is financed with a 30-year fixed rate mortgage at 85% Complete parts (a) through (e) below -CHEDD a. Find the required down payment $0 b. Find the amount of the mortgage How much must be paid for the three points at closing? (Round to the nearest dolar as needed) d. Find the monthly payment (excluding escrowed taxes and insurance) (Round to the nearest dollar as needed) e. Find the total cost of interest over 30 years (Round to the nearest dolar as needed)
You get hired by a residential mortgage lender to help them revamp their mortgage pricing models. They ask you to start by exploring three common client scenarios. First, they give you the “Second Lien Scenario.” In this scenario, a borrower goes to one of your competitors with the intention to buy a $1.2 million house. Your competitor gives them two options: • A 30-year, fully amortizing FRM with 80% LTV and an interest rate of 6.1%; or • A 20-year, fully amortizing FRM with 90% LTV and an interest rate of 6.8%. Next, the borrower comes to you and asks for a quote on a second lien (i.e. a junior loan) worth 10% LTV for 30 years. They want to price a scenario where they get the 80% LTV loan from your competitor and the 10% LTV loan from you instead of the 90% LTV loan from your competitor (in other words, paying for the same amount with two loans instead of one). 1. In order to be competitive, (a) what monthly payment and (b) what interest rate should you charge on this second lien?…
Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments are $989 per month, and the total finance charge is $9,504. After 25 months, you decide to pay off the loan. After calculating the finance charge rebate, find your loan payoff (in $). (Round your answer to the nearest cent.) Need Help? Read It Watch It Master It
Please show me how to solve this in excel using an excel spreadsheet and please show the excel formulas! Thank You! A house price of $100,000 can be financed with two loans below with monthly payments. The total origination cost associated with these two loans in the table attached is $3000. Alternatively, the borrower can borrow one loan in the amount of $90,000 with monthly payments and origination cost of $2,000. What should the interest rate be on the loan of $90,000 so that the borrower will be indifferent between these two choices?
Please solve via EXCEL and show table calculation functions used to get solutions. You are trying to talk your brother out of using one of those payday loan places. You told him that it would be a bad idea and you are explaining why. The loan is for $750 and it will be paid back in 12 days. He will have to pay them back $1100. If the company compounds every 12 days… What is the effective interest rate per year? What would you owe if you kept the money for 1 year?
Suppose you are buying your first condo for $190,000, and you will make a $10,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at 3.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be? You are not required to show calculations. However to receive credit you must provide the inputs used (N, PMT, FV, I/Y, PV) to solve. If you utilize a template, you can copy and paste the section used in the submission. $808.28 $853.18 $527.78
Suppose you need to borrow $200,000 to buy a home, and you are deciding between a 15 year mortgage and a 30 year mortgage. Research a bank offering 15 year and 30 year mortgage loans and find the interest rates on those loans. Use the techniques you learned in this Module to do the following: 1. Calculate the monthly payment for a 15-year mortgage and for a 30-year mortgage. 2. Find the total amount of interest you will pay on the 15 year mortgage and on the 30 year mortgage. 3. Describe some of the factors (financial and non-financial) that can influence whether to obtain a shorter term mortgage or a longer term mortgage. 4. Which mortgage would you take, the 15 year or the 30 year? Explain your decision.
please answer all subsets, I am trying to get an idea of how to do these types of proplems so I can do the remaing two loans for this project In this scenario, your financial institution is offering you a 30-year fixed mortgage with a 20% down payment at a 3.43% fixed rate. What is your monthly payment? Use technology or the monthly payment formula in your text to get the monthly payment for this loan. What is the total cost of the loan over 30 years? How much of this cost is interest? What is the total you will expect to pay at closing for this loan option? Closing costs must be paid before a bank will finance your loan. These costs include a fee to close, the down payment, and first month’s mortgage payment. Assume the fee to close a loan is $2700. What are the advantages of this loan? What are the disadvantages?
Please make an excel spreadsheet and show the formulas in the cells for the problem below and please explain You buy a house of $450,000 today. You put a down payment of 20% and borrow a fixed-rate mortgage of $360,000 with interest rate of 4% and 15 years. After 3 years, your house is appreciated to the value of $550,000 and market interest rate goes up to 6.5%. How much money will you make in book after 3 years?
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.