Please explain the answer and provide the excel function

The Blue Algae Mortgage Company has originated a pool containing 75 ten-year fixed rate mortgages with an average balance of $100,000 each with 1% origination fee. The annual interest rate on all loans in the pool is 12% and all loans require monthly payments. Initial Pool Balance Annual Interest Rate Maturity (years) Payments per year Question 1: What price should Blue Algae obtain if the pool is sold immediately to an investor with a required annual return of 11% and no prepayment is expected? Payments from Borrowers Prepaid Service Interest Principal Principal Fee Cash Flow to Investor Pool Balance Required Return Price Month 0 1 2 3 4 5 6 7 8 9 10 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 The Blue Algae Mortgage Company has originated a pool containing 75 ten-year fixed rate mortgages with an average balance of $100,000 each with 1% origination fee. The annual interest rate on all loans in the pool is 12% and all loans require monthly payments. Initial Pool Balance Annual Interest Rate Maturity (years) Payments per year Question 1: What price should Blue Algae obtain if the pool is sold immediately to an investor with a required annual return of 11% and no prepayment is expected? Payments from Borrowers Prepaid Service Interest Principal Principal Fee Cash Flow to Investor Pool Balance Required Return Price Month 0 1 2 3 4 5 6 7 8 9 10 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28