Question: With using Excel spreadsheet Consider a GNMA mortgage pool with principal of $20 million. The maturity is 30 years with a monthly mortgage payment of

With using Excel spreadsheet

  1. Consider a GNMA mortgage pool with principal of $20 million. The maturity is 30 years with a monthly mortgage payment of 10 percent per year. Assume no prepayments. (LG 24-4)

    1. What is the monthly mortgage payment (100 percent amortizing) on the pool of mortgages?

    2. If the GNMA insurance fee is 6 basis points and the servicing fee is 44 basis points, what is the yield on the GNMA pass-through?

    3. What is the monthly payment on the GNMA in part (b)?

    4. Calculate the first monthly servicing fee paid to the originating FIs.

    5. Calculate the first monthly insurance fee paid to GNMA.

please show formulas in excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Consider a GNMA mortgage pool with principal of $ 20 million. The maturity is 30 years with a monthly mortgage payment of 10 percent per year. Assume no prepayments. a. What is the monthly mortgage...

Q:

Consider a GNMA mortgage pool with principal of $20 million. The maturity is 30 years with a monthly mortgage payment of 10 percent per year. Assume no prepayments. (LG 24-4) A) What is the monthly...

Q:

Consider a GNMA mortgage pool with principal of $20 million. The maturity is 30 years with a monthly mortgage payment of 10 percent per year. Assume no prepayments. (LG 24-4) a. What is the monthly...

Q:

9. Consider a GNMA mortgage pool with principal of $20 million. The maturity is 30 years with a monthly mortgage payment of 10 percent per year. Assume no prepayments. (LG 24-4) a. What is the...

Q:

Chapter 24 problem 8, page 731. 8. Consider a GNMA mortgage pool with principal of $20 million. The maturity is 30 years with a monthly mortgage payment of 10 percent per year. Assume no prepayments....

Q:

Consider a GNMA mortgage pool with principal of $20 million. The maturity is 15 years with a monthly mortgage payment of 12 percent per year. Assume no prepayments. a. What is the monthly mortgage...

Q:

11. Consider a GNMA mortgage pool with principal of $20 million. The maturity is 30 years with a monthly mortgage payment of 10 percent per year. Assume no prepayments. a. What is the monthly...

Q:

Consider a GNMA mortgage pool with principal of $ 2 0 million. The maturity is 1 5 years with a monthly mortgage payment of 1 2 percent per year. Assume no prepayments. a . What is the monthly...

Q:

Consider a GNMA mortgage pool with principal of $ 2 0 million. The maturity is 1 5 years with a monthly mortgage payment of 1 2 percent per year. Assume no prepayments. a . What is the monthly...

Q:

1. Consider a GNMA mortgage pool with principal of $20 million. The maturity is 30 years with a monthly mortgage payment of 10 percent per annum. Assume no prepayments.

Q:

You are required to Work research, write, and present a research paper. You will apply in an actual or hypothetical scenario the framework learned from one of the topics studied during class. You...

Q:

In the text, we learned that workers displaced by import competition are eligible for compensation through the Trade Adjustment Assistance program. Firms are also eligible for support through Trade...

Q:

Which of the following statements regarding types / terms of leases is true? Percentage feases are most common for strip shopping centers. Prohibited use clauses are usually included in leases to...

Q:

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...