Question: Please include relevant excel formulas. The Blue Algae Mortgage Company has originated a pool containing 75 ten-year fixed rate mortgages with an average balance of

Please include relevant excel formulas.

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

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 Accounting Questions!

Urgent Help Plzz CE 1 1 K 1 M N D xo A 1 D 0 11 IPTS Excel Assignment the Blue Algue Mortgage Company has originated a pool containing 75-year fixed rate mortgages with an vrage balance of 100,000...

PLEASE SHOW EXCEL FORMULAS 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%...

The months go down to 120 for questions 1-4 please show all excel functions, thank you. MPTS Excel Assignment The Blue Algae Mortgage Company has originated a pool containing 75 ten-year fixed rate...

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

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

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. The annual interest rate on all loans...

Please help with Excel Formulas 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...

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

Borden Company received a federal tax levy on John Kline. Kline is single, claims 2 personal allowances, and had a takehome pay of $621.00 this week. The amount of the tax levy (in 2018) would be:...

tugue ey-Le 5 Now Item 30 of 30 What is the vote required to amend, repeal, or adopt new by laws? Seiect the comect resporse Majority of all menbers of the board Majority of a members of the bosard...

A stock has a spot price of $ 5 5 . Its May options are about to expire. One of its puts is worth $ 5 and one of its calls is worth $ 1 0 . The exercise price of the put must be and the exercise...

The selling price of Roscioli Corp only product is $210 per unit and its variable expense is $75.60 per unit. The companys monthly fixed expense is $537,600. Assume the companys monthly target profit...