Question

In: Finance

Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%.

Show work through excel formulas: please actually show how you do it   on excel exactly!

1. Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%. After your first mortgage payment, how much of the original loan balance is remaining? 


A. $1,054.82 B. $120,603.78 C. $124,570.18 D. $124,875.56

2. Assume you have taken out a partially amortizing loan for $325,000 that has a term of 7 years, but amortizes over 30 years. Calculate the balloon payment at maturity (Year 7) if the interest rate on this loan is 4.5%. 


A. $1,646.73 B. $118,468.21 C. $282,835.42 D. $324,572.02

Solutions

Expert Solution

1.

Loan amount $ 125,000.00
Term in years 15
Total number of payments 180
Annual Interest rate 6%
Monthly Interest rate 0.50%
Monthly payment $1,054.82
Principal paid in the first payment $          429.82
Loan Balance $ 124,570.18

Excel formulas:

2.

Loan amount $ 325,000.00
Amortizing term in years 30
Amortizing term in month 360
Annual interest rate 4.50%
Monthly interest rate 0.375%
Monthly payment $1,646.73
Number of payment upto 7 years 84
Principal paid upto 7 years $    42,164.58
Balloon payment $ 282,835.42

Excel formulas:


Related Solutions

Solve using excel: A. Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan...
Solve using excel: A. Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%. After your first mortgage payment, how much of the original loan balance is remaining? 
 B. Assume you have taken out a partially amortizing loan for $325,000 that has a term of 7 years, but amortizes over 30 years. Calculate the balloon payment at maturity (Year 7) if the interest rate on...
Suppose you have taken out a $175,000 fully amortizing fixed rate mortgage loan that has a...
Suppose you have taken out a $175,000 fully amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 5.25%. After your first mortgage payment, how much of the original loan balance is remaining? Can you teach me how to do it on excel, please? I am confused on how to make it monthly compounding.
A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is...
A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is 6 percent per year compounding monthly. Payments are to be made monthly. What is the principal payment in the first monthly payment?
A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years....
A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years. Payments are to be made monthly. (Ignore origination fee and other fees). a.      Using Excel, construct fully amortizing mortgage loan table including beginning balance, payment, interest, principal, and ending balance. (Please check your ending balance by using PV function in Excel) b.      Interest and principal payments during month 1. c.       Total Principal and total interest paid over 30 years. d.      The outstanding loan balance...
Assume you have taken out a partially amortizing loan for $1,250,000 that has a term of...
Assume you have taken out a partially amortizing loan for $1,250,000 that has a term of 7 years but amortizes over 20 years. Calculate the balloon payment if the interest rate on this loan is 7.25%.
Ms. Jordan has just taken out a $150,000 mortgage loan at an interest rate of 6...
Ms. Jordan has just taken out a $150,000 mortgage loan at an interest rate of 6 percent. If the mortgage calls for equal monthly payments for 20 years, what is the amount of each payment? Also, work out an amortization table
Assume a $270,000 fully amortizing mortgage loan, which accrues interest at a 7.5% interest rate, and...
Assume a $270,000 fully amortizing mortgage loan, which accrues interest at a 7.5% interest rate, and has a maturity of 25 years. Payments are monthly. What is the payoff of the loan in 12 years?
Mortgage Pricing A 30Y fixed rate mortgage is issued at 6% coupon rate. The loan fully...
Mortgage Pricing A 30Y fixed rate mortgage is issued at 6% coupon rate. The loan fully amortizes over 30 year period. Expected payoff time is 8 Years when initially issued. Assuming $1M in loan balance. a) Price the loan today at 5%, 6%, and 7% market yield, assuming loan termination term stays constant with interest rate (96 months at 5%; 96 months at 6%, and 96 months @ 7% b)calculate numerical duration and convexity at 6% market interest rate based...
15. Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments...
15. Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $3,200,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, which mortgage has the lowest cost of borrowing (ie lowest annualized IRR)? Type 1...
A customer has taken out a fully amortized loan for $56,000 at a 7.5% interest rate...
A customer has taken out a fully amortized loan for $56,000 at a 7.5% interest rate over 7 years.   The marginal tax rate is 30%. What is the yearly payment? a.$10,572.82 b.$10,143.93 c.$9,458.92 d.$8,496.73 What is the interest payment in year 2? a.$2,835.00 b.$2,438.68 c.$3,208.23 d.$3,722.04 What are the tax savings from interest in year 1? a.$11,116.61 b.$793.80 c.$1,260.00 d.$2,835.00
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT