Question: Please help with excel formulas Question 5: Suppose 5 years have passed since the MPTS in Question 4 was originated and the prepayment expectation was
Please help with excel formulas

Question 5: Suppose 5 years have passed since the MPTS in Question 4 was originated and the prepayment expectation was correct and will continue to be correct for the next 5 years. What is the value of the pool if investors today require a return of 6% annual return after a monthy service fee of 0.1% is deducted and the monthly prepayment rate is 0.1% ? Required Return Price Question 6: What is Blue Green Algae's net profit in Question 1 above if the originator's operating expenses total $150,000? Cash from investor Cash to borrowers Operating expenses Net profit Question 5: Suppose 5 years have passed since the MPTS in Question 4 was originated and the prepayment expectation was correct and will continue to be correct for the next 5 years. What is the value of the pool if investors today require a return of 6% annual return after a monthy service fee of 0.1% is deducted and the monthly prepayment rate is 0.1% ? Required Return Price Question 6: What is Blue Green Algae's net profit in Question 1 above if the originator's operating expenses total $150,000? Cash from investor Cash to borrowers Operating expenses Net profit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
