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
You just obtained a $325,000 adjustable rate mortgage (ARM) with 30 year amortization and a 3...
You just obtained a $325,000 adjustable rate mortgage (ARM) with 30 year amortization and a 3 year reset period. Your starting interest rate for the loan is 3% and you believe that your rate in 3 years will rise to 3.75%. If you are correct, what will be your new mortgage payment at the start of the 4th year (i.e., right after the reset period)? a. $1,407.96 b. $1,493.53 c. $1,281.75 d. $1,370.21