Question

Suppose you are buying a house and have taken out a mortgage for $250,000. The mortgage...

Suppose you are buying a house and have taken out a mortgage for $250,000. The mortgage is a 30 year fixed rate mortgage with an APR of 5.25%. What is your monthly mortgage payment?

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
A B C D E F G H I
2
3 Calculation of monthly payment:
4
5 Monthly payment can be calculated using PMT(RATE,NPER,PV,FV,TYPE) function in Excel as follows:
6
7 Given the following data:
8 Loan Amount $250,000
9 Duration of mortgage 30 Years
10 Interest rate 5.25%
11
12 Monthly Payment can be calculated as below:
13 RATE (Monthly interest rate): 0.44% =D10/12
14 NPER (No of Months): 360 =D9*12
15 PV (Loan Amount): -$250,000 =-D8
16 FV 0
17 TYPE 0
18 Monthly Payment $1,380.51 =PMT(D13,D14,D15,D16,D17)
19
20 Hence Monthly Mortgage Payment is $1,380.51
21
0 0
Know the answer?
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
Similar Questions
7. In order to purchase a house, you have taken out a 30 year mortgage of...
7. In order to purchase a house, you have taken out a 30 year mortgage of $200,000 at 4.29% interest per year. You make payments at the end of every month. What is the amount of each monthly payment?
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and an initial balance of $800,000. The mortgage is currently exactly 18½ years old, and you have just made a payment. If the interest rate on the mortgage is 5.25% (APR), how much cash will you have from the sale once you pay off the mortgage? Sale price $        1,000,000 Initial balance $           800,000 Number of years                        30 Periods...
You have sold your house for $1,100,000 in cash. Your mortgage was originally a 30-year mortgage...
You have sold your house for $1,100,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and an initial balance of $750,000. The mortgage is currently exactly 18.5 years old, and you have just made a payment. If the interest rate on the mortgage is 5.25 (APR), how much cash will you have from the sale once you pay off the mortgage?
You take out standard 30-year mortgage with fixed monthly payments to purchase your house. The mortgage...
You take out standard 30-year mortgage with fixed monthly payments to purchase your house. The mortgage is for $250,000 with a nominal annual rate of 4.6% (Monthly compounding). Each month, you send in a check for $1,403.81, which is above the required payment, where the excess payment directly reduces the outstanding balance each month. What portion of your payments in months 25-36 go towards interest?
You have taken out a standard $250,000, 30-year mortgage, at a nominal annual rate of 4.9%,...
You have taken out a standard $250,000, 30-year mortgage, at a nominal annual rate of 4.9%, with monthly compounding. Determine how much you will still owe on your mortgage, as a percent of the original $250,000, after 15 years (180 payments) if you only make the required monthly payments. A) 65.56% B) 66.23% C) 66.90% D) 67.56% E) 68.21% Pleasse do not use excel to explain this to me thank you.
Suppose you have decided to buy a house. The mortgage is a 30-year mortgage with an...
Suppose you have decided to buy a house. The mortgage is a 30-year mortgage with an interest rate of 7%, compounded monthly. You borrow a total of $250,000. Given this, by the time you pay off the loan, how much in total (interest + principal) would the house cost you?
You have just purchased a home and taken out a $275,000 mortgage. The mortgage has a...
You have just purchased a home and taken out a $275,000 mortgage. The mortgage has a 25-year term with monthly payments and an APR of 3% compounding monthly. How much of your 288th payment will be interest and how much will go toward reducing your principal?
You have just sold your house for $900,000 in cash. Your mortgage was originally a​ 30-year...
You have just sold your house for $900,000 in cash. Your mortgage was originally a​ 30-year mortgage with monthly payments and an initial balance of $700,000. The mortgage is currently exactly​ 18½ years​ old, and you have just made a payment. If the interest rate on the mortgage is 5.25% ​(APR), how much cash will you have from the sale once you pay off the​ mortgage? ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.)
Suppose you have taken out a $200,000 fully amortizing fixed rate mortgage loan that has a...
Suppose you have taken out a $200,000 fully amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 4.25%. In month two of the mortgage, how much of the monthly mortgage payment does the principal repayment portion consist of?
Suppose you take out a 30-year mortgage for a house that costs $496,845. Assume the following:...
Suppose you take out a 30-year mortgage for a house that costs $496,845. Assume the following: The annual interest rate on the mortgage is 3.9%. The bank requires a minimum down payment of 16% at the time of the loan. The annual property tax is 2.1% of the cost of the house. The annual homeowner's insurance is 0.6% of the cost of the house. There is no PMI If you make the minimum down payment, what will your monthly PITI...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT