You buy a rental property, taking out a 15 year loan with monthly payments and a mortgage rate of 4.7%. Your plan is to pay down the remaining balance after 7 years. How much will that balance be if the value of the loan is $250,000? (Answer to nearest dollar. HINT: you must find the payment before you can find the balance.)

You found your dream house. It will cost you $300000 and you will put down $45000 as a down payment. For the rest you get a 30-year 4.0% mortgage. What will be your monthly mortgage payment in S (assume no early repayment)?

You want to buy a new house.  You can afford to pay $15,000 per year for 30 years with the first payment being due one year from today.  If the interest rate on your loan is 3%, what price of home can you buy today? Enter your answer as a number rounded to 2 decimal places.

Suppose you want to purchase a home for $475,000 with a 30-year mortgage at 5.84% interest. Suppose also that you can put down 25%. What are the monthly payments? (Round your answer to the nearest cent.)$ What is the total amount paid for principal and interest? (Round your answer to the nearest cent.)$ What is the amount saved if this home is financed for 15 years instead of for 30 years? (Round your answer to the nearest cent.)

You plan to use a 15 year mortgage obtained from a local bank to purchase a house worth $124,000.00. The mortgage rate offered to you is 7.75%. You will make a down payment of 20% of the purchase price. a. Calculate your monthly payments on this mortgage. List in a spreadsheet the cash flow the bank expects to receive from you. Submit the spreadsheet with your answers. b. Calculate the amount of interest and principal for the 60th payment. Show your work. c. Calculate the amount of interest and principal to be paid on the 180th payment. Show your work. d. What is the amount of interest paid over the life of this mortgage?

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%: $

You are interested in purchasing a house but unfortunately you don't have any money for a down payment. Luckily the house you are looking at buying is only $325, 000 and the bank currently has an offer where they will lock in your interest rate for the entire length of the mortgage. The rate that they are offering is 4.5% interest over 15 years. Develop a worksheet that will show the monthly payment, the beginning and ending balance for each year of the loan, the annual cost of the loan, and the annual interest paid for each year of the loan. Please show Formulas

You are thinking of purchasing a house. The house costs $300,000. You have $43,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 30-year mortgage that requires annual payments and has an interest rate of 9% per year. What will be your annual payment if you sign this mortgage? The annual payment is $ (Round to the nearest dollar)

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?