Question

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 $300,000, 5/1 ARM. The initial rate of 5.4% (annual) is locked in for 5 years. Calculate the payment after recasting the loan (i.e., after the reset) assuming the interest rate after the initial lock period is 8.0%. (Note: the term on this 5/1 ARM is 30 years) 


A. $1,684.59 B. $1,784.79 C. $1,887.75 D. $2,138.02

Homework Answers

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
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:...
Show work through excel using formulas: but please actually show each step you use to do...
Show work through excel using formulas: but please actually show each step you use to do it on excel! 1. Assume you have taken out a balloon mortgage loan for $2,500,000 to finance the purchase of a commercial property. The loan has a term of 5 years, but amortizes over 25 years. Calculate the balloon payment at maturity (Year 5) if the interest rate on this loan is 4.5%. A. $5,637.99 B. $13, 895.82 C. $2,196,447.59 D. $2,495,479.19
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...
Please show all calculations and formulas. If using Excel (or tables), please show data, formulas, etc....
Please show all calculations and formulas. If using Excel (or tables), please show data, formulas, etc. Practice question 14: Calculate the company’s w.a.c.c. using the info below. ***assume this is a corporate bond that pays 2x annually when calculating the PV of the bond Harvey LLC’s capital structure consists of a 25-year bond issued 5 years ago with a coupon of 6% and a par value of $14,000,000. The company’s main competitor just issued a similar bond paying 5%. The...
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
Please show formulas in Excel or work - My formulas keep getting an Error and I...
Please show formulas in Excel or work - My formulas keep getting an Error and I don't know what I am doing wrong. You want to compare two separate retirement savings​ scenarios: (A) and​ (B). In scenario​ (A) you start​ immediately, contribute for a few​ years, but then stop contributing.​ However, you leave the accumulated savings to compound until retirement. In scenario​(B) you start later​ (after the end of savings in scenario​ A) and contribute all the way to retirement....
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...
Five years ago Lilian took out a 30 year 5/1 Hybrid ARM loan with monthly payments....
Five years ago Lilian took out a 30 year 5/1 Hybrid ARM loan with monthly payments. The initial rate on this loan is 2% and it resets to LIBOR plus a margin of 150bps. Suppose the remaining balance after five years of payments is $197,000 and the LIBOR rate at the first reset if 4%. What will be Lilian's new monthly payment during 6th year of the loan? Express your answer as a number rounded to the nearest cent (e.g....
Five years ago Lilian took out a 30 year 5/1 Hybrid ARM loan with monthly payments....
Five years ago Lilian took out a 30 year 5/1 Hybrid ARM loan with monthly payments. The initial rate on this loan is 2% and it resets to LIBOR plus a margin of 150bps. Suppose the remaining balance after five years of payments is $210,107 and the LIBOR rate at the first reset if 4%. What will be Lilian's new monthly payment during 6th year of the loan? Express your answer as a number rounded to the nearest cent (e.g....
Five years ago Lilian took out a 30 year 5/1 Hybrid ARM loan with monthly payments....
Five years ago Lilian took out a 30 year 5/1 Hybrid ARM loan with monthly payments. The initial rate on this loan is 4% and it resets to LIBOR plus a margin of 150bps. Suppose the remaining balance after five years of payments is $291,861 and the LIBOR rate at the first reset if 4%. What will be Lilian's new monthly payment during 6th year of the loan? Express your answer as a number rounded to the nearest cent (e.g....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT