You want to buy a house financed with a 15-year fixed-rate mortgage. The best interest rate...

You want to buy a house financed with a 15-year fixed-rate mortgage. The best interest rate you could find is 7% APR. Payments are made monthly, so the APR should be assumed to be a simple interest rate (i.e. a stupid interest rate) added up over 12 months.

What is the most you can borrow if you can only afford to pay $1,800 per month?

Expert Solution

We are given the following information:

Monthly payment	PMT	1800.00
Rate of interest	r	7.00%
Number of years	n	15.00
Monthly compounding	frequency	12.00
Loan amount	PV	To be calculated

We need to solve the following equation to arrive at the required PV

So the maximum loan amount possible is 200260.72

Below is the amortization schedule:

Opening balance = previous year's closing balance
Closing balance = Opening balance-Principal repayment
PMT is calculated as per the above formula
Interest = 0.07 /12 x opening balance
Principal repayment = PMT - Interest

jeff jeffy answered 1 year ago

You just took out a 15-year traditional fixed-rate mortgage for $100,000 to buy a house. The...

You just took out a 15-year traditional fixed-rate mortgage for $100,000 to buy a house. The interest rate is 6.24% (APR) and you have to make payments monthly. 1. What is your monthly payment? 2. How much of your first monthly payment goes towards paying down the outstanding balance (in $)? 3. What is the outstanding balance after 1 year if you have made all 12 payments on time? 4. How much of your 13th monthly payment goes towards paying...

Intro You just took out a 15-year traditional fixed-rate mortgage for $400,000 to buy a house....

Intro You just took out a 15-year traditional fixed-rate mortgage for $400,000 to buy a house. The interest rate is 1.2% (APR) and you have to make payments monthly. Part 1 What is your monthly payment? Part 2 How much of your first monthly payment goes towards paying down the outstanding balance (in $)? Part 3 How much of your 13th monthly payment goes towards paying down the outstanding balance (in $)?

you obtain a 265,000, 15 year fixed rate mortgage. The annua interest rate is 6.25%. In...

you obtain a 265,000, 15 year fixed rate mortgage. The annua interest rate is 6.25%. In addition to the principle and interest paid, you must pay 275 a month into a escrow account for insurance and taxes. What is the total monthly payment(to the nearest dollar)?

You borrow $396,000 to buy a home using a 15-year mortgage with an interest rate of...

You borrow $396,000 to buy a home using a 15-year mortgage with an interest rate of 3.00 percent and monthly payment. What percentage of the total amount paid in the first 5 years will go toward principal repayment? Group of answer choices 58.2 percent 68.7 percent 31.3 percent 41.8 percent

You borrow $395,000 to buy a home using a 15-year mortgage with an interest rate of...

You borrow $395,000 to buy a home using a 15-year mortgage with an interest rate of 3.75 percent and monthly payment. What percentage of the total amount paid in the first 3 years will go toward interest? Group of answer choices 60.3 percent 39.7 percent 68.4 percent 31.6 percent

You want to buy a house and will need to borrow $245,000. The interest rate on...

You want to buy a house and will need to borrow $245,000. The interest rate on your loan is 5.77 percent compounded monthly and the loan is for 30 years. What are your monthly mortgage payments?

Mortgage Payment You currently have a 30-year fixed rate mortgage with an annual interest rate of...

Mortgage Payment You currently have a 30-year fixed rate mortgage with an annual interest rate of 6%. You have had the mortgage 4 years, and on September 1, 2015 you made your 48th payment. The original principal amount was $280,000 and you monthly payment, without taxes and insurance, are $1,678.74 per month, computed using the Excel function =PMT(0.5%,360,280000,0,0). Starting with your original mortgage your banker calls and says that you could refinance your existing mortgage (6% rate, 30-year original term)...

You need a 22-year, fixed rate mortgage to buy a new home for $290,000. Your mortgage...

You need a 22-year, fixed rate mortgage to buy a new home for $290,000. Your mortgage bank will lend you the money at an annual interest rate of 6.5% APR and annual compounding. What is your annual payment?

You have just bought a house and have a $125,000, 25-year mortgage with a fixed interest...

You have just bought a house and have a $125,000, 25-year mortgage with a fixed interest rate of 8.5 percent with monthly payments. Over the next five years, what percentage of your mortgage payments will go toward the repayment of principal?.

When you buy a house, you also "buy" an interest rate. That is, depending on the...

When you buy a house, you also "buy" an interest rate. That is, depending on the conditions of the housing market and the current federal interest rate, you get locked into a rate for the duration of your loan agreement by the bank that sells you the loan. Though there are many home loan durations (often terminating at the time called the "pay-off" date), the most typical for home-buyers is 30 years. Suppose you buy a new home for $200,000...

Question