Answered step by step
Verified Expert Solution
Question
1 Approved Answer
this is everything rcise 2: Let's look at what happens when someone has an adjustable rate mortgage. The borrower will have a fixed rate for
this is everything
rcise 2: Let's look at what happens when someone has an adjustable rate mortgage. The borrower will have a fixed rate for the first three years: Exercise 3: Let's look at what happens when someone refinances a mortgage. The borrower begins with these terms: \begin{tabular}{|r|r|} \hline annual interest rate & 6.00% \\ \hline amount borrowed & $380,000 \\ \hline term in years & 15 \\ \hline \end{tabular} a. Prepare the amortization schedule with the initial terms denoted above using monthly payments. You can show a complete 15 year amortization schedule OR Just what is necessary to answer the question. b. and c. After making payments for 48 months, the borrower can refinance the loan with a lower Interest rate of 5.00%. The lender charges a $3,500 fee and the borrower decides to refinance the balance owed PLUS the $3,500 fee. Prepare the amortization schedule for the remaining length of time. Show your work on the Exercise 3 tab. \begin{tabular}{|l|l|l|l|l|l|l} \hline A & B & D & C & F & G & H \\ \hline Exercise 3 & & & & & \\ \hline \end{tabular} Please show your two different amortization schedules on this tab and answer the following questions: a. monthly payment initially with 6.00% rate b. balance owed after 48 months c. new monthly payment with new rate of 5.00% answers should be denoted in the answer boxes by cell references to the amort schedules a. Prepare the amortization schedule with the initial terms denoted above using monthly payments. You can show a complete 15 year amortization schedule OR just what is necessary to answer the question. b. and c. After making payments for 48 months, the borrower can refinance the loan with a lower interest rate of 5.00%. The lender charges a $3,500 fee and the borrower decides to refinance the balance owed PLUS the $3,500 fee. Prepare the amortization schedule for the remaining length of time. rcise 2: Let's look at what happens when someone has an adjustable rate mortgage. The borrower will have a fixed rate for the first three years: Exercise 3: Let's look at what happens when someone refinances a mortgage. The borrower begins with these terms: \begin{tabular}{|r|r|} \hline annual interest rate & 6.00% \\ \hline amount borrowed & $380,000 \\ \hline term in years & 15 \\ \hline \end{tabular} a. Prepare the amortization schedule with the initial terms denoted above using monthly payments. You can show a complete 15 year amortization schedule OR Just what is necessary to answer the question. b. and c. After making payments for 48 months, the borrower can refinance the loan with a lower Interest rate of 5.00%. The lender charges a $3,500 fee and the borrower decides to refinance the balance owed PLUS the $3,500 fee. Prepare the amortization schedule for the remaining length of time. Show your work on the Exercise 3 tab. \begin{tabular}{|l|l|l|l|l|l|l} \hline A & B & D & C & F & G & H \\ \hline Exercise 3 & & & & & \\ \hline \end{tabular} Please show your two different amortization schedules on this tab and answer the following questions: a. monthly payment initially with 6.00% rate b. balance owed after 48 months c. new monthly payment with new rate of 5.00% answers should be denoted in the answer boxes by cell references to the amort schedules a. Prepare the amortization schedule with the initial terms denoted above using monthly payments. You can show a complete 15 year amortization schedule OR just what is necessary to answer the question. b. and c. After making payments for 48 months, the borrower can refinance the loan with a lower interest rate of 5.00%. The lender charges a $3,500 fee and the borrower decides to refinance the balance owed PLUS the $3,500 fee. Prepare the amortization schedule for the remaining length of time Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started