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.

Use one of excel's TVM functions among =PV, =FV, =PMT, =RATE, =NPER, =CUMIPMT, =CUMPRINC answer this questions. (Please input the functions in excel and screeshot it )

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?

Please show all steps and formulas in an excel spreadsheet to answer a. through g. using the information below! You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?

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.

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

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?…

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)

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.