please answer highlighted cells in question 5 and 6 with excel formulas!

B D F H 1 MPTS Excel Assignshent 2 The Blue Algae Mortgage Company has originated a pool containing 75 ten-year fixed rate mortgages with an 3 average balance of $100,000 each with 1% origination fee. The annual interest rate on all loans in the pool is 4 12% and all loans require monthly payments. 7 Inital Pool Balance 8 Annual Interest Rate 9 Maturity (years) 10 Payments per year 11 523 524 Question 5: Suppose 5 years have passed since the MPTS in Question 4 was originated and the prepayment 525 expectation was correct and will continue to be correct for the next 5 years. What is the value of the pool if 526 investors today require a return of 6% annual return after a monthy service fee of 0.1% is deducted and the 527 monthly prepayment rate is 0.1%? 528 529 Required Return 530 Price 531 532 533 Question 6: What is Blue Green Algae's net profit in Question 1 above if the originator's operating expenses 534 total $150,000? 535 536 Cash from investor 537 Cash to borrowers 538 Operating expenses 539 Net profit 540 11 12 13 Question 1: What price should Blue Algae obtain if the pool is sold immediately to an investor with a required 14 annual return of 11% and no prepayment is expected? 15 Payments from Prepaid Service Cash Flow to 16 Month Borrowers Interest Principal Principal Fee Pool Balance Investor 17 0 18 1 19 2 20 3 21 4 5 23 6 24 7