Question

In: Finance

A)You have just taken a 30-year mortgage loan for $260,000. The annual percentage rate on the...

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?

Solutions

Expert Solution

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


Related Solutions

You have just taken out a 30‑year mortgage on your new home for$103,104. This mortgage...
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...
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...
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...
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...
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...
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%....
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...
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...
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...
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
ADVERTISEMENT