Question: need help with #2 please include excel formulas Qurctien 2t. What price thould Blue Algace obtain if the peet is sold imenediately to an investor

need help with #2

please include excel formulas

Qurctien 2t. What price thould Blue Algace obtain if the peet is sold imenediately to an investor with a required anenat return of 1105 aad the menthly prepayment rate is 0.1907 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!

Please help with excel formulas Question 2: What price should Blue Algae obtain if the pool is sold immediately to an investor with a required annual return of 11% and the monthly prepayment rate is...

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

Description Using the financial statements for Apple Inc. and Microsoft, Inc., respectively, you will calculate and compare the financial ratios listed further down this document and compare your...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

CCTFG 442 Investment Project Overview : Each of you will involve in a stock group for 10 weeks during this semester. You will invest $100,000 in a stock group and are required to track that...

Posting again. I need help with #2. please do not copy from another post thanks 2. Here is a series of addresses in hexadecimal: 20(w), 3C(r), 10(r), 16(w), 20(r). 04(w), 28(r). 6(r), 10(w). 17(w)...

I need help Cal 2 Please MATH 1326 FINAL Mock EXAM FALL 2024 Final Exam is 2hours 15 mins. This is not expected to be finished during class time. (1) (a) (5 points) Find the derivative of, (i) f(x) =...

Help on 2 please.. Is this correct? If not, please explain. 2. Draw all stereolsomers of 1,2,3-trimethylcyclohexane and indicate their relationships to one another (ie diastereomers or enantiomers)....

help with 2 please. explaing each step and code using just matlab. skelton script attached in pic 2. Construct your own FBP algorithm using the central slice theorem a. You will be given a skeleton...

Expenses recognition Sun Microsystems uses the accrual basis of accounting and recognizes revenue at the Lime it sells goods or renders services. It applies U.S. GAAP and reports in U.S. dollars....

I don't see any reason to do this net present value stuff. The payback method works well for me. It tells me how many years it takes to recoup the initial money I put in. As long as my payback period...

The equity of redemption can be waived by the mortgagor. a . True b . False

Discuss several ways ( at least four ways ) to improve the requirement process and thus, a project team can avoid a situation where too many changes to the project requirements occur at the later...

What are the expectations of the organisation(s) with which your research will be concerned? What organisational issues or priorities might affect the methods by which you gather data or the timing...

One of the advantages of mixed methods research is: a Facilitation of different methods in order to answer a research question. b Focus in depth using open interviews. c Theoretical purity. d...

Which of the following approaches to data enable a consideration of change over time? a Cross-sectional one moment in time survey. b Secondary data analysis. c Longitudinal data. d Literature review.