QUESTION 1 A 15 years 200,000 mortgage has a fixed mortgage rate of 1.3 percent. Estimate...

Question

Question

QUESTION 1 A 15 years 200,000 mortgage has a fixed mortgage rate of 1.3 percent. Estimate the interest portion of the payment

business finance

Answer 1

Answer #1

e =PMT(C2,C3,-C4,C5, C6) fx B ДА 1 2 RATE NPER 4 PV 5 FV 6 TYPE PMT 0.001083333 0.013/12 180 15*12 200,000 Rate Per Period To

Answer 2

Similar Homework Help Questions

A 15-years 200,000 mortgage has a fixed mortgage rate of 5.8 percent. Estimate the interest portion...

A 15-years 200,000 mortgage has a fixed mortgage rate of 5.8 percent. Estimate the interest portion of the payment in the second month. For example, if you find that the interest portion in the second month is $358.56, type "358.56" in the box.
A 15-year $200000 mortagage has a fixed mortgage rate of 10 percent . Estimate the total...

A 15-year $200000 mortagage has a fixed mortgage rate of 10 percent . Estimate the total mortagage payment and interest payment in the second month ?
Find the following for a $200,000 fixed-rate mortgage and the given informatic a) Monthly mortgage payment...

Find the following for a $200,000 fixed-rate mortgage and the given informatic a) Monthly mortgage payment (principal and interest) b) Monthly house payment (including property taxes and insurance) c) Initial monthly interest d) Income tax deductible portion of initial house payment e) Net initial monthly cost for the home (considering tax savings) Annual Owner's Term of Interest Property Annual Income Tax Mortgage Rate Tax Insurance Bracket 15 years 5.5% $924 $504 3596 a) The monthly mortgage payment is $ (Round...

Consider a $200,000 conventional fixed-rate mortgage, 7 percent, financed for 15 years. What is the loan...

Consider a $200,000 conventional fixed-rate mortgage, 7 percent, financed for 15 years. What is the loan balance after 10 years if paid as agreed? A. $92,721 B. $83,581 C. $85,492 D. $90,785
Find the following for a $200,000 fixed rate mortgage and the given information a) Monthly mortgage...

Find the following for a $200,000 fixed rate mortgage and the given information a) Monthly mortgage payment (principal and interest) b) Monthly house payment (including property taxes and insurance) c) Initial monthly interest d) Income tax deductible portion of initial house payment e) Net initial monthly cost for the home (considering tax savings) Annual Owner's Term of Interest Property Annual Income Tax Mortgage Rate Tax Insurance Bracket 20 years 7% $1284 $384 25% a) The monthly mortgage payment is (Round...
(Use an amortization schedule or financial calculator.) A 15-year, $100,000 mortgage has a fixed mortgage rate...

(Use an amortization schedule or financial calculator.) A 15-year, $100,000 mortgage has a fixed mortgage rate of 8 percent. In the first month, the total mortgage payment is $_______, and $_______ of this amount represents payment of interest. 1,014; 264 878.33; 525.24 955.65; 666.67 none of these

Problem 1: You just borrowed a 15-year fixed rate loan of $200,000 to buy a two-bed...

Problem 1: You just borrowed a 15-year fixed rate loan of $200,000 to buy a two-bed room apartment. Your annual rate of interest is 4%, and the mortgage will be paid annually at the end of each year. 1a. Calculate your annual mortgage payment Please show all of your work. Loan amount Annual Mortgage Payment Interest rate number of Years
Robert and Rebecca Richardson have just signed a 15-year, 4% fixed rate mortgage for $200,000 to...

Robert and Rebecca Richardson have just signed a 15-year, 4% fixed rate mortgage for $200,000 to but their house. Find out this couple's monthly mortgage payment; prepare a loan amortization schedule for Richardson's for the first 3 months; find how much of their payments applied to interest; and after 2 payments, how much of their principal will be reduced ( You may construct a loan amortization schedule and show your calculations).
You financed your $300,000 home with a $200,000 mortgage. If the mortgage has a fixed 6%...

You financed your $300,000 home with a $200,000 mortgage. If the mortgage has a fixed 6% APR with interest compounded monthly (ie, with a 0.5% periodic rate), and if the mortgage is for 30 years, what is the total interest paid over the course of the loan?

suppose you took a $100,000 15 year fixed-rate mortgage at 4.5% (APR) 3 years ago. Now...

suppose you took a $100,000 15 year fixed-rate mortgage at 4.5% (APR) 3 years ago. Now the market interest rate has dropped to 4%, and you are considering refinance your mortgage. (1) What was the original monthly payment? (2) Suppose you just made the 36th monthly payments. What is the remaining mortgage balance? (3) If you refinance with mortgage with another bank and keep the remaining term (that is, 12 years until the mortgage is paid off), what would the...