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

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.

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, use the PMT function to determine what your monthly payment will be.  Submit the spreadsheet in Canvas.

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?

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?

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?

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?

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?