a. The bank offers a 30​-year mortgage with fixed monthly payments and an interest rate of 0.53% per month. What is the amount of your monthly payment if you take this​ loan? b. Suppose you take the 30​-year mortgage described in part ​(a​).

You can afford a $1300 per month mortgage payment. You've found a 30 year loan at 6% interest.a) How big of a loan can you afford?$b) How much total money will you pay the loan company?$c) How much of that money is interest?

(Q) You would like to purchase a home and are interested to find out how much you can borrow. When your lender calculates your debt to income ratio, he determines that your maximum monthly payment can be no more than $3, 200. You would like to have a 30 year fully amortizing loan and the interest rate offered on such a loan is currently 8.5%. Given these constraints, what is the largest loan you can obtain?

Answer the following question using a spreadsheet and the material in the appendix. You would like to buy a house. Assume that given your income, you can afford to pay $12,000 a year to a lender for the next 30 years. If the interest rate is 7% how much can you borrow today based on your ability to pay? What about if the interest rate is 3%? Maximum mortgage at 7%: $     Maximum mortgage at 3%: $

Suppose you want to purchase a house. Your take-home pay is $4270 per month, and you wish to stay within the recommended guidelines for mortgage amounts by only spending 1/4 of your take-home pay on a house payment. You have $18,500 saved for a down payment and you can get an APR from your bank of 5.7%, compounded monthly. What is the total cost of a house you could afford with a 3030-year mortgage? Round your answer to the nearest cent, if necessary.

What is amortization?  Describe other types of loan arrangements. If you could afford to pay cash for a home, is it worth it to take a mortgage out anyway?   If no, why not.  If yes, why.  Here are the variables:30 year amortized mortgage at 5% fixedInvestment opportunity at 3.5% fixedPrice of the home is $500,000.  You’ll either invest $400,000 and make a down payment on the house of $100,000 and mortgage the rest.  Hint: Find out if the interest earned on the investment is more or less than the interest made on the investment.

Assume that a broker agent introduces you to a local bank, and that bank offers you their lowest interest rate at 3.25% APR, with a 10-year fixed interest rate or 20-year fixed interest rate. 1)  If you want a 10-year, fixed mortgage loan, find the monthly mortgage payment for a house that you will borrow $500,000 with no down payment. 2)  Determine the total amount paid over the full term of the loan. 3)  How much interest will be paid on the loan over the 10 years?

You can afford monthly payments of $800. If current mortgage rates are 3.06% for a 15-year fixed rate loan, how much can you afford to borrow? If you are required to make a 20% down payment and you have the cash on hand to do it, how expensive a home can you afford? (Hint: You will need to solve the loan payment formula for P.)

You are thinking of purchasing a house. The house costs $354,000. You have $45,000 in cash that you can use as a down payment on the house, but you need to borrow the rest of the purchase price. The bank is offering a 25-year mortgage that requires annual payments and has an interest rate of 6% per year. What will be your annual payment if you sign this mortgage?

You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. Please show all steps in excel and the excel spreadsheet. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?