Question

What size mortgage can you afford if you can make a monthly payment of $1,200 per...

What size mortgage can you afford if you can make a monthly payment of $1,200 per month for 30 years? You can borrow at 2.5%, compounded monthly.

PV=

FV=

PMT=

N=

I/Y=

Homework Answers

Answer #1
Particulars (Function) -
Monthly payment PMT $                    1,200
Years - 30
Number of payments in a year - 12
Total number of payments N 360
Interest rate - 2.50%
Monthly interest rate I/Y 0.208%
Future value FV 0
Size of mortgage PV $303,704.51

Excel formulas:

Know the answer?
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
Similar Questions
You have purchased a home for $200,000 with a down payment of 10 percent. Prevailing mortgage...
You have purchased a home for $200,000 with a down payment of 10 percent. Prevailing mortgage interest rates are 4.5 percent. If you finance the home for 30 years, what is your monthly payment? N I/Y PV PMT FV If you finance it for 20 years, what is your monthly payment? N I/Y PV PMT FV If you finance it for 15 years, what is your monthly payment? N I/Y PV PMT FV Assuming you choose a 20-year payment period...
You can afford a $1200 per month mortgage payment. You've found a 30 year loan at...
You can afford a $1200 per month mortgage payment. You've found a 30 year loan at 6% annual interest compounded monthly. a) How big of a loan can you afford? $ b) How much total money will you pay the loan company? $ c) How much of that money is interest? $
you can afford monthly payments of $500 if current mortgage rates are 2.94% for a 15...
you can afford monthly payments of $500 if current mortgage rates are 2.94% for a 15 year fixed loan rate how much can you afford to borrow? If you are required to make a 10% down payment and you have the cash on hand to do it how expensive of a home can you afford?
You have a credit card with an APR of 16%, compounded monthly, that has a balance...
You have a credit card with an APR of 16%, compounded monthly, that has a balance of $7,000. You want to transfer this balance to a different card with an APR of 14.5%, compounded monthly. Assuming that you will make the minimum payments of $150 per month for either card, what transfer fee would make you ambivalent between transferring or not? PV= FV= PMT= N= I/Y=
You make two separate deposits in a bank. The first amount of $1,200 deposited today earns...
You make two separate deposits in a bank. The first amount of $1,200 deposited today earns a 6% interest per year for 10 years, and the second amount of $800 to be deposited two years from now would earn a 5% interest per year for the next 8 years. What would be your total future value at the end of year 10? What is the future value of an annuity payment of $1250 over 5 years if interest rates are...
Juliet has a 10-year mortgage of $500,000 with an interest rate of 3.5% APR, compounded quarterly....
Juliet has a 10-year mortgage of $500,000 with an interest rate of 3.5% APR, compounded quarterly. Mortgage payments are made at the beginning of each month. What is the balance remaining on this mortgage after the 60th payment? PLEASE DO NOT GIVE THE INCORRECT ANSWER of Find first month rate as given rate is compounded quarterly (1 + r)^12 = (1 + 0.035/4)^4 r = (1 + 0.035/4)^(1/3) – 1 = 0.002908 = 0.2908% Set up the TVM parameters PV...
You can afford a $1250 per month mortgage payment. You have found a 30 year loan...
You can afford a $1250 per month mortgage payment. You have found a 30 year loan at 7% interest. How big of a loan can you afford? How much total money will you pay the loan company? How much of that money is interest?
You can afford a $1400 per month mortgage payment. You've found a 30 year loan at...
You can afford a $1400 per month mortgage payment. You've found a 30 year loan at 6% interest. a) How big of a loan can you afford? $ b) How much total money will you pay the loan company? $ c) How much of that money is interest? $
You can afford a $1000 per month mortgage payment. You've found a 30 year loan at...
You can afford a $1000 per month mortgage payment. You've found a 30 year loan at 8% interest. a) How big of a loan can you afford? $ b) How much total money will you pay the loan company? $ c) How much of that money is interest?
if sally mander can afford 1100 monthly mortgage payment (30 years ) and she plans to...
if sally mander can afford 1100 monthly mortgage payment (30 years ) and she plans to put 20% down in the current mortgage rate is 7% how expensive of a house is he planning to purchase $132270 $165338 $198406 $206673