Chapter 9, Problem 4BYOPFM

In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000.  It will be  a 30-year mortgage. The interest your bank will charge will be 7.5%.  In cell C5, use the PMT function to determine what your monthly payment will be.  Submit the spreadsheet in Canvas.

I need help for D, E, and G please   You are a loan officer at the West Elm Savings and Loan. Mr. and Mrs. Brady are in your office to apply for a mortgage loan on a house they want to buy. The house has a market value of $170,000. Your bank requires  1/5  of the market value as a down payment.   (a) What is the amount (in $) of the down payment? $     (b) What is the amount (in $) of the mortgage for which the Bradys are applying? $     (c) Your bank offers the Bradys a 30 year mortgage with a rate of 5%. At that rate, the monthly payments for principal and interest on the loan will be $5.37 for every $1,000 financed. What is the amount (in $) of the principal and interest portion of the Bradys' monthly payment? $     (d) What is the total amount (in $) of interest that will be paid over the life of the loan? $   (e) Your bank also requires that the monthly mortgage payments include property tax and homeowners insurance payments. If the property tax is $1,710 per…

We will now verify your results using an online Amortization Calculator. Return to www.bankrate.com (Links to an external site.), scroll down the home page and select Amortization Calculator (Links to an external site.) under the Mortgages heading. Enter the amount, time, and rate for the original loan to begin with and click CALCULATE. Your monthly payments will appear on the side. Click Show Amortization Schedule to see the month-to-month breakdown of your loan payments over the entire term of the loan.

If you are borrowing money to purchase a car, you should:Select an answer from the options below. A thoroughly read the loan documentsB withhold some items from the disclosureC borrow as much as you canD all of the above

Can Olivia and Anthony Afford This Home Using the Monthly Income Loan Criterion? Next week, your friends Olivia and Anthony want to apply to the Fourth Global Bank for a mortgage loan. They are considering the purchase of a home that is expected to cost $125,000. Given your knowledge of personal finance, they’ve asked for your help in completing the Home Affordability Worksheet that follows. (Note: When completing the form, round each dollar amount to the nearest whole dollar.) To assist in the preparation of the worksheet, Olivia and Anthony also collected the following information: • Their financial records report a combined gross before-tax annual income of $125,000 and current (premortgage) installment loan, credit card, and car loan debt of $1,823 per month. • Their property taxes and homeowner’s insurance policy are expected to cost $3,125 per year. • Their best estimate of the interest rate on their mortgage is 7.5%, and they are interested in obtaining a 15-year loan.…

In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000.  It will be  a 30-year mortgage. The interest your bank will charge will be 7.5%.  In cell C5, create a function that determines what your monthly payment will be.

Give an example each for real estate mortgage and chattel mortgage, with 3 people involved in each contract. What are the obligations being secured by each mortgage?

Jamison is looking at the historical prepayment for a passthrough security. He finds the following: mortgage balance in month 42 = $260,000,000 scheduled principal payment in month 42 = $1,000,000 prepayment in month 42 = $2,450,000   What is the SMM for month 42? How should Mr. Jamison interpret the SMM computed? What is the CPR for month 42?

Information for mortgage of a house How would I figure out what my income would have to be to afford my monthly payment?