Question: need help on #4 please include all excel formulas Question 4: What price should Btue Algae ohtain if the pool is carved into MPTS and

need help on #4

please include all excel formulas

Question 4: What price should Btue Algae ohtain if the pool is carved into MPTS and the investors require a 995 annual return after in monthy service fee of 0.196 is deducted and the monthly prepayment rate is 0.1% ? 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

need help with #3 please include all excel formulas Question 3: What price should Hue Algae obtain if the pool is carved into M1PTS and the investors require a 945 annual refure after a montby...

Please explain the answer and provide the excel function Question 3: What price should Blue Algae obtain if the pool is carved into MPTS and the investors require a 9% annual return after a monthy...

Please explain the answer and provide the excel function Question 4: What price should Blue Algae obtain if the pool is carved into MPTS and the investors require a 9% annual return after a monthy...

MPTS Excel Assignment K9 fx I J K L A B C 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...

MPTS Excel Assignment 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...

please answer question 4 highlighted cells with excel formulas! 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...

MPIS Excel Assignment 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...

please provide answers & excel formulas AutoSave BESU. MPTS Excel Assignment Module 9 Attempt 1 Home Insert Draw Page Layout Formulas Data Review View Tell me Times New Roman 12 "" Il General LO...

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...

please answer question 2 with excel functions! the highlighted cells need the formulas ud A D E F MPTS Excel Assignment The Blue Algae Mortgage Company has originated a pool containing 75 ten-year...

To increase its market share, Sole Brother Inc. decided to borrow $5000 from its banker for the purchase of newspaper advertising for its shoe retail line. The loan is to be paid in four equal annual...

Suppose that A > B > C > D and that the utilities of these alternatives satisfy U(A) + U(D) = U(B) + U(C). Is it true that U(1/2B + 1/2C) is greater than U(1/2 A + 1/2D) because the former has a...

The current spot rate between the US dollar and the Japanese yen is quoted as / $ = 1 1 7 . 3 3 3 . Interpret this quote. Is this quote direct or indirect from the US perspective? Is this quote in...

------------------------------------- At the beginning of its first year of operations, Bonita Limited has 4,900, $3 preferred shares and 48,000 common shares. Using the format shown below, allocate...

4. Explain how to use fair disciplinary practices.

3. Give examples of four fair disciplinary practices.

1. Chip Conley, founder of Joie de Vivre Hospitality, believes that most companies frame their financial incentives in the wrong way. Explain what he means. What does JDV do differently?