ZuoTi.Pro
Question

Ann buys a $300,000 house, with 20% down and a 6% annual interest rate and a...

Ann buys a $300,000 house, with 20% down and a 6% annual interest rate and a 30 year mortgage. What are the approximate monthly payments?

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

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

Home nert Page Layout Formulas Data Review View dd-Ins s Cut ta copy ▼ E AutoSum Calibri Wrap Text General в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Paste Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. Styles ▼ ㆆ ▼ Clipboard PS139 PK Font Alignment Number Cells PL PM PN PO PQ PR PS PT PU PV 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 240000 (300000-20%) LOAN YEARS RATE METHOD 1 USING FORMULA 30 5% PVA A/(r/m) (1-(1/(1+r/m)mn)) 240000 (A/(0.06/12)) (1-(1/(1+0.06/12)A12*30)) 240000 (A/(0.005) (0.83395807) m NO OF PERIODS IN A YEAR A 240000*0.005/0.83395807 1438.92 METHOD 2 USING EXCEL PMT- 1438.92 PMT(PO132/12, PO131 12,-P0130) CAP STRU VALUE ols LOCK BOX DILUTION DOLLAR COST AVG . MORTGAGE , EXPO Sheet1 . Sheet2 . Sheet3 Sheet4く rences: x261 02:52 24-01-2019

0 0
Add a comment
Know the answer?
Add Answer to:
Ann buys a $300,000 house, with 20% down and a 6% annual interest rate and a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • Ann got a 15 year Fully Amortizing FRM for $1,000,000 at an annual interest rate of...

    Ann got a 15 year Fully Amortizing FRM for $1,000,000 at an annual interest rate of 7% compounded monthly, with monthly payments. After 5 years of payments, Ann can refinance the balance into a 10 year Fully Amortizing FRM at an annual interest rate of 5.25% compounded monthly, with monthly payments. If Ann refinances into this 10 year loan, what will be her monthly savings on her mortgage payment? "

  • 1.You purchase a $255,000 house, pay 20% down and get a loan for $204,000. The loan is a 30-year fixed-rate mortgag...

    1.You purchase a $255,000 house, pay 20% down and get a loan for $204,000. The loan is a 30-year fixed-rate mortgage where the annual interest rate is 5.85% and there will be 360 monthly payments. What is the monthly payment?

  • Ann got a 30 year Fully Amortizing FRM for $1,000,000 at an annual interest rate of...

    Ann got a 30 year Fully Amortizing FRM for $1,000,000 at an annual interest rate of 8% compounded monthly, with monthly payments. After 5 years of payments, Ann can refinance the balance into a 25 year Fully Amortizing FRM at an annual interest rate of 5% compounded monthly, with monthly payments. Refinancing will cost Ann 2 points and $1,500 in closing costs. If Ann refinances into this loan after 5 years, what will be her total cost of refinancing?"

  • Mortgage Information Annual Interest Rate 4.90% Repayment Years 30 Price of House $275,000 Down Payment $55,000...

    Mortgage Information Annual Interest Rate 4.90% Repayment Years 30 Price of House $275,000 Down Payment $55,000 Principal of Loan Monthly Payments On the Mortgage worksheet, use the PMT function in cell B7 to calculate the monthly payments of the mortgage. Use cell locations from this worksheet to define each argument of the function. Assumethat payments are made at the end of each month.On the Mortgage worksheet, use the data provided to enter a formula in cell B6 to calculate the...

  • You just purchased a $400,000 house and gave a 20% down payment. For the remaining portion,...

    You just purchased a $400,000 house and gave a 20% down payment. For the remaining portion, you obtained a 30-year mortgage at a 6% interest rate. A) What are the monthly payments on this mortgage? B) If the house appreciates at a 3 percent annually, what will be the value of the house in ten years? C) In ten years, how much equity will you have on this home?

  • A family buys a house for which they assume a mortgage of $200,000. The annual mortgage...

    A family buys a house for which they assume a mortgage of $200,000. The annual mortgage rate is 9% and is compounded monthly. The loan amortization period is 15 years and the mortgage payments will be made at the end of each month What is the monthly mortgage payment? What will be the outstanding loan amount at the end of five years? What is the total interest that will be paid over the amortization period?

  • Barb bought a house with 20% down and the rest financed by a 30-year mortgage with monthly payments calculated at a nomi...

    Barb bought a house with 20% down and the rest financed by a 30-year mortgage with monthly payments calculated at a nominal annual rate of interest 8.4% compounded monthly. She notices that one-third of the way through the mortgage she will still owe 200,000. Determine the purchase price of the house. 252,706 262,706 272,806 282,706 292,706

  • Question 1 of 6 Lucy purchased a house for $300,000. She made a down payment of...

    Question 1 of 6 Lucy purchased a house for $300,000. She made a down payment of 20.00% of the value of the house and received a mortgage for the rest of the amount at 4.52% compounded semi-annually amortized over 15 years. The interest rate was fixed for a 6 year period. a. Calculate the monthly payment amount. Round to the nearest cent b. Calculate the principal balance at the end of the 6 year term. Round to the nearest cent...

  • A man buys a house for $255,000. He pays $40,000 down and takes out a mortgage...

    A man buys a house for $255,000. He pays $40,000 down and takes out a mortgage at 6.9% on the balance. Find his monthly payment and the total amount of interest he will pay if the length of the mortgage is (a) 15 years; (b) 20 years; (c) 25 years. (d) When will half the 20-year loan be paid off? (a) For the 15-year mortgage, the man will make monthly payments of $| (Do not round until the final answer....

  • 5. Jim has an annual income of $300,000 Jim is looking to buy a house with...

    5. Jim has an annual income of $300,000 Jim is looking to buy a house with monthly property taxes of $140 and monthly homeowner's insurance of $70 Jim has $178 in monthly student loan payments. Apple bank has a maximum front end DTI limit of 28% and a maximum back end DTI limit of 36%. Given both limits, what is the most they will allow Jim to spend on a monthly mortgage payment? 6. Jim has an annual income of...

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
ADVERTISEMENT