Question

Solve using excel: A. You have taken out a $225,000, 3/1 ARM. The initial rate of...

Solve using excel:

A. You have taken out a $225,000, 3/1 ARM. The initial rate of 5.8% (annual) is locked in for 3 years and is expected to increase to 6.5% at the end of the lock period. Calculate the initial payment on the loan. (Note: the term on this 3/1 ARM is 30 years) 


B. Given the following information, calculate the Effective Borrowing Cost (EBC). Loan amount: $175,000, Term: 30 years, Interest rate: 7 %, Payment: $1,164.28, Discount points: 1, Origination fee: $3,250. Assume the loan is held until the end of year 10.

C. Suppose you have taken out a $200,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 4.25%. In month 2 of the mortgage, how much of the monthly mortgage payment does the principal repayment portion consist of? 


Homework Answers

Answer #1

A)We taken out a $225,000, 3/1 ARM.

The initial rate of 5.8% (annual)

Locked in for 3 years and is expected to increase to 6.5% at the end of the lock period.

Given Present value 2,25,000
Face value 0
Interest rate 5.80%
Interest rate per month 0.0048333
Term 30 years
Total months(30*12) 360
PMT ₹ -1,320.19

b)Calculation of Effective Borrowing Cost

Loan amount: $175,000, Term: 30 years, Interest rate: 7 %, Payment: $1,164.28,

Discount points: 1 means it is $1,750. Origination fee: $3,250.

Total upfront cost =($1,750+$3,250)=$5,000

Total Loan Amount=$175,000+$5,000 =$180,000

Interest rate =7%. So amount of interest= ($180,000*7%)=$12,600

Effective rate of interest = ($12,600/175,000*100)= 7.2%

C)

Given Present value 2,00,000
Face value 0
Interest rate 4.25%
Interest rate per month 0.00354167
Term 15 years
Total months(15*12) 180
PMT ₹ -1,504.56
Loan Balance after a month
N(180-1) 179
Interest 4.25%
PMT ₹ -1,504.56
Face value 0
Present value 1,99,204
PMT ₹ -1,504.56
Interest 706
Principal 799

Please upvote if you find the solution to be helpful!

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
Suppose you have taken out a $200,000 fully amortizing fixed rate mortgage loan that has a...
Suppose you have taken out a $200,000 fully amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 4.25%. In month two of the mortgage, how much of the monthly mortgage payment does the principal repayment portion consist of?
Please answer using excel: please show formulas and how you actually do it   on there! 1....
Please answer using excel: please show formulas and how you actually do it   on there! 1. You have taken out a $350,000, 3/1 ARM. The initial rate of 6.0% (annual) is locked in for 3 years. Calculate the outstanding balance on the loan after 3 years. The interest rate after the initial lock period is 6.5%. (Note: the term on this 3/1 ARM is 30 years) 
 A. $2,098.43 B. $2,183.95 C. $336,294.25 D. $347,901.57 2. You have taken out a...
A basic ARM is made for $500, 000 at an initial interest rate of 3% with...
A basic ARM is made for $500, 000 at an initial interest rate of 3% with 2 discount points for 10 years. Payments are to be reset each year. The borrower believes that the interest rate at the beginning of year 2 will increase to 9 percent. Assuming that fulling amortizing is made and negative amortization is allowed if payment cap reached. If the ARM loan has a maximum 5% annual increase payment cap, what is the expected yield to...
A basic ARM is made for $500, 000 at an initial interest rate of 3% with...
A basic ARM is made for $500, 000 at an initial interest rate of 3% with 2 discount points for 10 years. Payments are to be reset each year. The borrower believes that the interest rate at the beginning of year 2 will increase to 9 percent. Assuming that fulling amortizing is made and negative amortization is allowed if payment cap reached. If the ARM loan has a maximum 5% annual increase payment cap, what is the expected yield to...
Solve using excel: A. Given the following information, calculate the balloon payment for a partially amortized...
Solve using excel: A. Given the following information, calculate the balloon payment for a partially amortized mortgage. Loan amount: $84,000, Term to maturity: 7 years, Amortization Term: 30 years, Interest rate: 4.5%, Monthly Payment: $425.62. 
 B. Given the following information about a fully amortizing loan, calculate the lender's yield (rounded to the nearest tenth of a percent). Loan amount: $166,950, Term: 30 years, Interest rate: 8 %, Monthly Payment: $1,225.00, Discount points: 2. C. Given the following information, calculate the...
Assume you have taken out a balloon mortgage loan for $2,000,000 to finance the purchase of...
Assume you have taken out a balloon mortgage loan for $2,000,000 to finance the purchase of a commercial property. The loan has a term of 3 years but amortizes over 25 years. Calculate the balloon payment at maturity (Year 3) if the interest rate on this loan is 6%. a. $2,495,479.19 b. $1,886,474.90 c. $2,196,447.59 d. $5,637.99
Answer using excel: Please show how you do it   on excel with formulas! 1. Given the...
Answer using excel: Please show how you do it   on excel with formulas! 1. Given the following information, calculate the effective borrowing cost (rounded to the nearest tenth of a percent). Loan amount: $166,950, Term: 30 years, Interest rate: 8 %, Monthly Payment: $1,225.00, Discount points: 2, Other Closing Expenses: $3,611. 
 A. 7.7% B. 8.2% C. 8.5% D. 9.1% 2. Suppose a potential home buyer is interested in taking a $500,000 mortgage loan that has a term of 30 years...
Mr. Homemaker has just taken out a $175,000 mortgage at an interest rate of 3.6% [Annual...
Mr. Homemaker has just taken out a $175,000 mortgage at an interest rate of 3.6% [Annual rate]. The mortgage calls for equal monthly payments for 15 years. Then the amount of the monthly payment is:[Assume monthly compounding]
You have just taken out an amortized loan for $404,000. Assume that the loan will be...
You have just taken out an amortized loan for $404,000. Assume that the loan will be paid in 24 equal monthly installments of ​$18,345.62​ and that the first payment will be due 1 month from today. How much of your third monthly payment will go toward the repayment of​ principal? Fill in the worksheet below.   Month Interest Owing at End of Month​ ($) Principal Repayment​ ($) Principal Owing at End of Month​ ($) 1 2 3
Tom has taken out a 9-year mortgage for $450,000.00 that requires you to make a payment...
Tom has taken out a 9-year mortgage for $450,000.00 that requires you to make a payment every month with the first payment being made exactly one month from now. The interest rate is fixed at 3.2 percent for the first three years if compounded monthly. a. What is the initial monthly payment? b. Immediately after the fixed-rate period expires, the loan interest rate increases to 4.65%. What is the new monthly payment (assume that the loan fully amortizes over the...