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

Using Excel 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 using excel and please show all formulas to answer questions A. B. and C. 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 MPT security. Suppose that they issue 150,000 shares of MPT security 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 MPT security? B. What is the price of each share of the MPT 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 MPT if there are a constant default rate of 1.5% every month (assuming the recovering rate is 50%) and no prepayment?
Please solve this and show step by step how to solve to answer questions A. B. and C. 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 MPT security. Suppose that they issue 150,000 shares of MPT security 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 MPT security? B. What is the price of each share of the MPT 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 MPT if there are a constant default rate of 1.5% every month (assuming the recovering rate is 50%) and no prepayment?
Please show step by step how to solve and all formulas. 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 MPT security. Suppose that they issue 150,000 shares of MPT security and the market interest rate is 6%. Questions A. Assume that there are no prepayment and no default, how much an investor would like to pay for each share of the MPT security? B. What is the price of each share of the MPT 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 MPT if there are a constant default rate of 1.5% every month (assuming the recovering rate is 50%) and no prepayment?
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?
In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, create a function that determines what your monthly payment will be.
Assume that a broker agent introduces you to a local bank, and that bank offers you their lowest interest rate at 3.25% APR, with a 10-year fixed interest rate or 20-year fixed interest rate. 1) If you want a 10-year, fixed mortgage loan, find the monthly mortgage payment for a house that you will borrow $500,000 with no down payment. 2) Determine the total amount paid over the full term of the loan. 3) How much interest will be paid on the loan over the 10 years?
Please show step by step how to solve and please show all formulas. 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%. Questions 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 briefly explain your findings.
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.
Your credit score is in the range of 720-739 and you want to buy a house in Davis (CA). You have 20% down payment to put on a house that has a market value of $450,000. a) Use www.bankrate.com website to identify the bank with the most convenient APR for your 30- year fixed mortgage and accordingly calculate your annual payment. Ignore external and additional costs in your calculation that may vary from one bank to another b) After 20 years of annual payment, how much you should pay in lump sum to your bank to end up all your debts. Ignore penalties or any other additional cost c) According to your finance, your maximum annual payment for your mortgage cannot exceed $24,000. Under this condition, how much should be your minimum down payment for your mortgage?
You plan to use a 15 year mortgage obtained from a local bank to purchase a house worth $124,000.00. The mortgage rate offered to you is 7.75%. You will make a down payment of 20% of the purchase price. a. Calculate your monthly payments on this mortgage. List in a spreadsheet the cash flow the bank expects to receive from you. Submit the spreadsheet with your answers. b. Calculate the amount of interest and principal for the 60th payment. Show your work. c. Calculate the amount of interest and principal to be paid on the 180th payment. Show your work. d. What is the amount of interest paid over the life of this mortgage?
Watch the video and then solve the problem given below. Click here to watch the video. You are considering a loan with an annual rate of 8%. The mortgage is $130,000 with 180 monthly payments of $1242.35 for 15 years. Complete the first two months of the amortization table. (Simplify your answers. Round to the nearest cent as needed.) Payment number Interest payment Principal payment Balance of loan 1