please post formulas

Tell me ANO IESU. MPTS Excel Assignment Module 9 Attempt 1 Home Insert Draw Page Layout Formulas Data Review View X Times New Roman 12 AA General Dante an ====== S% 9 Condon Porwanting 010 x fx B D E F G 1 K L 1 MPTS cel Asalamat 2 The Blue Algae Mortgage Company has originated a pool containing 75 tr-year fed rate mortgages with an 3 average balance of $100,000 each with 1% originate fre. The anal interest rates the poolt 4 12% and all as require monthly payments. 5 0 7 In Pool Balance Anal Interest Rate 9 Maturity Cyan) 10 Payments per you 11 12 11 Quatlon 1 What prices her Alpe obtain the pool is sold immediately to un tester with required 14 return of 11% and prepayment is espected? IS Payments from Prepaid Service Cash Flow 16 Month Barwen Interest Principal Principal Fee Pool Investor 17 0 Red Rem Price 2 20 3 21 4 5 BRUN 24 25 26 27 29 30 31 32 -7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 MPTS 34 35 17 30 39 10 000 esc 20 DOD FA F3 F5 76 7 1 K N10 fx A B D E F G H 1 MPTS Excel Assignment 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. 5 Required Return Price 19 4 7 Initial Pool Balance 8 Annual Interest Rate 9 Maturity (years) 10 Payments per year 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 2 20 3 21 22 5 23 6 24 7 25 8 26 27 10 28 11 29 12 30 13 31 14 32 15 33 16 34 17 35 18 36 19 37 20 38 21 39 22 40 23 > MPTS 9 Tell me ANO IESU. MPTS Excel Assignment Module 9 Attempt 1 Home Insert Draw Page Layout Formulas Data Review View X Times New Roman 12 AA General Dante an ====== S% 9 Condon Porwanting 010 x fx B D E F G 1 K L 1 MPTS cel Asalamat 2 The Blue Algae Mortgage Company has originated a pool containing 75 tr-year fed rate mortgages with an 3 average balance of $100,000 each with 1% originate fre. The anal interest rates the poolt 4 12% and all as require monthly payments. 5 0 7 In Pool Balance Anal Interest Rate 9 Maturity Cyan) 10 Payments per you 11 12 11 Quatlon 1 What prices her Alpe obtain the pool is sold immediately to un tester with required 14 return of 11% and prepayment is espected? IS Payments from Prepaid Service Cash Flow 16 Month Barwen Interest Principal Principal Fee Pool Investor 17 0 Red Rem Price 2 20 3 21 4 5 BRUN 24 25 26 27 29 30 31 32 -7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 MPTS 34 35 17 30 39 10 000 esc 20 DOD FA F3 F5 76 7 1 K N10 fx A B D E F G H 1 MPTS Excel Assignment 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. 5 Required Return Price 19 4 7 Initial Pool Balance 8 Annual Interest Rate 9 Maturity (years) 10 Payments per year 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 2 20 3 21 22 5 23 6 24 7 25 8 26 27 10 28 11 29 12 30 13 31 14 32 15 33 16 34 17 35 18 36 19 37 20 38 21 39 22 40 23 > MPTS 9