Question

Using the Mortgage Payment Formula, calculate a monthly mortgage payment for a home with the price of $405,000 using pencil and paper. Your down payment is 10% of your own money apart from the loan. Calculate the total paid for your home after paying the monthly payment for 15 years factoring in the rate of 2.500% and APR of 2.556%. You can use arithmetic. How much money will you pay in interest over 15 years? All Calculations must be shown.

Answer #1

Loan amount=Purchase price*(1-% downpayment)=405000*(1-10%)=364500.00

Monthly payment=Loan amount*(rate/12)/(1-1/(1+rate/12)^(12*n))

Case 1: Rate is 2.500%

=364500.00*(2.500%/12)/(1-1/(1+2.500%/12)^(12*15))

=2430.45

Case 2: Rate is 2.556%

=364500.00*(2.556%/12)/(1-1/(1+2.556%/12)^(12*15))

=2440.07

Money paid in interest=Monthly payments*12*n-Loan amount

Case 1: Rate is 2.500%

=2430.45*12*15-364500.00

=72981.00

Case 2: Rate is 2.556%

=2440.07*12*15-364500.00

=74712.60

Using the Mortgage Payment Formula, calculate a monthly mortgage
payment for a home with the price of $405,000 using pencil and
paper. Your down payment is 10% of your own money apart from the
loan. Calculate the total paid for your home after paying the
monthly payment for 30 years factoring in the rate of 2.990%. You
can use arithmetic. How much money will you pay in interest over 30
years? All Calculations must be shown.

3. You take a $500,000 mortgage to buy a vacation home. The
mortgage entails equal monthly payments for 10 years, 120 payments
in all, with the first payment in one month. The bank charges you
an interest rate of 9.6% (APR with monthly compounding).
a. How much of your first payment is interest, and how much is
repayment of principal?
b. What is the loan balance immediately after the 10th payment?
(Calculate the loan balance using the annuity formula.)
c....

Create a formula using the PMT function to calculate the monthly
loan payment using interest rate and loan period values in cells
C4:C8. Enter the formula with a - (negative) sign to return
positive value. Do not specify values for the optional arguments fv
or type.
Loan amount: $1,000,000
Interest Rate APR- 5.0%
Monthly Interest Rate- 0.4%
Payment periods (years)- 5
Period (months)- 60

Steve is buying home that costs $500,000. You have been offered
a 30-year mortgage that requires a 20% down payment for the house.
The loan is to be repaid in equal monthly installments. The APR of
the mortgage is 4%. Compute the EAR and the amount of your monthly
payment on the mortgage. Show all calculations. you need to find
the amount of the monthly payment in two different ways: 1) using
the built-in Excel function 2) using the annuity...

Estimate the affordable monthly mortgage payment, the affordable
mortgage amount, and the affordable home purchase price for the
following situation. (Refer to Exhibit 9-8 and Exhibit 9-9) (Round
time value factor to 2 decimal places, intermediate and final
answers to the nearest whole number.) Monthly gross income $ 3,400
Down payment to be made (percent of purchase price) 10 Percent
Other debt (monthly payment) $ 215 Monthly estimate for property
taxes and insurance $ 255 30-year loan 7.5 Percent
what...

You are borrowing $245,000 to purchase a home. The loan
agreement requires a monthly payment based upon a 4.5% quoted APR
over 20 years. What is your monthly mortgage payment?

Your monthly income is $10,000 per month. Your mortgage payment
is $1600, student loan payments are $500, car payments are $400 and
credit card payments (paying down a credit card debt) are $1000.
You are thinking of taking out a home equity loan to remodel your
house. In order to keep your debt to income ratio below 36%, what
is highest monthly payment you could afford on the home equity
loan? If the term of the loan is 5 years...

You have been saving money to buy a home and today, you decided
to buy a home and take out $350,000 mortgage loan from a bank. This
loan requires you to make a monthly payment for 30 years and the
interest rate on your loan is 4% APR compounded monthly. What is
your monthly mortgage payment for this loan? Please show your excel
formula in your answer and explain step-by-step calculation to
arrive to your answer.

4. A. What would be your mortgage payment if you pay for a
$250,000 home by making a 20% down payment and then taking out a
3.74% thirty year fixed rate mortgage loan to cover the remaining
balance. All work must be shown justifying the following
answers?
Mortgage payment = _______________
B. How much total interest would you have to pay over the entire
life of the loan?
Total interest paid = __________
C. Suppose you inherit some...

suppose that 10 years ago you bought a home for $140,000, paying
10% as a down payment, and financing the rest at 9% interest for 30
years.
a. how much money did you pay as your down payment?
b. how much money was your existing mortgage loan for?
c. what is your current monthly payment on your existing
mortgage?
d. how much total interest will you pay over the life of the
existing loan?

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 17 minutes ago

asked 41 minutes ago

asked 41 minutes ago

asked 51 minutes ago

asked 54 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago