Homework Answers
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
Add Answer to:
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...
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...
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,...
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...
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
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...
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...
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...
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...
You are planning to purchase a house that costs $620,000. You plan to put 20% down...
You are planning to purchase a house that costs $620,000. You plan to put 20% down and borrow the remainder. You have been pre-approved, based on your credit score and income, for a 30-year loan with an interest rate of 4.53%. 1. Use function “PMT” to calculate your mortgage payment. 2. Use function “PV” to calculate the loan amount given a payment of $2650 per month. What is the most that you can borrow? 3. Use function “RATE” to calculate...
Mortgage Analysis You are planning to purchase a house that costs $480,000. You plan to put...
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...
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 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]
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...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago