Monthly payment formula = | [P x R x (1+R)^N]/[(1+R)^N-1] | ||||
a | P x R | ((275,000*(0.05/12))) = 1,145.8333 | |||
b | (1+R)^N] | ((1+(0.05/12))^360) = 4.4677 | |||
c | (1+R)^N-1 | (1+(0.05/12))^360-1 = 3.4677 | |||
d | b/c | 4.4677/3.4677 = 1.2884 | |||
e | a*e | 1,145.8333*1.2884 = 1,476.2595 | |||
N = 12*30 =360 | |||||
P = 275,000 | |||||
R = monthly interest rate = 0.05/12 | |||||
Additional monthly fee = $229.17 | |||||
Monthly Payment = $1476.26 | |||||
Total monthly payment = $229.17+$1,476.26 = $1,705.43 | |||||
Mortgage value / Market value of home = 222,990/290,000 = 76.86% | |||||
Current Mortgage balance is $222, 900 which is 76.89% of market value of home i.e. $290,000. It means that now the equity value is 23.11% which is higher than the 20% equity requirement hence additional monthly fee of $229.17 can be removed now. |
If you buy a home with less than 20% down, you will pay an additional monthly...
If you buy a home with less than 20% down, you will pay an additional monthly fee, PMI (private mortgage insurance), until you reach 80% equity. Keep track of when you reach 80% equity so you can request to have your PMI removed. Ken Buckmiller’s home recently appraised at $290,000. His mortgage was for $275,000 at 5% for 30 years with PMI of $229.17 per month. What is his monthly payment plus PMI? His mortgage balance is currently $222,990. Has...
If you buy a home with less than 20% down, you will pay an additional monthly fee, PMI (private mortgage insurance), until you reach 80% equity. Keep track of when you reach 80% equity so you can request to have your PMI removed. Ken Buckmiller’s home recently appraised at $292,000. His mortgage was for $277,000 at 5% for 30 years with PMI of $249.17 per month. What is his monthly payment plus PMI? His mortgage balance is currently $170,500. Has...
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...
You want to buy a $230,000 home. You plan to pay 20% as a down payment, and take out a 30 year loan for the rest. a) How much is the loan amount going to be? $ b) What will your monthly payments be if the interest rate is 6%? $ c) What will your monthly payments be if the interest rate is 7%? $
1. You want to buy a $249,000 home. You plan to pay 5% as a down payment, and take out a 30 year loan for the rest. a) How much is the loan amount going to be? $ b) What will your monthly payments be if the interest rate is 6%? $ c) What will your monthly payments be if the interest rate is 7%? $ 2. You can afford a $1150 per month mortgage payment. You've found a 30...
You need a 20-year, fixed-rate mortgage to buy a new home for $240,000. Your mortgage bank will lend you the money at a 6.1 percent APR for this 240-month loan. However, you can afford monthly payments of only $800, so you offer to pay off any remaining loan balance at the end of the loan in the form of a single balloon payment. How large will this balloon payment have to be for you to keep your monthly payments at...
estivgpRice is 45,000 You negotiate with the seller to buy the home for $5000 less than the listing price. You are able to make a 20% down payment. Your bank will finance a loan for the remainder of the price at 3.8% annual interest compounded annually. Compare a 15 year mortgage and a 30 year mortgage. What will your annual payment be for each? How much interest will you pay the bank for each type of loan? Decide which length...
You buy a new home for $500,000 on the first day of the month. You put down $50,000 and finance the rest with a mortgage at 6% annual interest compounded monthly on the last day of the month. Your monthly payments including principal and interest are 2500. Your payments are due on the first day of the month, starting next month. What is your loan balance after your third monthly payment ? explain how you got the answer !
Total Loan amount: The total mortgage loan amount is the amount you borrow after paying your down payment. Here, we assumed that you would pay 20% of the home value (property value) as a down payment. 2. Months: The mortgage payment period is set to 30 years. In terms of months, this is equivalent to 30 years multiplied by 12 months. We put our primary basis of payments in terms of months, which is why we need to convert everything...
Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...