A pass-through is issued with the following characteristics:• Mortgage pool: $5 million•All mortgages are FRM at 10% per year, 3-year maturity, yearly paymentPass-through: $5 million, yearly payment•Fee payment: 1.5% of outstanding loan balance• Assume prepayment rate: 3% of the mortgage pool for the 1st year, 5% for the2nd yearFrom the information above, we have the following table:Year1Beginning Mortgage Interestbalancepayment payment$5,000,000 $2,010,574 500,000 $1,510,574 150,000PrincipalpaymentPre-paymentFeepayment$75,000 $1,935,574 $3,339,Payment to Endinginvestors balance2$3,339,426 1,924,146 $333,943 $1,590,203 $166,97150,091 $1,874,054 1,582,231,582,252$1,740,477 $158,225 1,582,252$0$23,734 $1,716,743What is the value of this pass-through at 8% discount rate?$5,168,900$4,339,025$5,000,000$4,761,703

present value of the future cash flows from the pass-through using the following formula:Present…

Answered: A pass-through is issued with the…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

A mortgage has the following terms: Amount: $750,000 Rate: 6.25% Amortization (Years): 30 Term (Years): 20 Please determine the following: What is the Monthly Payment? In preparing an Income Statement, what is the Interest Expense for years 1 – 5? What is the Principal Balance at the end of year 6? What is the value of the loan at the expiration? If rates remain constant (flat), what would the benefit be to refinance this loan after year 10? do all the questions 1-5 and show the formulas in excel and show how you got it
This Question: Complete the first two months of each amortization schedule for a fixed-rate mortgage. Mortgage, $144,800; Interest rate, 6.9%; Term of loan, 16 years Fill out the amortization schedule below and round all values to the nearest cent. 12 Monthly Mortgage Payment Formula: R= 121 12 1- 12 +r Interest Payment Formula: I=P 12 Payment Number Total Payment Interest Principal Payment Balance of Principal $144,800 Payment (a) S (e) S (b) $ () S[ (c) S (9) s (d) s (h) S 2.
Using this table as needed, calculate the required information for the mortgage. (Round dollars to the nearest cent.) AmountFinanced InterestRate Termof Loan(years) Numberof $1,000sFinanced TableFactor(in $) MonthlyPayment(in $) TotalInterest(in $) $162,300 5.25% 15 ? $ ? $ ? $ ?
Given the following information of the mortgage pool that backs a MPT, what is the regular scheduled payment in month 1 of the security? Use WAC as the mortgage rate and WAM as the number of periods for your calculations. Round your final answer to two decimals. • 30 year FRM, fully amortizing, monthly payments • Loans seasoned for 3 months before entering pool • WAM: 357 • WAC: 4% • Servicer/Guaran • Prepayment assumption: 75% PSA
Consider a 30-year home mortgage of $100,000 at 6% per year. What is the monthly payment? Use Theorem 1 as attached to make an amortization schedule of the first 6 months: Month (k) Principal P(k) Interest I(k) Balance due B(k) 1 2 3 4 5 6 where P(k) is the amount paid to the principal in the k’th payment, I(k) is the amount paid to interest in the k’th payment, B(k) is the balance due after the k’th payment.
Using this table as needed, calculate the required information for the mortgage. AmountFinanced InterestRate Termof Loan(years) Numberof $1,000sFinanced TableFactor(in $) MonthlyPayment(in $) TotalInterest(in $) $73,500 8.00% 30 $ $ $
1. Excel: Complete the amortization table provided in the Excel document posted in Ivylearn in the homework area by setting the appropriate values for a $165,000, 30-year mortgage at 4.5% interest and using Excel's autofill (drag) feature to fill in the cells to the end of the mortgage period. Use this to answer the following: a. How much of the first payment goes towards the principal? How much goes toward the interest? b. How much of the last payment goes towards the principal? How much goes toward the interest? c. Find the total interest paid by the end of the mortgage. d. How much will be owed on the mortgage after making payments for 10 years (hint this is 120 months)? e. How much interest has been paid total on the mortgage at the end of 10 years? f. How many months will it take to pay at least half of the principal?
How would I complete this?
A fully amortizing mortgage loan is made for $99,000 at 6 percent interest for 25 years. Payments are to be made monthly. Required: a. Calculate monthly payments. b. Calculate interest and principal payments during month 1. c. Calculate total principal and total interest paid over 25 years. d. Calculate the outstanding loan balance if the loan is repaid at the end of year 10. e. Calculate total monthly interest and principal payments through year 10. f. What would the breakdown of interest and principal be during month 50? Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required F What would the breakdown of interest and principal be during month 50? (Do not round intermediate calculations. Round final answers to 2 decimal places.) Interest payment Principal payment
A fully amortizing mortgage loan is made for $84,000 at 6 percent interest for 25 years. Payments are to be made monthly. Required: a. Calculate monthly payments. b. Calculate interest and principal payments during month 1. c. Calculate total principal and total interest paid over 25 years. d. Calculate the outstanding loan balance if the loan is repaid at the end of year 10. e. Calculate total monthly interest and principal payments through year 10. f. What would the breakdown of interest and principal be during month 50?
Complete the first two months of an amortization schedule for the fixed-rate mortgage. Mortgage: $114,150 Interest rate: 5.25% Term of loan: 12 years Complete the first two payments of the amortization schedule below. (Do not round until the final answer. Then round to the nearest cent as needed.) Payment Number Total Interest Principal Payment Balance of Principal Payment Payment $4 1 %$4 %24 Enter your answer in each of the answer boxes. Copyright © 2020 Pearson Education Inc. All rights reserved
Please eolve this question on excell and show formulas please.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS