Showing Page:
1/1
Part1; fixed rate mortgage and amortization and yield to prepayment without points
Consider the following fixed rate mortgage loan:
Loan amount $200000
Interest rate $4.75 percent
Term 20 years
Payments monthly
Discount points in part (1) zero (0%)
Use excel to generate a mortgage amortization table that includes each monthly payments. for each
month, print six columns showing : (1) month in question , (2) the payments amount (3) the dollars of
interest (4) principal reduction (5) the remaining balance of the loan (6)the yield to prepayment if in fact
if the loans were to be prepaid at the end of any of the 240 months under consideration
Part 2: fixed rate mortgage and amortization and yield to prepayment with discount points
Consider the following fixed rate mortgage loan:
Loan amount $200000
Interest rate 4.25 percent
Term 20 years
Payments monthly
Discount points in part (1) one (1%)
In another excel tab, generate a mortgage amortization table

Unformatted Attachment Preview

Part1; fixed rate mortgage and amortization and yield to prepayment without points Consider the following fixed rate mortgage loan: Loan amount $200000 Interest rate $4.75 percent Term 20 years Payments monthly Discount points in part (1) zero (0%) Use excel to generate a mortgage amortization table that includes each monthly payments. for each month, print six columns showing : (1) month in question , (2) the payments amount (3) the dollars of interest (4) principal reduction (5) the remaining balance of the loan (6)the yield to prepayment if in fact if the loans were to be prepaid at the end of any of the 240 months under consideration Part 2: fixed rate mortgage and amortization and yield to prepayment with discount points Consider the following fixed rate mortgage loan: Loan amount $200000 Interest rate 4.25 percent Term 20 years Payments monthly Discount points in part (1) one (1%) In another excel tab, generate a mortgage amortization table Name: Description: ...
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4