In: Finance

A)You have just taken a 30-year mortgage loan for $260,000. The annual percentage rate on the loan is 4.25%, and payments will be made monthly. Estimate your monthly payments. Assume compounding is monthly. Prepare an amortization table.

B) At age 30, Susan starts investing $18,000 per year with the investments at the end of each year. She does this for 9 years. She never invests any more but she leaves this money in the no-load mutual fund. The fund earns 8% per year. Calculate the value of the fund when Ann is 65. Assume compounding is annually.

C) For question B above, assuming Ann makes equal withdrawals from her retirement account at the end of each year from age 65 to age 85, how much does she withdraw to bring the fund to zero?

A: Monthly payment =1279.04 (Due to space constraint posting, first 10 and last 10 payments)

Month |
StartingBalance |
Interest |
Principal |
EndingBalance |
TotalInterest |

1 | $260,000.00 | $920.83 | $358.21 | $259,641.79 | $920.83 |

2 | $259,641.79 | $919.56 | $359.48 | $259,282.31 | $1,840.40 |

3 | $259,282.31 | $918.29 | $360.75 | $258,921.56 | $2,758.69 |

4 | $258,921.56 | $917.01 | $362.03 | $258,559.53 | $3,675.70 |

5 | $258,559.53 | $915.73 | $363.31 | $258,196.22 | $4,591.44 |

6 | $258,196.22 | $914.44 | $364.60 | $257,831.62 | $5,505.88 |

7 | $257,831.62 | $913.15 | $365.89 | $257,465.73 | $6,419.03 |

8 | $257,465.73 | $911.86 | $367.19 | $257,098.54 | $7,330.89 |

9 | $257,098.54 | $910.56 | $368.49 | $256,730.06 | $8,241.45 |

10 | $256,730.06 | $909.25 | $369.79 | $256,360.26 | $9,150.70 |

351 | $12,544.78 | $44.43 | $1,234.61 | $11,310.17 | $200,254.51 |

352 | $11,310.17 | $40.06 | $1,238.99 | $10,071.18 | $200,294.57 |

353 | $10,071.18 | $35.67 | $1,243.37 | $8,827.80 | $200,330.24 |

354 | $8,827.80 | $31.27 | $1,247.78 | $7,580.02 | $200,361.50 |

355 | $7,580.02 | $26.85 | $1,252.20 | $6,327.83 | $200,388.35 |

356 | $6,327.83 | $22.41 | $1,256.63 | $5,071.19 | $200,410.76 |

357 | $5,071.19 | $17.96 | $1,261.08 | $3,810.11 | $200,428.72 |

358 | $3,810.11 | $13.49 | $1,265.55 | $2,544.56 | $200,442.21 |

359 | $2,544.56 | $9.01 | $1,270.03 | $1,274.53 | $200,451.22 |

360 | $1,274.53 | $4.51 | $1,274.53 | $0.00 | $200,455.74 |

WORKINGS

B | Value of fund at 65 | $3,101,702.47 |

C | Amount of withdrawal | $315,915.25 |

You have just taken out a 30‑year mortgage on your new home for
$103,104. This mortgage is to be repaid in 360 equal monthly
installments. If the stated (nominal) annual interest rate is 13.35
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 13.35 % APR,
compounded monthly for this...

Mortgage Payment
You currently have a 30-year fixed rate mortgage with an annual
interest rate of 6%. You have had the mortgage 4 years, and on
September 1, 2015 you made your 48th payment. The original
principal amount was $280,000 and you monthly payment, without
taxes and insurance, are $1,678.74 per month, computed using the
Excel function =PMT(0.5%,360,280000,0,0).
Starting with your original mortgage your banker calls and says
that you could refinance your existing mortgage (6% rate, 30-year
original term)...

You have just bought a house and have taken out a mortgage (an
installment) loan for $500,000. This is a 30-year loan that
requires monthly payments and the first payment is due one month
from today. The APR for the loan is 24%. You are interested to know
how much of your 210th monthly payment will go toward
the repayment of principal? That amount is _______________
Question 10 options:
$762.65
$9,586.98
$625.64
$9,494.78
$513.24
$9,382.38
$421.04
$9,245.37

You currently have a 30-year fixed rate mortgage with an annual
interest rate of 6%. You have had the mortgage 4 years, and on
September 1, 2015 you made your 48th payment. The
original principal amount was $280,000 and you monthly payment,
without taxes and insurance, are $1,678.74 per month, computed
using the Excel function =PMT(0.5%,360,280000,0,0).
Starting with your original mortgage your banker calls and says
that you could refinance your existing mortgage (6% rate, 30-year
original term) into a...

32.
Mortgage rates: Following are interest rates
(annual percentage rates) for a 30-year fixed rate mortgage from a
sample of lenders in Macon, Georgia on a recent day. It is
reasonable to assume that the population is approximately
normal.
4.750
4.375
4.176
4.679
4.426
4.227
4.125
4.250
3.950
4.191
4.299
4.415
a.
Construct a 99% confidence interval for the mean rate.
b.
One week earlier, the mean rate was 4.050%. A mortgage broker
claims that the mean rate is now...

You have just purchased a new home and have taken out a mortgage
loan for $300,000 at an interest rate of 4.00% and a maturity of 30
years. You will make 360 equal monthly payments.
What is the amount of your monthly payment? Please
fill in the amortization schedule below for the
first two months (month1 and 2) of the 360 months
that you will be paying on the mortgage.
Hint: PVA = Payment [1-(1+r)^-N / r]
Please fill in...

You
currently have a 30-year mortgage with annual payments of $6000.
Annual interest rate is 8%. In how many years, the balance on your
mortgage will drop to half of its current value? Round your result
to two decimal places (i.e., if the result is 7.6542, enter it as
7.65).

You just took a $90,000, 10 years loan. The annual percentage
rate (APR) is 8%. You are obligated to pay a flat payment at the
end of each QUARTER. (a) Make a loan amortization table; (b) Plot a
figure to show the flat payment, payment to interest, and payment
in each quarter. SHOW IN EXCEL PLEASE

Suppose that you take out a 30-year mortgage loan of $200,000 at
an interest rate of 10%.
What is your total monthly payment?
How much of the first month’s payment goes to reduce the size of
the loan?
If you can afford to pay $2,000 per month, how long would it
take you to pay
for this loan (still at 10% interest)?
If you can only pay $1,700 per month, and still want to finish
paying in 30
years, what...

You are currently maintaining a conventional 30-year
mortgage loan with your bank and the annual interest rate is 8%.
Your bank manager now offers you a 30-year adjustable rate mortgage
(ARM) at 2% but the rate will be adjusted once each year. Evaluate
your current mortgage and the new option in terms of the following:
Risk that the monthly payment will change over the next 30 years,
and, interest rate risk. Explain your understanding on the risk
involved in this...

ADVERTISEMENT

ADVERTISEMENT

Latest Questions

- Write a C++ program that will use good object-oriented principles. You have been tasked to write...
- Python: What are the defintions of the three method below for a class Date? class Date(object):...
- What position does Michael Porter take when describing Shared Value? How does this differ from the...
- What is the treatment for schzophrenia condition? How was this disorder treated in the past? Has...
- Which of these are a case for Cultural Relativism? 1. Different societal contexts demand different moral...
- Annuity You are going to borrow money from the bank. But when considering your income, you...
- As you will learn, working in groups is no easy task! Hopefully, you will master some...

ADVERTISEMENT