The monthly payments will be given as equal to
=245000*(1-10%)*(5.5%/12)/(1-1/(1+5.5%/12)^(12*15))
=$1,801.67
You are evaluating a property with a price tag of $245,000. You plan to put 10%...
Suppose you plan to purchase a $250,000 home. You plan to put 5% down, and take a loan from the bank for the remaining amount. The bank has offered you a 30-year loan with a 4.5% APR (compounded monthly). Calculate the total interest paid to the bank in the 2nd year of the loan
Problem 2-Buying a Car You see a car that you absolutely must have. The price tag says $18,450, but you want to keep your payment low over a 4-year period. Since you want to make payments no larger than $250 at the end of every month, you must find a bank to finance a loan for you. The bank you find charges interest at a rate of 6.99% compounded monthly. Use this information to find the following: The amount you...
You want to buy a $200,000 home. You plan to pay 10% 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 5%? c. What will your monthly payments be if the interest rate is 6%?
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...
Sam inherited $2 million at age 20 and put this amount in an investment account earning an rate of return of 5.5%, compounded monthly. Today, Sam turns to age 50 and deposits the accumulated amount from the inheritance in a 25-year annuity due plan at an interest rate of 5.5% that he can withdraw a set amount of monthly income immediately to pay for mortgage payments, property tax and living expenses on the first day upon his retirement.Sam loves nature...
You decide to finance the purchase a used $10,000 car with $2500 down, borrowing $7500 from a local bank. They tell you the interest being charged is 6% per year. You agree to repay the loan in 24 equal monthly payments. The monthly payment they calculate for you is: 7500 (7500)(.06)(2 yrs) _c250 24 months 24 After considering their loan offer, will you decide to accept it? Why or why not? (10 points]
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 just bought an investment property for $450,000 . The loan is fully amortized over 30 years and payments are made monthly You took a loan for 80% of the purchase price to buy the property. The nominal annual rate of interest is 3.9% for this loan. a. How much will your monthly loan payments be? b. How much total interest will you pay over the entire life of the loan? What is your loan balance after exactly 15 years...
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...
You have an opportunity to acquire a property form First Capital Bank. The bank recently obtained the property from a borrower who defaulted on his loan. First Capital is offering the property for $200,000. If you buy the property, you believe that you will have to spend (1) $10,500 on various acquisition-related expenses and (2) an average of $2,000 per month during the next 12 months for repair costs, etc., in order to prepare it for sale. Because First Capital...