Transcribed Image Text
What is the present value of a $15 million pool of 30-yearmortgages with an 10.5 percent per year monthly mortgage coupon ifmarket rates are 7 percent? The GNMA guarantee fee is 7 basispoints and the FI servicing fee is 43 basis points.a. Assume that the GNMA pass-through is fullyamortized.b. Assume that the GNMA pass-through is only halfamortized. Market rates are still 7 percent. If there is a lump sumpayment at the maturity of the GNMA pass-through that equals 60percent of the mortgage pool's face value, find the present valueof the pass-through.PLEASE PROVIDE EXCEL FORMULA SPELLED OUT TO ANSWER THESEPROBLEMS. SPECIFICALLY QUESTION B. I'm having trouble understandinghow to get the answer properly I understand how to get answerA.