Question 11:
Jerry and Elaine finally got married, and have bought a $325,000 house. The interest rate is at 3.90%, paid monthly, and is a 30-year loan. They plan to borrow $300,000 for the purchase and put down $25,000.00. How much principal on the loan will they pay over the 30 years?
The Formula for Loan is given by
Where,
Given
P0= $300,000, d=?, r=3.9% =0.039 , k=12, N=30 years.
putting the above values in formula above
so the couple will pay $1415 monthly payment for 30 years or 360 month.
Therefore the couple have to pay a priciple of $1415 * 360 = $509,400 over 30 years. Answer.
Question 11: Jerry and Elaine finally got married, and have bought a $325,000 house. The interest...
Question 20: Jim and Cathy have bought a $300,000 house. The interest is at 3.9%, paid monthly, and is a 20 year loan. They plan to borrow the entire $300,000 for the purchase. How much will their monthly payment be, excluding taxes and insurance?
Mortgage Analysis Part I You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Use the function “PMT” to calculate your mortgage payment. Calculate the total cost of the home purchase. (Down payment plus principal (loan amount) plus interest.) Calculate how much interest you will pay in total? Assume that you plan to pay...
You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Use function “PMT” to calculate your mortgage payment. Use function “PV” to calculate the loan amount given a payment of $1700 per month. What is the most that you can borrow? Use function “RATE” to calculate the interest rate given a payment of $1700...
Question: Suppose your friend April is considering to refinance her mortgage. She bought her house 60 month... Suppose your friend April is considering to refinance her mortgage. She bought her house 60 months ago. The amount of loan equals 196,000. She paid cash to cover the 5% down payment plus all required closing costs (closing costs include application fee, appraisal fee, loan origination fees and other costs, usually about 3%-5% of the loan amount). Since she had a decent credit...
Mortgage Analysis Part I You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. 1. Use function "PMT" to calculate your mortgage payment. 2. Calculate the total cost of the home purchase. (Down payment plus principle (loan amount) plus interest.) 3. Calculate how much interest you will pay in total? 4. Assume that you...
Scenario: You want to buy a house in Ypsilanti's up and coming Normal Park neighborhood. You find a cute home that is going for $210.500. You talk to your bank and with 10%down, you can talke out a 30 year mortgageS.3%Jinterest Home purchase questions: How much will the down payment on the house be? 2. How much will you need to finance for the home loan? 3. How much will your monthly payment be (round to 2 decimal places)? 4....
Suppose your friend April is considering to refinance her mortgage. She bought her house 60 months ago. The amount of loan equals 154,00. She paid cash to cover the 5% down payment plus all required closing costs (closing costs include application fee, appraisal fee, loan origination fees and other costs, usually about 3%-5% of the loan amount). Since she had a decent credit history and relatively stable income, her mortgage rate was 5.25% for 30 years at the time of...
Answer 5-14 please
Scenario: You want to buy a house in Ypsilanti's up and coming Normal Park neighborhood. You find a cute home that is going for $210.500. You talk to your bank and with 10%down, you can talke out a 30 year mortgageS.3%Jinterest Home purchase questions: How much will the down payment on the house be? 2. How much will you need to finance for the home loan? 3. How much will your monthly payment be (round to 2...
Mortgage Analysis You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.25% on a 30-year mortgage. (Use Excel) Use function “PMT” to calculate your mortgage payment. Use function “PV” to calculate the loan amount given a payment of $1550 per month. What is the most that you can borrow? Use function “RATE” to calculate the interest rate given...
Ben Thenking wants to borrow $300,000 to buy a house. He plans to live there for exactly 5 years before selling the house, repaying the lender the balance and moving. Ben is considering a 30 year fully amortizing fixed rate mortgage with monthly payments. The banker shows Ben three loan options: (1) A loan with a 5% annual interest rate which requires Ben to pay 2 points up front, (2) the same terms as (1), but the loan principal is...