Question

3. You have just taken a 30-year mortgage loan for $200,000. The annual percentage rate on the loan is 8%, and payments will be made monthly. Estimate your monthly payments.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum Calibri ー E ゴWrap Text General ta copy. в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Paste Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard PM146 PJ Font Alignment Number Styles Cells Edting PK PL PM PN PO Pa PR PS PT PU 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 11 1 トーCALCULATOR ( LOAN OPTIONS | pv, fv, annuity 1 CAP STRU VALUE LOAN YEARS RATE METHOD 1 USING FORMULA 200000 30 8% PVA A/(r/m) (1-(1/(1+r/m)mn)) 200000 (A/(0.08/12)) (1-(1/(1+0.08/12)A12*30)) m-NO OF PERIODS IN A YEAR 200000 (A/(0.00666667) (0.90855663) A= 200000*0.00666667/0.90855663 1467.53 METHOD 2 USING EXCEL PMT- $1,467.53 PMT(PO132/12,PO131 12,-PO130) BOX | DILUTION DOLLAR COST AVG MORTGAGE.. EXPO ( Sheet1 . Sheet2. Shell- rences: x261 09:02

Add a comment
Know the answer?
Add Answer to:
3. You have just taken a 30-year mortgage loan for $200,000. The annual percentage rate on...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You have just taken out a 13 -year, $ 267 ,000 mortgage loan at an annual...

    You have just taken out a 13 -year, $ 267 ,000 mortgage loan at an annual interest rate of 7.5 percent. The mortgage has monthly payments. What is the amount of each payment? Calculate your answer to the nearest $.01. Enter your answer as a postive number. Do not use the $ or , sign.

  • A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The...

    A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two years of the loan have a “teaser” rate of 4%, after that, the rate can reset with a 2% annual rate cap. On the reset date, the composite rate is 5%. What would the Year 3 monthly payment be? a. $955 b. $1,071 c. $1,067 d. $1,186 e. Because of the rate cap, the payment would not change.

  • You just bought a house and have a mortgage of $200,000. The mortgage is for 30...

    You just bought a house and have a mortgage of $200,000. The mortgage is for 30 years and has a mortgage rate of 8 percent annually. After 36 payments (3 years ). What will be the remaining balance on your mortgage? What is the cumulative interest you have paid over the 36 periods?

  • 2. (25 Points) Suppose a borrower takes out a 30-year adjustable rate mortgage loan for $200,000...

    2. (25 Points) Suppose a borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two years of the loan have a "teaser" rate of 4%, after that, the rate can reset with a 2% annual rate cap. On the reset date, the composite rate is 7%. What would the Year 3 monthly payment be? (15 points) Step I Step2 PV= -179084.11 PV = -200 000 I= 7412=10.58) I=47212= 10.33) N= 336 N=360 130x2)...

  • you have just taken out a 30 year $120,000 mortgage on your new home. This mortgage...

    you have just taken out a 30 year $120,000 mortgage on your new home. This mortgage is to be repaid in 360 equal monthly installments. if the stated (nominal) annual interest rate is 15.73 percent, what is the amount of interest portion of the FIRST installment?

  • Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan...

    Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...

  • 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).

  • 1. You have just taken out a 30‑year mortgage on your new home for $126,142. This...

    1. You have just taken out a 30‑year mortgage on your new home for $126,142. This mortgage is to be repaid in 360 equal monthly installments. If the stated (nominal) annual interest rate is 15.4 percent, what is the amount of each of the monthly installments? (Note: The convention when periodic payments are involved is to assume that the compounding frequency is the same as the payment frequency, unless stated otherwise. Thus this implies 15.4 % APR, compounded monthly for...

  • you have just taken out a 30 year, $120,000 mortgage on your new home. this mortggage...

    you have just taken out a 30 year, $120,000 mortgage on your new home. this mortggage is to be repaid in 360 equal monthly installments. if the stated (nominal) annual interest rate is 13.95 %, what is the amount of the INTEREST PORTION od the FIRST monthly installment?

  • You have just taken out a $27,000 car loan with a 7 % ​APR, compounded monthly....

    You have just taken out a $27,000 car loan with a 7 % ​APR, compounded monthly. The loan is for five years. When you make your first payment in one​ month, how much of the payment will go toward the principal of the loan and how much will go toward​ interest?  ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.) You have just sold your house for $900,000 in cash. Your mortgage was originally a​...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT