SHOW EXCEL FUNCTIONS FOR ALL GREEN CELLS

MIPTS Excel Assigament The Blue Agae Mortgage Compagy bas originated a pool containing 75 tea year fixed rate mortzages with as average balace of $100,000 each vith 1% origination fee. The annul interest rate on all loans in the pool is 12% and all loans require mosthly paymeats. 13 Qeestion 1: What price should Blue Algac obtain if the poel is sold immediately to an iavestor with a required ausual 14 return of 11% and no prepayment is expected